Caching Data Source Metadata with CData Provider

The CData provider can cache retrieved data in a local file or an external database depending on your connection string configuration. It can cache not only the data but also the data source tables metadata information.


When you specify

Cache Metadata=True;

in your connection string and you also have the Cache Location or Cache Connection and Cache Provider set, the table metadata will also be cached. The next time a connection is made with the same connection string, the metadata will be read from the cache instead of retrieving it from the data source. This is much faster.

However, bear in mind that you will not see any updates to the table's schema definition since you created the cache.


This feature is only applicable for data sources where the CData provider uses dynamically retrieved schema definitions. Those includes SharePoint and Excel.


Articlesread all »

Not what you were looking for?

Browse the other articles in the knowledge base!

Or search kb articles, Q&A content and every connection string here.

Start over in the connection string reference or check out the Q&A forums where you can ask your own questions!