none
ADF Copy pipeline - schemamapping parameter

    Question

  • Hi There,

    We have ADF templates that our customers can use to import their data into xyz system. There is a copy task in it. The problem is every time we onboard a customer, we have to do some manual work to fix the schema and mapping between source and destination, because every customers data is different.

    Is there a way to inject the schema/mappings as parameters in ADF pipeline, so that we dont have to do manual work?

    Thanks

    Thursday, August 16, 2018 12:54 AM

All replies

  • Hi,

    This is an example of mapping parameterization:

    @Json('{"type": "TabularTranslator","columnMappings": {"Prop_0": "Prop_0","Prop_1": "Prop_1"}}')

    and an example of schema parameterization:

    @json('[{"name": "Prop_0","type": "String"},{"name": "Prop_1","type": "String"}]')

    Thursday, August 16, 2018 1:43 AM
  • Hi VairavanS,

    Do you have samples on how this id done? I'm kinda stuck in making my pipeline generic (can accept different tables from successfactors) and be able to load to azure DW.

    Thank you.


    Thursday, September 27, 2018 4:26 AM