Warning: TimeXtender no longer supports or distributes CData providers. In version 20.10.62 and above, new TimeXtender Enhanced providers are available. CData providers will continue to work on machines where they are installed, but we recommend that you upgrade to the TimeXtender-branded providers.
If you delete an existing provider, TimeXtender can no longer distribute a new file to you. Do not attempt to update a CData provider as deleting the existing file will succeed, but downloading the new provider will fail.
If you're running TimeXtender 20.10.57 or older with the ODX, a workaround is required to add a new data source that uses a CData provider installed on your local machine:
1) Go to Manage Data Source Providers and add the "TimeXtender CData Placeholder" provider. It's an empty provider we've added to enable this workaround.
2) Add a new data source using the provider you just downloaded.
3) Edit the new data source and choose to provider you actually want to use in the Provider list.

CData Data Source

A CData Data Source uses a provider from CData to connect to a wide variety of data sources. In this section, you can learn how to add a CData data source. For help with configuring the individual providers, see our support site at https://support.timextender.com and CData's help site at cdata.com/kb/help/

Managing Data Source Providers

CData providers can be downloaded and installed from an online library using the Manage CData Providers tool. You can also use the tool to update a provider to the newest version or delete it.

To open the Manage CData Providers tool

• In the Tools menu, click Manage Data Source Providers.

To add a new provider, follow the steps below.

1. Open the Manage Data Source Providers
2. Click Add... OR click Add Specific Versions... from the Add list if you want to add a version of a provider other than the latest
3. Select the providers you want to install and click OK. The required files will be download and installed.
4. Click OK to close the tool.

To update a provider

• Open the tool, select a provider with Update Available in the Status column and click Update.

Note: You can have multiple major versions of the same provider installed, but only one minor version within each major version.

To delete a provider

• Open the tool, select a provider and click Delete.

Providers are downloaded to the folder listed in the Component Path box in the Manage CData Providers window.

To change the component path

• Click ... (browse), navigate to new folder and click OK.

Warning: If you change the component path while you have providers installed, you will have to reinstall these providers.

Adding and Synchronizing A Data Source

To add a new data source, follow the steps below.

1. Open a business unit, right click Data Sources, click Data Sources and then click Add CData Data Source.
2. In the Name box, type the name you want to use for the source.
3. In the Provider list, click on the provider you want to use.
4. In the property grid, enter the information required to connect to the data source.
5. Click OK to add the data source.