In TimeXtender Classic (v20.10), it is possible to add additional connections. This is a very powerful feature that many of our customers are using.
It is especially useful when you have many similar data sources (such as NAV/BC or Exact software). In our customer base, it is often the case that there is a separate database for each country, region, or office. Some of these customers frequently acquire new companies or open new offices. In such cases, these data sources can easily be added to the main data source connection. The transformations then also apply to these sources, all the way up to the semantic layers.
In TDI, we do not have this option, even though it is a very powerful feature. For some of our customers, this is the only reason holding them back from migrating from Classic to TDI.
A possible workaround in TDI could be to clone the data sources and adjust some settings. However, in that case, all tables still need to be mapped to the Prepare instance. You then have two options:
- Manually map all tables: You can use smart mapping, but it still requires a lot of work.
- Use mapping sets: This can be a very powerful feature, but in the current setup, you need to manually synchronize all mapping sets for all tables.
An option to synchronize all mapping sets at once could also be a solution. Alternatively, and perhaps preferably, it would be great to have the ability to create additional connections in TDI as well.
