ADF - (Part 1) Create Resource Group and Azure SQL DB

By
Resource Group in Azure is container which will hold your related Azure service or resources. 

eg. If you want to create SQL server in azure portal then you can create SQL server and link that SQL server to particular resource group.

You can check out below video for creating Resource group and Azure SQL DB.

Comments

Post a Comment

Popular posts from this blog

Accessing Fields on QuickView Form through javaScript

By
QuickView form is template to view information about related entity record within a form for another entity record. Sometimes you need to access data from QuickView form for performing business logic. In order to get QuickView form in js you can use following syntax :  Syntax :  formContext.ui.quickForms.get(arg); Following is the example how you can access field from QuickView Form :  getAttributeValueFromQuickViewForm: function(executionContext) { var formContext = executionContext.getFormContext(); var quickViewControl = formContext.ui.quickForms.get("quickFormName"); if (quickViewControl != undefined) { if (quickViewControl.isLoaded()) { //not necessary to use this condition quickViewControl.getControl("new_name").getAttribute().setValue("Abhishek Dhandare"); //to get value used below syntax quickViewControl.getControl("new_type").getAttribute().getValue(); //perform your
Read more

ADF - (Part 2) Integrate Data From CRM to External system

By
Image
 In this blog we will integrate data from Microsoft Dynamic CRM to External system's SQL databse. we are going to integrate Account and Contact tables from CRM to external system Before starting with this, you should have following things :  1. Microsoft Dynamics CRM Environment 2. Microsoft SQL Server Management Studio Software(SSMS) 3. Azure Portal account First connect to your SQL server in SSMS and create Account and Contact Table. You can use following query to create table CREATE TABLE Account( [AccountId] [uniqueidentifier] NULL, [AccountName] [varchar](200) NULL, [CreditHold] [int] NULL ) CREATE TABLE Contact( [ContactId] [uniqueidentifier] NULL, [name] [varchar](200) NULL, [MobileNumber] [varchar](50) NULL, [FirstName] [varchar](200) NULL, [LastName] [varchar](200) NULL, [AccountID] [uniqueidentifier] NULL, [AccountName] [varchar](200) NULL ) After creating tables, Navigate to Azure Data factory in azure portal, and Create Dataset for your source and destina
Read more

Power Apps Portals - Lock/Unlock User Account for Invalid Sign In Attempt

By
  Site Settings that are related to Invalid Sign In Attempt. you can configure these site settings as per your requirement. Authentication/LoginThrottling/IpAddressTimeoutTimeSpan : The amount of time the IP address will have to wait if Authentication/LoginThrottling/MaxInvaildAttemptsFromIPAddress occur within Authentication/LoginThrottling/MaxAttemptsTimeLimitTimeSpan amount of time. Default: 00:10:00 (10 mins) Authentication/LoginThrottling/MaxAttemptsTimeLimitTimeSpan The amount of time the Authentication/LoginThrottling/MaxInvalidAttemptsFromIPAddress are to be within before the IP address has to wait Authentication/LoginThrottling/IpAddressTimeoutTimeSpan. Default: 00:03:00 (3 mins) Authentication/LoginThrottling/MaxInvaildAttemptsFromIPAddress The default number of unauthenticated login attempts from an IP address before the IP address is blocked for Authentication/LoginThrottling/IpAddressTimeoutTimeSpan if the attempts occur within Authentication/LoginThrottling/MaxAttemptsTim
Read more