CData Software - Knowledge Base
Recent Articles
-
Import Real-Time Gong Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Gong in ColdFusion.
-
Automated Continuous ShipEngine Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable ShipEngine replication to PostgreSQL.
-
Explore Geographical Relationships in Mixpanel Data with Power Map
Create data visualizations with Mixpanel in Power Map.
-
Automate SAP Concur Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SAP Concur from PowerShell? This article demonstrates how to utilize the SAP Concur Cmdlets for tasks like connecting to SAP Concur, automating operations, downloading data, and more.
-
Automated Continuous Tally Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Tally ERP replication to OneLake in Microsoft Fabric.
-
Connect to Qualaroo Data in NetBeans
Connect to Qualaroo in NetBeans with the data source configuration wizard.
-
Connect to Freshdesk Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Freshdesk.
-
Moving Data from Exa to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Exa data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrate Elasticsearch Data into Power Automate Desktop using CData Connect
CData Connect for Elasticsearch Data enables you to integrate Elasticsearch into workflows built using Microsoft Power Automate Desktop.
-
Moving Data from Google Analytics to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Google Analytics data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Timely Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Timely and the SQL Gateway to access Timely from Google Apps Script.
-
Bind Live Oracle Service Cloud Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Oracle Service Cloud data
-
Integrate with Live Sage 200 Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Sage 200 from the MuleSoft Anypoint Platform to integrate live Sage 200 into custom reports and dashboards.
-
Integrating OpenCode Terminal with SAP SuccessFactors LMS 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.
-
Connect to Amazon S3 from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Amazon S3, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to create SAP Fieldglass federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SAP Fieldglass in MySQL .
-
Connect to Avro Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Apache Avro.
-
Connect to RSS Feeds in CloverDX (formerly CloverETL)
Transfer RSS Feeds using the visual workflow in the CloverDX data integration tool.
-
Write a Simple Go Application to work with Typeform Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Typeform.
-
Automated Highrise Data Replication to Teradata
Use CData Sync to Customize and automate Highrise CRM replication to Teradata.
-
Import and Visualize Superchat Data in Power View
Create data visualizations based on Superchat in Excel.
-
Connect Scrapfly to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Scrapfly using the CData Python MCP Server.
-
Connect to eBay Data from AWS Glue
Use CData Connect AI to gain access to live eBay from your AWS Glue jobs.
-
Connect to Tally Data in JRuby
Create a simple JRuby app with access to live Tally ERP.
-
Integrate Twilio with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Twilio with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Twilio.
-
Connect to GitHub Data from AWS Glue
Use CData Connect AI to gain access to live GitHub from your AWS Glue jobs.
-
How to Connect to & Open Salesforce Marketing Data in Microsoft Excel
This article uses the CData ODBC driver for Salesforce Marketing to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to connect to Oracle Service Cloud Data from IntelliJ
Integrate connectivity to Oracle Service Cloud with wizards in IntelliJ.
-
Trigger MailChimp IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for MailChimp with standard wizards in Logic Apps.
-
How to import Salesloft Data into Apache Solr
Use the CData Software JDBC Driver for Salesloft in Data Import Handler and create an automated import of Salesloft to Apache Solr Enterprise Search platform.
-
Connect Printful to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Printful with IBM WebSphere for seamless data integration and connectivity.
-
Build a Singer.io Tap for Active Directory With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Active Directory data using
-
Automated Continuous Oracle Sales Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Oracle Sales replication to PostgreSQL.
-
Connect to Tavily Data in DBArtisan
Use wizards in DBArtisan to configure Tavily as a data source.
-
Connect to Smartsheet Data in CloverDX (formerly CloverETL)
Transfer Smartsheet using the visual workflow in the CloverDX data integration tool.
-
A PostgreSQL Interface for Azure DevOps Data (MySQL Remoting via JDBC)
Use the Remoting features of the Azure DevOps JDBC Driver to create a PostgreSQL entry-point for data access.
-
Bidirectional Access to ConvertAPI Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate ConvertAPI in Filemaker Pro for Mac or Windows.
-
Edit and Search External Google Drive Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Google Drive to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Google Drive Data objects that you can access from apps and the dashboard.
-
Connect to Google Sheets Data in HULFT Integrate
Connect to Google Sheets as a JDBC data source in HULFT Integrate
-
Visualize SharePoint Data in TIBCO Spotfire through OData
Integrate Microsoft SharePoint into dashboards in TIBCO Spotfire.
-
Connect to SpaceX Data in DBeaver
Use the CData ODBC Driver to connect to SpaceX in DBeaver.
-
Object-Relational Mapping (ORM) with ActiveCampaign Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to ActiveCampaign into a Java-based ORM framework, Hibernate.
-
How to connect to Google Sheets Data with Squirrel SQL client
Connect to Google Sheets and execute queries in the Squirrel SQL Client.
-
How to use SQLAlchemy ORM to access AfterShip Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of AfterShip.
-
Build Dashboards with Hugging Face Data in Dundas BI
Create dynamic dashboards and perform analytics based on Hugging Face in Dundas BI.
-
Integrate with Google Tasks Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Google Tasks to a JSON file on disk.
-
Use Dash to Build to Web Apps on Browserless Data
Create Python applications that use pandas and Dash to build Browserless-connected web apps.
-
Migrating data from Bullhorn CRM to Snowflake using CData SSIS Components.
Easily push Bullhorn CRM to Snowflake using the CData SSIS Tasks for Bullhorn CRM and Snowflake.
-
Build a PostgreSQL Interface for Zoho Inventory Data using the CData JDBC Driver
Use the Remoting features of the Zoho Inventory JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Phoenix Data in DBeaver
Use the CData ODBC Driver to connect to Apache Phoenix in DBeaver.
-
DataBind EmailOctopus Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide EmailOctopus to a chart.
-
How to connect and process Freshteam from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Freshteam.
-
How to Connect DBeaver to Aweber via a JDBC Driver
Manage Aweber with visual tools in DBeaver like the query browser.
-
Build Semantic Layer Views for Redis Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Redis.
-
Integrating OpenCode Terminal 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.
-
Create a Data Access Object for Opsgenie Data using JDBI
A brief overview of creating a SQL Object API for Opsgenie in JDBI.
-
Create Data Visualizations in Cognos BI with Salesforce Marketing Data
Access Salesforce Marketing Cloud as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Access Live Sage Cloud Accounting Data in Excel 365 Online (Excel for the web)
Connect to Sage Business Cloud Accounting from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Import and Visualize Mode Data in Power View
Create data visualizations based on Mode in Excel.
-
Build AI/ML Models with Live Aircall Data using Dataiku
Connect Aircall Data with Dataiku using the CData API Driver for JDBC.
-
Getting Started with the CData Tableau Connector for Confluence
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Confluence.
-
Integrating Claude Code with QuickBooks Time Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on QuickBooks Time within assisted coding and automated development workflows.
-
Getting Started with the CData Python Connector for Stripe
Learn to install and license the CData Python Connector
-
Work with Live Google Campaign Manager 360 Data in Power Query
Use CData Connect AI to connect to Google Campaign Manager 360 and work with live Google Campaign Manager 360 in Microsoft Power Query.
-
Integrate Real-Time Access to EnterpriseDB in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to EnterpriseDB in real time.
-
Query Amazon Athena Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Amazon Athena entities in PHP by modeling them as objects.
-
Use the CData Software ODBC Driver for eBay Analytics in MicroStrategy Desktop
Connect to eBay Analytics in MicroStrategy Desktop using the CData Software ODBC Driver for eBay Analytics.
-
Build Contentful-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Contentful.
-
Access Live Google Sheets Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Google Sheets through MCP integration.
-
Integrating Google Spanner Data in Talend Cloud Data Management Platform
Connect Google Spanner Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Google Spanner.
-
Automate Tickspot Data Replication to Couchbase
Use CData Sync to Customize and automate Tickspot replication to Couchbase.
-
Seamlessly Bring BigCommerce Data into Retool Using CData Connect AI
Integrate BigCommerce data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Feed AfterShip Data into FineReport
How to set AfterShip as a JDBC data source in FineReport.
-
Migrating data from Databricks to Databricks using CData SSIS Components.
Easily push Databricks to Databricks using the CData SSIS Tasks for Databricks and Databricks.
-
How to Connect to & Open Pipedrive Data in Microsoft Excel
This article uses the CData ODBC driver for Pipedrive to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Access Billsby Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Billsby from your Oracle system.
-
Connect to PDFMonkey Data in DBeaver
Use the CData ODBC Driver to connect to PDFMonkey in DBeaver.
-
Import Real-Time Power BI XMLA Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Power BI XMLA in ColdFusion.
-
Use the CData Software ODBC Driver for Box in SAS for Real-Time Reporting and Analytics
Connect to real-time Box in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Box.
-
Build a Singer.io Tap for Bullhorn CRM With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Bullhorn CRM data using
-
Integrating Contentful Data in Talend Cloud Data Management Platform
Connect Contentful Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Getting Started with the CData ADO.NET Provider for Quaderno
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Access Gong Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Gong.
-
Query Jumpseller Data in ColdFusion
Write standard ColdFusion data access code to connect to Jumpseller.
-
Design BIRT Reports on Active Directory Data
Provide current Active Directory to your embedded analytics.
-
Connect to Productboard from Asprova with CData Software ODBC Driver for Productboard
This article shows how to connect faster to Productboard data from Asprova.
-
Use Azure AI Foundry to Talk to Your Instagram 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 Instagram for you.
-
Build Twitter Ads-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Twitter Ads to explore live Twitter Ads Data in Gemini Code Assist to assist with building Twitter Ads-powered applications.
-
How to Connect to Live QuickBooks Online Data 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 QuickBooks Online for you.
-
How to create Visio diagrams from Salesforce CRM Analytics Data
Automatically update Salesforce CRM Analytics with the changes you make to Visio master shapes.
-
Getting Started with the CData Python Connector for PDFMonkey
Learn to install and license the CData Python Connector
-
Feed ADP Data into FineReport
How to set ADP as a JDBC data source in FineReport.
-
Query Webflow Data as a MySQL Database in Node.js
Execute MySQL queries against Webflow from Node.js.
-
Deploy the ADO.NET Provider for Stripe on an SSRS Report Server
Connect to Stripe from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
How to integrate IBM Informix with Apache Airflow
Access and process IBM Informix in Apache Airflow using the CData JDBC Driver.
-
Connect to Couchbase Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Couchbase and the SQL Gateway to access Couchbase from Google Apps Script.
-
Getting Started with the CData Power BI Connector for FreshBooks
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connect to Certinia Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Certinia from Filemaker Pro on Mac.
-
Consume Exact Online OData Feeds in PowerBuilder
This article demonstrates how to consume Exact Online as OData feeds from PowerBuilder using the API Server.
-
Connect to ActiveCampaign Data as an External Source in Dremio
Use the CData JDBC Driver to connect to ActiveCampaign as an External Source in Dremio.