Hello friends, In this blog we will learn how to create an Azure SQL database in Azure portal. Steps: Go to www.portal.azure.com and create new resource of SQL Database. Create New database, click on new server and fill the necessary details, the login id and password will be the same that you will use to authenticate the database. Now the database is ready! You can click on Basic pricing tire to change the pricing of the database.Pricing Overview of Azure SQL:   BASIC STANDARD PREMIUM DATA SIZE MAX 2 GB 250 GB 500GB DTU MAX 5 50 4000 PRICE (INR) /Month 329.89 4958.54 1057537.88 Hope this helps!

Introduction: Creating a Connection is one of the first Steps during the integration of data. While performing Integration with Dynamics AX or more specifically Dynamics 365 for Finance and Operations create a connection using the following steps. Step 1: Right Click on Connection Managers and click on New Connection Manager. Step 2: Configure your AX Application to get the following details: Step 2.1 Go to www.portal.azure.com and login with your credentials. Go to “app registrations ”. Step 2.2 Enter a Name for the Application, appropriate Support Account Type and Redirect URI having a Similar Address as that of the Service URL which you Enter and finally click on Register. Step 2.3 Note Down the Following details for creating connection. Step 2.4 Click on New client Secret and add description and select expires as required. Step 2.5 Add description and select Never in expires section and click on Add. Step 2.6 This is the Client secret which is Generated only once, so must copy and store it in a file for future reference. Step 2.7 In the Data Scope section select required value as per your AX deployment and click on register and click on Open in Browser.   You will be redirected to your Finance and Operations page. Once authorized you can test the Connection by clicking on the Test Connection Button. Conclusion Now you can Move on with development of your Control and Data flow for Integration with Finance and Operations as a Source/Destination.

Hello, In this blog I am going to demonstrate how to move database from sandbox to development environment. In some cases, there might be a situation where you need to debug the code with production data. For this, first we need to move database from production to sandbox with refresh database  in LCS as shown in below screenshot. Then we need to move database from sandbox to development as follows. Steps to move database from Sandbox to Dev Login to LCS and click on Sandbox Environment full details. On Maintain Tab click Move database. To export the Sandbox Database, click on Export Database. 4.  You can find the .bacpac file in Database backup of asset library after successfully executing export command . Download the .bacpac file to development VM. 5. Open SSMS in development server. Before importing the database AxDB you must rename the existing AxDB by the following Script. USE master;  GO  ALTER DATABASE MyTestDatabase SET SINGLE_USER WITH ROLLBACK IMMEDIATE GO ALTER DATABASE MyTestDatabase MODIFY NAME = MyTestDatabaseCopy ; GO  ALTER DATABASE MyTestDatabaseCopy SET MULTI_USER GO 6. Right click on Database, select Import Data-tier Application. 7. Click Next. 8. Change the New database name to AxDB and click Next. 9. Click Next and Browse to the folder where .bacpac is downloaded. 10. Click Finish to import database. 11.  You can see the Steps as follows. 12. Once Import is done, Open Visual Studio and do Full Synchronization.   I hope this blog will help you.    

Most of the organization are using the built-in integration between Dynamics 365 and SharePoint, which allows the organization to manage and store documents in SharePoint. Microsoft has expanded the document management capabilities for Dynamics 365 with the built-in integration of Dynamics 365 with OneDrive for Business. With this integration, users can manage the documents for the D365 CE entities from their OneDrive for Business. In this article, we are going to see how to enable Dynamics 365 integration with OneDrive for Business. IT Considerations: No additional software required. You need to have the System Administration role in Dynamics 365 to enable OneDrive for Business integration with D365. Users must have a SharePoint Online license. Enabling D365 integration with OneDrive for Business: Go to Settings > Document Management > Enable OneDrive for Business. Tick on Enable OneDrive for Business and click OK. After enabling OneDrive for Business, you can see OneDrive for Business Folder Settings, in which you can define the folder which will be used for storing the Dynamics 365 documents in your OneDrive for Business. You can see the default folder as /CRM. Go to Dynamics 365 records > Related > Documents. In the Document Location, you will see two folders appeared. OneDrive – From here you can save the document in OneDrive CRM Shared with me  – Files shared with you for the associated record will be shown here. Using OneDrive for Business for Dynamics 365 Entities: Once you are in the Document Location of a record, you can create or upload the document in OneDrive. You will need to first select OneDrive in Document Location. In this case, I am uploading a document to OneDrive for an Opportunity. When I select All locations, I will be able to see all the documents associated with this record. The above-uploaded document has now been associated with this Opportunity. Here is how the folder gets created in your OneDrive for Business. The folder structure will be like CRM > Opportunity > Record. Now, let’s see if the other user can access the OneDrive document I uploaded for the record. I went to the same record and selected All locations. So, the user is only able to see the files on SharePoint. Let’s try to share this file with the user and see if it is accessible after sharing. When the file was shared with other users, the document is now visible under Shared with me a folder or under All locations in the D365 record. You can check the source; it says Shared with Me. This is how we can integrate Dynamics 365 CE with OneDrive for Business and can associate their documents with D365 for Customer Engagement records which any other individual will not be able to see unless the file is shared.

One of the common tasks to import multiple users in Office 365 is to be able to create multiple users in the most efficient way possible. Here’s a quick guide to doing so using Import multiple users feature in Office 365 Admin Center. Download Template for Importing Users Let’s say you are in the Admin Center using portal.office.com. Under Users, You’ll find a button to Add Multiple Users And the feature lets you download a template with some sample data in case you’re unsure of what to enter. Once downloaded, you’ll get the Excel in your system Now, you’ll see some sample data which you can simply delete to add your actual data. And let’s say, your data looks like this. I’ve added Kuldeep Gupta and Subhash Mahato, 2 users with some info. Import Back into O365 Now, we are set to import this in O365. On the same feature, look for Browser button to import. Click Verify to validate the info entered for any errors. Once verified, you can click Next. On the next step, I’ll assign licenses and proceed by clicking Next. Once the processing is done, users will be added And you’ll see 2 new users in O365 with the selected licenses Hope this was easy! 🙂  

If your organization is using Zoho People and Office 365, you will find this article very useful. In this article we are going to synchronize users between two applications, we will link Zoho people with Office 365 and can log in to Zoho People using Office 365 password instead of having a separate password for both the applications. IT Considerations: Zoho People subscription is required. Office 365 subscription is required. This article basically applies if you have a new Zoho people system and none of the users is added yet. If the users are already added in Zoho, there is a password created already for accessing Zoho People. Domain DNS Zone credential is required for the domain verification process. Step 1: Get the Zoho People App. Sign in to your Office 365 account (portal.office.com). Click on All Apps and click the Add-In button. Search for the Zoho People App and click on “GET IT NOW” and then click on Continue (check below screenshot). Once the above process is followed, you will be asked to log in and then provide permission to the app. Once you accept, you will be able to access Zoho People. The administrator who installs the Zoho People app for Office 365 will automatically become an admin in Zoho People. After you get the app, it will be shown in the app list on portal.office.com. Step 2: Adding users from Office 365. Once the Zoho People app is enabled for Office 365, you can add your users to the Zoho people account from Office 365 tenant. Note – Only Zoho people admin can sync the users from Office 365 to Zoho. To add users from Office 365 tenant, go to Zoho People, click Settings > Users. Click on sync > Import from Office 365. After that, you will be asked to verify the domain (see below screenshot). To verify the domain, you will need to add either the TXT or CNAME records to the DNS Zone for the domain. DNS Propagation may take some time, depending upon where it is hosted. After some time you can click on the verify button. If the DNS propagation is done, the domain will get verified, if it doesn’t get verified, you will need to wait for the propagation. You can see the verification status in the below screenshot. You will find the Users from Office 365. Select Users from the list to be added to your Zoho People account and Click ‘Import User’. The imported users will be added to the user’s list in Zoho People. Note – When you have synced the users from Office 365, Zoho People will not create a password for those users and you will need to log in with Office 365 credentials. Step 3: User login – For End-users. Once all the user is added to the Zoho People account, the user will be able to login to Zoho. Here are the steps on how to log in. Log in to portal.office.com and click on All Apps (the same process which is shown in step 1). Click the Add-In button and search for the Zoho People app and then click the “GET IT NOW” button. It will now show in the My Apps on the portal.office.com. End-users can directly go to portal.office.com and then click Zoho People to login. If you directly want to log in to Zoho People without going to the above portal, you can go to the URL – https://www.zoho.com/people/login.html Click on Sign In and since we do not have Zoho People password as we synced the users from office 365 and not created it on Zoho People directly, we will need to click on Sign in with Google or other IDPs. After that select Office 365 and sign in using your Office 365 credentials. Since this will become a longer process, it is better to get the Add-In on portal.office.com and go to Zoho People directly. It will be very helpful for the Admins with regards to the User management since the user will be managed from Office 365 itself, which means adding users and a password reset will be done from Office 365 Admin Center. It’s just that whenever a user is added in Office 365 Admin Center, user list needs to be synced once from Zoho People by the admin. This article will also be very helpful for those who are using Office 365 and Zoho people or who are willing to use Zoho People for HR processes. By following the above process, you can log in to Zoho people by using Office 365 credentials and will not have Zoho People credentials separately to remember.

You might be having some requirements for automatically sending Microsoft Forms survey in recurrence like there might be any type of survey form which needs to be sent out to all the employee on a quarterly basis or monthly basis. To achieve that you can use Microsoft Flow, there are four options available currently Automated Flow, Instant Flow, Scheduled Flow, and Business Process Flow. You need to use the Scheduled Flow, as the survey needs to be sent out in recurrence. Let’s see how to do that. Note: You need to have Microsoft Forms Pro because in Microsoft Forms “Send a Survey” action is not available in Flows. Assuming you have already created Survey in Microsoft Forms Pro. Steps 1: Office 365 Group You must have an Office 365 Group, or you can create one, in which you will need to add all the users to whom you want to send out the survey. Go to Microsoft 365 Admin Center > Groups. Create an Office 365 Group. Add members. Step 2: Creating a new Flow As it will be a scheduled survey, you will need to create a scheduled Flow. Click Create. Select Scheduled Flow. Provide the required details and click Create. Automatically this Recurrence tab will be there, where you can make changes in the frequency in which this survey will be sent. You can also specify the advanced options, where you can select the Time zone and start time. Click on +New step and then in Choose an action search for “Office 365 Group”. This is required as the Flow will require the list of addresses on which the survey will be sent. After selecting Office 365 Groups, choose Actions “List Group Members” and then select the Office 365 Group which you created earlier in Step 1. Click on New Step again and search for Microsoft Forms Pro and then choose Action “Send a Survey”. You will need to provide the following details (see screenshot). To: When you click on ‘To’ field, you will get a list of Dynamics Content from which you will have to choose “Mail”. After selecting Mail in the ‘To’ field it will look something like this, again you will need to click on Send a Survey. It asked for the ‘To’ filed again, click on the To field and from Dynamic Content, select ‘Mail’. Survey: You will need to select the Survey which you created in Microsoft Forms Pro. Email Template: There are already few default templates provide, you can choose from that. For now, “Enter Custom Value” shouldn’t be selected. The Flow is completed now, and you can go ahead and Save the flow and test if it is working as expected. I hope this article helps you in sending a Microsoft Forms survey automatically to all the people added in the Office 365 Group on a frequency which you set in the Flow. Thanks!

Modern authentication in Exchange Online enables authentication features like multi-factor authentication (MFA). Modern Authentication is by default enabled in Exchange Online and Outlook 2013 or later supports Modern authentication. I got this issue from one of my clients that the users are unable to login to Outlook after they enforce Multi-Factor Authentications for the users and as the users were using Office 2016, I haven’t thought of checking the modern authentication and it is already enabled in Outlook 2013 or later. But then it might be the possibility that somehow, they have disabled it. Of course, they were able to login to Outlook mobile as this will always use modern authentications and it doesn’t depend whether you have disabled modern authentication for Exchange Online. There was a workaround to create an App password to login but then why not modern authentication. So, let’s see how I enabled modern authentication through PowerShell. Connect to Exchange Online PowerShell. Set-ExecutionPolicy RemoteSigned $UserCredential = Get-Credential $Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ -Credential $UserCredential -Authentication Basic -AllowRedirection Import-PSSession $Session -DisableNameChecking 2. Run the following command to enable Modern Authentication connection to Exchange Online by Outlook 2013 or later clients. Set-OrganizationConfig -OAuth2ClientProfileEnabled $true 3. Some organizations might have the requirement to disable modern authentication connection to Exchange Online by Outlook 2013 or later clients. Run the following command to disable the same. Set-OrganizationConfig -OAuth2ClientProfileEnabled $false 4. To verify that the change was successful. Get-OrganizationConfig | Format-Table Name,OAuth* -Auto I hope the above steps will be able to resolve the issues whenever the user is unable to login to Outlook client with Multi-Factor Authentication.

While Creating Any Cloud-Hosted Environment in LCS it Is Necessary to create Azure Connector for which ARM(Azure Resource Manager) configuration is necessary. So this article will help you to create Azure Connector. Steps to follow :- Role assignment at the azure portal For Proper Working of Azure Connector make sure you have mentioned role assignment in your azure portal.Visit the Azure portal with the same credential as that of LCS and visit subscription section. Now select Access Control(IIM) In which click on Add Button and select Add Role Assignment. Now Configure the Add Role Assignment field as follows and save those configurations. Authorize link Now Navigate back to LCS in which Project Settings>>Azure Connectors and make sure to autorize link by clicking authorize button. Create Add option for connector Click on Add Button in Azure Connectors section and add Name, Azure subscription Id ,  and Toggle Configure to Azure Resource Manager(ARM) option to Yes. Click on next and Check for the following page Again Click on next move to the next step Upload Management Certificate Download the management certificate Now Upload Downloaded Certificate in Azure portal as follows And upload the certificate Select Region for Connector Navigate back to previous LCS session and Complete setup By selecting required Azure Region Click on confirm and your Azure connector is created and the screen looks as follows  

Let’s say you need to create a new store with multiple registers on CPOS.   It is now possible to have a retail store with multiple registers each running CPOS and each having their own dedicated hardware.   For example: A store with two registers both running CPOS and both having their own receipt printer, scanner, etc. . Here comes the concept of a shared hardware station for CPOS, It may seem impractical to have multiple registers sharing the same scanner, pin pad, etc but it is actually possible.   You’ll need to install a hardware station per CPOS and then you should be good to go.   Sharing hardware can be handy in scenarios with limited space or lesser sales persons moving around taking the sales and so on and it’s valid for CPOS.   Note: However, for MPOS you need a dedicated hardware.   Please notice that you can’t have multiple hardware stations installed on the same machine. Please do correct me anyone if that has changed 🙂 This can be done absolutely and is perfectly possible. Just deploy a Hardware station on each device and it will work as discussed in the example above.