Note: There is an updated version of this article, which applies to the next generation of TimeXtender.

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.