KB42495: How to create a DSN through the command line interface in MicroStrategy Intelligence Server Universal

• Strategy

This article outlines the syntax and examples for creating a DSN through the command line interface in MicroStrategy Intelligence Server Universal.

Description

In order to create an ODBC DSN in Strategy Intelligence Server Universal, it is possible to use the utility mstrconnectwiz. When this utility is run with no arguments, it launches a graphical application for creating and managing DSNs. However, when adding some arguments, as indicated in this document, the same utility can be used to create and manage DSNs when a graphical user interface is not available.
In Strategy 2021, DSNs can be created with TLS enabled. For more usage details, please refer to KB484551.

Usage

Oracle Wire Protocol


mstrconnectwiz ORCLW DataSourceName HostName (SID | -sname:ServiceName) PortNumber

DB2 UDB


mstrconnectwiz DB2 DataSourceName HostName DatabaseName PortNumber

Greenplum


mstrconnectwiz GREENPLUM DataSourceName HostName DatabaseName PortNumber

Informix


mstrconnectwiz INFX9 DataSourceName ServerName HostName PortNumber DatabaseName

Sybase ASE


mstrconnectwiz SYBASE DataSourceName NetworkAddrss,PortNumber DatabaseName Unicode

SQL Server


mstrconnectwiz SQLSERVER DataSourceName HostName PortNumber DatabaseName

DB2 ISeries


mstrconnectwiz DB2ISERIES DataSourceName IpAddress Collection Location IsolationLevel PackageOwner PortNumber

DB2 z/OS


mstrconnectwiz DB2ZOS DataSourceName IpAddress Collection Location PackageCollection PackageOwner PortNumber

MySQL


mstrconnectwiz MYSQL_CONNECTOR DataSourceName HostName PortNumber DatabaseName -u:uid

PostgreSQL


mstrconnectwiz POSTGRESQL DataSourceName HostName PortNumber DatabaseName -u:uid

SalesForce


mstrconnectwiz SALESFORCE DataSourceName HostName -u:uid -p:pwd

Where

```
-r
```
replaces a DSN if the DSN already exists.
```
-u:uid
```
provides the logonID to perform a test connection.
```
-p:pwd
```
provides the password to perform a test connection.

Notes

```
mstrconnectwiz
```
allows you to specify a
```
<blank>
```
parameter by using the special character
```
^
```
for optional parameters.
DSN cannot contain spaces unless the names are enclosed in double quotes.

Examples

Example 1: Creating a normal DSN.


mstrconnectwiz SQLSERVER AnyName TS_SPHINX 1433 DevProject

Example 2: Replacing an existing DSN.


mstrconnectwiz -r SQLSERVER AnyName TS_SPHINX 1433 ProdProject

Example 3: Creating a DSN and performing a test connection with login and password.


mstrconnectwiz SQLSERVER AnyName TS_SPHINX 1433 ProdProject -u:admin -p:pwd

Example 4: Creating a DSN with a blank value in one of the parameters.


mstrconnectwiz DB2ISERIES AnyName 10.10.25.235 TUTORIAL AS400 NO_COMMIT ^ 446

Example 5: Creating a DSN MySQL Driver


mstrconnectwiz MYSQL_CONNECTOR AnyName 10.10.25.50 3306 MYSQL_SCHEMA_NAME /usr/lib64/libmyodbc5w.so -u:mstr -p:pwd/pre>

Comment

0 comments

Details

Knowledge Article

Published:

April 4, 2017

Last Updated:

February 13, 2024