CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData Tableau Connector for Printful
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Build Billsby-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Billsby data and build web apps with connectivity to live Billsby data.
-
Build Data Flows from Redshift to SQL Server using SSIS
Easily back up Redshift data to SQL Server using the SSIS components for Redshift.
-
How to Build an ETL App for Paddle Data in Python with CData
Create ETL applications and real-time data pipelines for Paddle data in Python with petl.
-
Build Semantic Layer Views for Adobe Experience Manager Data in APOS Live Data Gateway
Use the CData Connector for Adobe Experience Manager in APOS Live Data Gateway to build Semantic Layer Views for Adobe Experience Manager data.
-
Moving Data from Telegram to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Telegram data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Access Live Zoom Data in AWS Lambda
Connect to live Zoom data in AWS Lambda using the CData JDBC Driver.
-
Visualize ConvertAPI Data in Tableau
The CData ODBC driver for ConvertAPI enables you integrate ConvertAPI data into Tableau dashboards.
-
Query Reckon Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Reckon entities in PHP by modeling them as objects.
-
DataBind Charts to Unbounce Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Unbounce data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Publish LinkedIn-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live LinkedIn data.
-
How to connect to Microsoft Dataverse Data in DBVisualizer
Integrate Microsoft Dataverse data with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate with Live Microsoft Teams Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Microsoft Teams from the MuleSoft Anypoint Platform to integrate live Microsoft Teams data into custom reports and dashboards.
-
How to connect Amazon QuickSight to Authorize.Net Data
Create a connection to Authorize.Net data in CData Connect AI and insert Authorize.Net data into Amazon QuickSight SPICE to build interactive dashboards.
-
Build Semantic Layer Views for Google Analytics Data in APOS Live Data Gateway
Use the CData Connector for Google Analytics in APOS Live Data Gateway to build Semantic Layer Views for Google Analytics data.
-
Import Testmonitor Data Using Azure Data Factory
Use CData Connect AI to connect to Testmonitor Data from Azure Data Factory and import live Testmonitor data.
-
Connect to LDAP Objects in JRuby
Create a simple JRuby app with access to live LDAP objects.
-
Getting Started with the CData Power BI Connector for Procore
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Automated Continuous Aha! Replication to Vertica
Use CData Sync for automated, continuous, customizable Aha! replication to Vertica.
-
Automate PostgreSQL Data Replication to Azure Data Lake
Use CData Sync to customize and automate PostgreSQL data replication to Azure Data Lake.
-
Integrate with Live Omnisend Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Omnisend from the MuleSoft Anypoint Platform to integrate live Omnisend data into custom reports and dashboards.
-
Automated Continuous Dotmailer Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Dotmailer replication to Amazon Redshift.
-
Connect to Webex Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Webex to connect to Webex data and execute queries in PowerBuilder.
-
Getting Started with the CData Excel Add-In for CockroachDB
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for CockroachDB.
-
Automate Webflow Data Replication to SAP HANA
Use CData Sync to customize and automate Webflow data replication to SAP HANA.
-
Analyze Eventbrite Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Eventbrite from Power Pivot. You will use the Table Import Wizard to load Eventbrite data. You can visually build the import query or use any SQL supported by the driver.
-
ETL Moosend in Oracle Data Integrator
This article shows how to transfer Moosend data into a data warehouse using Oracle Data Integrator.
-
Automated Continuous Strava Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Strava replication to Apache Kafka.
-
Choosing the Best Method to Connect ChartMogul to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ChartMogul data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to ZohoSubscriptions Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with ZohoSubscriptions Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Replicate Multiple NASA Accounts via the CData Sync CLI
Replicate multiple NASA accounts to one or many databases.
-
Visualize Datadog Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Datadog data.
-
Work with Live SendPulse Data in Power Query
Use CData Connect AI to connect to SendPulse data and work with live SendPulse data in Microsoft Power Query.
-
Automated Continuous Square Replication to Oracle
Use CData Sync for automated, continuous, customizable Square replication to Oracle.
-
Integrating LangChain with Adobe Target Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Adobe Target data within automated workflows.
-
Integrate with Avalara AvaTax Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Avalara AvaTax data in SnapLogic.
-
Automated Continuous Redis Replication to MongoDB
Use CData Sync for automated, continuous, customizable Redis replication to MongoDB.
-
Create Dynamic Microsoft Dataverse Grids Using the Infragistics XamDataGrid
Learn how you can connect Microsoft Dataverse to Infragistics XamDataGrid to build dynamic grids.
-
Use the CData ODBC Driver for FreeAgent in Microsoft Power Query
You can use the CData FreeAgent ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import FreeAgent data into Microsoft Power Query.
-
Integrating Gumloop with Oracle Sales Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Oracle Sales data within automated workflows.
-
Integrate Bullhorn CRM Data in Pentaho Data Integration
Build ETL pipelines based on Bullhorn CRM data in the Pentaho Data Integration tool.
-
Automated Continuous XML Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable XML replication to PostgreSQL.
-
Use ChatGPT to Talk to Your Square Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Square data for you.
-
Configure the CData JDBC Driver for Salesforce CRM Analytics in a Connection Pool in Tomcat
Connect to Salesforce CRM Analytics data from a connection pool in Tomcat.
-
ETL ServiceDesk Plus in Oracle Data Integrator
This article shows how to transfer ServiceDesk Plus data into a data warehouse using Oracle Data Integrator.
-
How to work with MailerSend Data in Apache Spark using SQL
Access and process MailerSend Data in Apache Spark using the CData Software JDBC Driver.
-
Integrate Dynamics NAV Data into Power Automate Desktop using CData Connect
CData Connect for Dynamics NAV Data enables you to integrate Dynamics NAV data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Cloudant Data from a Connection Pool in Jetty
The Cloudant JDBC Driver supports connection pooling: This article shows how to connect faster to Cloudant data from Web apps in Jetty.
-
Build LDAP-Connected Apps in Choreo
Use CData Connect AI to connect to LDAP Objects from Choreo and build custom apps using live LDAP objects.
-
Insightly Reporting in OBIEE with the Insightly JDBC Driver
Deploy the Insightly JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Sage 200 Data from AWS Glue
Use CData Connect AI to gain access to live Sage 200 data from your AWS Glue jobs.
-
Visualize Greenhouse Data in TIBCO Spotfire through ADO.NET
Integrate Greenhouse data into dashboards in TIBCO Spotfire.
-
Integrate FTP Data in Pentaho Data Integration
Build ETL pipelines based on FTP data in the Pentaho Data Integration tool.
-
Automated Continuous GetResponse Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable GetResponse replication to Google BigQuery.
-
Integrating LangGraph with SAP SuccessFactors LMS Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on SAP SuccessFactors LMS data within automated workflows.
-
Integrate OpenCode with Live SuiteCRM Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live SuiteCRM data from within your AI coding agent.
-
Use Claude to Talk to Your IBM Cloud Object Storage 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 IBM Cloud Object Storage data for you.
-
Automated Continuous SageHR Replication to SingleStore
Use CData Sync for automated, continuous, customizable SageHR replication to SingleStore.
-
ETL SAP HANA XS Advanced in Oracle Data Integrator
This article shows how to transfer SAP HANA XS Advanced data into a data warehouse using Oracle Data Integrator.
-
Query TigerGraph Data through ODBC in Node.js
Use node-odbc to execute SQL queries against TigerGraph data from Node.js.
-
DataBind Controls to Mistral AI Data in Delphi
DataBind to Mistral AI data in Delphi with standard data access components and controls.
-
Publish Reports with Nuclia Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Nuclia data.
-
Access Live Google Analytics Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Google Analytics data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
A PostgreSQL Interface for WooCommerce Data (MySQL Remoting via JDBC)
Use the Remoting features of the WooCommerce JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Tally Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Tally data from Filemaker Pro on Mac.
-
A PostgreSQL Interface for Excel Data (MySQL Remoting via JDBC)
Use the Remoting features of the Excel JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Live Apify Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Apify data for you.
-
Connect to Spark Data in DBeaver
Use the CData ODBC Driver to connect to Spark data in DBeaver.
-
Integrate with Avalara AvaTax Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Avalara AvaTax data to a JSON file on disk.
-
Use the CData ODBC Driver for Google Spanner from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Google Spanner to connect to Google Spanner data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Google Spanner data in Excel.
-
Access BambooHR Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access BambooHR data from your Oracle system.
-
How to Work with PolarTeamPro Data in ETL Validator JDBC
Connect to PolarTeamPro from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect and Visualize Live Amazon Athena Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Amazon Athena data into the Databricks platform and create visualization dashboards with real-time Amazon Athena data.
-
Getting Started with the CData ODBC Driver for Zoho Projects
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Zoho Projects.
-
Integrate Apify Data in Pentaho Data Integration
Build ETL pipelines based on Apify data in the Pentaho Data Integration tool.
-
Integrate Google Forms Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Google Forms data and integrate live Google Forms data into your Power Automate tasks.
-
Work with SageHR Data in FoxPro
Load SageHR data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Analyze DB2 Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze DB2 data with the CData JDBC Driver for DB2.
-
Create Jumpseller Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Jumpseller data access from reports, embedded analytics, and more.
-
Connect to RabbitMQ from Asprova with CData Software ODBC Driver for RabbitMQ
This article shows how to connect faster to RabbitMQ data from Asprova.
-
Load LaunchDarkly Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load LaunchDarkly data to a database.
-
Build Apps with Live CircleCI Data Using the Low-Code Development Platform of Mendix
Connect CircleCI data with Mendix to build apps using the CData API Driver for JDBC.
-
Model Toggl Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Toggl, enabling the direct import of real-time Toggl data.
-
Analyze Avalara AvaTax Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Avalara AvaTax data in Microsoft R Open.
-
Connect to Elasticsearch Data from Crystal Reports
Use CData Connect AI to connect to and report on live Elasticsearch data from Crystal Reports.
-
Create ZohoPeople-Connected Applications in Appsmith
Connect to ZohoPeople Data via CData Connect AI in Appsmith and create custom business applications with real-time access to ZohoPeople data.
-
Yelp Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Yelp facts in real time.
-
How to Connect HubDB Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live HubDB data in real time using natural language.
-
Visualize Clockify 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 Clockify data into TIBCO Spotfire.
-
Import Real-Time Contentful Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Contentful data in ColdFusion.
-
Create Data Visualizations Based On Google Calendar Data in Mode
Use CData Connect AI to connect to Google Calendar Data from Mode and build visualizations using live Google Calendar data.
-
Create Informatica Mappings From/To a JDBC Data Source for ZohoDesk
Create ZohoDesk data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Trigger PostgreSQL IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for PostgreSQL with standard wizards in Logic Apps.
-
Write a Simple Go Application to work with ZohoInvoice Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to ZohoInvoice data.
-
Build an OLAP Cube in SSAS from Freshservice Data
Establish a connection to Freshservice data data from SQL Server Analysis Services, and use the Freshservice Data Provider to build OLAP cubes for use in analytics and reporting.
-
Access FreeAgent Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access FreeAgent data from your Oracle system.
-
Create XML Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time XML data access from reports, embedded analytics, and more.
-
Consume Power BI XMLA OData Feeds in PowerBuilder
This article demonstrates how to consume Power BI XMLA data as OData feeds from PowerBuilder using the API Server.
-
Connect to LDAP Objects as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live LDAP objects.
-
Migrating data from Billsby to Snowflake using CData SSIS Components.
Easily push Billsby data to Snowflake using the CData SSIS Tasks for Billsby and Snowflake.