KB38648: How to setup Oracle database connections using TNSnames in MicroStrategy 9.x and newer

• Strategy

In some cases it may be beneficial to use a TNSNames file in order to setup connectivity to an Oracle Database or listener service for use with MicroStrategy 9.x and newer. In these cases, the following steps can be followed in order to setup the connectivity. In all cases, it is assumed that a TNSNames.ora file is already provided by the Database Administrator.

In some cases it may be beneficial to use a TNSNames file in order to setup connectivity to an Oracle Database or listener service for use with Strategy 9.x and newer. In these cases, the following steps can be followed in order to setup the connectivity. In all cases, it is assumed that a TNSNames.ora file is already provided by the Database Administrator.

Open Connectivity Wizard, located under the tools menu in windows or ./mstrconnectwiz in the /bin folder on *nix machines.
Select Strategy ODBC Driver for Oracle Wire Protocol
Select the "TNSNames Connection" radio button under the Data Source Name text field.
Fill out the Server Name field and put a fully qualified path to the TNSNames file as shown below. It's important that the value entered for the "Server Name" field has a matching entry in the TNSNames file.

Test the connection and hit finish.

If a GUI is not available, manually creating the entry in the ODBC.ini file will be required. An example file is below:


TNSNAMES=Strategy ODBC Driver for Oracle Wire Protocol
  ...

[TNSNAMES]
ServerName=Test
TNSNamesFile=/home/mstr902/MicroStrategy/tnsnames.ora
Driver=/home/mstr902/MicroStrategy/install/lib32/MYoraXX.so
Description=Strategy ODBC Driver for Oracle Wire Protocol
ApplicationUsingThreads=1
ArraySize=60000
CachedCursorLimit=32
CachedDescLimit=0
CatalogIncludesSynonyms=1
CatalogOptions=0
DefaultLongDataBuffLen=1024
EnableDescribeParam=1
EnableNcharSupport=1
EnableScrollableCursors=1
EnableStaticCursorsForLongData=0
EnableTimestampWithTimeZone=0
IgnoreODBCTimeStampLiteral=1
LocalTimeZoneOffset=
LockTimeOut=-1
ProcedureRetResults=0
UseCurrentSchema=1
IANAAppCodePage=111

The ServerName and TNSNamesFile are used to specify the corresponding fields that would have been present in the GUI. Additionally, the location of the driver specified in this example will change depending on your environment but should be in <MSTR_INSTALL_PATH>/lib32/ for 9x or <MSTR_INSTALL_PATH>/lib for 10x. Once it is done you should be able to test connectivity using the Strategy ODBC Test Tool(mstrtodbcx in the /bin folder).

Comment

0 comments

Details

Knowledge Article

Published:

May 31, 2017

Last Updated:

May 31, 2017

TNSNAMES=Strategy ODBC Driver for Oracle Wire Protocol ... [TNSNAMES] ServerName=Test TNSNamesFile=/home/mstr902/MicroStrategy/tnsnames.ora Driver=/home/mstr902/MicroStrategy/install/lib32/MYoraXX.so Description=Strategy ODBC Driver for Oracle Wire Protocol ApplicationUsingThreads=1 ArraySize=60000 CachedCursorLimit=32 CachedDescLimit=0 CatalogIncludesSynonyms=1 CatalogOptions=0 DefaultLongDataBuffLen=1024 EnableDescribeParam=1 EnableNcharSupport=1 EnableScrollableCursors=1 EnableStaticCursorsForLongData=0 EnableTimestampWithTimeZone=0 IgnoreODBCTimeStampLiteral=1 LocalTimeZoneOffset= LockTimeOut=-1 ProcedureRetResults=0 UseCurrentSchema=1 IANAAppCodePage=111