Azure SQL Database
Requirements
Data Hub v8.1 or later.
An Azure SQL Database.
The IP address or IP addresses used by your instance Data Hub.
Add Microsoft Azure firewall access for Data Hub
To use this Data Source, Data Hub needs access through the Microsoft Azure firewall. We recommend providing database-level access, not server-level access.
To provide database-level access for Data Hub:
Login to Microsoft Azure using an account with access to modify the Azure SQL Database resource.
Navigate to the Overview screen for the SQL Database.
From the side pane, select Query editor and log in to the SQL Server.
Run the sp_set_database_firewall_rule command to allow Data Hub to access the database.
Tip
sp_set_database_firewall_rule @name = N'<rule_name>'
, @start_ip_address = '99.255.255.99'
, @end_ip_address = '99.255.255.99'
;
The access may take up to 5 minutes to be finalized after the command has executed successfully.
Adding the Azure SQL Database data source
An Azure SQL Database data source can be added to a new or existing model.
Select source
Under Databases select Azure SQL Database.
From the source type pop-up, click Connect.
Connect
Complete the following fields:
Server
The Server name of the Azure SQL Database. The Server Name is a URL such as: <my_sql_db>.database.windows.net.
Authentication
Provide credentials to authenticate to the Azure SQL instance in two ways. The method used will depend on how your Azure SQL instance is configured:
Windows login: Enter an Azure user name and password.
SQL Server login: Enter an Azure SQL user name and password.
User Name
Enter the user name of a user with access to the Azure SQL Database instance. The user name provided may require the domain name (such as domain\user) or a User Principal Name format (user@fully-qualified_domain_name).
Password
Type a password for the specified user name.
Database
Type a database name to use as the data source, or select the database from a drop-down list of databases found on the specified Azure SQL instance.
Setting Advanced Data Source Properties (Optional) One or more optional advanced connection settings can be added or modified for this data source using either: Advanced panel on the Connect screen when adding the data source. Properties panel when viewing an existing data source, under the Advanced section.
Click Test Connection to verify that Data Hub can connect to the Azure SQL database with the credentials provided.
Click Next to continue to the Configure Source.
Select from the four calendars provided:
Note
All four calendars start on January 1 by default. This can be changed using the calendar pane.
Calendar YQMD - Calendar: Year, Quarter, Month, Day
Calendar YWD - Calendar: Year, Week, Day
Fiscal YQMD - Calendar: Year, Quarter, Month, Day
Fiscal YWD - Calendar: Year, Week, Day
Click Finish.