Can a new Oracle Data Visualization 12c 12.2.4.0.0 connect to a onpremise database? or DBCS?(Databas

Question

Summary

Can a new Oracle Data Visualization 12c 12.2.4.0.0 connect to a onpremise database? or DBCS?(Database Cloud Service)

Content

[Urgent] Can a new Oracle Data Visualization 12c 12.2.4.0.0 connect to a on-premise database? or DBCS?(Database Cloud Service)?

My customer wants to connect DVCS directly with the existing on-premise database  but as far as I know, the only way is to export the table in JSON format & send it to DVCS using REST API (curl method)

I know that DV Desktop can connect to database but DV Cloud service(DVCS) cannot.

Are these correct?

Pasan J · Answer

DVCS connects to DBCS; on-prem requires secure network setup.

Hope this might be helpful for you.

FPonte · Answer

Hi.

It can connect to Database Cloud Service, yes.

https://docs.oracle.com/en/cloud/paas/data-visualization-cloud/bidvc/creating-database-connections.html

On premises databases have a look here.

http://www.ateam-oracle.com/configuring-the-remote-data-connector-rdc-for-bi-cloud-service-bics/ http://www.ateam-oracle.com/configuring-the-data-sync-tool-for-bi-cloud-service-bics/

Additional info.

http://www.oracle.com/webfolder/technetwork/dataviz/index.html

http://www.ateam-oracle.com/installing-data-sync-in-compute-for-cloud-to-cloud-loading-into-bics/

Cheers.

Fernando