You can now import multiple tables from your source system to create object types, and also use the metadata for the tables to identify and create object to object relationships between them. If your source system database already has an object-centric structure, it's a quick way to get started with custom modeling for your object-centric data model.

When you create object types using the Import from table option, you can select more than one table from a connected data source to import at the same time. Each table becomes one object type, with columns from the table becoming attributes of the object type. You can edit the new object types and add attributes in their previews in the same way as you can when you import a single table. We’ve also added an option for you to pick a column to be used as the object type’s ID. You can only import tables from one connected data source at a time, and you can only create one object type from each table at a time. But you can go through the import flow as many times as you want, to import other data sources or create different object types.

After setting up the object types, you can view the foreign keys that connect the source system tables to each other, and choose which ones to use as one to many (1:m) object to object relationships between your new object types. In this step, you can also add custom one to many relationships between tables you're importing. If you need any many to many (m:n) object to object relationships, you'll need to create these after the import.

When you've finished, we'll show a summary for you to check the object types and object to object relationships you'll be creating, and go back and make any edits you need to. Then we'll create them all, along with the SQL transformation scripts to populate the attributes and relationship columns for the object types with the data from your source system tables. You'll need to check the scripts, ensure the object IDs are unique, and populate any extra attributes that use data from somewhere other than your original source system table. For the instructions to run the import, see Importing object types and relationships from source data.