CData Software Knowledge Base

Design BIRT Reports on Asana

Provide current Asana to your embedded analytics.

Use the CData Software ODBC Driver for Instagram in MicroStrategy Desktop

Connect to Instagram in MicroStrategy Desktop using the CData Software ODBC Driver for Instagram.

Integrate with Salesforce Pardot using Apache Camel2

Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Salesforce Pardot to a JSON file on disk.

Work with Dynamics 365 Business Central in FoxPro

Load Dynamics 365 Business Central into a FoxPro database. This article includes full code and a walk-through of the process.

Analyze Sybase IQ in R via JDBC

Use standard R functions and the development environment of your choice to analyze Sybase IQ with the CData JDBC Driver for Sybase IQ.

How to import Google Campaign Manager 360 into Apache Solr

Use the CData Software JDBC Driver for Google Campaign Manager 360 in Data Import Handler and create an automated import of Google Campaign Manager 360 to Apache Solr Enterprise Search platform.

PowerShell Scripting to Replicate QuickBooks to MySQL

Write a simple PowerShell script to replicate QuickBooks Desktop to a MySQL database.

Automated Continuous Vertica Replication to SQL Server

Use CData Sync for automated, continuous, customizable Vertica replication to SQL Server.

LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Oracle Data Provider.

Create OData-Connected Applications in Appsmith

Connect to OData Services via CData Connect Cloud in Appsmith and create custom business applications with real-time access to OData.

Query FHIR as a SQL Server Database in Node.js

Execute SQL Server queries against FHIR from Node.js.

Connect to SingleStore from Asprova with CData Software ODBC Driver for SingleStore

This article shows how to connect faster to SingleStore data from Asprova.

Configure the CData JDBC Driver for JDBC-ODBC Bridge in a Connection Pool in Tomcat

Connect to JDBC-ODBC Bridge from a connection pool in Tomcat.

Analyze Amazon Athena in SAP Analytics Cloud

Use CData Connect Cloud to create an OData API on top of Amazon Athena and visualize Amazon Athena in SAP Analytics Cloud.

Connect to Twilio from PowerBuilder via ADO.NET

This article demonstrates how to access Twilio from Appeon PowerBuilder using the CData ADO.NET Provider for Twilio.

Use the CData Software JDBC Driver for Typeform in MicroStrategy Desktop

Connect to Typeform in MicroStrategy Desktop using the CData Software JDBC Driver for Typeform.

Build Data Flows from SQL Server to IBM Informix through SSIS

Easily push SQL Server data to IBM Informix using the CData SSIS Tasks for IBM Informix.

How to Connect to & Open Microsoft Planner in Microsoft Excel

This article uses the CData ODBC driver for Microsoft Planner to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

Analyze MailChimp with Power Pivot

This article walks you through the process of using the CData ODBC Driver for MailChimp from Power Pivot. You will use the Table Import Wizard to load MailChimp. You can visually build the import query or use any SQL supported by the driver.

Feed SAP Ariba Source into FineReport

How to set SAP Ariba Source as a JDBC data source in FineReport.

How to Use a Microsoft Access Database to Update Zoho Inventory in Real Time

Update Zoho Inventory data by creating a linked table in Microsoft Access with the CData Zoho Inventory ODBC Driver.

Use Dash to Build to Web Apps on Phoenix

Create Python applications that use pandas and Dash to build Phoenix-connected web apps.

Connect to Zoom from a Connection Pool in JBoss

Integrate Zoom into Java servlets: Use the Management Console in JBoss to install the Zoom JDBC Driver.

Integrate CSV in the Pentaho Report Designer

Publish reports based on CSV/TSV Files in the Pentaho BI tool.

Build Cloudant-Connected Dashboards Using Zoho Analytics

Use CData Connect Cloud to connect to Cloudant from Zoho Analytics and import live IBM Cloudant.

Prepare, Blend, and Analyze Oracle in Alteryx Designer (ODBC)

Build workflows to access live Oracle Database for self-service data analytics.

How to Build an ETL App for Oracle Eloqua in Python with CData

Create ETL applications and real-time data pipelines for Oracle Eloqua in Python with petl.

Query ADP through ODBC in Node.js

Use node-odbc to execute SQL queries against ADP from Node.js.

How to Query Live HDFS in Claude Desktop

Connect to and query live HDFS in Claude Desktop using the CData MCP Server.

Consume Trello OData Feeds in SAP Lumira

Use the API Server to create data visualizations on Trello feeds that reflect any changes in SAP Lumira.

Integrate with Stripe in JReport Designer

Create charts and reports based on Stripe in JReport Designer.

Import Google Search Results into Microsoft Power Query

The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Google Search. In this article, you will use the OData format to import Google Search into Microsoft Power Query.

Natively Connect to Avalara AvaTax in PHP via ODBC (Linux)

Create PHP applications on Linux/UNIX machines with connectivity to Avalara AvaTax. Leverage the native support for ODBC in PHP.

How to Import Data from Airtable into Google Sheets

Import Airtable into a Google spreadsheet that is automatically refreshed.

Extract, Transform, and Load Zoho CRM in Informatica PowerCenter

Create a simple Workflow for Zoho CRM in Informatica PowerCenter.

Replicate Google Data Catalog from PowerShell

Write a quick PowerShell script to query Google Data Catalog. Use connectivity to the live data to replicate Google Data Catalog to SQL Server.

Create Reports with Google Search Results in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Google Search.

Build a PostgreSQL Interface for Azure Analysis Services using the CData JDBC Driver

Use the Remoting features of the Azure Analysis Services JDBC Driver to create a PostgreSQL entry-point for data access.

Connect MailChimp to AI Assistants With the CData Python MCP Server

Learn how to give AI assistants like Claude direct access to live MailChimp using the CData Python MCP Server.

CData Software - Knowledge Base

Recent Articles