CData Software - Knowledge Base
Recent Articles
-
Automated ShipStation Data Replication to Teradata
Use CData Sync to Customize and automate ShipStation replication to Teradata.
-
Perform Batch Operations with Google Directory Data in Apache NiFi
Connect to Google Directory and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Connect to Kintone Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Kintone and the SQL Gateway to access Kintone from Google Apps Script.
-
Automated Continuous Intercom Replication to SingleStore
Use CData Sync for automated, continuous, customizable Intercom replication to SingleStore.
-
Choosing the Best Method to Connect Zoho Books to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Zoho Books from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Connect to BigQuery Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Google BigQuery. Leverage the pyodbc module for ODBC in Python.
-
How to connect to Delighted Data from IntelliJ
Integrate connectivity to Delighted with wizards in IntelliJ.
-
Connect to Opsgenie Data in RazorSQL
Connect to Opsgenie from wizards and query Opsgenie from the GUI in the RazorSQL database management tool.
-
How to connect SharePoint with Tally Data through external lists
Provide Tally ERP to SharePoint users as an external list.
-
How to connect to Mocean Data from IntelliJ
Integrate connectivity to Mocean with wizards in IntelliJ.
-
Automated Continuous ZohoSubscriptions Replication to Vertica
Use CData Sync for automated, continuous, customizable ZohoSubscriptions replication to Vertica.
-
Create Tally-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Tally Data from OutSystems and build custom enterprise apps using live Tally ERP.
-
Process & Analyze Attio Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Attio Data.
-
Connect to Mailgun Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Mailgun and the SQL Gateway to access Mailgun from Google Apps Script.
-
Easily Integrate Asana Data in Lazarus Pascal IDE
Learn how to easily integrate live Asana in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Back Up Wistia 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 Wistia data.
-
Integrate Microsoft Planner Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Microsoft Planner and integrate live Microsoft Planner into your Power Automate tasks.
-
Connect to Avaza Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Avaza in the Denodo Virtual DataPort Administrator.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for MailerLite
Provide connectivity to MailerLite through an SAP BusinessObjects universe.
-
Automated Continuous Microsoft Ads Replication to SQLite
Use CData Sync for automated, continuous, customizable Microsoft Ads replication to SQLite.
-
Connect to ElevenLabs Data in Ruby
Connect to ElevenLabs in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Visualize Live Beeminder Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Beeminder.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Placid
Provide connectivity to Placid through an SAP BusinessObjects universe.
-
Connect to SuiteCRM Data in CloverDX (formerly CloverETL)
Transfer SuiteCRM using the visual workflow in the CloverDX data integration tool.
-
Import and Visualize SAP Ariba Procurement Data in Power View
Create data visualizations based on SAP Ariba Procurement in Excel.
-
How to connect to Gumroad Data from IntelliJ
Integrate connectivity to Gumroad with wizards in IntelliJ.
-
Visualize Hacker News Data in Tableau
The CData ODBC driver for Hacker News enables you integrate Hacker News into Tableau dashboards.
-
How to Build an ETL App for GetResponse Data in Python with CData
Create ETL applications and real-time data pipelines for GetResponse in Python with petl.
-
Connect to Odoo Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Odoo ERP.
-
Query FreshBooks Data as a SQL Server Database in Node.js
Execute SQL Server queries against FreshBooks from Node.js.
-
Working with Aircall Data in LINQPad
Execute LINQ queries to Aircall in LINQPad.
-
Load Klaviyo Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Klaviyo to a database.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live ADP within intelligent workflows.
-
Connect to Amplitude Data in NetBeans
Connect to Amplitude in NetBeans with the data source configuration wizard.
-
Visualize ElevenLabs Data in Sisense
Create an ElastiCube in Sisense app with access to ElevenLabs.
-
Access SurveyMonkey Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SurveyMonkey from your Oracle system.
-
Import Real-Time Freshteam Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Freshteam in ColdFusion.
-
Build Dashboards with ConvertAPI Data in DBxtra
Create dynamic dashboards and perform analytics based on ConvertAPI in DBxtra.
-
Connect to Apollo from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Apollo, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Coda
Provide connectivity to Coda through an SAP BusinessObjects universe.
-
Automated Continuous TaxJar Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable TaxJar replication to delimited files (CSV/TSV).
-
Access Lakebase Data from MySQL in Amazon QuickSight
Connect to Lakebase and build visualizations of Lakebase using a MySQL Connection in Amazon QuickSight.
-
Access Live Clari Data in AWS Lambda
Connect to live Clari in AWS Lambda using the CData JDBC Driver.
-
Rapidly Develop Avalara AvaTax-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Avalara AvaTax.
-
Access Live Zoho Inventory Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Zoho Inventory data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Build Agents in Relevance AI with Access to Live Marketo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Marketo within intelligent agent workflows.
-
Create Google Spanner-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Google Spanner Data from OutSystems and build custom enterprise apps using live Google Spanner.
-
Connecting Agentforce with Oracle Service Cloud Data 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 Oracle Service Cloud for you.
-
Validate Webflow Data with QuerySurge
Access and validate Webflow in QuerySurge using the CData JDBC Driver.
-
Build Dashboards with Delighted Data in Dundas BI
Create dynamic dashboards and perform analytics based on Delighted in Dundas BI.
-
Build Hugging Face-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Hugging Face.
-
Visualize Bitbucket Data in TIBCO Spotfire through OData
Integrate Bitbucket into dashboards in TIBCO Spotfire.
-
Automated Continuous Twitter Ads Replication to Vertica
Use CData Sync for automated, continuous, customizable Twitter Ads replication to Vertica.
-
Connect to Amazon Marketplace Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Amazon Marketplace in the Denodo Virtual DataPort Administrator.
-
Connecting Moonlit Workflow with SAP SuccessFactors LMS Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your SAP SuccessFactors LMS in real time.
-
Replicate Azure Data Lake Storage Data to Multiple Databases
Replicate Azure Data Lake Storage to disparate databases with a point-and-click configuration.
-
Create Google Contacts Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Google Contacts from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Amazon Marketplace from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Amazon Marketplace, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Automate ConstantContact Data Replication to Azure Data Lake
Use CData Sync to customize and automate ConstantContact replication to Azure Data Lake.
-
Automated Continuous Cloudflare Replication to MySQL
Use CData Sync for automated, continuous, customizable Cloudflare replication to MySQL.
-
Create Google Drive-Connected Business Apps in AppSheet
Connect to Google Drive Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Google Drive.
-
Feed Pipedrive Data into FineReport
How to set Pipedrive as a JDBC data source in FineReport.
-
Connect to Dynamics CRM Data in Jaspersoft Studio
Execute SQL to remote Microsoft Dynamics CRM in Jaspersoft Studio.
-
Integrate Pipeline CRM with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Pipeline CRM with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Pipeline CRM.
-
Connect to SAP Concur Data in NetBeans
Connect to SAP Concur in NetBeans with the data source configuration wizard.
-
Migrating data from Cosmos DB to Google BigQuery using CData SSIS Components.
Easily push Azure Cosmos DB to Google BigQuery using the CData SSIS Tasks for Cosmos DB and Google BigQuery.
-
How to Query Customer.io Data in MySQL Workbench
Execute MySQL queries against live Customer.io from MySQL Workbench.
-
Create Box-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Box Data from OutSystems and build custom enterprise apps using live Box.
-
How to Build an ETL App for LeadDesk Data in Python with CData
Create ETL applications and real-time data pipelines for LeadDesk in Python with petl.
-
Migrating data from Act-On to Snowflake using CData SSIS Components.
Easily push Act-On to Snowflake using the CData SSIS Tasks for Act-On and Snowflake.
-
Build Odoo-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Odoo to explore live Odoo Data in GitHub Copilot to assist with building Odoo-powered applications.
-
ETL Active Directory in Oracle Data Integrator
This article shows how to transfer Active Directory into a data warehouse using Oracle Data Integrator.
-
How to Connect DBeaver to FreshBooks via a JDBC Driver
Manage FreshBooks with visual tools in DBeaver like the query browser.
-
Automated Continuous Blackbaud FE NXT Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to Google Cloud SQL.
-
Integrate with Hubstaff Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Hubstaff to a JSON file on disk.
-
Connect to Gong Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Gong in Airbyte.
-
How to Connect to Live Sybase Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Sybase for you.
-
Build a PostgreSQL Interface for Stripe Data using the CData JDBC Driver
Use the Remoting features of the Stripe JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Datasets from ZohoDesk in Domo Workbench and Build Visualizations of ZohoDesk Data in Domo
Use the CData Software ODBC Driver for ZohoDesk to create datasets from ZohoDesk in Domo Workbench and then build visualizations in the Domo service.
-
Build Dashboards with Bannerbear Data in DBxtra
Create dynamic dashboards and perform analytics based on Bannerbear in DBxtra.
-
Write a Simple Go Application to work with eBay Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to eBay.
-
Connecting Mastra with SAP SuccessFactors Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time SAP SuccessFactors, no replication required.
-
Connect Sugar CRM to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Sugar CRM using the CData Python MCP Server.
-
Load HubDB Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load HubDB to a database.
-
Visualize Live AdRoll Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live AdRoll.
-
Getting Started with the CData SSIS Components for Everhour
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Everhour.
-
Publish Reports with OnePageCrm Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date OnePageCrm.
-
Extract, Transform, and Load Greenplum Data in Informatica PowerCenter
Create a simple Workflow for Pivotal GreenPlum in Informatica PowerCenter.
-
How to Seamlessly Import MongoDB Data into IBM SPSS Modeler
Integrate MongoDB data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Unbounce Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Unbounce and the SQL Gateway to access Unbounce from Google Apps Script.
-
Build Visualizations of Avro Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Apache Avro in Birst.
-
Access Onfleet Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Onfleet from your Oracle system.
-
Migrating data from OData to Google BigQuery using CData SSIS Components.
Easily push OData to Google BigQuery using the CData SSIS Tasks for OData and Google BigQuery.
-
Getting Started with the CData Tableau Connector for AfterShip
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Access Klaviyo Data from MySQL in PHP
Connect to Klaviyo through the standard MySQL libraries in PHP.
-
Automated Continuous Delighted Replication to Oracle
Use CData Sync for automated, continuous, customizable Delighted replication to Oracle.
-
Connect to Sage 200 Data in DBArtisan
Use wizards in DBArtisan to configure Sage 200 as a data source.
-
Replicate Multiple CapsuleCRM Accounts via the CData Sync CLI
Replicate multiple CapsuleCRM accounts to one or many databases.
-
Automated Continuous Zendesk Replication to Snowflake
Use CData Sync for automated, continuous, customizable Zendesk replication to Snowflake.
-
Access GitHub Data from MySQL in Amazon QuickSight
Connect to GitHub and build visualizations of GitHub using a MySQL Connection in Amazon QuickSight.