Categories
- All Categories
- 161 Oracle Analytics News
- 28 Oracle Analytics Videos
- 14.8K Oracle Analytics Forums
- 5.7K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 56 Oracle Analytics Trainings
- 12 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
Support OAC DV connection to Microsoft Azure SQL Database on Private Network
Account: VERINT CES LTD
Currently as per the certification matrix of OAC, one can only connect to Microsoft Azure SQL Database using Standard connection, means that the data source host is accessible via the public Internet.
Requesting to consider supporting OAC connection to Microsoft Azure SQL Database using Private connection.
https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsds/microsoft-azure-sql-database.html
Business JustificationCustomer is moving their complete database to Microsoft Azure on Private network. For this they need to be able to connect to OAC to perform the reporting.
Failure to connect may lead them to use another analytics based product apart from OAC”
Comments
-
Enable with Private internet.
0 -
Certification is planned. However, you should be able to configure using the SQL Server connection type.
0 -
@Alan Lee - Oracle-Oracle Thanks for your response.
Customer's Microsoft Azure SQL Database is hosted inside a Private network and is not accessible via the public internet. As per the certification document only Standard mode of connectivity is supported for Microsoft Azure SQl Database for SQL Server connection type.
Since this connectivity is important for the Customer, as a test, Customer even configured PAC and tried the DV connection with SQL Server Connection Type for the Microsoft Azure SQL Database but even that did not work.
Can you kindly give some insights on how is the connection being planned ie. via PAC , RDG, RPD etc..
0 -
@ashish.f.singh-Oracle Did the customer try with RDG?
0 -
@Alan Lee - Oracle-Oracle No they just tested on PAC. Should I request the Customer to try the connection with RDG once as well? Will the connection via RDG work with Microsoft Azure SQL Database hosted on private host?
0 -
@Alan Lee - Oracle-Oracle , When this feature is going to implement.
My organization planned to move to Azure sql private connection from another databases.
If oracle team is unable to provide this feature, we have to move to another reporting tool from OAC.
0 -
@Benjamin Arnulf-Oracle, Can you help here?
0 -
@Alan Lee - Oracle-Oracle , When this will implement?
0 -
@Naresh Gopavaram I would suggest testing through RDG. Use the SQL Server connection type and select Remote Data Connectivity option.
0 -
@Alan Lee - Oracle-Oracle , Discussed with Oracle support on RDG, they took 1 month time and confirmed it is not possible. Can you please help to enable this feature.
0
