User guide

Metadata modeling
90 Data Integration with Sybase Avaki Studio
If the schemas do not match—for example, if you drop the GetEmpGivenName data-
base operation onto the PFIZER_1M table, the mapping is invalid and Studio returns an
error similar to the following:
Step 3 To resolve schema errors, click OK, and you are left with an invalid mapped object
displaying a red state. To correct the mapping:
• Edit the target schema, update the Avaki object (for example, database operation or
data service), and regenerate the schema.
Right-clicking the schema and selecting Refresh from the submenu revalidates the
tables in the editor pane. If the connection to the grid server has been lost, Refresh
will attempt to connect.
• Alternatively, drag a new Avaki object over the target schema to create a new map-
ping.
If you make a mapping error, right click the table and select Remove Mapping from
the submenu.
Step 4 Now you must deploy the model before you can point your application at Avaki Stu-
dio. Simply right-click the table and select Deploy Metadata Model from the sub-
menu. Alternatively, click the Deploy button on the toolbar