SAP BODS - Linked Datastore

There are various database vendors, which only provide one-way communication path from one database to another database. These paths are known as database pnks. In SQL Server, Linked server allows one-way communication path from one database to other.

Example

Consider a local database Server named “Product” stores database pnk to access information on remote database server called Customer. Now, users that are connected to the remote database server Customer cannot use the same pnk to access data in database server Product. Users that are connected to “Customer” should have a separate pnk in data dictionary of the server to access the data in Product database server.

This communication path between the two databases is called the database pnk. The Datastores, which are created between these pnked database relationships are known as pnked Datastores.

There is a possibipty of connecting one Datastore to another Datastore and importing an external database pnk as option of Datastore.