We were loading the actual data in our application in BOARD with manual files.
Now we want to integrate it with ADW Datalake. Please let me know how we could connect the servers with BOARD to fetch the data instead of loading it with text files.
Hi Divya, you should be able to connect via JDBC I would expect (see here https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsds/set-jdbc-connection-data-source.html#GUID-6983C2FE-6719-412A-9095-9B13D0BBE82E ), alternatively it looks like REST API connectivity should be an option looking at this https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/rest-apis.html
Hi Robert, I was trying to make the data pipeline connections with Oracle ADW from - https://datapipeline-ae.board.com/hdpui/datasources For credentials we have the wallet with us, which I wasn't able to upload for the connection. Please guide me how to connect datalake oracle with BOARD for data sync.
Hi Divya, assuming you've enabled REST Enabled SQL Service then it looks like you just need to use standard Oauth 2.0 authentication , you'll need the Client ID and Client Secret, but it should be straightforward enough I would think. If you have a specific error then by all means post it here.