Connect to a model store to use the data federated from various sources such as
databases, file servers, and cloud services. Once a connection is defined, you can
use the data in the logical and physical models of a model store in the
Read from DB and Write to DB stages of
Enterprise Designer.
-
Open Management Console.
-
Go to .
- Click the Add button .
-
In the Name field, enter a name for the connection. The
name can be anything you choose.
Note: Once you save a connection you cannot change the name.
-
In the Type field, choose Model
Store.
-
In the Model store field, enter the name of the model
store that you are establishing connection with.
To find the names of the available model stores, open Metadata Insights, to
Modeling, and click the Model Store tab.
-
To test the connection, click Test.
-
Click Save.