My Oracle Support Banner

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 later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.