Hello team, Is there a native way to integrate two...
# gooddata-cloud
b
Hello team, Is there a native way to integrate two databases as a source of information in a workspace? It is necessary to do this since the user has two databases, the current one dating from 2024 onwards and a previous one that has previous historical data from 2024 - both databases have the same structure
k
Yes, GoodData natively supports using multiple data sources within a single workspace LDM. Here's what's relevant to your scenario: Using Multiple Data Sources in an LDM You can include datasets from different data sources in a single LDM and connect them using common attribute or date dimension datasets. [Advanced Modelling Use Cases] Since both your databases share the same structure, you can connect them through a shared date dimension or a common primary key attribute — which is exactly the kind of setup this feature is designed for. Data Blending for Visualizations Once your datasets from both sources are connected in the LDM, you can create visualizations that blend metrics from both data sources into a single result set using shared conformed dimension attributes (e.g., a common date dimension). This feature is out of beta and available for production use. [Data Blending Release] Key Limitations to Be Aware Of • Metrics from different sources can only be sliced/filtered using attributes that are references to common dimension datasets and present in each data source involved in the visualization. • Only fact-based metrics can be used in blended visualizations. • There can only be one data source change in a single path of relationships (e.g.,
TableA (DB1) → Dimension → TableB (DB2)
is fine, but switching back and forth is not supported). • This feature is not compatible with the "Unique Data Sources for Tenants" feature. [Advanced Modelling Use Cases] Recommended Approach for Your Case Since both databases have the same structure and you want to combine historical (pre-2024) and current (2024+) data: 1. Add both databases as separate data sources in GoodData. 2. In your LDM, map datasets from each source and connect them via a shared date dimension. 3. Build visualizations that blend metrics from both sources, sliced by the common date dimension to get a unified historical + current view. This is a well-supported use case in GoodData. [Advanced Modelling Use Cases] 👍 0 button 👎 0 button ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups. 👀 Our Support team monitors all messages and will jump in if needed.
m
Hi Bruno, please, review the provided response from our Agent, and let us know if you need further assistance.