OBIEE - nqcmd.exe ODBC Client Tool

Bi Server Architecture With Client

About

nqcmd is an ODBC client tools for BI Server that is named:

  • nqcmd (under UNIX)
  • nQCmd.exe (under Windows)

You can use nqcmd to run queries against other ODBC data sources than the Oracle BI Server.

How to run NqCmd ?

You can run nQCmd.exe from:

You run it:

  • in interactive mode (without passing a SQL input file). (pattern: % to see all character and underscore (_) to replace a single character).
  • or in script mode (passing a SQL input file)

Oracle recommend to use Job Manager to run nQCmd.exe.

10g

A version can be found in the following Oracle BI installation folder: [installdrivepath]:\OracleBI\server\Bin.

11g

From the command line (in 11g), you must first set up the environment variable by running first the script bi-init.

  • Client installations: ORACLE_HOME/bifoundation/server/bin
  • Server installations: ORACLE_INSTANCE/bifoundation/OracleBIApplication/coreapplication/setup

Syntax

SYNOPSIS
         nqcmd [OPTION]...
DESCRIPTION
         -d<data source name>
         -u<user name>
         -p<password>
         -s<sql input file name>
         -o<output result file name>
         -D<Delimiter> - The delimiter used in the SQL input file (for example, semicolon (;) or colon (:)). This option is only used with -s.
         -b<super batch file name>
         -w<# wait seconds>
         -c<# cancel interval seconds>
         -C<# number of fetched rows by column-wise binding>
         -n<# number of loops>
         -r<# number of requests per shared session>
         -R<# number of fetched rows by row-wise binding>
         -t<# number of threads>
         -T (a flag to turn on time statistics)
         -a (a flag to enable async processing) - This option is typically used with -s, when you are passing a SQL input file with multiple SQL statements.
         -f (a flag to enable to flush output file for each write)
         -H (a flag to enable to open/close a request handle for each query)
         -z (a flag to enable UTF8 instead of ACP) - in the output result file in order to display international characters in query results.
         -utf16 (a flag to enable UTF16 instead of ACP)
         -q (a flag to turn off row output)
         -NoFetch (a flag to disable data fetch with query execution)
         -SmartDiff (a flag to enable SmartDiff tags in output)
         -NotForwardCursor (a flag to disable forwardonly cursor) - Disables the ODBC forward only cursor. Including this argument overrides the setting specified in the ODBC DSN.
         -P<the percent of statements to disable cache hit>
         -impersonate <the impersonate username>
         -runas <the runas username>
         -v (a flag to display the version) - 11g only
         -SessionVar <SessionVarName>=<SessionVarVAlue> - Includes the specified session variable and sets it to the specified value.

where:

See also: nqcmd advanced by setting the following environment variable:

SA_NQCMD_ADVANCED=yes

Support

Architecture mismatch

Connection open failed:
[0][State: IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch 
between the Driver and Application

Verify that you are using the good nqcmd installation and not for instance the 32 bit cmd provides with a 10g installation.

Documentation / Reference





Discover More
Obiee 11g Connection Pool Connection Script Timesten
OBIEE - Aggregate Persistence (Script)

The Aggregate Persistence functionality is the ability to: create and populate aggregate tables, and map them to the metadata repository in order to use the aggregate navigation capability of the...
Bi Server Architecture With Client
OBIEE - BI Server Clients (ODBC, JDBC)

The Open interface of BI Server gives the possibilities to made a client connection throught ODBC and JDBC. Clients of the Oracle BI Server see a logical schema view independent of the source physical...
Bi Server Architecture With Client
OBIEE - nqudmlexec

nqudmlexec is a executable that permit you to generate a repository from an udml file.
Bi Server Architecture With Client
OBIEE 10G/11G - BI Server Utilities

OBIEE have several executables files which permit you to automate some actions. bi-init.cmd (or bi-init.sh on UNIX) To interact with the repository, the Oracle BI Server has two system management API:...
Bi Server Architecture With Client
OBIEE 10g - Oracle BI Open Intelligence Interface (ODBC and JDBC) client connectivity

Some sites use third-party analytical tools, such as spreadsheets and databases, which require connectivity to the Oracle BI Server (ie the BI Server becomes a data source) The Oracle BI Open Intelligence...
Obiee Set Disable Cache Hit
OBIS - Purging / Disabling the Query Cache

How to purge the Query Cache To disable completly the query cache, you must set to the ENABLE cache parameter the value NO in the file nqsconfig. For one session, you have to set the session...
Card Puncher Data Processing
ODBC - Client

from nqcmd See mkleehammer/pyodbc/wiki Python Script



Share this page:
Follow us:
Task Runner