CData Software - Knowledge Base
Recent Articles
-
Load Zoho Books Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Zoho Books data to a database.
-
Design BIRT Reports on HelloSign Data
Provide current HelloSign data to your embedded analytics.
-
How to Connect the Power BI Service to Clockify: Complete Guide
Connect to the CData Software Power BI Connector for Clockify from PowerBI.com to provide real-time Clockify data across the organization.
-
Automated Continuous RabbitMQ Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable RabbitMQ replication to Amazon Redshift.
-
How to connect to Access Data in DBVisualizer
Integrate Access data with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect Amazon DynamoDB to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Amazon DynamoDB with IBM WebSphere for seamless data integration and connectivity.
-
Integrate Billsby Data in the Pentaho Report Designer
Publish reports based on Billsby data in the Pentaho BI tool.
-
Automated Continuous Clockify Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Clockify data replication to OneLake in Microsoft Fabric.
-
Integrate Cursor with Live Sage 300 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Sage 300 data from within the editor.
-
Connect to Missive from Asprova with CData Software ODBC Driver for Missive
This article shows how to connect faster to Missive data from Asprova.
-
Getting Started with the CData JDBC Driver for Sage Cloud Accounting
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Sage Cloud Accounting.
-
Visualize Vimeo Data in TIBCO Spotfire through ADO.NET
Integrate Vimeo data into dashboards in TIBCO Spotfire.
-
Add Couchbase Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Couchbase with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build Sage Cloud Accounting Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Sage Cloud Accounting data and build visualizations in Tableau.
-
Integrate with Wrike Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Wrike data to a JSON file on disk.
-
Query Contentful Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Contentful data from Node.js.
-
Access Oracle Eloqua Data from MySQL in Amazon QuickSight
Connect to Oracle Eloqua and build visualizations of Oracle Eloqua data using a MySQL Connection in Amazon QuickSight.
-
Build Notion Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Notion data and build visualizations in Tableau.
-
Import IBM Informix Data Using Azure Data Factory
Use CData Connect AI to connect to IBM Informix Data from Azure Data Factory and import live IBM Informix data.
-
Connect to Aircall Data from a Connection Pool in Jetty
The Aircall JDBC Driver supports connection pooling: This article shows how to connect faster to Aircall data from Web apps in Jetty.
-
Back Up Invoiced data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Invoiced data data.
-
Replicate Multiple Oracle Eloqua Accounts via the CData Sync CLI
Replicate multiple Oracle Eloqua accounts to one or many databases.
-
Build a Singer.io Tap for ClickUp With the CData Python Connector
Learn how to easily build a Singer.io Tap for live ClickUp data using the CData Python Connector.
-
Use Manus AI to Talk to Your ConstantContact Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on ConstantContact data.
-
Build MVC Applications with Connectivity to Toggl Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Toggl from an ASP.NET MVC application.
-
Build Pipedrive-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Pipedrive data without replication.
-
Getting Started with the CData ADO.NET Provider for Facebook
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Facebook.
-
Integrating Gumloop with Microsoft Entra ID Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Microsoft Entra ID data within automated workflows.
-
DataBind Controls to Amplitude Data in C++Builder
DataBind to Amplitude data in C++Builder with standard components and controls.
-
Connect to Live HDFS Data in PostGresSQL Interface through CData Connect AI
Create a live connection to HDFS in CData Connect AI and connect to your HDFS data from PostgreSQL.
-
Excel Spreadsheet Automation on QuickBooks Time Data with the QUERY Formula
Pull data from QuickBooks Time, automate spreadsheets, and more with the QUERY formula.
-
How to create an RPA flow for GraphQL Data in UiPath Studio
Use the GraphQL ODBC Driver to create workflows that access real-time GraphQL data without any coding.
-
Integrating Gumloop with Yelp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Yelp data within automated workflows.
-
Use the CData Software ODBC Driver for Pipeline CRM in SAS for Real-Time Reporting and Analytics
Connect to real-time Pipeline CRM data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Pipeline CRM.
-
Automated Continuous Azure Blob Storage Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Azure Blob Storage data replication to OneLake in Microsoft Fabric.
-
Connect to SendInBlue Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to SendInBlue and work with SendInBlue data in your FileMaker applications.
-
Build MailChimp-Connected Apps in Choreo
Use CData Connect AI to connect to MailChimp Data from Choreo and build custom apps using live MailChimp data.
-
How to update Cassandra from Excel
This article explains how to transfer data from Excel to Cassandra using the Excel Add-In for Cassandra.
-
Create Informatica Mappings From/To a JDBC Data Source for Parquet
Create Parquet data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Getting Started with the CData SSIS Components for SparkPost
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SparkPost.
-
Publish Pinterest-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Pinterest data.
-
Configure the CData JDBC Driver for Sage Intacct in a Connection Pool in Tomcat
Connect to Sage Intacct data from a connection pool in Tomcat.
-
Import Real-Time Codat Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Codat data in ColdFusion.
-
How to update Freshdesk from Excel
This article explains how to transfer data from Excel to Freshdesk using the Excel Add-In for Freshdesk.
-
How to Connect to Live Cvent Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Cvent data for you.
-
Query Google Drive Data in DataGrip
Create a Data Source for Google Drive in DataGrip and use SQL to query live Google Drive data.
-
Analyze Salesforce Marketing Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Salesforce Marketing data with the CData JDBC Driver for Salesforce Marketing.
-
Use Databricks Agent Bricks to Talk to Your Jumpseller Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Jumpseller data for you.
-
Access iContact Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access iContact data from your Oracle system.
-
Connect to Power BI XMLA Data in RazorSQL
Connect to Power BI XMLA from wizards and query Power BI XMLA data from the GUI in the RazorSQL database management tool.
-
Create Sage 300 Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Sage 300 data access from reports, embedded analytics, and more.
-
Connect to Planio Data in DBArtisan
Use wizards in DBArtisan to configure Planio data as a data source.
-
Access Salesforce CRM Analytics Data from MySQL in PHP
Connect to Salesforce CRM Analytics through the standard MySQL libraries in PHP.
-
Extract, Transform, and Load Reply.io Data in Informatica PowerCenter
Create a simple Workflow for Reply.io data in Informatica PowerCenter.
-
Connect and Visualize Live HBase Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live HBase data into the Databricks platform and create visualization dashboards with real-time HBase data.
-
Connect to Square Data from AWS Glue
Use CData Connect AI to gain access to live Square data from your AWS Glue jobs.
-
Create Informatica Mappings From/To a JDBC Data Source for iContact
Create iContact data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrate Cursor with Live Apollo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Apollo data from within the editor.
-
Query NetSuite Data as a SQL Server Database in Node.js
Execute SQL Server queries against NetSuite data from Node.js.
-
Connecting GenSpark with ZohoPeople Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to ZohoPeople data without any replication or custom integration required.
-
Connect to SAP Netweaver Gateway Data in CloverDX (formerly CloverETL)
Transfer SAP Netweaver Gateway data using the visual workflow in the CloverDX data integration tool.
-
Use Dash to Build to Web Apps on MailerLite Data
Create Python applications that use pandas and Dash to build MailerLite-connected web apps.
-
Access Salesforce Data from MySQL in Amazon QuickSight
Connect to Salesforce and build visualizations of Salesforce data using a MySQL Connection in Amazon QuickSight.
-
Analyze Google Campaign Manager 360 Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Google Campaign Manager 360 data with the CData JDBC Driver for Google Campaign Manager 360.
-
Visualize Active Directory Data in Tableau
The CData ODBC driver for Active Directory enables you integrate Active Directory data into Tableau dashboards.
-
Integrating Kiro with Pipedrive Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Getting Started with the CData Python Connector for Harvest
Learn to install and license the CData Python Connector and configure a connection to live Harvest data.
-
Integrate Dify with Live SAP HANA XS Advanced Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live SAP HANA XS Advanced data.
-
Query Insightly Data as a MySQL Database in Node.js
Execute MySQL queries against Insightly data from Node.js.
-
Getting Started with the CData Power BI Connector for Timely
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Analyze Live Okta Data in SAS Viya
Use CData Connect AI to connect to Okta data from SAS Viya and deploy self-service analytics using live Okta data.
-
Connect to Tally Data in Ruby
Connect to Tally data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automate Dynamics CRM Data Replication to Azure Synapse
Use CData Sync to customize and automate Dynamics CRM data replication to Azure Synapse.
-
Integrate Theia IDE with Live Xero Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Xero data from within the development environment.
-
Connect to Pipeline CRM Data from a Connection Pool in Jetty
The Pipeline CRM JDBC Driver supports connection pooling: This article shows how to connect faster to Pipeline CRM data from Web apps in Jetty.
-
Create Reports from Shortcut Data in Looker Studio
Use CData Connect AI to gain access to live Shortcut data and create custom reports in Looker Studio.
-
How to Work with Autopilot Data in ETL Validator JDBC
Connect to Autopilot from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Zoho Projects Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Zoho Projects replication to Amazon S3.
-
Integrating LangGraph with Google Calendar Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Google Calendar data within automated workflows.
-
Automated Continuous Zoho CRM Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Zoho CRM replication to delimited files (CSV/TSV).
-
Build Smartsheet-Connected Apps in Choreo
Use CData Connect AI to connect to Smartsheet Data from Choreo and build custom apps using live Smartsheet data.
-
Create Samanage-Connected Applications in Appsmith
Connect to Samanage Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Samanage data.
-
Easily Integrate OData Services in Lazarus Pascal IDE
Learn how to easily integrate live OData services in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous Paylocity Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Paylocity replication to Google BigQuery.
-
Getting Started with the CData Python Connector for Beeminder
Learn to install and license the CData Python Connector and configure a connection to live Beeminder data.
-
Getting Started with the CData Excel Add-In for Hubstaff
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Hubstaff.
-
Automated Continuous Sage 200 Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Sage 200 replication to Amazon S3.
-
Search External Mailjet Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Mailjet data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Mailjet Data objects that you can access from apps and the dashboard.
-
Prepare, Blend, and Analyze ClickTime Data in Alteryx Designer (ODBC)
Build workflows to access live ClickTime data for self-service data analytics.
-
Prepare, Blend, and Analyze MailChimp Data in Alteryx Designer (Connect AI)
Build workflows to access live MailChimp data for self-service data analytics.
-
How to Seamlessly Import Attio Data into IBM SPSS Modeler
Integrate Attio data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automated Continuous Salesforce Replication to MySQL
Use CData Sync for automated, continuous, customizable Salesforce replication to MySQL.
-
Use the CData Software JDBC Driver for Act CRM in MicroStrategy
Connect to Act CRM data in MicroStrategy Developer using the CData Software JDBC Driver for Act CRM.
-
Getting Started with the CData Power BI Connector for Presto
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Presto.
-
Automated Continuous Missive Replication to Snowflake
Use CData Sync for automated, continuous, customizable Missive replication to Snowflake.
-
How to create Bitbucket federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Bitbucket data in MySQL .
-
Connect to SageHR Data in Ruby
Connect to SageHR data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Everhour Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Everhour data using standard SQL.
-
Build Data Flows from Pushbullet to SQL Server using SSIS
Easily back up Pushbullet data to SQL Server using the SSIS components for Pushbullet.
-
Analyze Cosmos DB Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Cosmos DB from Power Pivot. You will use the Table Import Wizard to load Cosmos DB data. You can visually build the import query or use any SQL supported by the driver.