MicroStrategy ONE

Creating DSNs for Specific Data Sources

You can create a DSN for data sources available through the Connectivity Wizard. The following table lists the information required for each type of data source when you create a new DSN using the Connectivity Wizard. For information on what operating systems each ODBC driver is certified for, see Certified ODBC Drivers for MicroStrategy Intelligence Server.

  • For ODBC-specific driver details, refer to the different ODBC driver sections below the table.
  • You can create a DSN from the command line version of the Connectivity Wizard in Linux. Browse to HOME_PATH/bin, where HOME_PATH is the directory you specified as the home directory during installation. In the console window, type ./mstrconnectwiz -h, then press Enter. This command displays command line syntax and examples for different database platforms. Create your command based on the syntax and examples displayed. Once you run your command, a DSN is created in the odbc.ini file.

 

Driver Details

MicroStrategy ODBC Driver for DB2 Wire Protocol for Windows and Linux

Data source name

Host name

Database name

Port number

MicroStrategy ODBC Driver for DB2 Wire Protocol for IBM Db2 for i for Windows and Linux

Data source name

IP address

Collection

Location

Isolation level

Package owner

TCP port (446 in most cases)

MicroStrategy ODBC Driver for IBM Db2 for z/OS for Windows and Linux

Data source name

IP address

Collection

Location

Package collection

Package owner

TCP port (446 in most cases)

MicroStrategy ODBC Driver for Microsoft SQL Server for Windows and Linux

Data source name

Host name

Port number

Database name

Use Windows NT Authentication for login ID

Enable SQL Database (Azure) support

MicroStrategy ODBC Driver for MongoDB for Windows and Linux

Data source name

Host name

Port number

Database name

MicroStrategy ODBC Driver for Oracle Wire Protocol for Windows and Linux

Data source name and either:

Standard connection:

Host name

Port number (in most cases, 1521)

SID (MicroStrategy default is ORCL)

Service name

Alternate servers

TNSNames connection:

Server name

TNSNames file

MicroStrategy ODBC Driver for SAP Sybase ASE Wire Protocol for Windows and Linux

Data source name

Network address

Database name

Enable unicode support

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.

MicroStrategy ODBC Driver for Salesforce

The MicroStrategy ODBC Driver for Salesforce allows you to access resources on Salesforce.com, from an Intelligence Server hosted on a Linux machine.

ODBC Driver for Teradata for Windows and Linux

Data Source Name

Server Name

Authentication Mechanism

Database Name

Session Character Set

Enable Data Encryption

SnowflakeDSII ODBC Driver for Snowflake Database for Windows and Linux

Data Source Name

Server Name

Database Name

Schema

Warehouse

Role

Enable SSL 

This section also provides information on how to install and configure drivers from other vendors with MicroStrategy: