Creating Freeform SQL reports and Query Builder reports from text files - Step 3: Creating a database instance for the text file

You must complete Step 1: Preparing the text File, and Step 2: Setting up the data source (ODBC) before performing the following steps:

1. In MicroStrategy Developer, create a new database instance to point to the DSN for the text file. It is recommended that you use Generic DBMS for the Data Connection Type.

2. To make the database instance available for your Freeform SQL and Query Builder reports, right-click a project and select Project Configuration. The Project Configuration dialog box opens.

3. Expand Database Instances, and select SQL Data Warehouses.

4. From the list of available database instances, select the check box for the text file database instance and click OK.

Next step

• Step 4: Creating a Freeform SQL report from text files

Or

• Step 4: Creating a Query Builder report from text files