CData Software - Knowledge Base
Recent Articles
-
Build Pipelines with Live Paylocity in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Paylocity from Google Cloud Data Fusion, enabling the integration of live Paylocity into the building and management of effective data pipelines.
-
Visualize Cassandra in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Apache Cassandra into TIBCO Spotfire.
-
Import Real-Time OneNote via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Microsoft OneNote in ColdFusion.
-
Integrate with SQL Server in JReport Designer
Create charts and reports based on Microsoft SQL Server in JReport Designer.
-
Consume Avalara AvaTax OData Feeds in PowerBuilder
This article demonstrates how to consume Avalara AvaTax as OData feeds from PowerBuilder using the API Server.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Twitter within intelligent workflows.
-
Automated Continuous TaxJar Replication to SingleStore
Use CData Sync for automated, continuous, customizable TaxJar replication to SingleStore.
-
Create Marketo-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Marketo from Klipfolio and build custom visualizations using live Marketo.
-
Integrate Sage 200 with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Sage 200 with External Services.
-
Automated Continuous Kafka Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Kafka replication to delimited files (CSV/TSV).
-
Back Up Microsoft Excel Online to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Excel Online. In this article, we will employ an SSIS workflow to populate a database with Microsoft Excel Online data.
-
View Reports on Real-Time Box in Power BI Report Server
Use the CData ODBC Driver for Box to visualize Box in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Work with Azure Data Lake Storage in ETL Validator JDBC
Connect to Azure Data Lake Storage from ETL Validator jobs using the CData Software JDBC Driver.
-
Design BIRT Reports on Printify
Provide current Printify to your embedded analytics.
-
Automate BambooHR Replication to SAP HANA
Use CData Sync to customize and automate BambooHR replication to SAP HANA.
-
Bind Live Teradata Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Teradata data
-
Access Live Salesforce in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Salesforce & Force.com into the statistical analysis tools available in SAS JMP. This article shows how to use Salesforce & Force.com in the Graph Builder and Query Builder.
-
How to Connect to Live Active Directory in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Active Directory for you.
-
How to Connect to & Open Cosmos DB in Microsoft Excel
This article uses the CData ODBC driver for Cosmos DB to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous CSV Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable CSV replication to Azure SQL Database.
-
Access Live Twitter in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Twitter from your Excel spreadsheets.
-
Edit and Search External SendGrid Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of SendGrid to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SendGrid objects that you can access from apps and the dashboard.
-
Visualize Live Authorize.Net in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Authorize.Net.
-
Getting Started with the CData SSIS Components for Basecamp
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Basecamp.
-
Consume MariaDB OData Feeds in PowerBuilder
This article demonstrates how to consume MariaDB as OData feeds from PowerBuilder using the API Server.
-
Automated Continuous Xero Replication to Oracle
Use CData Sync for automated, continuous, customizable Xero replication to Oracle.
-
How to Use a Microsoft Access Database to Update SharePoint Excel Services in Real Time
Update SharePoint Excel Services data by creating a linked table in Microsoft Access with the CData SharePoint Excel Services ODBC Driver.
-
Automated Continuous Dynamics CRM Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Dynamics CRM replication to IBM DB2.
-
Query Gmail as a MySQL Database in Node.js
Execute MySQL queries against Gmail from Node.js.
-
Connect to Zoho Creator in Claris FileMaker Pro
-