Configure the Microsoft Azure SQL database connection

You can configure the Microsoft Azure SQL database name to connect to a Microsoft Azure SQL Server database and retrieve the database details.

Configure the Microsoft Azure SQL database connection

1. In the Data Adapter Type list, select Microsoft Azure SQL Database.

   The Data Source Configuration section appears as follows.

   

2. In the Data Source Configuration section, do the following:

   1. In the Data Source time zone list, click the time zone of the database that the external data source system is referencing.

      You can click the Automatically adjust time for Daylight Savings check box if the time zone that you select is affected by daylight saving time (DST).

      For more information, see Time zone for a data source.

   In the Server name box, type the URL of the Microsoft Azure SQL server.

   1. In the Database name box, type the database name that you want to connect to.

   2. Select the authentication mode and then enter the user name and password.

      • Select the Active Directory Authentication mode if you want to connect using the Active Directory credentials. You must specify the user name and password for authentication.

      • Select the SQL Server Authentication mode if you want to connect using the SQL Server credentials. You must specify the user name and password for authentication.

3. Click Connect. If the connection succeeds, the Getting schema notification message appears. It can take a few minutes to retrieve the schema from the data source. For more information about retrieving the schema, see Retrieve the schema.

4. Click Done and then click Save.