Creating Freeform SQL reports or Query Builder reports from text files - Step 2: Setting up the data source (ODBC)

You must complete Step 1: Preparing the text File before performing the following steps:

From the Control Panel of your machine, select Administrative Tools.
Select Data Sources (ODBC). The ODBC Data Source Administrator dialog box is displayed.
Select the System DSN tab, and then click Add. The Create New Data Source dialog box is displayed.
Select MicroStrategy ODBC Driver for Text and then click Finish. The ODBC Text Driver Setup dialog box is displayed.

This driver is available with MicroStrategy 8.0.2 and later.
On the General tab, enter a Data Source Name (DSN).
In the Database Directory field, provide the path of the directory where you saved the text file.
Select Comma as the Default Table Type, unless the file has a different delimiter (comma is the default).
Select the Column Names in First Line check box.
On the Advanced tab, click Define. The Define File dialog box is displayed.
Select the text file to define and click Open. The Define Table dialog box is displayed.
You must associate a table name with the text file. In the Table Information area, in the Table text box, enter the name to be used for the table within MicroStrategy.
Select the Column Names in First Row check box.
Click Guess to display all the columns contained in this table.
Click OK to return to the Define File dialog box.
Click Cancel to return to the ODBC Test Driver Setup dialog box.
Click Apply and then OK to return to the ODBC Data Source Administrator dialog box.
Click OK. The data source for the text file is now set up.

You can use the MicroStrategy ODBC Test Tool to test if data can be retrieved from the table you created in the text file.

Next step