topic Re: TOSDI connectivity from on-premise to Oracle cloud schema as a service in Talend Studio

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

_AnonymousUser — Thu, 31 Dec 2015 04:50:27 GMT

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

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

Anonymous — Thu, 31 Dec 2015 11:27:37 GMT

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

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

_AnonymousUser — Tue, 05 Jan 2016 09:53:02 GMT

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