You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Integration Agent: Can a SQL Server database name be parameterized in a Data Source query?

in Planning 1 comment

Hi all,

We have multiple company databases on the same SQL Server instance. Currently we have sperate Application registrations and separate queries for each ccompany

Question: Is there any supported way to use a single Data Source Application and parameterize which SQL Server database is queried at runtime (e.g., via a bind variable)? I've run into issues trying to use bind variables as replacements for similar things in the past (aside for swapping data criteria, period, year etc.) so I assume the answer is no but figured I'd ask…

Thanks!

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!