What Metadata Mapping File is used for Salesforce Metadata schema?

Six Stars

What Metadata Mapping File is used for Salesforce Metadata schema?

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?

Moderator

Re: What Metadata Mapping File is used for Salesforce Metadata schema?

Hello,

There is no mapping-salesforce.xml file in metadata of TalendType. Do you want to get the "scale"(precision in talend) from salesforce?

Best regards

Sabrina

 

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: What Metadata Mapping File is used for Salesforce Metadata schema?

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.  

Moderator

Re: What Metadata Mapping File is used for Salesforce Metadata schema?

Hello,

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.

Best regards

Sabrina

 

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: What Metadata Mapping File is used for Salesforce Metadata schema?

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. 

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog