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
, whereHOME_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 theodbc.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 |
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 |
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 MicroStrategy ODBC Driver for Salesforce allows you to access resources on Salesforce.com, from an Intelligence Server hosted on a Linux machine. |
|
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:
- ODBC Driver for Sybase Adaptive Server IQ for Linux
- ODBC Driver for Informix 8 for Linux
- ODBC Driver for Netezza for Linux
- ODBC Driver for MySQL for Linux
- ODBC Driver for Aster Database for Linux
- ODBC Driver for DataDirect Cloud for Linux
- ODBC Driver for Vertica for Linux
- ODBC Driver for SAP HANA for Windows and Linux
- Other Data Sources and Relational Databases for Windows