Connection to my database on-premise from OAC service — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Connection to my database on-premise from OAC service

Received Response
44
Views
2
Comments
Lenin Valencia
Lenin Valencia Rank 4 - Community Specialist
in Oracle Analytics Cloud and Server

Summary

How enable connection to my database on-premise from OAC service

Content

Hi,
 
I enabled a oac service for data visualization, but need create a new database connections to my site.
My question is, How to make a connection from my OAC service, to my on-premise database.
I think need the public ip asigned   to Compute Classic that contains the OAC Service, and in my firewall enable accept petitions from that ip public.
 
Another option is enable a VPN connection, this is possible?, how to enable the VPN from OAC to my database on-premise? 
 
Which is the best option and that has the highest security?
 
Someone kown how make this connection to my database on-premise.
 
Thanks a lot.

Version

OAC 18.2.1-1510

Tagged:

Answers

  • FPonte
    FPonte Rank 6 - Analytics Lead

    Hi Lenin.

    I did an OAC trial consuming data on premisse.

    The best option for me was to use VPN as a Service.

    Setting Up a VPN Connection Using VPNaaS

    You first need to create the VPN and configure inside a cloud IP Network. After that you have to create a new OAC instance inside that network.

    As far as I know is not possible to move an existing OAC instance to a just created IP network.

    Cheers.

    Fernando

     

     

  • Lenin Valencia
    Lenin Valencia Rank 4 - Community Specialist
    Hi Fernando,
     
    I checked this options i see really this is the solution. Thanks for your time.
     
    Regards.

    Lenin