When I schema is retrieved from salesforce what mapping is used? I would like to modify the default mapping so when I retrieve a table from salesforce string is specified instead of BigDecimal.
From reading other posts I gather I need to modify a mapping file at:
Project Settings > General > Metadata of TalendType
Which mapping file is used for salesoforce? I tried mapping_Oracle.xml, but that didn't seem to work. Does anyone know for sure?
There is no mapping-salesforce.xml file in metadata of TalendType. Do you want to get the "scale"(precision in talend) from salesforce?
Hi, thanks for the response.
I was looking to manipulate the conversion when a schema is generated. For example if a source field is say Number in salesforce I would like the corresponding field converted to String when I generate the metadata schema via Talend. Not a huge issue, I was just wondering if I was missing something regarding capabilities.
If we understand your requirement very well, are you trying to convert data type for your Salesforce Metadata schema? If so, you can use tMap or tConvertType component to do data type conversion.
The workflow looks like: tSalesforceInput--> tConvertType(Convert Int to String)-->output.
Thank you for the reply. I was just wondering if it was possible to manipulate the actual metadata schema generation from salesforce instead of having to convert it each time at run time.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema