Home / Modeling / Data integration with Excel

Data integration with Excel

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 data connections

Configuring periodic model data exchange

Excel connection

Structure of an Excel connection

Creating an Excel connection

Importing model data from an Excel workbook

Exporting model data to an Excel workbook

Limitations on naming Excel mappings for export

Using timed data in the Excel import and export

Creating relations using an Excel import

Import and export of Excel worksheets using an ADOdb connection

Mappings and relations

Modeling object references in a mapping

Laying out mapping relations

Modeling parent-child relations in a mapping

Mapping tables, metaobjects, and metarelations

Importing table column headings from Excel

Adding and deleting mapping table columns

Text to date and number to money conversion for Excel import

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

Linking multiple types to a metaobject or metarelation

Mapping metaobject or metarelation properties to a relation cross-reference table

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

Collapsing and expanding a metarelation

Using metadata as meta-element property

Personal support

Sign in to contact us >

Expand your skills

Explore our tutorials >