Skip to Content
avatar image
Former Member

One Datastore for multiple SQL Server databases?

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Sep 27, 2017 at 02:34 PM

    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/

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 05, 2017 at 01:00 PM

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

    Add comment
    10|10000 characters needed characters exceeded