Creating a Compound Live Access RDBMS Source

You can create a compound Live Access source that combines more than one table from the source relational database into a single data source in Birst.

Important: If you use the Data Flow page to map Live Access sources you should not use the Manage Local Sources page to modify them. Conversely, if you have used the Manage Local Sources page to map your Live Access sources, you should continue to use the Manage Local Sources page and should not use the Data Flow page to modify them.

To create a Live Access compound source using the Data Flow

1. Create a real-time Live Access connection in Birst Connect.
2. Add a Live Access source on the Define Sources - Data Flow page. See Modeling a Live Access Relational Database Source.
3. In the Import Table/Cube Definition dialog box, select the connection to use then select Import a Compound Table.

4. On the next screen, select the tables to import and type the name you want to use for the compound table. For example, import the Order Details and Orders tables and naming the compound table "Orders".

5. After clicking Import, the new source appears on the Data Flow page diagram.

6. Right-click the source and select Manage Sources. The Modify Data Source dialog shows the imported columns.

7. Click the Properties tab. Specify a join condition between the two tables.


8. Click Save and Close in the Modify Data Source dialog box.
9. Set the primary key for each source by right-clicking the source and selecting Set Primary Key.
10. Create joins between Live Access sources as necessary. To create a join between tables that have the same column but use different column names, you can do a complex join to a related source.

The columns from the Live Access sources you create become available in the Subject Area of Designer or Visualizer.

Tips:

You can only create joins between Live Access sources. Joins cannot be created between warehouse dimensions or measures and Live Access sources. Joins also cannot be created between Live Access sources and raw data sources.

Column names in PostgreSQL databases are case-sensitive. You need to use quoted column names when defining joins. For example: "Categories-New Level"."CategoryID"="Products-New Level"."CategoryID"

You can add custom columns and expressions to your Live Access sources. See Adding Custom Columns and Custom Expressions to a Live Access Source.

See Also
Creating a Live Access Connection
Creating a Live Access Opaque View (Query) Source
Modeling a Live Access Relational Database Source