CData Software - Knowledge Base
Recent Articles
-
Create Reports from Avro Data in Looker Studio
Use CData Connect AI to gain access to live Avro data and create custom reports in Looker Studio.
-
How to Query Insightly Data in MySQL Workbench
Execute MySQL queries against live Insightly data from MySQL Workbench.
-
Integrating LangChain with OData Services via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on OData services within automated workflows.
-
Automate Calendly Data Replication to Azure Synapse
Use CData Sync to customize and automate Calendly data replication to Azure Synapse.
-
Create Informatica Mappings From/To an ODBC Data Source for Chargebee
Create an ODBC connection to Chargebee in Informatica and browse and transfer Chargebee data.
-
Integrate ShipStation Data in Pentaho Data Integration
Build ETL pipelines based on ShipStation data in the Pentaho Data Integration tool.
-
A PostgreSQL Interface for Outlook Data (MySQL Remoting via JDBC)
Use the Remoting features of the Outlook JDBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze Adobe Experience Manager Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Adobe Experience Manager data and visualize live Adobe Experience Manager data in Infragistics Reveal.
-
Connect to Gorgias Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Gorgias to connect to Gorgias data and execute queries in PowerBuilder.
-
Automated Continuous Outlook Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Outlook replication to Amazon Redshift.
-
Connect to BenchmarkEmail Data in Aqua Data Studio
Access BenchmarkEmail data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Harvest Data in RazorSQL
Connect to Harvest from wizards and query Harvest data from the GUI in the RazorSQL database management tool.
-
Connect to Close Data in Aqua Data Studio
Access Close data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Analyze ServiceNow Data in Cognos Analytics
Use CData Connect AI to connect to ServiceNow Data from Cognos Analytics and analyze live ServiceNow data.
-
Create Datasets from Presto in Domo Workbench and Build Visualizations of Presto Data in Domo
Use the CData Software ODBC Driver for Presto to create datasets from Presto data in Domo Workbench and then build visualizations in the Domo service.
-
Replicate PhantomBuster Data to Multiple Databases
Replicate PhantomBuster data to disparate databases with a point-and-click configuration.
-
Connect to ZohoInvoice Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to ZohoInvoice and work with ZohoInvoice data in your FileMaker application.
-
How to Visualize EnterpriseDB Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live EnterpriseDB data in Python.
-
Integrate Exa Data in the Pentaho Report Designer
Publish reports based on Exa data in the Pentaho BI tool.
-
Import Real-Time Active Directory Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Active Directory data in ColdFusion.
-
How to Connect to & Open Jira Data in Microsoft Excel
This article uses the CData ODBC driver for Jira to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Sybase-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Sybase data and build Sybase-connected web apps with Axios.
-
Build Semantic Layer Views for Pinterest Data in APOS Live Data Gateway
Use the CData Connector for Pinterest in APOS Live Data Gateway to build Semantic Layer Views for Pinterest data.
-
Create Datasets from Bitly in Domo Workbench and Build Visualizations of Bitly Data in Domo
Use the CData Software ODBC Driver for Bitly to create datasets from Bitly data in Domo Workbench and then build visualizations in the Domo service.
-
Create SAP Business One-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to SAP Business One Data from OutSystems and build custom enterprise apps using live SAP Business One data.
-
Replicate RabbitMQ Data to Multiple Databases
Replicate RabbitMQ data to disparate databases with a point-and-click configuration.
-
View Reports on Real-Time Google Contacts Data in Power BI Report Server
Use the CData ODBC Driver for Google Contacts to visualize Google Contacts data in Power BI Desktop and then publish them to Power BI Report Server.
-
Moving Data from MessageBird to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live MessageBird data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build MongoDB Visualizations in Tableau Desktop
Use CData Connect AI to connect to live MongoDB data and build visualizations in Tableau.
-
Build FHIR-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live FHIR data.
-
Analyze SageHR Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SageHR data with the CData JDBC Driver for SageHR.
-
Connect to Zoho Creator Data in RazorSQL
Connect to Zoho Creator from wizards and query Zoho Creator data from the GUI in the RazorSQL database management tool.
-
Build AI/ML Models with Live XML Data using Dataiku
Connect XML Data with Dataiku using the CData JDBC Driver for XML.
-
Analyze YouTube Analytics Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for YouTube Analytics from Power Pivot. You will use the Table Import Wizard to load YouTube Analytics data. You can visually build the import query or use any SQL supported by the driver.
-
Analyze Microsoft Entra ID Data in Looker
Use CData Connect AI to connect to Microsoft Entra ID Data from Looker and build custom apps using live Microsoft Entra ID data.
-
Integrating Cursor with FreshBooks 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.
-
Creating Freshservice-Connected Applications in Unqork
You can use CData Connect AI to feed Freshservice data to Unqork and build custom business apps.
-
Integrate Live MarkLogic Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live MarkLogic data to Blue Prism using the CData ODBC Driver for MarkLogic to create automated workflows for repetitive business tasks.
-
Build Freshservice-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Freshservice Data and create custom apps in Bubble.
-
Connect to Bright Data Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Bright Data data from Filemaker Pro on Mac.
-
Getting Started with the CData SSIS Components for Figshare
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Figshare.
-
Getting Started with the CData Power BI Connector for Office 365
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Office 365.
-
Migrating data from ShipEngine to Snowflake using CData SSIS Components.
Easily push ShipEngine data to Snowflake using the CData SSIS Tasks for ShipEngine and Snowflake.
-
Create Oracle Eloqua-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Oracle Eloqua Data from OutSystems and build custom enterprise apps using live Oracle Eloqua data.
-
How to Connect to & Open Sentry Data in Microsoft Excel
This article uses the CData ODBC driver for Sentry to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Analyze CapsuleCRM Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for CapsuleCRM from Power Pivot. You will use the Table Import Wizard to load CapsuleCRM data. You can visually build the import query or use any SQL supported by the driver.
-
Natively Connect to Odoo Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Odoo data. Leverage the native support for ODBC in PHP.
-
Automated Zoho Recruit Data Replication to Teradata
Use CData Sync to Customize and automate Zoho Recruit data replication to Teradata.
-
Build Automated Oracle Service Cloud-Connected Workflows in Zapier
Use CData Connect AI to connect to live Oracle Service Cloud data and build automated workflows in Zapier.
-
Migrating data from Teamwork to Databricks using CData SSIS Components.
Easily push Teamwork data to Databricks using the CData SSIS Tasks for Teamwork and Databricks.
-
Connect to Oracle SCM Data in ACL Analytics
Connect to Oracle SCM data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Oracle SCM data.
-
Connecting Pipedream with Facebook 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 Facebook data in real time.
-
Connect to Aha! Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Aha! and the SQL Gateway to access Aha! data from Google Apps Script.
-
IBM Informix Reporting in OBIEE with the IBM Informix JDBC Driver
Deploy the IBM Informix JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Cloudant
Provide connectivity to Cloudant data through an SAP BusinessObjects universe.
-
Use the CData Software JDBC Driver for SAP Hybris C4C in MicroStrategy Desktop
Connect to SAP Hybris C4C data in MicroStrategy Desktop using the CData Software JDBC Driver for SAP Hybris C4C.
-
How to Access CouchDB Data Using Entity Framework
This article shows how to access CouchDB data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Timely from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Timely data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Getting Started with the CData ADO.NET Provider for XML
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for XML.
-
Integrating Antigravity CLI with Okta data via CData CLI
Connect Okta data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to integrate Act-On with Apache Airflow
Access and process Act-On data in Apache Airflow using the CData JDBC Driver.
-
Create Data Visualizations Based On Shortcut Data in Mode
Use CData Connect AI to connect to Shortcut Data from Mode and build visualizations using live Shortcut data.
-
Visualize Presto Data in Tableau
The CData ODBC driver for Presto enables you integrate Presto data into Tableau dashboards.
-
Integrate Goose with Live BenchmarkEmail Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live BenchmarkEmail data from within the local AI agent.
-
Prepare, Blend, and Analyze Helpscout Data in Alteryx Designer (ODBC)
Build workflows to access live Helpscout data for self-service data analytics.
-
Integrating LangGraph with Cvent Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Cvent data within automated workflows.
-
Build Dashboards with ActiveCampaign Data in DBxtra
Create dynamic dashboards and perform analytics based on ActiveCampaign data in DBxtra.
-
Design BIRT Reports on Authorize.Net Data
Provide current Authorize.Net data to your embedded analytics.
-
How to Seamlessly Import Xero Data into IBM SPSS Modeler
Integrate Xero data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to Connect to Live Zuora 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 Zuora data for you.
-
Getting Started with the CData SSIS Components for Amazon S3
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Amazon S3.
-
How to Query Demio Data in MySQL Workbench
Execute MySQL queries against live Demio data from MySQL Workbench.
-
Access Dropbox 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 Dropbox data.
-
Stream Google Analytics Data into Apache Kafka Topics
Access and stream Google Analytics data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Foursquare Reporting in OBIEE with the Foursquare JDBC Driver
Deploy the Foursquare JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous Spotify Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Spotify data replication to OneLake in Microsoft Fabric.
-
Replicate Multiple Aweber Accounts
Replicate multiple Aweber accounts to one or many databases.
-
Create GitHub-Connected Nintex Workflows
Use CData Connect AI to connect to GitHub Data from Nintex Workflow Cloud and build custom workflows using live GitHub data.
-
Model MariaDB Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and MariaDB, enabling the direct import of real-time MariaDB data.
-
Visualize ChartMogul Data in Sisense
Create an ElastiCube in Sisense app with access to ChartMogul data.
-
Extract, Transform, and Load ZohoDesk Data in Informatica PowerCenter
Create a simple Workflow for ZohoDesk data in Informatica PowerCenter.
-
Migrating data from Aha! to Databricks using CData SSIS Components.
Easily push Aha! data to Databricks using the CData SSIS Tasks for Aha! and Databricks.
-
Query Freshdesk Data in ColdFusion
Write standard ColdFusion data access code to connect to Freshdesk data.
-
Connect to Close Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Close.
-
Connect to Google Contacts Data in ACL Analytics
Connect to Google Contacts data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Google Contacts data.
-
Connect to PostgreSQL Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for PostgreSQL data.
-
Object-Relational Mapping (ORM) with Zoho Recruit 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 Zoho Recruit data into a Java-based ORM framework, Hibernate.
-
Automated Figshare Data Replication to Teradata
Use CData Sync to Customize and automate Figshare data replication to Teradata.
-
Use Dash to Build Web Apps on Greenplum Data via CData Connect AI
Build interactive Dash web apps on live Greenplum data using pandas and the CData Connect AI Python SDK.
-
Integrating Antigravity CLI with ServiceDesk Plus data via CData CLI
Connect ServiceDesk Plus data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to Connect to & Open Shippo Data in Microsoft Excel
This article uses the CData ODBC driver for Shippo to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Using the CData Software ODBC Driver for Planio in PyCharm
Connect to Planio as an ODBC data source in PyCharm using the CData Software ODBC Driver for Planio.
-
How to connect PolyBase to Oracle Eloqua
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Oracle Eloqua data.
-
Import and Visualize Google Directory Data in Power View
Create data visualizations based on Google Directory data in Excel.
-
Build Data Flows from Reckon to SQL Server using SSIS
Easily back up Reckon data to SQL Server using the SSIS components for Reckon.
-
Create Data Visualizations Based On Salesforce Marketing Data in Mode
Use CData Connect AI to connect to Salesforce Marketing Data from Mode and build visualizations using live Salesforce Marketing data.
-
Connect to SFTP Data in Ruby
Connect to SFTP data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Use CData Connect AI to Access eBay Analytics Data in Microsoft Power Pivot
Use CData Connect AI to connect to live eBay Analytics data in the Power Pivot business intelligence tool.
-
Connect and Visualize Live Microsoft Ads Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Microsoft Ads data into the Databricks platform and create visualization dashboards with real-time Microsoft Ads data.
-
Analyze IBM Informix Data in Cognos Analytics
Use CData Connect AI to connect to IBM Informix Data from Cognos Analytics and analyze live IBM Informix data.