Skip to main content

Find CData connectors in TimeXtender Classic solutions

  • January 18, 2026
  • 3 replies
  • 43 views

Søren Sørensen
Contributor
Forum|alt.badge.img+1

CData is imposing a monthly fee on customers that use their connectors after 5 March 2026.

It’s easy to switch to TimeXtender connectors but it can be a tedious process in larger solutions with many projects to find those connectors.

Here’s a query you can run against the project repository to get a list of currently used connectors:

/***** Current CData Usage *****/
select p.Name as Project
      ,s.Name as DataSource
      ,left(stuff(c.ProviderName, 1, 18, ''), charindex('.', stuff(c.ProviderName, 1, 18, '')) - 1) as Provider
  from CDataDataSources c
  inner join DataSources s on c.CDataDataSourceId = s.DataSourceId and s.ValidTo = 99999999
  inner join BusinessUnits b on s.BusinessUnitId = b.BusinessUnitId and b.ValidTo = 99999999
  inner join Projects p on b.ProjectId = p.ProjectId and p.ValidTo = 99999999
  where c.ValidTo = 99999999
  order by 1, 2

3 replies

  • Problem Solver
  • January 19, 2026

Nice! A similar query was posted here: 

 


rvgfox
Problem Solver
Forum|alt.badge.img+4
  • Problem Solver
  • January 22, 2026

How can we do it in SAS versions?


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

Hi ​@rvgfox 

Same way. You just need to turn on 

It allows you access to the repositories content and you will be able to run the same query against the tables used for this.

I can see I was a bit fast.
You can see all data sources, but a specific CDataDatasources table does not exist.

The info you want exists in the 

Global_DataSourceConnections table