Connecting to Live Access Databases Using Birst Connect 2.0

Similar to connecting to a database, you can select the Live Access option to create a logical mapping of data from a database rather than importing the data into the Birst Cloud.

Note: You can map the tables using the Live Access connection, but you cannot prepare the data since it is not in the Birst Cloud.

Caution:

Before Birst can connect to a database, you must download the Birst Cloud Agent to the machine that will access the database. The agent enables Birst to access the database behind its firewall.

The Modeler Relate feature creates joins between mapped sources.

For Birst Enterprise customers, you can use Birst Connect 2.0 (HTML Admin) to create Live Access connections and model your existing ADR sources in the HTML interface along with joining both LA and ARD sources for an end to end experience.

For instructions on creating a new Live Access connection, see Connecting to Database Data Sources.

Note: Infor Data Lake connections are not supported by Live Access.

After completing your data source connections, you can create the logical data map by clicking the Map Data button. The name of this button includes your connection name. For example, Map MSSQL LA Data.

Live Access objects connect like database objects. After establishing a Live Access connection, you can edit data source connections like database objects.