To create an SQR connection to BI Server using ODBC:
Open SQR Production Reporting Studio and launch the Query Builder.
On the Connection tab, select New.
In Create Data Connection, enter a name for the data source connection.
In Select Provider, select ODBC.
In Select Data Source, select the appropriate BI Server DSN.
You can create a different DSN for each BI Server catalog.
In Select SQR Database, select ODBC as the local run.
In Enter Login Parameters, enter the necessary values.
Click Finish.