Skip to Content
0

One Datastore for multiple SQL Server databases?

Sep 26, 2017 at 06:01 PM

62

avatar image
Former Member

Hi, I have multiple SQL Server Databases on one DB Server. I can create multiple datastores to connect to each individual SQLServer DB and can also setup linked server for performance improvement. I want to know if there is any option to connect to multiple SQL Server databases using one datastore?

Thanks

Shashi

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Sep 27, 2017 at 02:34 PM
0

My question to the OP would be , are the source/target table structure the same in all the DBs that you've mentioned? . If the answer is NO , then create one data store for each DB ; otherwise , create one data store and use configurations.Aliasing is of no use in this case.

https://blogs.sap.com/2017/09/08/sap-data-services-configuration-management/

https://blogs.sap.com/2015/01/13/alias-and-their-application-during-runtime/

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Oct 05, 2017 at 01:00 PM
0

Each database has different data. So looks like I have to create multiple Data stores.

Share
10 |10000 characters needed characters left characters exceeded