User guide

Data Integration with Sybase Avaki Studio 79
Importing metadata models
You can ensure that Avaki data services you create conform to a particular
schema.
Suppose you created a schema in a modeling tool, such as Sybase PowerDe-
signer or ERwin, and you want to create a data service that produces results matching
your schema.
Solution: Import the schema into Avaki Studio as a metadata model and derive a new
view model from the metadata model. As you add operators to the view model, Studio
monitors the schema and alerts you if the view model’s schema diverges from that of
the metadata model. Any data services you deploy from this view model will match
the schema you imported from the modeling tool.
Importing metadata models
You can import several kinds of data model (schema) files into Avaki Studio. The fol-
lowing are the supported formats:
You’ll import the metadata model into a project folder. If you don’t want to use an
existing project folder, create a new one by selecting File > New > Studio Project. For
detailed instructions, see “Creating a project” on page 14.
Format Sources Notes
ERwin XML ERWin 7.0.1
JDBC An existing Avaki database
connector
You can specify one table,
multiple tables, or all tables
to import into the database.
Physical data model (.pdm) Sybase PowerDesigner 12.0