Mapping and API

  • Posts: 327
  • Thank you received: 1

Mapping and API was created by SelwynO

Hi.

The new facility to do the mapping via the API is most welcome.

I have not implemented this as the mapping using the VimpX is fantastic and makes short work of the task as opposed to the new option that would require a call to the API for each column. Many table contain 80+ columns, thus requiring 80+ call to the API.

I also appreciate the positive aspect of not loading the template at all, but rather using the VimpX API to set all the properties.

It would be absolutely the way to go if there was an API method to automate the process as is available in the interface. This option would also need to have a default value for the date columns.

Kindest regards
Selwyn
7 years 6 months ago #9823

Please Log in or Create an account to join the conversation.

  • Posts: 8283
  • Karma: 33
  • Thank you received: 540

Replied by admin on topic Mapping and API

Apart from the fact that everything is great what exactly are you suggesting?

Mike
Mike
ETL Architect
7 years 6 months ago #9826

Please Log in or Create an account to join the conversation.

  • Posts: 327
  • Thank you received: 1

Replied by SelwynO on topic Mapping and API

Hi Mike.

I am suggesting an additional method that duplicates the mapping in the VimpX using the wizard. This would reduce the effort in mapping via the API. My suggestion here would reduce the calls to the API from 80+ for a single table to 1.

Kindest regards,
Selwyn
7 years 6 months ago #9830

Please Log in or Create an account to join the conversation.

  • Posts: 8283
  • Karma: 33
  • Thank you received: 540

Replied by admin on topic Mapping and API

If you want to copy mapping from one to another you can just copy script.
If you want to do it through the interface (eg user does the mapping) there is and automap option.

I hope it is useful.

Mike
Mike
ETL Architect
7 years 6 months ago #9832

Please Log in or Create an account to join the conversation.

  • Posts: 327
  • Thank you received: 1

Replied by SelwynO on topic Mapping and API

Hi Mike,

None of the above are workable solutions.

Regards
Selwyn
7 years 6 months ago #9838

Please Log in or Create an account to join the conversation.

  • Posts: 8283
  • Karma: 33
  • Thank you received: 540

Replied by admin on topic Mapping and API

What is workable solution than?

Mike
Mike
ETL Architect
7 years 6 months ago #9840

Please Log in or Create an account to join the conversation.

 

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies