GoodData-PostgreSQL Integration Details
When setting up direct data distribution from your PostgreSQL database, pay attention to the considerations and best practices listed in this article.
This article is applicable to all use cases of GoodData and PostgreSQL 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 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 Type | GoodData LDM Data Type |
|---|---|
| bigint | INT |
| boolean | BOOLEAN |
| char | VARCHAR(1) |
| date | DATE |
| decimal | DECIMAL(12,2) |
| double precision | DECIMAL(12,2) |
| numeric | DECIMAL(12,2) |
| real | DECIMAL(12,2) |
| smallint | INT |
| text | VARCHAR (10000) |
| timestamp | TIMESTAMP |
| varchar | VARCHAR (10000) |
| varchar(n) | VARCHAR(n) |
Materialized Views
Materialized views are supported. They appear in the list of available tables in the LDM Modeler alongside regular tables or views, and are included in the schema scanning.