Easy Insight Logo
Call 1-(720)-316-8174

Combining Data Sources

What are composite data sources?
Composite data sources are data sources which combine one or more other data sources. In many cases, the data source(s) you installed via a connection may already be a composite data source. For example, creating a connection to Basecamp implicitly creates a composite data source on top of individual data sources of Projects, Todos, Comments, and Calendar Events. If you're more familiar with databases, you can think of each individual data source as a table. The composite data source brings these tables together.
Creating custom composite data sources

Beyond the implicit composite data sources of your connections, you can choose to explicitly create composite data sources. For example, if you're working with custom data, you might have several individual data sources, each representing a particular flat file or database query. In order to create a report that spans these different data sources, you'll need to create a composite data source.

You can also choose to combine thoes implicitly created data sources into a composite data source. For example, if you want a dashboard which contains reports from Basecamp, Highrise, Zendesk, and Constant Contact into a single view, you'd create a composite source containing each of those data sources.

You can create a composite data source by clicking on Connections and choosing the "Combine Sources" connection.From here, you'll be prompted to either Join Different Sources or Federate Similar Sources. Choose Join Different Sources to create a new composite data source.

Working with composite data sources
Defining a composite data source requires you to define the data sources that the new composite will contain and to define the joins between those data sources.
First, you'll need to add the various child data sources into the composite data source in the Data Sources table of the screen. If you're combining five different database sources, you'll add those five different database sources here. If you're combining Pivotal Tracker and Zendesk, you'll add those two different sources here.
Next, you'll optionally need to define the joins between these data sources. Joins tell Easy Insight how to connect the data between different child data sources. If you've imported two database tables, Customer and Order, and the Order table has a CustomerID field on it, you'd define the join in Easy Insight between the two tables, using the ID field from the Customer data source and the CustomerID field from the Order data source.
Once you've saved the data source, you can start creating reports on the combined data source just as you would on any other data source inside of Easy Insight. The different child data sources will be available as folders within the report editor, each containing its set of fields. As you drag in fields from different data sources, your report results will be based on those joins you've defined.
RESOURCES
Twitter Logo Facebook Logo Linkedin Logo Instagram Logo