CData Software - Knowledge Base
Recent Articles
-
Use JayDeBeApi to access Pinterest Data in Python
Use standard Python scripting and the development environment of your choice to access live Pinterest.
-
How to Query Sage 300 Data in MySQL Workbench
Execute MySQL queries against live Sage 300 from MySQL Workbench.
-
Query Live Klaviyo Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Klaviyo directly from the development environment.
-
Create Dynamic Adobe Commerce Grids Using the Infragistics XamDataGrid
Learn how you can connect Adobe Commerce to Infragistics XamDataGrid to build dynamic grids.
-
Excel Spreadsheet Automation on LDAP Objects with the QUERY Formula
Pull data from LDAP, automate spreadsheets, and more with the QUERY formula.
-
Getting Started with the CData JDBC Driver for Freshdesk
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Freshdesk.
-
Visualize Live SAP SuccessFactors LMS Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SAP SuccessFactors LMS using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Viewing HelloSign Data in RAD Studio Data Explorer
How to view HelloSign in RAD Studio Data Explorer using the CData ODBC Driver for HelloSign.
-
How to Easily Query Gong Data in OpenOffice Base
Connect to Gong data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Integrating Kiro CLI with ShipStation 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.
-
Use the CData Software JDBC Driver for FreshBooks in MicroStrategy Desktop
Connect to FreshBooks in MicroStrategy Desktop using the CData Software JDBC Driver for FreshBooks.
-
Build a Singer.io Tap for Dropbox With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Dropbox data using
-
Query Microsoft Planner Data as a MySQL Database in Node.js
Execute MySQL queries against Microsoft Planner from Node.js.
-
Manage Oracle Eloqua Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Oracle Eloqua.
-
Replicate Multiple LeadDesk Accounts
Replicate multiple LeadDesk accounts to one or many databases.
-
Bind Live Google Ad Manager Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Google Ad Manager data
-
Build an OLAP Cube in SSAS from Twilio Data
Establish a connection to Twilio data from SQL Server Analysis Services, and use the Twilio Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous REST Replication to Databricks
Use CData Sync for automated, continuous, customizable REST replication to Databricks.
-
Build Apps with Live Trello Data Using the Low-Code Development Platform of Mendix
Connect Trello with Mendix to build apps using the CData JDBC Driver for Trello.
-
Connect to PostgreSQL Data from Crystal Reports
Use CData Connect AI to connect to and report on live PostgreSQL from Crystal Reports.
-
Connect to Printful from Asprova with CData Software ODBC Driver for Printful
This article shows how to connect faster to Printful data from Asprova.
-
How to Connect to Live Bullhorn CRM 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 Bullhorn CRM for you.
-
Use the CData Software ODBC Driver for iContact in MicroStrategy Desktop
Connect to iContact in MicroStrategy Desktop using the CData Software ODBC Driver for iContact.
-
Process & Analyze Shippo Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Shippo Data.
-
Query JobNimbus Data in DataGrip
Create a Data Source for JobNimbus in DataGrip and use SQL to query live JobNimbus.
-
Bullhorn CRM Reporting in OBIEE with the Bullhorn CRM JDBC Driver
Deploy the Bullhorn CRM JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Validate DocuSign Data with QuerySurge
Access and validate DocuSign in QuerySurge using the CData JDBC Driver.
-
Build Visualizations of Blackbaud FE NXT Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Blackbaud FE NXT in Birst.
-
Connect to Bullhorn CRM Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Bullhorn CRM and the Script function in FileMaker Pro to connect to Bullhorn CRM and work with Bullhorn CRM in your FileMaker application.
-
ETL ShipEngine in Oracle Data Integrator
This article shows how to transfer ShipEngine into a data warehouse using Oracle Data Integrator.
-
Connect to YouTube Analytics Data in Ruby
Connect to YouTube Analytics in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrate Amazon DynamoDB Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Amazon DynamoDB and integrate live Amazon DynamoDB into your Power Automate tasks.
-
Connect to Microsoft Exchange from a Connection Pool in WebLogic
Use the CData JDBC Driver for Microsoft Exchange to connect to Microsoft Exchange from Web applications running on WebLogic.
-
Build AI/ML Models with Live HubDB Data using Dataiku
Connect HubDB Data with Dataiku using the CData JDBC Driver for HubDB.
-
Build a PostgreSQL Interface for MessageBird Data using the CData JDBC Driver
Use the Remoting features of the MessageBird JDBC Driver to create a PostgreSQL entry-point for data access.
-
Operational Reporting on Marketo Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Marketo.
-
Connect Bannerbear to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Bannerbear using the CData Python MCP Server.
-
How to connect PolyBase to Todoist
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Todoist.
-
Automated Continuous AfterShip Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable AfterShip replication to Apache Cassandra.
-
How to Access Live Nethunt Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Nethunt enables you to integrate Nethunt into workflows built using Microsoft Power Automate Desktop.
-
Connect to Live Dynamics 365 Business Central Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Dynamics 365 Business Central in CData Connect AI and connect to your Dynamics 365 Business Central from PostgreSQL.
-
Build Visualizations of Wave Financial Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Wave Financial in Birst.
-
Create Data Visualizations in Cognos BI with Cohere Data
Access Cohere as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automate NetSuite Data Replication to Azure Data Lake
Use CData Sync to customize and automate NetSuite CRM & ERP replication to Azure Data Lake.
-
Integrate with PhantomBuster Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy PhantomBuster to a JSON file on disk.
-
Connect Tickspot to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Tickspot using the CData Python MCP Server.
-
Work with Sage Intacct Data in FoxPro
Load Sage Intacct into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous Marketo Replication to SQL Server
Use CData Sync for automated, continuous, customizable Marketo replication to SQL Server.
-
DataBind Zuora Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Zuora with the DevExpress Windows Forms and Web controls to provide Zuora to a chart.
-
How to Access Live Apify Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Apify enables you to integrate Apify into workflows built using Microsoft Power Automate Desktop.
-
How to create an RPA flow for Klipfolio Data in UiPath Studio
Use the Klipfolio ODBC Driver to create workflows that access real-time Klipfolio without any coding.
-
Prepare, Blend, and Analyze Amazon Athena Data in Alteryx Designer (ODBC)
Build workflows to access live Amazon Athena for self-service data analytics.
-
View Reports on Real-Time LinkedIn Ads Data in Power BI Report Server
Use the CData ODBC Driver for LinkedIn Ads to visualize LinkedIn Ads in Power BI Desktop and then publish them to Power BI Report Server.
-
Build Spotify-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Spotify and build web apps with connectivity to live Spotify.
-
Automated Continuous ClickTime Replication to MongoDB
Use CData Sync for automated, continuous, customizable ClickTime replication to MongoDB.
-
Use the CData Software JDBC Driver for Webflow in MicroStrategy Desktop
Connect to Webflow in MicroStrategy Desktop using the CData Software JDBC Driver for Webflow.
-
Enable the ShipStation JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with ShipStation.
-
Use Microsoft Copilot Studio to talk to your Oracle HCM Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Oracle HCM Cloud for you.
-
Automated Continuous Hive Replication to Databricks
Use CData Sync for automated, continuous, customizable Hive replication to Databricks.
-
Create SAP Fieldglass-Connected Dashboards in Grafana
Connect to SAP Fieldglass Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to SAP Fieldglass.
-
Create CampaignMonitor Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time CampaignMonitor data access from reports, embedded analytics, and more.
-
Access AgileCRM Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access AgileCRM from your Oracle system.
-
Connect to Perplexity Data from a Connection Pool in JBoss
Integrate Perplexity into Java servlets: Use the Management Console in JBoss to install the Perplexity JDBC Driver.
-
Bidirectional Access to Zoho CRM Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Zoho CRM in Filemaker Pro for Mac or Windows.
-
Use Biml to Build SSIS Tasks to Replicate Zoho Books Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Zoho Books to SQL Server.
-
Replicate Multiple AfterShip Accounts
Replicate multiple AfterShip accounts to one or many databases.
-
Connect to Stripe Data in RazorSQL
Connect to Stripe from wizards and query Stripe from the GUI in the RazorSQL database management tool.
-
Build Automated Epicor Kinetic-Connected Workflows in Zapier
Use CData Connect AI to connect to live Epicor Kinetic and build automated workflows in Zapier.
-
Automated Continuous Sage Cloud Accounting Replication to Vertica
Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to Vertica.
-
Connect to Highrise Data in Claris FileMaker Pro
Use the CData ODBC Driver for Highrise in FileMaker Pro to connect to Highrise and work with Highrise CRM in your FileMaker applications.
-
Create Data Visualizations Based On ADP Data in Mode
Use CData Connect AI to connect to ADP Data from Mode and build visualizations using live
-
Automate ActiveCampaign Data Replication to Couchbase
Use CData Sync to Customize and automate ActiveCampaign replication to Couchbase.
-
Automated Continuous Jodoo Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Jodoo replication to Apache Cassandra.
-
Build Semantic Layer Views for SAP Business One Data in APOS Live Data Gateway
Use the CData Connector for SAP Business One in APOS Live Data Gateway to build Semantic Layer Views for SAP Business One.
-
Easily Integrate Sendwithus Data in Lazarus Pascal IDE
Learn how to easily integrate live Sendwithus in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Getting Started with the CData Power BI Connector for PDFMonkey
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to connect Amazon QuickSight to eBay Data
Create a connection to eBay in CData Connect AI and insert eBay into Amazon QuickSight SPICE to build interactive dashboards.
-
Access SAP BusinessObjects BI Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SAP BusinessObjects BI from HeidiSQL.
-
Create Data Visualizations in Cognos BI with SAP BusinessObjects BI Data
Access SAP BusinessObjects BI as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to SAP Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SAP ERP/NetWeaver in the Denodo Virtual DataPort Administrator.
-
Prepare, Blend, and Analyze SurveyMonkey Data in Alteryx Designer (ODBC)
Build workflows to access live SurveyMonkey for self-service data analytics.
-
Connect to ZohoPeople Data in NetBeans
Connect to ZohoPeople in NetBeans with the data source configuration wizard.
-
Connect and Visualize Live Reckon Accounts Hosted Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Reckon Accounts Hosted into the Databricks platform and create visualization dashboards with real-time Reckon Accounts Hosted.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Stripe
Provide connectivity to Stripe through an SAP BusinessObjects universe.
-
Write a Simple Go Application to work with Anaplan Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Anaplan.
-
Apify Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Apify facts in real time.
-
Build AI/ML Models with Live Bullhorn CRM Data using Dataiku
Connect Bullhorn CRM Data with Dataiku using the CData JDBC Driver for Bullhorn CRM.
-
Automated Continuous Jodoo Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Jodoo replication to Azure SQL Database.
-
How to connect to Kintone Data with Squirrel SQL client
Connect to Kintone and execute queries in the Squirrel SQL Client.
-
Use Azure AI Foundry to Talk to Your PostgreSQL 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 PostgreSQL for you.
-
Analyze Salesforce Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Salesforce & Force.com with the CData JDBC Driver for Salesforce.
-
Automate Figshare Data Replication to Azure Synapse
Use CData Sync to customize and automate Figshare replication to Azure Synapse.
-
Build Data Flows from Elorus to SQL Server using SSIS
Easily back up Elorus to SQL Server using the SSIS components for Elorus.
-
Getting Started with the CData ADO.NET Provider for PDFMonkey
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
How to Connect DBeaver to Google Translate via a JDBC Driver
Manage Google Translate with visual tools in DBeaver like the query browser.
-
Integrate Adobe Target Data in the Pentaho Report Designer
Publish reports based on Adobe Target in the Pentaho BI tool.
-
Connect to Avro Data in RazorSQL
Connect to Avro from wizards and query Apache Avro from the GUI in the RazorSQL database management tool.
-
Access Live Hive Data in Coginiti Pro
Connect to and query live Apache Hive from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrating GitHub Copilot CLI with Bannerbear 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.
-
Create Reports with Dotmailer Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Dotmailer.