InfoSphere Optim

 View Only
  • 1.  Oracle DB support in TDF 1.0.2.2

    Posted Mon May 10, 2021 04:54 PM
    Hi,

    I have installed the TDF 1.0.2.2 version, and I found only 2 options in DB dropdown list (DB2 and SQLite) to select for adding resource. I have to use Oracle DB as a resource to fabricate data.
    Can anyone let me know which fix/update patch is required to upgrade my current version to support Oracle DB, and also can anyone provide the link from where I will be able to download it. As I have searched in the download products, fixes section but wasn't able to find anything useful.

    ------------------------------
    Brij Singh
    ------------------------------

    #InfoSphereOptim
    #Optim


  • 2.  RE: Oracle DB support in TDF 1.0.2.2

    Posted Wed May 12, 2021 08:51 AM
    Hi Brij,

    No need to apply any fix pack to connect to the Oracle DB you just need to import the appropriate JDBC to the right locations.
    Please refer to the 1.5.1 How to Add a new JDBC Driver section in the installation document which comes with the setup.
    Mentioned the same steps below
    TDF uses JDBC driver to connect to databases. The initial installation includes the JDBC version for DB2 (Windows/Linux) only. To add new JDBC drivers, please follow the below
    steps:
    For TDF Core and Resource Manager:
                    • Shut down the Tomcat server
                    • Copy the JDBC driver that you need to add to 'webapps/DataFab/WEB-INF/lib' folder of Apache Tomcat
                     • Copy the JDBC driver that you need to add to 'webapps/DataFabResourceManager/WEB-INF/lib' folder of Apache Tomcat
                     • Copy the JDBC driver that you need to add to 'webapps/DataFabWebServices/WEBINF/lib' folder of Apache Tomcat
                     • Restart the Tomcat server

    Anyway, I recommend you update the TDF to 1.0.2.4 and you need to follow same steps to add any DB

    Thanks and regards
    Narasimha Maiya



    ------------------------------
    Narasimha Maiya
    ------------------------------