Card Puncher Data Processing


The odbc.ini file is a unixodbc configuration file that define data sources name (DSN).

Every DSN to which your application connects must have an entry in this file.



odbcinst (odbc installer) is the ODBC Installer and Uninstaller command line tool which can create/remove entries in odbc.ini and odbcinst.ini

It can still be done manually.

with odbcinst

odbcinst -j
unixODBC 2.3.2
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
USER DATA SOURCES..: /u01/app/oracle/product/fmw/instances/instance1/bifoundation/OracleBIApplication/coreapplication/setup/odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8

Location and scope

Location and scope of the data source is done through the location of the file.


System-wide (ie application/process wide) data sources specifications.

The environment parameter ODBCINI configures its path: Example:

export ODBCINI=/u01/app/oracle/product/fmw/instances/instance1/bifoundation/OracleBIApplication/coreapplication/setup/odbc.ini


User-specific data sources specifications.

## Equivalent to


ODBC Data Sources

The section [ODBC Data Sources] is use to list the data source defined.

[ODBC Data Sources]
my_new_dsn = Description of my DSN


The DSN section lists:

  • the driver
  • and the driver attributes

Example of a OBIEE DSN:

Driver = ORACLE_HOME/bifoundation/server/bin/call_interface.library_suffix
ServerMachine = local
Port = bi_server_port_number
ForwardOnlyCursor = No
SelectPhysical = No
Regional = Yes



man odbc.ini

Discover More
Cluster Config Bdm
BDM - Installation in Azure

Open the node Domain > ClusterConfigurations Right Click > Import With Cluster Connection (if with file convention: , such as Hive_ccMapR.) Information from the cluster (needed for during the configuration...
Card Puncher Data Processing
Fusion Middelware - OPMN.xml configuration file

OPMN.xml is the main configuration file for OPMN that is used to launch each system component (such as Oracle Business Intelligence). It specifies environment variable (path, ...) PATH LD_LIBRARY_PATH...
Obiee Dsn Configuration 1
OBIEE 10G/11G - How to create an Analytics ODBC Data Source (System DSN ODBC connexion)

How to create an odbc DSN to be able to connect to the OBIEE BI Server ? On Windows XP (), go to Control Panel / Administration Tools and open “Data Sources ODset up in the configuration filodbc.inopmn.xmlConfiguring...
Card Puncher Data Processing
ODBC - DSN (data source name)

When an ODBC based application connects to a database, it connects to a logical name, the Data Source Name (DSN), which identifies the datasource to which it wants to connect. Some external repository...
Card Puncher Data Processing
ODBC - odbcinst (odbc installer)

odbcinst (odbc installer) is the ODBC Installer and Uninstaller command line tool which can create/remove entries in odbc.ini and odbcinst.ini It can still be done manually. It updates system files,...
Card Puncher Data Processing
ODBC - odbcinst.ini

odbcinst.ini has all driver information configuration. See Configuration file containing all the database drivers specifications. odbcinst.ini Run: Normally: /etc/odbcinst.ini In the...
Card Puncher Data Processing

unixodbc notes. See Make sure that /lib is in the beginning of the libray path environment variable: LD_LIBRARY_PATH for Linux/Solaris LIB_PATH for AIX DYLD_LIBRARY_PATH...
Card Puncher Data Processing
Oracle Database - ODBC Driver Insallation on Linux

where is the data manager home () and ~/.odbc.ini === Drivers === Example odbcinst.ini === DSN === odbc.ini Minimal parameters Complete: ==== Test it ==== with ===== Support...
Odbc Sap Hana

ODBC For now, it's a type 2. connection string: server:port For example, if the SAP HANA server is running on the host MyServer, as instance 01, on port 30115, and the SAP HANA client...
Card Puncher Data Processing
UnixODBC - odbc_config (UnixODBC environment)

This articles talks the utility odbc_config. It permits to retrieve scalar configuration information. For the configuration of DSN, see

Share this page:
Follow us:
Task Runner