CData Software - Knowledge Base
Recent Articles
-
Visualize Live GetResponse Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live GetResponse.
-
Getting Started with the CData Excel Add-In for Paymo
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Paymo.
-
Automated Continuous Marketo Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Marketo replication to Apache Cassandra.
-
Automated Continuous Marketo Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Marketo replication to Google BigQuery.
-
Integrate with Discord Data in JReport Designer
Create charts and reports based on Discord in JReport Designer.
-
Configure the CData JDBC Driver for AfterShip in a Connection Pool in Tomcat
Connect to AfterShip from a connection pool in Tomcat.
-
Rapidly Develop MailChimp-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 MailChimp.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for GraphQL
Provide connectivity to GraphQL through an SAP BusinessObjects universe.
-
Integrating Antigravity CLI with ADP via CData CLI
Connect ADP to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Access Pipeline CRM Data from MySQL in PHP
Connect to Pipeline CRM through the standard MySQL libraries in PHP.
-
Automated Raisers Edge NXT Data Replication to Teradata
Use CData Sync to Customize and automate Raisers Edge NXT replication to Teradata.
-
Access Live IBM Cloud Object Storage Data in Coginiti Pro
Connect to and query live IBM Cloud Object Storage from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Import Real-Time SAP Ariba Procurement Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SAP Ariba Procurement in ColdFusion.
-
Build AI Agents with SharePoint Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Microsoft SharePoint through CData Connect AI.
-
Integrating Codex CLI with Mouseflow 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.
-
Explore Geographical Relationships in Teamwork Data with Power Map
Create data visualizations with Teamwork in Power Map.
-
Build Data Flows from Oracle Financials Cloud to SQL Server using SSIS
Easily back up Oracle Financials Cloud to SQL Server using the SSIS components for Oracle Financials Cloud.
-
Use Biml to Build SSIS Tasks to Replicate Adobe Commerce Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Adobe Commerce to SQL Server.
-
How to connect and process Mouseflow from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Mouseflow.
-
How to connect to Insightly Data with Squirrel SQL client
Connect to Insightly and execute queries in the Squirrel SQL Client.
-
Process & Analyze Pipeline CRM Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Pipeline CRM Data.
-
Connect to Sugar CRM Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Sugar CRM as an External Source in Dremio.
-
How to Connect DBeaver to Azure Data Lake Storage via a JDBC Driver
Manage Azure Data Lake Storage with visual tools in DBeaver like the query browser.
-
Replicate Sage Cloud Accounting Data in Heroku for Use in Salesforce Connect
Replicate Sage Business Cloud Accounting to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Creating Certinia-Connected Applications in Unqork
You can use CData Connect AI to feed Certinia to Unqork and build custom business apps.
-
Connect Sugar CRM Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Sugar CRM using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrating LangGraph with SAP Business One Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on SAP Business One within automated workflows.
-
A PostgreSQL Interface for Sybase IQ Data (MySQL Remoting via JDBC)
Use the Remoting features of the Sybase IQ JDBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData ADO.NET Provider for ClickUp
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Access Live SAP Business Warehouse Data in AWS Lambda
Connect to live SAP Business Warehouse in AWS Lambda using the CData JDBC Driver.
-
Establish a Live Connection with Cloudflare Data using Tableau Bridge
The CData ODBC Driver for Cloudflare enables you to integrate live Cloudflare into Tableau Cloud dashboards using the Tableau Bridge.
-
How to work with LaunchDarkly Data in Apache Spark using SQL
Access and process LaunchDarkly Data in Apache Spark using the CData Software JDBC Driver.
-
Build Avro Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Apache Avro and build visualizations in Tableau Cloud.
-
Connect to Recurly Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Recurly as an External Source in Dremio.
-
Publish Crystal Reports on RabbitMQ Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date RabbitMQ.
-
Replicate Multiple Drift Accounts
Replicate multiple Drift accounts to one or many databases.
-
Publish Reports with Act CRM Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Act CRM.
-
Integrating LangGraph with Airtable Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Airtable within automated workflows.
-
Build Data Flows from Hubstaff to SQL Server using SSIS
Easily back up Hubstaff to SQL Server using the SSIS components for Hubstaff.
-
How to Connect to Live MarkLogic 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 MarkLogic for you.
-
Create Dynamic Google Drive Grids Using the Infragistics XamDataGrid
Learn how you can connect Google Drive to Infragistics XamDataGrid to build dynamic grids.
-
Build a Singer.io Tap for Zuora With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Zuora data using
-
Connect to JotForm Data from PowerBuilder via ADO.NET
This article demonstrates how to access JotForm from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect to Workday Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Workday.
-
Edit and Search PostgreSQL External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of PostgreSQL to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create PostgreSQL objects that you can access from apps and the dashboard.
-
How to connect PolyBase to Productboard
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Productboard.
-
How to work with Square Data in Apache Spark using SQL
Access and process Square Data in Apache Spark using the CData Software JDBC Driver.
-
Import Real-Time Pipedrive Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Pipedrive in ColdFusion.
-
Rapidly Develop Tickspot-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 Tickspot.
-
Automated Continuous ShipStation Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable ShipStation replication to Apache Kafka.
-
Visualize Live Trello Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Trello into custom reports in Power BI.
-
Build Dashboards with Pushbullet Data in DBxtra
Create dynamic dashboards and perform analytics based on Pushbullet in DBxtra.
-
Import Real-Time PayPal Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use PayPal in ColdFusion.
-
Use the CData Software ODBC Driver for Sentry in SAS for Real-Time Reporting and Analytics
Connect to real-time Sentry in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Sentry.
-
Integrate with Quaderno Data in JReport Designer
Create charts and reports based on Quaderno in JReport Designer.
-
How to Connect DBeaver to Jumpseller via a JDBC Driver
Manage Jumpseller with visual tools in DBeaver like the query browser.
-
Visualize Live Stack Exchange Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Stack Exchange using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Import and Visualize Shippo Data in Power View
Create data visualizations based on Shippo in Excel.
-
Use the CData Software JDBC Driver for Avalara AvaTax in MicroStrategy
Connect to Avalara AvaTax in MicroStrategy Developer using the CData Software JDBC Driver for Avalara AvaTax.
-
Create Reports from Microsoft Ads Data in Looker Studio
Use CData Connect AI to gain access to live Microsoft Ads and create custom reports in Looker Studio.
-
Create a Data Access Object for Instagram Data using JDBI
A brief overview of creating a SQL Object API for Instagram in JDBI.
-
Query Figshare Data in ColdFusion
Write standard ColdFusion data access code to connect to Figshare.
-
Getting Started with the CData SSIS Components for Reckon Accounts Hosted
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Reckon Accounts Hosted.
-
Excel Spreadsheet Automation on Todoist Data with the QUERY Formula
Pull data from Todoist, automate spreadsheets, and more with the QUERY formula.
-
Integrate Live Exact Online Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Exact Online from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Exact Online.
-
Bridge Bannerbear Connectivity with Apache NiFi
Access and process Bannerbear in Apache NiFi using the CData JDBC Driver.
-
How to create Redshift federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Amazon Redshift in MySQL .
-
Connect to Webex in SpagoBI
Create reports featuring live Webex in SpagoBI Studio. Host Webex reports on SpagoBI Server.
-
Analyze Microsoft Exchange Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Microsoft Exchange and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
How to Easily Query Drift Data in OpenOffice Base
Connect to Drift data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Integrate HCL Domino with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate HCL Domino with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to HCL Domino.
-
How to connect Amazon QuickSight to Box Data
Create a connection to Box in CData Connect AI and insert Box into Amazon QuickSight SPICE to build interactive dashboards.
-
Creating Odoo-Connected Applications in Unqork
You can use CData Connect AI to feed Odoo ERP to Unqork and build custom business apps.
-
Build SAP Netweaver Gateway Visualizations in Tableau Desktop
Use CData Connect AI to connect to live SAP Netweaver Gateway and build visualizations in Tableau.
-
Connect to SAP SuccessFactors LMS Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live SAP SuccessFactors LMS.
-
Visualize ClickUp Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to ClickUp.
-
How to Build an ETL App for ZohoPeople Data in Python with CData
Create ETL applications and real-time data pipelines for ZohoPeople in Python with petl.
-
Integrate NetSuite Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live NetSuite CRM & ERP from Informatica Cloud.
-
How to Connect to Live Zoho CRM Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Zoho CRM through natural language.
-
Access Live Quickbase Data in Coginiti Pro
Connect to and query live Quickbase from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create Informatica Mappings From/To a JDBC Data Source for QuickBooks Time
Create QuickBooks Time data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build Dropbox-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Dropbox Data and create custom apps in Mendix.
-
Connect to Dynamics CRM Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Microsoft Dynamics CRM from Filemaker Pro on Mac.
-
Access Live Gmail Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Gmail from your Google Sheets.
-
Connect to CircleCI Data as an External Source in Dremio
Use the CData JDBC Driver to connect to CircleCI as an External Source in Dremio.
-
Operational Reporting on Webex Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Webex.
-
Connect to and Visualize Live ChargeOver Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live ChargeOver.
-
Enable the Google Directory JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Google Directory.
-
Build Dashboards with Google Drive Data in DBxtra
Create dynamic dashboards and perform analytics based on Google Drive in DBxtra.
-
Connect to ElevenLabs Data in DBeaver
Use the CData ODBC Driver to connect to ElevenLabs in DBeaver.
-
Build Apps with Live Microsoft Planner Data Using the Low-Code Development Platform of Mendix
Connect Microsoft Planner with Mendix to build apps using the CData JDBC Driver for Microsoft Planner.
-
Query, Visualize, and Share live PostgreSQL Data in Redash
Use CData Connect AI to connect to live PostgreSQL in Redash for querying, visualizing, and sharing.
-
Create Dynamic MarkLogic Grids Using the Infragistics XamDataGrid
Learn how you can connect MarkLogic to Infragistics XamDataGrid to build dynamic grids.
-
Use Dash to Build to Web Apps on Omnisend Data
Create Python applications that use pandas and Dash to build Omnisend-connected web apps.
-
A PostgreSQL Interface for Drip Data using the CData ODBC Driver
Use the SQL Gateway and Drip ODBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software ODBC Driver for Omnisend in MicroStrategy Desktop
Connect to Omnisend in MicroStrategy Desktop using the CData Software ODBC Driver for Omnisend.
-
Use the CData Software ODBC Driver for Gong in MicroStrategy Web
Connect to Gong in MicroStrategy Web using the CData Software ODBC Driver for Gong.
-
Use Azure AI Foundry to Talk to Your Avalara AvaTax Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Avalara AvaTax for you.
-
Getting Started with the CData Connect AI Python SDK for Google Ad Manager
Install the CData Connect AI Python SDK to read and write live Google Ad Manager with standard DB-API 2.0 Python code.
-
Connect to Copper Data from a Connection Pool in JBoss
Integrate Copper into Java servlets: Use the Management Console in JBoss to install the Copper JDBC Driver.