Enabling the Do Not Use Prefix Option

You can set table prefix names for Birst Connect 2.0 extract connections allowing for an easier migration path for existing ADR data models from Birst Connect 1.0 to Birst Connect 2.0.

If you are using Birst Connect 2.0 to import data into a converted ADR space (converted to new metadata infrastructure), you will likely want to employ the No Prefix option located in the more options section of the UI. By default, Birst Connect 2.0 applies your connection name as a prefix to any sources you are importing to your data model. That means, that existing sources no longer get populated with data extracted from your source systems because BC 2.0 is now importing data to a source called something like this: ConnectionName_SourceName rather than populating the existing source.

Note: We recommend you initially perform the steps documented below on a copy of your space first to ensure the migration was successful.

Here is an example where we called the Birst Connect 2.0 connection Northwind to import data from the source database table into the converted ADR space:

Birst Connect 2.0 can ignore the connection name as the prefix to the connection so that the source data will instead import to the original modeled source that will save you from having to re-create the ADR model in the Admin module.

From the Create Connection panel in Birst Connect 2.0, you can now customize the source prefix by accessing the More Options panel. Enable the Do not use prefix option to remove the connection name as the prefix.

Note: Birst automatically looks for other existing connections to see if others share the same prefix to warn you of the possibility of overwriting the sources with the same name.

In the case where we do want to import data into existing sources, we do want to proceed and overwrite the existing the source defined with Birst Connect 1.0 to Birst Connect 2.0.