Platform

Platform

A place for Apptio product users to learn, connect, share and grow together.

 View Only

  • 1.  DataLink to connect to a Oracle DB in AWS

    Posted Fri November 04, 2022 08:25 AM
    Hello.

    My current customer wants to leave a database in AWS. Any experience of using a DL to a database in AWS?

    We currently have the agent on premise and the idea is to use the "Default Agent" and from there attack AWS. Any details to take into account?

    Thanks!
    #TBMStudio


  • 2.  RE: DataLink to connect to a Oracle DB in AWS

    Posted Tue November 08, 2022 09:50 AM
    Interesting question, @Mario Luque. I have never tried anything like this. Let's see what the D/L experts say.​

    ------------------------------
    Regards, Guillermo
    ------------------------------

    Original Message


  • 3.  RE: DataLink to connect to a Oracle DB in AWS

    Posted Tue November 08, 2022 10:26 AM
    Hola Guillermo.

    Let´s wait DL experts feedback.

    Normally via DL if you attack an object from a third party tool on the cloud, you have your user/pass and the details of that object.

    But how would it work for a database in AWS? The connection localhost is a localhost that you publish in AWS and from there you attack with that URL and a user from that database and that's it?

    In our on premise agent, we have installed the driver for oracle and we have that detail /params in the DL connection to connect to a on premise DDBB. Customer wants to move some DB to AWS cloud
    Original Message


  • 4.  RE: DataLink to connect to a Oracle DB in AWS

    Posted Wed November 09, 2022 01:10 AM
    Edited by Guillermo Cuadrado Tue November 05, 2024 06:32 PM

    @Mario Luque. Browsing through the Help Center, I found the Generic Database connector (link).
     
    I know little about JDBC-nothing, really-but you may want to tinker with that:

     

    Oracle DB (12.1.0.2.0) jdbc:oracle:thin:@<HostName>:1522:<ServiceName> oracle.jdbc.driver.
    OracleDriver
     
    In similar situations, I have tried Postman and then some Python code, just to make sure I can access the data from the machine the agent runs on (e.g. this post-link).
     
    The documentation for the Oracle E-Business connector (link), seems to require you to have the DBMS on prem.​

    @Jenny Franklin and @Tony Wong know a lot about many things, maybe they can help.

    ------------------------------
    Regards, Guillermo
    ------------------------------

    Original Message


  • 5.  RE: DataLink to connect to a Oracle DB in AWS

    Posted Wed November 09, 2022 11:47 AM
    What @Guillermo Cuadrado posted above is exactly what you need to follow. We don't have any On Premise DL agent installed in our environment. Our AWS DL connector is Apptio hosted Datalink agent. We simply just select the Cloud Providers AWS and enable any Account ID/Access Key to configure the actions you want to take.

    ------------------------------
    Tony Wong
    ExxonMobil TBM Analyst
    ------------------------------

    Original Message