CData Software - Knowledge Base
Recent Articles
-
A PostgreSQL Interface for Asana using the CData ODBC Driver
Use the SQL Gateway and Asana ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to SAP Ariba Procurement from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from SAP Ariba Procurement, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to Invoiced in Aqua Data Studio
Access Invoiced from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrate WordPress in Pentaho Data Integration
Build ETL pipelines based on WordPress in the Pentaho Data Integration tool.
-
Manage Xero in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Xero.
-
Building Dynamic Web Pages with Sugar CRM Using AngularJS
Create single-page applications with live connectivity to Sugar CRM using the CData API Server.
-
Manage Sybase IQ in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Sybase IQ.
-
Connect to LinkedIn from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from LinkedIn, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Create Power BI Reports on Real-Time Snowflake
Use the CData ODBC Driver for Snowflake to visualize Snowflake in Power BI Desktop.
-
A PostgreSQL Interface for Oracle (MySQL Remoting via JDBC)
Use the Remoting features of the Oracle JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Informatica Mappings From/To an ODBC Data Source for QuickBooks Online
Create an ODBC connection to QuickBooks Online in Informatica and browse and transfer QuickBooks Online.
-
Access Live ActiveCampaign in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live ActiveCampaign from your Excel spreadsheets.
-
Automated Access Replication to Teradata
Use CData Sync to Customize and automate Microsoft Access replication to Teradata.
-
Integrating Claude Code with Salesforce via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Salesforce & Force.com within assisted coding and automated development workflows.
-
Connecting Agentforce with Microsoft Dataverse via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Microsoft Dataverse (CDS) for you.
-
Connect to Avalara AvaTax in Jaspersoft Studio
Execute SQL to remote Avalara AvaTax in Jaspersoft Studio.
-
Work with ADP in FoxPro
Load ADP into a FoxPro database. This article includes full code and a walk-through of the process.
-
Visualize CSV in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load CSV/TSV Files into TIBCO Spotfire.
-
DataBind Controls to Klaviyo in Delphi
DataBind to Klaviyo in Delphi with standard data access components and controls.
-
Integrate with Microsoft Teams in SnapLogic
Use CData Connect AI to connect to and integrate with live Microsoft Teams in SnapLogic.
-
Bridge Snapchat Ads Connectivity with Apache NiFi
Access and process Snapchat Ads in Apache NiFi using the CData JDBC Driver.
-
Query CSV from Node.js
Use the OData endpoint of the CData API Server to connect to your CSV/TSV Files and perform CRUD operations on CSV from Node.js.
-
Create Apps from Microsoft Exchange in Qlik Sense Cloud
Use CData Connect AI to connect to Microsoft Exchange and build apps from live Microsoft Exchange in Qlik Sense Cloud.
-
Automated Continuous IBM Cloud Object Storage Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable IBM Cloud Object Storage replication to delimited files (CSV/TSV).
-
Query Twilio as a SQL Server Database in Node.js
Execute SQL Server queries against Twilio from Node.js.
-
Replicate Multiple SQL Server Accounts via the CData Sync CLI
Replicate multiple SQL Server accounts to one or many databases.
-
Use Databricks Agent Bricks to Talk to Your Snowflake via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Snowflake for you.
-
Getting Started with the CData Power BI Connector for Microsoft Dataverse
-