Connection Steps From OAC RPD To On-Premise SQL Server
(Doc ID 2861556.1)
Last updated on AUGUST 29, 2024
Applies to:
Oracle Analytics Cloud - Version January 2022 (6.4) and laterInformation in this document applies to any platform.
Symptoms
1- Configured Public Access Channel (PAC) for direct connection with On-Perm SQL Server.
2- Configured RPD with SQL Server Driver as provided in hhttps://docs.oracle.com/en/cloud/paas/analytics-cloud/acsds/configure-and-register-data-gateway-reporting.html#GUID-50AC9767-2B31-46FA-835F-52A287560D17
2- Create DSN in local Admin Tool and import metadata.
3- Open RPD in Admin Tool --> Physical Layer --> select a table --> right click --> "View Data" OR after deploy the RPD File into OAC start getting
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |