GoodData-Microsoft SQL Server Integration Details

When setting up direct data distribution from your Microsoft SQL Server, pay attention to the considerations and best practices listed in this article.

This article is applicable to all use cases of GoodData and Microsoft SQL Server integration:

Contents:

Ports Used

By default, Data Sources connect to Microsoft SQL Server via port 1433. You can use a different port from a permitted range of 1420-1450.

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 Microsoft SQL Server to have sufficient permissions to be able to establish outbound connections.

Access to Microsoft SQL Server

So that the GoodData platform can connect to your Microsoft SQL Server, authorize access to it. For information, see GoodData IP Addresses and IP Whitelisting.

Data Types

Microsoft SQL Server 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 a Microsoft SQL Server 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.

Microsoft SQL Server Data TypeGoodData LDM Data Type
bigintBIGINT
bitBOOLEAN
charVARCHAR
dateDATE
datetimeDATE
datetime2DATE
decimalNUMERIC
floatFLOAT
intINTEGER
moneyNUMERIC
ncharVARCHAR
numericNUMERIC
nvarcharVARCHAR
realFLOAT
smalldatetimeDATE
smallintINTEGER
smallmoneyNUMERIC
tinyintINTEGER
uniqueidentifierVARCHAR
varcharVARCHAR
Other data typesNot supported

Custom Parameters

Custom parameters in URLs are not supported.

Powered by Atlassian Confluence and Scroll Viewport.