GoodData-PostgreSQL Integration Details

When setting up direct data distribution from your PostgreSQL database, pay attention to the best practices concerning the following:

  • Connection
  • User access rights
  • Data types

This article is applicable to all use cases of GoodData and PostgreSQL integration:

Contents:

Connection

The default port for Data Sources to connect to PostgreSQL databases is 5432. You can use a different port from the following permitted ranges:

  • 5420-5450
  • 15420-15450
  • 25420-25450
    ...
  • 65420-65450

User Access Rights

We recommend that you grant the following access rights to the user who is referenced in Data Sources:

GRANT CONNECT ON DATABASE {database_name} TO {role_name};
GRANT USAGE ON SCHEMA {schema_name} TO {role_name};
GRANT SELECT ON ALL TABLES IN SCHEMA {schema_name} TO {role_name};
GRANT {role_name} TO {user_name};

Data Types

During mapping the PostgreSQL schema and the GoodData logical data model (LDM), data types are automatically converted from a PostgreSQL data type to a GoodData LDM data type. Only the PostgreSQL data types listed in the table are supported. If you want to prevent automatic changes, update the schema manually.

PostgreSQL Data TypeGoodData LDM Data Type
smallintINT
bigintINT
numericDECIMAL(12,2)
decimalDECIMAL(12,2)
realDECIMAL(12,2)
double precisionDECIMAL(12,2)
varcharVARCHAR (10000)
varchar(n)VARCHAR(n)
charVARCHAR(1)
textVARCHAR (10000)
dateDATE
timestampTIMESTAMP
booleanBOOLEAN
Powered by Atlassian Confluence and Scroll Viewport.