Migrate Birst Connect 1.0 Live Access Connections Metadata to Birst Connect 2.0

Birst Connect 1.0 Live Access Connections can be migrated to Birst Connect 2.0 Live Access connections.

Important: Before beginning, the Birst Connect 1.0 Agent must be off for at least one minute and Birst Connect 2.0 agent must be open. The former Birst Connect Live Access 1.0 connection will disappear from the 1.0 agent.

Note: Migration will only work with version 5.33 or above.

There are two ways to migrate a connection either using Administrative Commands or Web Services. For web services, see migrateLAConnectionToBC2. For administrative commands, see Administrative Commands.

Supported Database types for migration include the following:

• Non-Generic
  • Microsoft SQL Server
  • MySQL
  • Oracle 11g
  • PostgreSQL
  • SAP Hana
  • Microsoft Analysis Services (XMLA)
  • Infor OLAP (XMLA)
• Generic
  • Microsoft SQL Server
  • MySQL
  • Oracle 11g
  • Impala
  • PostgreSQL
  • Exasol
  • Drill
  • SAP
  • Hana
  • Microsoft Analysis Services (XMLA)
  • Infor OLAP (XMLA)
  • Redshift