Hi there, does GoodData integrate with Cube by any...
# gd-beginners
c
Hi there, does GoodData integrate with Cube by any chance?
y
Hi Christoph, Thanks for sending this in, happy to help. Could you please clarify which “Cube” you’re referring to (e.g., Cube.js, Cube Cloud, or another product)? It would also help if you could describe your use case, for example, are you looking to embed dashboards, integrate two analytics systems, or migrate between platforms?Thanks.
c
Hey Yvonne, yes, cube cloud or the open source version of it. This assumes cube is our single access layer to host our semantic layer, caching and authorization to service application code via it's apis and bi tooling with a consistent picture. Cube exposes a postgres/jdbc interface but also exposes a sql api which is probably a bit richer in exposing the semantic layer and pass through jwt claims. Can GoodData leverage the Postgres driver or sql api to populate it's semantic model without us having to re-define or augment the semantic layer in GoodData?
y
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.
c
ok, thanks for clarifying!