CData Software - Knowledge Base
Recent Articles
-
ETL Unbounce in Oracle Data Integrator
This article shows how to transfer Unbounce into a data warehouse using Oracle Data Integrator.
-
Build Charts with Office 365 Data in Clear Analytics
Create dynamic charts and perform analytics based on Microsoft Office 365 in Clear Analytics.
-
Access Keap Data from MySQL in PHP
Connect to Keap through the standard MySQL libraries in PHP.
-
Build Data Flows from DocuSign to SQL Server using SSIS
Easily back up DocuSign to SQL Server using the SSIS components for DocuSign.
-
How to connect and process LDAP from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live LDAP.
-
Add Toggl Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Toggl with the Informatica Enterprise Data Catalog to classify and organize data.
-
Replicate SAP Hybris C4C Data from PowerShell
Write a quick PowerShell script to query SAP Hybris C4C. Use connectivity to the live data to replicate SAP Hybris C4C to SQL Server.
-
Getting Started with the CData Python Connector for Reckon Accounts Hosted
Learn to install and license the CData Python Connector
-
Integrating Dataiku with Square Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Square.
-
Connect to SharePoint Data in JRuby
Create a simple JRuby app with access to live Microsoft SharePoint.
-
Object-Relational Mapping (ORM) with Zendesk 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 Zendesk into a Java-based ORM framework, Hibernate.
-
Automated Continuous Outreach.io Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Outreach.io replication to AlloyDB.
-
Connect to Freshdesk Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Freshdesk Data and connect to Freshdesk in Akorbi Digital RunMyProcess.
-
Prepare, Blend, and Analyze SAP SuccessFactors LMS Data in Alteryx Designer (Connect AI)
Build workflows to access live SAP SuccessFactors LMS for self-service data analytics.
-
Use the CData Software ODBC Driver for Adobe Target in MicroStrategy
Connect to Adobe Target in MicroStrategy Developer using the CData Software ODBC Driver for Adobe Target.
-
Visualize Procore Data in Sisense
Create an ElastiCube in Sisense app with access to Procore.
-
Access Live Bitly Data in Coginiti Pro
Connect to and query live Bitly from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Query, Visualize, and Share live SAP BusinessObjects BI Data in Redash
Use CData Connect AI to connect to live SAP BusinessObjects BI in Redash for querying, visualizing, and sharing.
-
Build Semantic Layer Views for GraphQL Data in APOS Live Data Gateway
Use the CData Connector for GraphQL in APOS Live Data Gateway to build Semantic Layer Views for GraphQL.
-
Analyze Autopilot Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Autopilot with the CData JDBC Driver for Autopilot.
-
Connect to Jumpseller Data in JRuby
Create a simple JRuby app with access to live Jumpseller.
-
Connect to Zoho Inventory Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Viewing ZohoSubscriptions Data in RAD Studio Data Explorer
How to view ZohoSubscriptions in RAD Studio Data Explorer using the CData ODBC Driver for ZohoSubscriptions.
-
How to work with SQL Analysis Services Data in Apache Spark using SQL
Access and process SQL Analysis Services Data in Apache Spark using the CData Software JDBC Driver.
-
Automate Xero Data Replication to Azure Synapse
Use CData Sync to customize and automate Xero Accounting replication to Azure Synapse.
-
Configure the CData JDBC Driver for Deel in a Connection Pool in Tomcat
Connect to Deel from a connection pool in Tomcat.
-
Import Real-Time OnePageCrm Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use OnePageCrm in ColdFusion.
-
Integrate with Phoenix Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Apache Phoenix in SnapLogic.
-
How to create Act-On federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Act-On in MySQL .
-
Import Real-Time Guru Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Guru in ColdFusion.
-
Connecting Moonlit Workflow with Jira Assets Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Jira Assets in real time.
-
Automated Continuous ZohoDesk Replication to Amazon S3
Use CData Sync for automated, continuous, customizable ZohoDesk replication to Amazon S3.
-
Create Reports with Testmonitor Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Testmonitor.
-
Build a Singer.io Tap for Unbounce With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Unbounce data using
-
Integrate Eventbrite with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Eventbrite with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Eventbrite.
-
Integrate Goose with Live BambooHR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live BambooHR from within the local AI agent.
-
Excel Spreadsheet Automation on OnePageCrm Data with the QUERY Formula
Pull data from OnePageCrm, automate spreadsheets, and more with the QUERY formula.
-
Connect to Couchbase from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Couchbase, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Build Pipelines with Live NetSuite Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to NetSuite from Google Cloud Data Fusion, enabling the integration of live NetSuite CRM & ERP into the building and management of effective data pipelines.
-
Connect to Suadeo from Asprova with CData Software ODBC Driver for Suadeo
This article shows how to connect faster to Suadeo data from Asprova.
-
Create MongoDB Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time MongoDB data access from reports, embedded analytics, and more.
-
Build MVC Applications with Connectivity to SingleStore Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SingleStore from an ASP.NET MVC application.
-
Publish Crystal Reports on Clockify Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Clockify.
-
Bidirectional Access to Notion Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Notion in Filemaker Pro for Mac or Windows.
-
Prepare, Blend, and Analyze LinkedIn Data in Alteryx Designer (Connect AI)
Build workflows to access live LinkedIn for self-service data analytics.
-
How to update OneNote from Excel
This article explains how to transfer data from Excel to OneNote using the Excel Add-In for OneNote.
-
Model NetSuite Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and NetSuite, enabling the direct import of real-time NetSuite CRM & ERP.
-
Use the CData Software ODBC Driver for MarkLogic in MicroStrategy Desktop
Connect to MarkLogic in MicroStrategy Desktop using the CData Software ODBC Driver for MarkLogic.
-
Integrate LibreChat with Live Dropbox Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Dropbox from within the chat interface.
-
Create Power BI Reports on Real-Time Flowlu Data
Use the CData ODBC Driver for Flowlu to visualize Flowlu in Power BI Desktop.
-
Import Impala Data Using Azure Data Factory
Use CData Connect AI to connect to Impala Data from Azure Data Factory and import live Apache Impala.
-
How to connect SharePoint with DocuSign Data through external lists
Provide DocuSign to SharePoint users as an external list.
-
Integrate Pinterest Data in the Pentaho Report Designer
Publish reports based on Pinterest in the Pentaho BI tool.
-
Build Charts with Beeminder Data in Clear Analytics
Create dynamic charts and perform analytics based on Beeminder in Clear Analytics.
-
Create Power BI Reports on Real-Time SAP Data
Use the CData ODBC Driver for SAP to visualize SAP ERP/NetWeaver in Power BI Desktop.
-
Build Data Flows from SQL Server to Salesforce Pardot through SSIS
Easily push SQL Server data to Salesforce Pardot using the CData SSIS Tasks for Salesforce Pardot.
-
Design BIRT Reports on Twitter Ads Data
Provide current Twitter Ads to your embedded analytics.
-
Integrate Airtable Data in the Pentaho Report Designer
Publish reports based on Airtable in the Pentaho BI tool.
-
Create Redshift Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Redshift from PowerBI.com to create Power BI Dataflows with real-time data.
-
Use the CData Software JDBC Driver for Act-On in MicroStrategy
Connect to Act-On in MicroStrategy Developer using the CData Software JDBC Driver for Act-On.
-
Manage XML Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for XML.
-
Automated Continuous Facebook Replication to Vertica
Use CData Sync for automated, continuous, customizable Facebook replication to Vertica.
-
Connect to and Query Harvest Data in QlikView over ODBC
Create data visualizations with Harvest in QlikView.
-
How to connect SharePoint with WordPress Data through external lists
Provide WordPress to SharePoint users as an external list.
-
Build an OLAP Cube in SSAS from ZeroBounce Data
Establish a connection to ZeroBounce data from SQL Server Analysis Services, and use the ZeroBounce Data Provider to build OLAP cubes for use in analytics and reporting.
-
Access Drift Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Drift from your Oracle system.
-
Access Live JSON Services 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 JSON through MCP integration.
-
How to connect and process Klipfolio from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Klipfolio.
-
How to load Microsoft OneDrive data into Elasticsearch via Logstash
Introducing a simple method to load Microsoft OneDrive data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
BigQuery Reporting in OBIEE with the BigQuery JDBC Driver
Deploy the BigQuery JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Lakebase Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Lakebase using standard SQL.
-
DataBind Controls to Suadeo Data in Delphi
DataBind to Suadeo in Delphi with standard data access components and controls.
-
Build Charts with Outlook Data in Clear Analytics
Create dynamic charts and perform analytics based on Outlook in Clear Analytics.
-
Work with Mailgun Data in FoxPro
Load Mailgun into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Seamlessly Import Exact Online Data into IBM SPSS Modeler
Integrate Exact Online data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Access Live Hive Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Apache Hive from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
A PostgreSQL Interface for CircleCI Data using the CData ODBC Driver
Use the SQL Gateway and CircleCI ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Outreach.io Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Outreach.io replication to PostgreSQL.
-
Deploy the ADO.NET Provider for Clockify on an SSRS Report Server
Connect to Clockify 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.
-
Integrating Claude Code CLI with Ontraport 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.
-
Build QuickBooks Online-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for QuickBooks Online to explore live QuickBooks Online Data in Cursor to assist with building QuickBooks Online-powered applications.
-
Getting Started with the CData Power BI Connector for ClickTime
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Automated Continuous Stack Exchange Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Stack Exchange replication to Apache Kafka.
-
A PostgreSQL Interface for Azure Data Lake Storage Data (MySQL Remoting via JDBC)
Use the Remoting features of the Azure Data Lake Storage JDBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Pipeliner CRM 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 Pipeliner CRM into TIBCO Spotfire.
-
Automate Freshteam Data Replication to Azure Data Lake
Use CData Sync to customize and automate Freshteam replication to Azure Data Lake.
-
Connect to Freshsales 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 Freshsales and work with Freshsales in your FileMaker application.
-
Build Dynamics 365-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Dynamics 365 Data and create custom apps in Mendix.
-
Automated Continuous SAP ByDesign Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable SAP ByDesign replication to Azure SQL Database.
-
Build Airtable-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Airtable.
-
Create Informatica Mappings From/To an ODBC Data Source for HubDB
Create an ODBC connection to HubDB in Informatica and browse and transfer HubDB.
-
Build Pipelines with Live Sybase IQ Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Sybase IQ from Google Cloud Data Fusion, enabling the integration of live Sybase IQ into the building and management of effective data pipelines.
-
How to Work with ConvertAPI Data in AWS Glue Jobs Using JDBC
Connect to ConvertAPI from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Outreach.io Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Outreach.io in the Denodo Virtual DataPort Administrator.
-
Connect Unbounce to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Unbounce using the CData Python MCP Server.
-
Automated Continuous Sendwithus Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Sendwithus replication to Azure SQL Database.
-
Build Charts with Dynamics NAV Data in Clear Analytics
Create dynamic charts and perform analytics based on Microsoft Dynamics NAV in Clear Analytics.
-
Create Data Visualizations Based On Instagram Data in Mode
Use CData Connect AI to connect to Instagram Data from Mode and build visualizations using live
-
Automated Continuous ClickUp Replication to SQL Server
Use CData Sync for automated, continuous, customizable ClickUp replication to SQL Server.
-
Connect to Sage 300 Data in HULFT Integrate
Connect to Sage 300 as a JDBC data source in HULFT Integrate