Hi,
I have created an endpoint in my TimeXtender OData Data Source (provider version 1.4.1). I am currently using TimeXtender version 20.10.74.64.
The endpoint supports incremental loading by applying a filter such as lastModifiedDateTime gt .... For the input variables, I use a Dynamic Value SQL query.
We have three separate environments,Development, Test, and Production, hosted on different servers. The current environment is available through the TimeXtender variable vEnvironment.
Is it possible to use a dynamic variable, such as vEnvironment, in the connection string to select the appropriate server?
For example something like this?
Server = $(vEnvironment);
Initial Catalog = ODX;
Persist Security Info = ...
