Skip to main content
To homepage To homepage
Question

Dynamic variables in TimeXtender OData Data Source (1.4.1) Classic

  • September 21, 2026
  • 1 reply
  • 25 views
Participant

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 = ...

 

 

    1 reply

    Thomas Lind
    Community Manager
    Forum|alt.badge.img+5
    • Thomas Lind
    • Community Manager
    • September 22, 2026

    Hi ​@annfoss

    You can use dynamic variables in custom selection rules, but the variables aren’t accessible inside the setup.

    So it doesn’t seem like you can add these variables in the connection string.

    If you have multiple environments, you can make the data source run as a global data source.

    The downside is that the data source is completely unique for each environment, so you will have t manually make it the same in each environment.

    For example, this is the Prod version of the above data source.

     

    Terms and ConditionsAccessibility statement