Follow

Add a CData data source

Author: Thomas Lind Last updated:
Data Source CData

Since the 18.6.1 release it has been possible to use all available ADO.Net versions of CData.

They provide the ability to access a wide array of different data sources. Some of the data sources are already available as a normal adapter, so you may choose to use those instead.

Contents

Specific CData provider setup

Here are the links to the specific CData setup guides. You will need to go through the Initial setup before you attempt to go through these.

If the CData provider doesn't have a guide here, a good start is to click the ? button. This will show you CData's own setup guide.

Initial setup

Add the first provider

You can add a CData data source by right clicking on the data sources and choosing Add CData Data Source.

1.PNG

The first time you do this you will be presented with this menu.

2.PNG

After you click on Yes you will get this menu. Here you can see the providers you have installed.

3.PNG

When you press Add.. you will be presented with the list of CData providers. You can choose multiple providers at once.

4.PNG

Following this you can add these as a CData data source. The available providers can be seen in the providers drop-down menu.

5.PNG

Add more providers

If you want to add more CData providers following the first attempt you can open the Manage CData Providers menu here.

6.PNG

If there is new versions of a provider you will be able to upgrade it here. The status will be Needs to be Updated and the Update button wont be grayed out.

7.PNG

Add a old version of a provider

You can also choose to not update it and add the same provider again, but in another edition. This makes the change from one edition to the other easier, as you can copy the connection string in the old version, change the edition to the new one and add the connection string to that. If there is no issues following this, you can delete the old edition in the Manage CData Providers menu.

If you for some reason need an older version of a CData connector than the one you have, we now provide this possiblity.

Capture.PNG

1.PNG

Then you can choose an specific edition when adding a data source.

2.PNG

Was this article helpful?
1 out of 1 found this helpful

4 Comments

Date Votes
  • 0
    Avatar
    Thomas Lind

    Hi

    If you have a specific data source that CData provides, that still doesn't have a guide. Write a request to support@timextender.com and we will make one. To make it easier it would be nice if we got some test data as well.

    Regards

    Thomas Lind

  • 0
    Avatar
    CalmCo Support

    In terms of licensing, do we need to buy our own license from CData?

  • 1
    Avatar
    Thomas Lind

    We have recently made a deal with the CData company, so we can provide all sources to our customers free of charge. The feature is part of all licenses.

    So now all licenses contain the CData data sources. All 90+ providers is available right away.

    As stated above you do have to upgrade to at least 18.6.1 to see them.

    Additionally none of the already existing providers will be deprecated. Our own developed connectors is often preferable.
    CData should generally be used where we don't already have a connector.

  • 0
    Avatar
    Hansen, Mikkel Hecht DK - NOH

    Hi,

     

    Is it possible to import multiple CSV Files into one tabel using a condition like: DATA_Actuals*.csv ?

     

Please sign in to leave a comment.