Configure the Birst Connect 2.0

Create a new user or use an existing one for Birst to connect to the LSF database.

As a best practice, create a new user called birstuser. This user must be assigned to the default schema for your database. See Setting up the user default schema.

Log into https://app2103.bws.birst.com/.

Select the Model space and click on Connections on the right.

Note: By default, the Modeler displays after selecting the space.

From the Connections section, select the database that is not required (LSF_Oracle or LSF_SQL_Server). Click the down arrow and click Delete.

Edit the connection for the database. For example: LSF_SQL_Server. Click the down arrow and click Edit

Enter the Server Name, Database Name, Username, and Password for your database.

Under Assign agent, select agent to configure the Birst agent.

Click Download Local Agent and download the zipped file.

Extract the contents of the zipped file. In the examples below, the contents are extracted into a folder called BirstAgent.

Navigate to the BirstAgent folder.

With a text editor, open the agent.properties file and edit these values.

agent.name: Enter Birst Agent
agent.description: Enter Birst Agent for Infor LSF database

For example:

com.birst.agent.name=Birst Agent
com.birst.agent.description=Birst Agent for Infor LSF database

Open a command prompt and change directories to the BirstAgent\bin directory.

Start the Birst agent. Type

Agent

Under Assign agent, click the greater than icon (Select agent) and select Birst Agent to assign the newly created Birst agent to the connection.

Click Save and click <Back.

Click the connection to preview the data and verify that the connection is working.

For example: LSF_SQL_Server

Select a source to preview data.

The selected table data should show with column headers and data. When there is no data for the selected source, you should see the column headers if the connection is working.