Is there a feature in Workato to generate the source table/object DDL(structure) as per the selected target database type?
Hi Workato Support Team,
I am working on Recipe development where one of my Microsoft Dynamics source table "Account" has 460+ columns & all i wanted to be included as part of my integration to target table.
So i would like to know that Is there a feature in Workato to generate the source table/object DDL(structure) as per the selected target database type?
Like for example, in my recipe , Microsoft Dynamics is my source & Oracle Database is my target.
So in order to integrate the data, I need to create the table structure first in database but it is very difficult & time consuming to create the target table structure manually for 460+ columns in Database as i want to create target table as is same as my source structure including all columns & that should be based on Target database type.
I have many other sources from MSD that i need to integrate as is to Oracle database & most of the tables having 400+ columns present in Source.
Your immediate help is really appreciated."
Thanks.
V
Viavi Dev Account
said
almost 5 years ago
Please update on above request.
V
Viavi Dev Account
said
almost 5 years ago
Hi Workato Support team, Any update on above request?
V
Viavi Dev Account
said
almost 5 years ago
Hi Workato Support team, Any update on above request?
Viavi Dev Account
Is there a feature in Workato to generate the source table/object DDL(structure) as per the selected target database type?
Hi Workato Support Team,
I am working on Recipe development where one of my Microsoft Dynamics source table "Account" has 460+ columns & all i wanted to be included as part of my integration to target table.
So i would like to know that Is there a feature in Workato to generate the source table/object DDL(structure) as per the selected target database type?
Like for example, in my recipe , Microsoft Dynamics is my source & Oracle Database is my target.
So in order to integrate the data, I need to create the table structure first in database but it is very difficult & time consuming to create the target table structure manually for 460+ columns in Database as i want to create target table as is same as my source structure including all columns & that should be based on Target database type.
I have many other sources from MSD that i need to integrate as is to Oracle database & most of the tables having 400+ columns present in Source.
Your immediate help is really appreciated."
Thanks.