Home / Modeling / Data integration with SQL

Data integration with SQL

General

Model data exchange using Bizzdesign Connect

Process of creating a data connection

About data mapping in Bizzdesign Connect

Creating a Connection model

Elements for modeling connections

Controls for Connection objects and relationships

Validation of a data connection

Configuring periodic model data exchange

SQL connection

Structure of an SQL connection

Creating an SQL connection

Importing model data from an SQL database

Exporting model data to an SQL database

Viewing all tables available in an SQL database

Viewing all possible columns of an SQL database table

Required drivers for the SQL connection

Mappings and relations

Modeling object references in a mapping

Laying out mapping relations

Mapping a reference onto a relation

Mapping entries from a relation table onto a relation

Mapping tables, metaobjects, and metarelations

Adding and deleting mapping table columns

Adding metaobjects and metarelations via the Create pane or quick-create pop-up window

Linking multiple types to a metaobject or metarelation

Changing the order of properties in a metaobject or metarelation

Changing the property value of a metaobject or metarelation

Making imported tagged values non-persistent

Relocating the connectors of a metarelation

Using metadata as meta-element property

Personal support

Sign in to contact us >

Expand your skills

Explore our tutorials >