topic Re: Salesforce Database Type? in Data Quality

Salesforce Database Type?

Anonymous — Sat, 16 Nov 2024 10:38:09 GMT

Hi. Im pretty new to Talend tools, Im just trying to use DQ to screen data in my Salesforce. Im trying to follow the tutorial, but when trying to create DB connection, in second step I dont know what DB Type Salesforce is. Does anyone know? Many thanks

Re: Salesforce Database Type?

Anonymous — Wed, 18 May 2016 21:28:22 GMT

Salesforce is NOT a database. Talend access the Salesforce data via web services. If you want to screen your Salesforce data you must have them available in a database.

Re: Salesforce Database Type?

Anonymous — Thu, 19 May 2016 09:01:18 GMT

Hi jlolling. Thanks yes I get that, but there is database behind Salesforce and Im trying to access that. Im trying with 'General JDBC' database type, downloaded the latest JDBC driver - ojdbc7.jar (not sure if I downloaded the correct one as there are plenty). But there are additional parametres which I dont know how to fill.. such as JDBC URL, Class name or Mapping file. Any ideas anyone? Many many thanks

Re: Salesforce Database Type?

Anonymous — Thu, 19 May 2016 10:28:51 GMT

I would be really impressed if you can access to the underlaying database from salesforce! And if you could achieve that, Salesforce would have a serious security problem!
So the simple answer is NO. You cannot have access to this database and I will not start thinking about that.

Re: Salesforce Database Type?

Anonymous — Thu, 19 May 2016 10:46:08 GMT

Well thanks anyway. Im probably saying this wrong.. Im not db specialist at all, not even IT oriented actually. I dont really understand what are the structures behind. But I was assuming you can 'somehow' access the data in your salesforce org directly