Scripting source type creation


Has anyone written any utilities to automate the creation of Source types from a given source system? We have 70-80 tables that we will be having to create from an Oracle source and want to use something like select table_name,column_name,data_type from user_tab_cols to use as baseline data to then build our source types, field and field types.



There is a tool called “C3 Data Management” which is included in the latest “beta” release of “C3 Tools”. This application is specifically designed to assist with the use case you describe. If you are interested in participating in the beta please contact your team leads.

1 Like