CData Software - Knowledge Base
Recent Articles
-
Write a Simple Go Application to work with PayPal Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to PayPal.
-
How to Build an ETL App for Retently Data in Python with CData
Create ETL applications and real-time data pipelines for Retently in Python with petl.
-
Using the CData Software ODBC Driver for SFTP in PyCharm
Connect to SFTP as an ODBC data source in PyCharm using the CData Software ODBC Driver for SFTP.
-
Access Live Anaplan Data in AWS Lambda
Connect to live Anaplan in AWS Lambda using the CData JDBC Driver.
-
Connect to Oracle Eloqua Reporting Data in Aqua Data Studio
Access Oracle Eloqua Reporting from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connecting Pipedream with SAP Hybris C4C Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on SAP Hybris C4C data in real time.
-
How to import Templated Data into Apache Solr
Use the CData Software JDBC Driver for Templated in Data Import Handler and create an automated import of Templated to Apache Solr Enterprise Search platform.
-
Provide OData Services of Paddle Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Paddle by developing a WCF Service Application.
-
Use the CData Software JDBC Driver for Strava in MicroStrategy Desktop
Connect to Strava in MicroStrategy Desktop using the CData Software JDBC Driver for Strava.
-
Connect to Everhour Data in Ruby
Connect to Everhour in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrate Goose with Live SAP SuccessFactors Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live SAP SuccessFactors from within the local AI agent.
-
Integrate Live Demio Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Demio to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Analyze Highrise Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Highrise CRM with the CData JDBC Driver for Highrise.
-
How to connect to Google Drive Data with Squirrel SQL client
Connect to Google Drive and execute queries in the Squirrel SQL Client.
-
Integrating OpenCode Terminal with Delighted 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 Dash to Build to Web Apps on IBM Informix Data
Create Python applications that use pandas and Dash to build IBM Informix-connected web apps.
-
Integrate Xero Data into Power Automate Desktop using CData Connect
CData Connect for Xero Data enables you to integrate Xero Accounting into workflows built using Microsoft Power Automate Desktop.
-
Know Your LLM Series: Claude
Explore Anthropic Claude model family and learn how to pair it with CData Connect AI to securely enable natural-language, governed access to enterprise data.
-
Use Dash to Build to Web Apps on Kintone Data
Create Python applications that use pandas and Dash to build Kintone-connected web apps.
-
Automated Continuous Salesforce Pardot Replication to MySQL
Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to MySQL.
-
Visualize Freshteam Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Freshteam into TIBCO Spotfire.
-
Object-Relational Mapping (ORM) with Sybase IQ 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 Sybase IQ into a Java-based ORM framework, Hibernate.
-
How to integrate Metabase with ServiceNow Data
Use CData Connect AI to connect to live ServiceNow and create an interactive dashboard in Metabase from ServiceNow.
-
Connect to and Query Aha! Data in QlikView over ODBC
Create data visualizations with Aha! in QlikView.
-
Manage Shippo Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Shippo.
-
Integrate with live Adobe Commerce Data in Jitterbit
Use CData Connect AI to connect to and integrate live Adobe Commerce in Jitterbit.
-
Prepare, Blend, and Analyze BigCommerce Data in Alteryx Designer (ODBC)
Build workflows to access live BigCommerce for self-service data analytics.
-
How to Connect Flowise AI Agents to Live Impala Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Apache Impala without replication.
-
Query, Visualize, and Share live CouchDB Data in Redash
Use CData Connect AI to connect to live Apache CouchDB in Redash for querying, visualizing, and sharing.
-
Use Claude to Talk to Your GitLab Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your GitLab for you.
-
Integrating LangGraph with IBM Informix Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on IBM Informix within automated workflows.
-
Connect to Azure Data Catalog Data in JRuby
Create a simple JRuby app with access to live Azure Data Catalog.
-
Query Clockify Data in ColdFusion
Write standard ColdFusion data access code to connect to Clockify.
-
Use the CData Software JDBC Driver for Facebook in MicroStrategy Web
Connect to Facebook in MicroStrategy Web using the CData Software JDBC Driver for Facebook.
-
Replicate Notion Data to Multiple Databases via the CData Sync CLI
Replicate Notion to disparate databases with a single configuration.
-
Access Wave Financial Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Wave Financial from your Oracle system.
-
Use Claude to Talk to Your Google Campaign Manager 360 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Google Campaign Manager 360 for you.
-
Automate Yelp Data Replication to Couchbase
Use CData Sync to Customize and automate Yelp replication to Couchbase.
-
Connect to LDAP Objects in RazorSQL
Connect to LDAP from wizards and query LDAP from the GUI in the RazorSQL database management tool.
-
How to connect to FreshBooks Data from Spring Boot
Connect to FreshBooks in a Spring Boot Application using the CData API Driver for JDBC
-
Automate Elasticsearch Data Replication to Azure Synapse
Use CData Sync to customize and automate Elasticsearch replication to Azure Synapse.
-
Create Data Visualizations in Cognos BI with iContact Data
Access iContact as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Migrating data from AgileCRM to Snowflake using CData SSIS Components.
Easily push AgileCRM to Snowflake using the CData SSIS Tasks for AgileCRM and Snowflake.
-
Query Raisers Edge NXT Data as a MySQL Database in Node.js
Execute MySQL queries against Raisers Edge NXT from Node.js.
-
Analyze Aircall Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Aircall from Power Pivot. You will use the Table Import Wizard to load Aircall. You can visually build the import query or use any SQL supported by the driver.
-
Integrate Live Oracle HCM Cloud Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Use the CData Software ODBC Driver for Monday.com in SAS for Real-Time Reporting and Analytics
Connect to real-time Monday.com in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Monday.com.
-
Connect Sentry to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Sentry with IBM WebSphere for seamless data integration and connectivity.
-
How to connect to Neo4J Data in DBVisualizer
Integrate Neo4J with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Google Sheets-Connected Applications in Appsmith
Connect to Google Sheets Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Google Sheets.
-
Build MariaDB Visualizations in Tableau Cloud
Use CData Connect AI to connect to live MariaDB and build visualizations in Tableau Cloud.
-
Design BIRT Reports on Discourse Data
Provide current Discourse to your embedded analytics.
-
Connect to Azure DevOps Data from AWS Glue
Use CData Connect AI to gain access to live Azure DevOps from your AWS Glue jobs.
-
Build a Singer.io Tap for Teamwork With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Teamwork data using
-
Provide OData Services of BambooHR Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for BambooHR by developing a WCF Service Application.
-
Connect to Azure DevOps Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Azure DevOps and the Script function in FileMaker Pro to connect to Azure DevOps and work with Azure DevOps in your FileMaker application.
-
Connect to Discord Data in Ruby
Connect to Discord in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Establish a Live Connection with SendPulse Data using Tableau Bridge
The CData ODBC Driver for SendPulse enables you to integrate live SendPulse into Tableau Cloud dashboards using the Tableau Bridge.
-
Create Informatica Mappings From/To a JDBC Data Source for SQL Server
Create SQL Server data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
DataBind Controls to Avalara AvaTax Data in Delphi
DataBind to Avalara AvaTax in Delphi with standard data access components and controls.
-
Connect to Salesforce CRM Analytics Data from HeidiSQL
Use CData Connect AI to connect to and query live Salesforce CRM Analytics from HeidiSQL.
-
Integrate Live QuickBooks Online Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to QuickBooks Online and integrate live QuickBooks Online into apps built in Microsoft Power Apps.
-
Consume BigQuery OData Feeds in PowerBuilder
This article demonstrates how to consume Google BigQuery as OData feeds from PowerBuilder using the API Server.
-
Create a Data Access Object for Tanda Data using JDBI
A brief overview of creating a SQL Object API for Tanda in JDBI.
-
Publish Crystal Reports on Teamwork Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Teamwork.
-
How to Visualize Azure Analysis Services Data in Python with pandas
Use pandas and other modules to analyze and visualize live Azure Analysis Services in Python.
-
Manage DB2 Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for DB2.
-
Connect to Google Directory Data from a Connection Pool in Jetty
The Google Directory JDBC Driver supports connection pooling: This article shows how to connect faster to Google Directory from Web apps in Jetty.
-
Connect and Query Live Outreach.io Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Outreach.io into Databricks
-
Visualize Live Zoho Books Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Zoho Books into custom reports in Power BI.
-
Connect to and Visualize Live Facebook Ads Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Facebook Ads.
-
Configure the CData JDBC Driver for Zoho Creator in a Connection Pool in Tomcat
Connect to Zoho Creator from a connection pool in Tomcat.
-
Analyze Asana Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Asana and visualize Asana in SAP Analytics Cloud.
-
Build a Singer.io Tap for Anaplan With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Anaplan data using
-
Using the CData Software ODBC Driver for SharePoint in PyCharm
Connect to SharePoint as an ODBC data source in PyCharm using the CData Software ODBC Driver for SharePoint.
-
Integrating LangGraph with Oracle Eloqua Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Oracle Eloqua within automated workflows.
-
Migrating data from SurveyMonkey to Databricks using CData SSIS Components.
Easily push SurveyMonkey to Databricks using the CData SSIS Tasks for SurveyMonkey and Databricks.
-
Validate Retently Data with QuerySurge
Access and validate Retently in QuerySurge using the CData JDBC Driver.
-
Integrating Cursor CLI with Highrise 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 Mailgun Data from PowerBuilder via ADO.NET
This article demonstrates how to access Mailgun from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Use the CData Software JDBC Driver for Pipeliner CRM in MicroStrategy Web
Connect to Pipeliner CRM in MicroStrategy Web using the CData Software JDBC Driver for Pipeliner CRM.
-
Connect to Clari Data in JRuby
Create a simple JRuby app with access to live Clari.
-
How to create Visio diagrams from Sybase Data
Automatically update Sybase with the changes you make to Visio master shapes.
-
Object-Relational Mapping (ORM) with ShipEngine 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 ShipEngine into a Java-based ORM framework, Hibernate.
-
Visualize Live Impala Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Apache Impala using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Replicate Multiple GetResponse Accounts
Replicate multiple GetResponse accounts to one or many databases.
-
Connect to eBay Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with eBay Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Integrating Claude Code CLI with Azure Data Lake Storage 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.
-
Using the CData Software ODBC Driver for Missive in PyCharm
Connect to Missive as an ODBC data source in PyCharm using the CData Software ODBC Driver for Missive.
-
Getting Started with the CData Python Connector for HBase
Learn to install and license the CData Python Connector
-
How to Connect to Live Microsoft OneDrive Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Microsoft OneDrive securely in real time.
-
Build Salesforce CRM Analytics-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Salesforce CRM Analytics to explore live Salesforce CRM Analytics Data in Cursor to assist with building Salesforce CRM Analytics-powered applications.
-
How to integrate Metabase with Active Directory Data
Use CData Connect AI to connect to live Active Directory and create an interactive dashboard in Metabase from Active Directory.
-
Create Informatica Mappings From/To an ODBC Data Source for Delighted
Create an ODBC connection to Delighted in Informatica and browse and transfer Delighted.
-
Migrating data from Couchbase to Google BigQuery using CData SSIS Components.
Easily push Couchbase to Google BigQuery using the CData SSIS Tasks for Couchbase and Google BigQuery.
-
Use the CData Software ODBC Driver for Elasticsearch in MicroStrategy Web
Connect to Elasticsearch in MicroStrategy Web using the CData Software ODBC Driver for Elasticsearch.
-
Visualize ScrapingBee Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load ScrapingBee into TIBCO Spotfire.
-
A PostgreSQL Interface for Calendly Data using the CData ODBC Driver
Use the SQL Gateway and Calendly ODBC Driver to create a PostgreSQL entry-point for data access.
-
Manage SQL Analysis Services Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SQL Analysis Services.
-
Integrate with Live Dynamics 365 Business Central Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Dynamics 365 Business Central from the MuleSoft Anypoint Platform to integrate live Dynamics 365 Business Central into custom reports and dashboards.