How to Create Metadata Database Connection

As explained in previous post about the metadata.

As we all know Metadata is data about data. It is descriptive information about a particular data set, object, or resource, including how it is formatted, and when and by whom it was collected.

In terms of Taled open Studio, metadata refers to reusable configurations that describe the data, its attributes, or its containers. We could define metadata in the Studio that describes an XML schema, a web service definition, or an FTP connection.

The steps of Database Connection are as follows:-

Step 1:- Go to the Repository view Metadata right click on Db Connection and select Create Connection.

Step 2:- In the Database Connection window write in the name field for example my_db and click on Next button.

Step 3:- Now here in the DB Type list, select the type of database you want to connect . Fill the login and password field .In the Server field, fill the name or IP address of the server .In the Port field, fill the listening port .In the Database field, fill the name of the database.Then click Check to verify the database connection.

Step 4:- Now this clear screen appears when your connection is successful click OK button.If your connection is not successful then again check the database settings.

Step 5:- Click Finish Button on this screen also.

Step 6:- In the Repository view the new connection will appear under the Metadata - Db Connections node. Now at last your connection has been created.