Skip to content

OBIEE: Test ODBC connection using nqcmd

June 3, 2013

Introduction

 

This post explains how to test connectivity to data sources using nqcmd. This kind of testing is useful when debugging ODBC issues on OBIEE; It help to validate that the odbc data source is correctly configure and the right driver is been used.

Nqcmd is a connectivity tool for sanity testing provided with OBIEE11g.

“This utility (nqcmd) is intended for sanity testing. For heavier load testing, use Answers or another client. Queries with many thousands of rows will not work with nqcmd.” (Textual transcript from Oracle OBIEE documentation)

 

Platform

 

  • OBIEE 11g 11.1.1.7.0 running on Solaris 10 64b
  • MS SQL 2008 SR2 database on Windows 2008 64b

 

Procedure

 

  1. Verify if the Data Source Name (DSN) entry is correctly configure in the file $ORACLE_INSTANCE/bifoundation/OracleBIApplication/coreapplication/setup/odbc.ini
  2. Verify that you have the appropriate ODBC driver.
  3. Set the required environment variables executing bi-init.sh from the ORACLE_INSTANCE/bifoundation/OracleBIApplication/coreapplication/setup directory.
  4. Put your SQL query in a text file; use a simple SQL query.
  5. Execute the nqcmd command:

nqcmd -d <Data Source Name> -u <DB userid> -p <password> -s command.sql> > results.out
 

For example, the following command will execute the sql command found in the file “uvertest.sql” against the data base defined on the data source named “instance1_BIPLATFORM_UAT01″, the connection to the data source will be established using the credential of the user ‘MyUser” and the result of the query will be written to the file “uvertest.out”.
 

nqcmd -d instance1_BIPLATFORM_UAT01-u MyUser -p MyPassword -s uvertest.sql > uvertest.out

If this test fails, you have an ODBC connection problem; otherwise, your ODBC connection is Ok.
 

Advertisements

From → MSSQL, OBIEE, ODBC

One Comment
  1. Aditya permalink

    Thanks for providing this information’s as these are very imperative. Oracle Business Intelligence Applications are prebuilt solutions that start with the user, embrace any existing corporate data source, and are seamlessly integrated with Oracle’s transactional solutions to increase effectiveness across the entire customer life cycle. Those who are new and want some more information may visit this page- https://intellipaat.com/oracle-obiee-training/

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: