GoodData-Azure SQL Database Integration Details
When setting up direct data distribution from your Microsoft Azure SQL Database, pay attention to the considerations and best practices listed in this article.
This article is applicable to all use cases of GoodData and Azure SQL Database integration:
- Integrate a Data Source for a Data Warehouse (a getting-started guide based on sample data)
- Integrate Data Warehouses Directly to GoodData based on an Existing LDM
Ports Used
You can use any port from within the range of 1024-65535.
User Access Rights
We recommend that you grant the following minimum access rights to the user who is referenced in Data Sources:
GRANT SELECT ON SCHEMA {database_name}.{schema_name} TO {user_name} WITH GRANT OPTION;
Database Permissions
Configure your Azure SQL Database to have sufficient permissions to be able to establish outbound connections.
Access to Azure SQL Database
So that the GoodData platform can connect to your Azure SQL Database, authorize access to it. For information, see GoodData IP Addresses and IP Whitelisting.
Active Directory
If you use Active Directory for user authentication, make sure that the parameters in Active Directory are aligned with the GoodData platform.
SSL Mode
Use the verify-full SSL mode that allows your database to connect to a server you specify only if it supports encryption and is trusted.
Data Types
Azure SQL Database provides a wide range of data types. During mapping the SQL schema and the GoodData logical data model (LDM), data types are automatically converted from an Azure SQL Database data type to a GoodData LDM data type. Some columns may be ignored because their data type is not supported within GoodData or their type may lead to performance issues. If you want to prevent automatic changes, update the schema manually.
| Azure SQL Database Data Type | GoodData LDM Data Type |
|---|---|
| bigint | BIGINT |
| bit | BOOLEAN |
| char | VARCHAR |
| date | DATE |
| datetime | DATE |
| datetime2 | DATE |
| decimal | NUMERIC |
| float | FLOAT |
| int | INTEGER |
| money | NUMERIC |
| nchar | VARCHAR |
| numeric | NUMERIC |
| nvarchar | VARCHAR |
| real | FLOAT |
| smalldatetime | DATE |
| smallint | INTEGER |
| smallmoney | NUMERIC |
| tinyint | INTEGER |
| uniqueidentifier | VARCHAR |
| varchar | VARCHAR |
| Other data types | Not supported |
Custom Parameters
Custom parameters in URLs are not supported.