Importing Schema from Connections

Schema Import allows you to automatically create or update Objects based on external database schemas. This feature reads the database structure from a connection and generates corresponding Objects with matching fields.

What is Schema Import?

Schema Import analyzes the database structure connected through a Database connection and:

• Creates Objects: New Objects are created for tables that don't have corresponding Objects
• Updates Objects: Existing Objects are updated to match current database schema
• Tracks Changes: Shows which Objects were created, updated, or deleted

Supported Connection Types

Schema Import is primarily used with Database connections (PostgreSQL, MySQL, Oracle).

How It Works

1. Create and Test Connection: Ensure your database connection is working
2. Import Schema: Click "Import Schema" from the connection details
3. Review Results: View created, updated, and deleted Objects
4. View Details: Click on any Object to see its schema and data

Import Results

After importing, you'll see three categories:

Created Objects

New Objects created from database tables that didn't have corresponding Objects. Each table becomes an Object with fields matching the table columns.

Updated Objects

Existing Objects that were updated to match the current database schema. Fields are added or modified to reflect schema changes.

Deleted Objects

Objects that were removed because their corresponding database tables no longer exist.

Viewing Imported Objects

After import, you can:

• View Schema: See the field structure of imported Objects
• View Data: Browse sample data from the imported Objects
• Edit Objects: Modify imported Objects as needed
• Use in Workflows: Use imported Objects in workflows with DbDataLoad

Best Practices

1. Test Connection First: Always test your connection before importing schema
2. Review Changes: Carefully review created/updated/deleted Objects
3. Backup Data: Consider backing up existing Objects before importing
4. Incremental Updates: Re-import schema periodically to keep Objects in sync with database changes

Related Introduction

• Creating Connections - Learn how to create database connections
• Objects Introduction - Understand Objects and their structure
• DbDataLoad - Use imported Objects to load data from databases