Data Replication 2
Results 1 to 1 of 1

Thread: HOW TO: Using the AIS ODBC Provider on UNIX

  1. #1
    Join Date
    Sep 2006
    Posts
    233
    Rep Power
    10

    HOW TO: Using the AIS ODBC Provider on UNIX

    AIS provides an ODBC interface on all of its supported platforms. Applications can use the ODBC API to access all data sources supported by AIS.
    There are two common ways of accessing an ODBC provider such as AIS:
    1. By linking directly with the ODBC library provided - in the case of AIS that would be $NAVROOT/lib/navcli.so (the linking may be static or dynamic)
    2. By linking with a driver manager (once) and defining the desired provider in the driver manager (e.g. in the odbc.ini file)
    While the first option is possible in most cases it has several drawbacks:
    • It is complicated for non-programmers
    • It requires the application to work with the exact ODBC version that the provider supports
    • It is harder to switch providers as a matter of configuration
    For this reason, most packaged applications that consume ODBC bundle an ODBC driver manager and use it to connect to a specific driver (in many cases, this is a OEM of the DataDirect ODBC driver manager). The driver manager bridges between different ODBC versions and provides for an easy ODBC datasource configuration similar to the Microsoft file based DSN.

    A common setting for working with ODBC driver manager on most UNIX platforms follows this steps:
    1. Locate the driver manager definition file. This file is typically pointed at by the symbol ODBCINI or otherwise is located at ~/.odbc.ini (a file by the name of .odbc.ini in the user's home directory).
    2. Add an item for the AIS data source in the list of data sources at the beginning of the definition file.
    3. Add a section for the AIS data source in the definition file. For example:

      [ODBC Data Sources]
      ...
      AIS=Attunity Connect
      ...

      [AIS]
      Driver=/disk2/users/ais/navroot/lib/navcli.so
      Description=Attunity Connect ODBC access to NAVDEMO
      BindURL=10.10.22.134:8990/Navigator
      DefTDPName=NAVDEMO
      #Username=tiger
      #Password=scott
      ...
    4. Make sure the environment variable NAVROOT is defined and points to the AIS installation directory.
    5. Make sure the environment variable LD_LIBRARY_PATH (or LIBPATH or SHLIBPATH, depending on the platform) includes $NAVROOT/lib so that AIS would be able to locate its shared libraries
    Last edited by DrorHarari; 01-21-2008 at 08:01 AM.
    By Dror Harari

    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •