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.