Solutions & Use Cases

Ruby Lang Logo
June 14, 2017

Building Data-Driven Apps with Ruby

Ruby provides natural (but complex) development features in a free, flexible platform for creating expressive Web applications. Our ODBC drivers offer simplified access to your data, allowing you to write SQL-92 queries to work with data from any of the 80+ supported sources. By utilizing...

ODBC Connectivity in MS Excel for Mac
June 8, 2017

ODBC Connectivity in MS Excel for Mac

Earlier this year we announced the release of our ODBC Drivers for Mac and Linux/UNIX environments. With the ability to install our drivers on virtually any environment, you gain greatly expanded flexibility and functionality. For instance, you can now work with data from 80+ sources in M...

 New Embedded Tunneling Support in API Server
May 24, 2017

New Embedded Tunneling Support in API Server

The API Server has been enhanced with built-in 'Cloud Gateway' tunneling functionality. This powerful new capability allows users of API Server to create a secure reverse tunnel to any publicly accessible host, allowing external clients to connect to your on-premises API Server data behin...

Node-RED logo
May 23, 2017

Connect Node-RED to API Server and Let Your Data Flow

Node-RED is a flow-based programming tool, built around JavaScript. With it, you can build applications using in a drag-and-drop interface to control the flow of data to and from a variety of sources, from IoT devices to APIs and online services. When paired with the API Server , which bu...

API Server security operations
May 18, 2017

API Server Overview: REST APIs for Your Data

The API Server allows you to build a single, uniform REST API for your company's data, which is often stored in dozens of on-premises and Web-based sources, ranging from traditional databases and applications (like QuickBooks and Microsoft Excel) to SaaS and other cloud-based data sources...

React & D3 logos
April 4, 2017

React & D3.js + API Server: Dynamic Data Apps

React D3.js + API Server: Dynamic Data Apps The CData API Server provides users with a quick and easy way to create uniform APIs from any of the 80+ supported RDBMS, NoSQL, and SaaS data sources. Since many popular JavaScript frameworks (like React and D3 ) are capable of consuming OData, ...

Strategies to Mitigate SaaS Service Interruption
March 8, 2017

Strategies to Mitigate SaaS Service Interruption

Consistent data access is critical to data-driven applications and services. However, unlike RDBMS operations or flat file integration, SaaS service integration relies heavily on network connectivity. As we all know, networks are subject to certain issues - DNS failures, network configura...

January 25, 2017

Angular2 + API Server: Dynamic Database Apps

The API Server provides users with a quick and easy way to create REST APIs to access your database, whether your database is hosted on-premises or in the cloud. Since Angular2 can natively consume OData, you can easily build dynamic Web apps based on your databases using Angular2 with th...

Dundas Logo
November 16, 2016

Connect to More Data in Dundas BI

Earlier this week, Dundas published a blog article featuring our ODBC Driver for JSON. By connecting to data in Dundas BI using our ODBC Drivers, users are able to utilize a single and unified experience across all data sources and all devices, providing full functionality and faster perf...

Using AngularJS to Build Dynamic Web Pages with Salesforce.com Data
October 13, 2016

Using AngularJS to Build Dynamic Web Pages with Salesforce.com Data

Since the publication of this article, we have bundled our OData Connectors into a single product, called API Server, which allows you to easily build RESTful APIs (including OData) for your data. The connectivity principles outlined below still hold. Learn more. AngularJS (Angular) is a ...

Power BI logo
August 18, 2016

Power BI Data Gateway: How to Connect and Access Data

Do you have on-premises or cloud-based data that you would love to access from Power BI (or any of the new Microsoft workflow tools like PowerApps, Azure Logic Apps, and Flow)? CData Drivers are just the tools for you. Paired with the Microsoft Power BI Gateway, the CData JDBC and ODBC Drivers and CData Sync let you access your data exactly where you want.

Replicating NetSuite Data for Use in Tableau
August 11, 2016

Replicating NetSuite Data for Use in Tableau

As a NetSuite user, you may want to use data visualization tools beyond those offered directly by NetSuite, or you may want to create visualizations that combine your NetSuite data with data from another source. CData Software can help with both situations. With the Sync Application for N...