Hi Christoph,
Thanks for the clarification regarding Cube Cloud.
I wanted to provide some context regarding how GoodData could work with Cube Cloud based on the information you shared:
•
Postgres Driver / JDBC Interface:
GoodData Cloud can connect to PostgreSQL data sources via JDBC/Postgres drivers. This allows it to scan tables and metadata, which can then be used to create a Physical Data Model (PDM). From there, you can build a Logical Data Model (LDM) , GoodData’s semantic layer, on top of that data.
•
SQL API Access:
GoodData supports defining datasets via custom SQL queries, which could leverage Cube Cloud’s SQL API to access your data. This approach provides flexibility in shaping the PDM and LDM.
At present, GoodData does
not explicitly support importing or automatically synchronizing an external semantic model from Cube Cloud into its LDM. While you can map tables and queries from Cube, the semantic layer (attributes, measures, hierarchies) would likely need to be defined or augmented within GoodData.
In summary, GoodData can connect to Cube Cloud’s data via Postgres or SQL API and use that to populate datasets, but
manual definition of the semantic layer in GoodData will likely still be required.
You can also refer to our
documentation here on the datasources that can be integrated with GoodData cloud.
Let me know if this helps.