CData Software - Knowledge Base
Recent Articles
-
Publish Crystal Reports on Google Tasks Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Google Tasks.
-
Integrating PostgreSQL Data in Talend Cloud Data Management Platform
Connect PostgreSQL Data with Talend Cloud Data Management Platform using the CData JDBC Driver for PostgreSQL.
-
Migrating data from CouchDB to Google BigQuery using CData SSIS Components.
Easily push Apache CouchDB to Google BigQuery using the CData SSIS Tasks for CouchDB and Google BigQuery.
-
Migrating data from Onfleet to Databricks using CData SSIS Components.
Easily push Onfleet to Databricks using the CData SSIS Tasks for Onfleet and Databricks.
-
Use the CData ODBC Driver for Lakebase in Microsoft Power Query
You can use the CData Lakebase ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Lakebase into Microsoft Power Query.
-
Integrate Real-Time Access to Monday.com in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Monday.com in real time.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for AgileCRM
Provide connectivity to AgileCRM through an SAP BusinessObjects universe.
-
Connect to Phoenix Data from Crystal Reports
Use CData Connect AI to connect to and report on live Apache Phoenix from Crystal Reports.
-
Create MessageBird Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time MessageBird data access from reports, embedded analytics, and more.
-
Connect to Close in SpagoBI
Create reports featuring live Close in SpagoBI Studio. Host Close reports on SpagoBI Server.
-
Build Apps with Live Amazon Athena Data Using the Low-Code Development Platform of Mendix
Connect Amazon Athena with Mendix to build apps using the CData JDBC Driver for Amazon Athena.
-
Object-Relational Mapping (ORM) with Accelo 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 Accelo into a Java-based ORM framework, Hibernate.
-
How to Connect to & Open Azure Data Lake Storage Data in Microsoft Excel
This article uses the CData ODBC driver for Azure Data Lake Storage to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Import Real-Time Parallel Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Parallel in ColdFusion.
-
Analyze Cassandra Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Cassandra from Power Pivot. You will use the Table Import Wizard to load Apache Cassandra. You can visually build the import query or use any SQL supported by the driver.
-
Build a PostgreSQL Interface for SQL Analysis Services Data using the CData JDBC Driver
Use the Remoting features of the SQL Analysis Services JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to EnterpriseDB Data from PowerBuilder via JDBC
This article demonstrates how to access EnterpriseDB from PowerBuilder using the EnterpriseDB JDBC Driver.
-
Build Zoho Recruit-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Zoho Recruit.
-
Choosing the Best Method to Connect HBase to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Apache HBase from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Publish Reports with Dotmailer Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Dotmailer.
-
Connect to FTP Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for FTP and the SQL Gateway to access FTP Servers from Google Apps Script.
-
Feed Monday.com Data into FineReport
How to set Monday.com as a JDBC data source in FineReport.
-
Connect to Azure Analysis Services Data in RapidMiner
Integrate Azure Analysis Services with standard components and data source configuration wizards in RapidMiner Studio.
-
Create Data Visualizations in Cognos BI with SharePoint Data
Access Microsoft SharePoint as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Use Dash to Build to Web Apps on LionDesk Data
Create Python applications that use pandas and Dash to build LionDesk-connected web apps.
-
How to connect to Planio Data with Squirrel SQL client
Connect to Planio and execute queries in the Squirrel SQL Client.
-
Publish Apify-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Apify.
-
Use the CData Software ODBC Driver for BenchmarkEmail in MicroStrategy Desktop
Connect to BenchmarkEmail in MicroStrategy Desktop using the CData Software ODBC Driver for BenchmarkEmail.
-
Integrate Microsoft OneDrive Data in the Pentaho Report Designer
Publish reports based on Microsoft OneDrive in the Pentaho BI tool.
-
Back Up Gong to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Gong data.
-
How to connect to Rootly Data in DBVisualizer
Integrate Rootly with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous Jodoo Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Jodoo replication to AlloyDB.
-
Integrate Zuora Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Zuora and integrate live Zuora into your Power Automate tasks.
-
Getting Started with the CData SSIS Components for PayPal
Complete guide to installing, licensing, and connecting with the CData SSIS Components for PayPal.
-
How to create an RPA flow for Oracle SCM Data in UiPath Studio
Use the Oracle SCM ODBC Driver to create workflows that access real-time Oracle SCM without any coding.
-
Integrating Claude Code CLI with Oracle Eloqua 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.
-
Automated Continuous PayPal Replication to Snowflake
Use CData Sync for automated, continuous, customizable PayPal replication to Snowflake.
-
Object-Relational Mapping (ORM) with Clockify 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 Clockify into a Java-based ORM framework, Hibernate.
-
Build Visualizations of Pinterest Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Pinterest in Birst.
-
How to connect to Pingdom Data in DBVisualizer
Integrate Pingdom with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Visualizations of Factorial Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Factorial in Birst.
-
Publish Crystal Reports on Hive Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Apache Hive.
-
Query Mixpanel Data in ColdFusion
Write standard ColdFusion data access code to connect to Mixpanel.
-
Connect to Spotify Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Automated Continuous Samanage Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Samanage replication to Apache Kafka.
-
Natively Connect to Contentful Data in PHP
The CData ODBC driver for Contentful enables you to create PHP applications with connectivity to Contentful. Leverage the native support for ODBC in PHP.
-
Build RabbitMQ-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live RabbitMQ.
-
How to Connect the Power BI Service to iContact: Complete Guide
Connect to the CData Software Power BI Connector for iContact from PowerBI.com to provide real-time iContact across the organization.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live SAP Concur using the Model Context Protocol.
-
Analyze Optimizely Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Optimizely in Microsoft R Open.
-
Connecting Supabase to CData Connect AI
Learn how to connect a Supabase PostgreSQL database to CData Connect AI so your AI tools and agents can query live data using natural language.
-
Analyze Gong Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Gong in Microsoft R Open.
-
Edit and Search ShipStation External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of ShipStation to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create ShipStation objects that you can access from apps and the dashboard.
-
Connect Google Translate to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Google Translate with IBM WebSphere for seamless data integration and connectivity.
-
Integrate Jira with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Jira with External Services.
-
Automated Continuous Perplexity Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Perplexity replication to Azure SQL Database.
-
Build Nethunt-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData API Driver for MCP Server to explore live Nethunt Data in Gemini Code Assist to assist with building Nethunt-powered applications.
-
Feed HBase Data into FineReport
How to set Apache HBase as a JDBC data source in FineReport.
-
Automated Continuous API Replication to IBM DB2
Use CData Sync for automated, continuous, customizable API replication to IBM DB2.
-
Replicate Multiple FreshBooks Accounts via the CData Sync CLI
Replicate multiple FreshBooks accounts to one or many databases.
-
Automated Continuous Act-On Replication to Databricks
Use CData Sync for automated, continuous, customizable Act-On replication to Databricks.
-
Build Oracle Eloqua-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Oracle Eloqua Data and create custom apps in Mendix.
-
How to Connect to Live SAP SuccessFactors LMS Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your SAP SuccessFactors LMS for you.
-
How to Build an ETL App for Twilio Data in Python with CData
Create ETL applications and real-time data pipelines for Twilio in Python with petl.
-
Trigger Zendesk IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Zendesk with standard wizards in Logic Apps.
-
Automated Continuous Salesforce CRM Analytics Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Salesforce CRM Analytics replication to Google BigQuery.
-
Manage Todoist Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Todoist.
-
How to Connect to Live SingleStore 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 SingleStore for you.
-
Connect CampaignMonitor to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect CampaignMonitor with IBM WebSphere for seamless data integration and connectivity.
-
Back Up AgileCRM to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with AgileCRM data.
-
Connect to Bright Data Data in Aqua Data Studio
Access Bright Data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Operational Reporting on NetSuite Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote NetSuite CRM & ERP.
-
Connect to Onfleet Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Onfleet.
-
Automated Continuous Grafana Replication to SQL Server
Use CData Sync for automated, continuous, customizable Grafana replication to SQL Server.
-
Automated Continuous Sendwithus Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Sendwithus replication to Amazon S3.
-
Analyze Tavily Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Tavily and visualize live Tavily in Infragistics Reveal.
-
Connect to and Visualize Live Quickbase Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Quickbase.
-
Natively Connect to Snowflake Data in PHP
The CData ODBC driver for Snowflake enables you to create PHP applications with connectivity to Snowflake. Leverage the native support for ODBC in PHP.
-
Connect to SAP Concur Data in DBeaver
Use the CData ODBC Driver to connect to SAP Concur in DBeaver.
-
Automated Continuous Kintone Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Kintone replication to Apache Kafka.
-
Extract, Transform, and Load Power BI XMLA Data in Informatica PowerCenter
Create a simple Workflow for Power BI XMLA in Informatica PowerCenter.
-
Work with Microsoft Ads Data in FoxPro
Load Microsoft Ads into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create Data Visualizations in Cognos BI with ServiceNow Data
Access ServiceNow as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Connect to Live Apollo Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Apollo through natural language.
-
Use the CData Software JDBC Driver for Email in MicroStrategy
Connect to Email in MicroStrategy Developer using the CData Software JDBC Driver for Email.
-
How to work with PayPal Data in Apache Spark using SQL
Access and process PayPal Data in Apache Spark using the CData Software JDBC Driver.
-
Use Biml to Build SSIS Tasks to Replicate Outlook Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Outlook to SQL Server.
-
Getting Started with the CData ODBC Driver for Templated
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Templated.
-
Connect to Neo4J from Asprova with CData Software ODBC Driver for Neo4J
This article shows how to connect faster to Neo4J data from Asprova.
-
Access Live ADP Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live ADP from your Excel spreadsheets.
-
Connect to CampaignMonitor Data as an External Source in Dremio
Use the CData JDBC Driver to connect to CampaignMonitor as an External Source in Dremio.
-
How to Design QuickBooks Online Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to QuickBooks Online from mobile and tablet Power Apps.
-
Access Live Kintone Data in TIBCO Data Virtualization
Use the Kintone Tibco DV Adapter to create a Kintone data source in TIBCO Data Virtualization Studio and gain access to live Kintone from your TDV Server.
-
Integrate Lakebase Data into Power Automate Desktop using CData Connect
CData Connect for Lakebase Data enables you to integrate Lakebase into workflows built using Microsoft Power Automate Desktop.
-
Create Dynamic Discord Grids Using the Infragistics XamDataGrid
Learn how you can connect Discord to Infragistics XamDataGrid to build dynamic grids.
-
Replicate SAP Fieldglass Data from PowerShell
Write a quick PowerShell script to query SAP Fieldglass. Use connectivity to the live data to replicate SAP Fieldglass to SQL Server.
-
Integrating Cursor CLI with HDFS 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 the CData Software JDBC Driver for Adobe Experience Manager in MicroStrategy
Connect to Adobe Experience Manager in MicroStrategy Developer using the CData Software JDBC Driver for Adobe Experience Manager.
-
How to work with ZarMoney Data in Apache Spark using SQL
Access and process ZarMoney Data in Apache Spark using the CData Software JDBC Driver.
-
Replicate Google Calendar Data to Multiple Databases
Replicate Google Calendar to disparate databases with a point-and-click configuration.