Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only
Back to discussions
Expand all | Collapse all

CA and Jupyter Notebook Server 11.2.4: ODBC connection to Oracle DB in R and python

  • 1.  CA and Jupyter Notebook Server 11.2.4: ODBC connection to Oracle DB in R and python

    Posted Mon September 04, 2023 12:53 PM

    We're trying to connect to Oracle DB in CA Jupyter notebook

    In the container ''ca_jupyter-.......' we've got:

    /etc/odbcinst.ini

    [OracleCA]
    Driver=/usr/lib/x86_64-linux-gnu/odbc/liboraodbcS.so

    /etc/odbc.ini

    [AMSDWHC]
    Driver=OracleCA
    DSN=OracleCA
    ServerName=AMSDWHC
    UserID=""
    Password=""

    /home/ca_user/.tnsnames.ora

    AMSDWHC =  (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ...)(PORT = 1521))) (CONNECT_DATA =     (SERVICE_NAME = AMSDWHD)))

    then

    isql -v AMSDWHC

    [IM004][unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed
    [ISQL]ERROR: Could not SQLConnect

    Similar error from R with packages DBI and odbc or RODBC

    Installation of the Oracle instant_client led to other errors like libaio.so.1, libclntsh.so.21.1 and libclntshcore.so.21.1  missing



    ------------------------------
    Thomas Strehl
    ------------------------------


  • 2.  RE: CA and Jupyter Notebook Server 11.2.4: ODBC connection to Oracle DB in R and python
    Best Answer

    Posted Tue September 05, 2023 11:01 AM

    Solved:

    Install required  packages, drivers and files by modification to Dockerfile_server_instance



    ------------------------------
    Thomas Strehl
    ------------------------------

    Original Message


Related Content