One Star

TOSDI connectivity from on-premise to Oracle cloud schema as a service

Hello Talend Team,
Below is my Requirement,
I have data in on premise Oracle Database ,I need to push the data to Oracle provided schema in cloud (Schema as a Service ).
Will Talend Opend studio consists of components to connect to Oracle provided schema in cloud (Schema as a service) Or Database as a service (DBaaS)?
Let me know the version of TOSDI which offers the components to connect to oracle cloud (Schema as a service  or DBaaS)
If not in TOSDI any other flavour or Talend which support the above requirement.
(Links on loading data to cloud from on premise would be helpful)
Thanks,
Raj

  • Data Integration
2 REPLIES
Employee

Re: TOSDI connectivity from on-premise to Oracle cloud schema as a service

This should be the same Oracle components that provide access to on-premises instances and DBaaS instances. Have you tried?
One Star

Re: TOSDI connectivity from on-premise to Oracle cloud schema as a service

This should be the same Oracle components that provide access to on-premises instances and DBaaS instances. Have you tried?

Hi,
For Oracle DB Schema as a service Oracle does not provide SQL * Net feature (No SID,Host details are provided),


To load data to schema on Cloud from on premise  Oracle has provided Data Sync tool which uses Cloud Service User ID & Password & a Url which has information like
 (servicename-identitydomain).analytics.(dc).oraclecloud.com/analytics.


So having above details can we connect to Cloud schema using Talend-OSDI?

Thanks,
Raj