MicroStrategy ODBC Driver for SequeLink

The MicroStrategy ODBC Driver for SequeLink allows you to access Microsoft Access databases or Microsoft Excel files stored on a Windows machine from an Intelligence Server hosted on a Linux machine. The steps below show you how to perform the necessary configurations on the various machines to support this type of configuration.

Preparing the Microsoft Access Database from an Intelligence Server Hosted on Linux

You must complete the steps below to access an Access database stored on a Windows machine from an Intelligence Server hosted on a Linux machine.

On the Windows machine where the Access database is stored, you must create a DSN to connect to the Access database. For instructions on creating a DSN, see Creating a DSN for a data source.

1. On the Windows machine that stores the Access database to connect to, install the SequeLink ODBC Socket Server. This can be installed as part of a MicroStrategy installation, and is included in the Other components options of the MicroStrategy Product Suite (see Select Components).

   The SequeLink ODBC Socket Server that is provided with a MicroStrategy installation is for exclusive use with the MicroStrategy Product Suite. You are not licensed to use this product with any application other than MicroStrategy products.

2. On the Windows machine where you installed the SequeLink ODBC Socket Server, go to the SequeLink Management Console Snap-in.
3. Under Console Root, go to SequeLink 6.0 Manager > Connected to SLAgent55 > SequeLink Services > SLSocket55 > Configuration > Data Source Settings.
4. From the Action menu, go to New > Data Source.
5. Type a descriptive name for the new data source, such as Access Data Source.
6. Expand the new data source and select Advanced.
7. Right-click DataSourceSOCODBCConnStr and select Properties. The DataSourceSOCODBCConnStr Properties dialog box opens.
8. In the Value field, type DSN=AccessDSN, where AccessDSN is the DSN you created to connect to your Access database. This is different from the data source you created as part of the steps to configure the SequeLink ODBC Socket Server.
9. Click OK.
10. Within the same data source, select User Security.
11. Right click DataSourceLogonMethod and select Properties.
12. From the Value drop-down list, select Anonymous.
13. Click OK.
14. Right-click the data source, point to All Tasks, and select Save configuration.
15. On the Linux machine that hosts your Intelligence Server, you must configure the MicroStrategy ODBC driver for SequeLink to connect to the Access database. For instructions on how to perform this configuration, see Configuring the MicroStrategy ODBC Driver for SequeLink.

Preparing the Microsoft Excel File from an Intelligence Server Hosted on Linux

You must complete the steps below to access Excel files stored on a Windows machine from an Intelligence server hosted on a Linux machine

1. On the Windows machine that stores the Excel files to connect to, install the SequeLink ODBC Socket Server. This can be installed as part of a MicroStrategy installation, and is included in the Other components options of the MicroStrategy Product Suite (see Select Components).
2. On the Windows machine where you installed the SequeLink ODBC Socket Server, go to the SequeLink Management Console Snap-In.
3. Under Console Root, expand SequeLink 6.0 Manager, expand Connected to SLAgent55, expand SequeLink Services, expand SLSocket55, expand Configuration, and then select Data Source Settings.
4. From the Action menu, point to New, and select Data Source. A new data source is created underneath Data Source Settings.
5. Type a descriptive name for the new data source, such as Excel Data Source.
6. Expand the new data source, and select Advanced.
7. Right-click DataSourceSOCODBCConnStr and select Properties. The DataSourceSOCODBCConnStr Properties dialog box opens.
8. In the Value field, type DSN=ExcelDSN, where ExcelDSN is the DSN you created to connect to your Excel file. This is different from that data source you created as part of the steps to configure the SequeLink ODBC Socket Server.
9. Click OK.
10. Within the same data source, select User Security.
11. Right click DataSourceLogonMethod and select Properties. The DataSourceLogonMethod Properties dialog box opens.
12. From the Value drop-down list, select Anonymous. This allows connection to the Excel file without using a user name and password.
13. Click OK.
14. Right-click the data source, point to All Tasks, and select Save configuration.
15. On the Linux machine that hosts your Intelligence Server, you must configure the MicroStrategy ODBC driver for SequeLink to connect to the Excel files. For instructions on how to perform this configuration, see Configuring the MicroStrategy ODBC Driver for SequeLink.

Configuring the MicroStrategy ODBC Driver for SequeLink

The steps below show you how to configure the MicroStrategy ODBC driver for SequeLink to access either Microsoft Access databases or Excel files stored on a Windows machine:

1. On the Linux machine that hosts Intelligence Server, browse to HOME_PATH where HOME_PATH is the directory you specified as the Home Directory during installation.
2. Open the odbc.ini.example file and find the section that starts with [SequeLinkODBC]. Copy this section into the odbc.ini file. For information on the parameters, refer to DataDirect's documentation at http://media.datadirect.com/download/docs/odbc/allodbc/help.html.
3. Edit the parameters listed below:
   • Host: Type the IP address of the Windows machine that stores the Access database or Excel files.
   • ServerDataSource: Type the name of the data source for the Access database or Excel file to connect to as a data source. This is the name of the data source that you defined while configuring the SequeLink ODBC Socket Server, as shown in the example image below:

     

4. Save the odbc.ini file.
5. Restart Intelligence Server.