Skip to main content

Instead of modeling an object type from scratch, you can now choose to create it based on a table in your source system, with columns from the table becoming attributes of the object type. When you use this method, we'll create a preview of the object type where you can select which columns you do and don't want to turn into attributes. You can rename the object and its attributes (by default we use the table and column names). You can also add extra attributes for data in your table or outside it.

When you've finished, we'll create the object type, and you can choose to also have us autogenerate the SQL transformation scripts for it. The autogenerated transformation contains the SQL statements that you'll need to populate the object type’s attributes with the data from your source system table. You'll need to add SQL statements to identify the object ID, and to populate any extra attributes that use data from somewhere other than your original source system table. Then your object type is ready for you to create its relationships to other objects and to events as part of your object-centric data model.

For the instructions, see Creating custom object types and custom event types.

 
Be the first to reply!