CData Software - Knowledge Base
Recent Articles
-
Access Live JSON Services in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to JSON from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Stream Campaigner Data into Apache Kafka Topics
Access and stream Campaigner in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Design BIRT Reports on Zuora Data
Provide current Zuora to your embedded analytics.
-
How to integrate GitLab with Apache Airflow
Access and process GitLab in Apache Airflow using the CData JDBC Driver.
-
Create Informatica Mappings From/To a JDBC Data Source for Oracle HCM Cloud
Create Oracle HCM Cloud data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous SAP Replication to SQLite
Use CData Sync for automated, continuous, customizable SAP replication to SQLite.
-
Automated Continuous Excel Online Replication to MongoDB
Use CData Sync for automated, continuous, customizable Excel Online replication to MongoDB.
-
How to create an RPA flow for PabblySubscriptions Data in UiPath Studio
Use the PabblySubscriptions ODBC Driver to create workflows that access real-time PabblySubscriptions without any coding.
-
Create a Data Access Object for SuiteCRM Data using JDBI
A brief overview of creating a SQL Object API for SuiteCRM in JDBI.
-
Bidirectional Access to GetResponse Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate GetResponse in Filemaker Pro for Mac or Windows.
-
Connect to DB2 Data from AWS Glue
Use CData Connect AI to gain access to live IBM DB2 from your AWS Glue jobs.
-
Build SAP Business One Visualizations in Tableau Desktop
Use CData Connect AI to connect to live SAP Business One and build visualizations in Tableau.
-
Integrating Gumloop with GitHub Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on GitHub within automated workflows.
-
How to Seamlessly Import MarkLogic Data into IBM SPSS Modeler
Integrate MarkLogic data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to CapsuleCRM Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for CapsuleCRM in the Denodo Virtual DataPort Administrator.
-
Design BIRT Reports on Codat Data
Provide current Codat to your embedded analytics.
-
Connect to Apollo Data in CloverDX (formerly CloverETL)
Transfer Apollo using the visual workflow in the CloverDX data integration tool.
-
Create Data Visualizations in Cognos BI with Avro Data
Access Apache Avro as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Process & Analyze ZarMoney Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live ZarMoney Data.
-
How to Connect DBeaver to Timely via a JDBC Driver
Manage Timely with visual tools in DBeaver like the query browser.
-
Rapidly Develop LDAP-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by LDAP.
-
Build AI/ML Models with Live Paymo Data using Dataiku
Connect Paymo Data with Dataiku using the CData API Driver for JDBC.
-
Integrating Cursor CLI with SAS xpt 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.
-
Create SSAS Tabular Models from SAP HANA XS Advanced Data
How to build a SQL Server Analysis Service Tabular Model from SAP HANA XS Advanced using CData drivers.
-
Use the CData Software ODBC Driver for CSV in SAS for Real-Time Reporting and Analytics
Connect to real-time CSV/TSV Files in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for CSV.
-
How to Build an ETL App for Klaviyo Data in Python with CData Connect AI
Build ETL pipelines that read and write live Klaviyo in Python with petl and the CData Connect AI Python SDK.
-
Integrate Real-Time Access to Sybase IQ in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Sybase IQ in real time.
-
Prepare, Blend, and Analyze Oracle SCM Data in Alteryx Designer (Connect AI)
Build workflows to access live Oracle SCM for self-service data analytics.
-
Getting Started with the CData SSIS Components for Raisers Edge NXT
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Raisers Edge NXT.
-
Model, Search, and Visualize Live AlloyDB Data in ThoughtSpot
Use CData Connect AI to connect to live Google AlloyDB for modeling, searching, and visualizing.
-
Connect to Reply.io 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 Reply.io and work with Reply.io in your FileMaker application.
-
Build Intercom-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Intercom.
-
Automate Oracle Eloqua Data Replication to SAP HANA
Use CData Sync to customize and automate Oracle Eloqua replication to SAP HANA.
-
How to Access Live SAS xpt Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SAS xpt enables you to integrate SAS XPORT into workflows built using Microsoft Power Automate Desktop.
-
Connect to PingOne Data in NetBeans
Connect to PingOne in NetBeans with the data source configuration wizard.
-
Bridge Neo4J Connectivity with Apache NiFi
Access and process Neo4J in Apache NiFi using the CData JDBC Driver.
-
Replicate Multiple Everhour Accounts via the CData Sync CLI
Replicate multiple Everhour accounts to one or many databases.
-
Automated Continuous ZohoExpense Replication to Databricks
Use CData Sync for automated, continuous, customizable ZohoExpense replication to Databricks.
-
Automated Continuous Shortcut Replication to MongoDB
Use CData Sync for automated, continuous, customizable Shortcut replication to MongoDB.
-
How to Connect to Live FTP 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 FTP Servers for you.
-
A PostgreSQL Interface for SAP HANA Data using the CData ODBC Driver
Use the SQL Gateway and SAP HANA ODBC Driver to create a PostgreSQL entry-point for data access.
-
Replicate Multiple Mailgun Accounts
Replicate multiple Mailgun accounts to one or many databases.
-
Moving Data from Contentful to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Contentful data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Live SAP SuccessFactors Data in PostGresSQL Interface through CData Connect AI
Create a live connection to SAP SuccessFactors in CData Connect AI and connect to your SAP SuccessFactors from PostgreSQL.
-
How to work with MariaDB Data in Apache Spark using SQL
Access and process MariaDB Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Invoiced Data in HULFT Integrate
Connect to Invoiced as a JDBC data source in HULFT Integrate
-
How to Build an ETL App for Planio Data in Python with CData
Create ETL applications and real-time data pipelines for Planio in Python with petl.
-
Visualize Live Tanda Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Tanda using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
A PostgreSQL Interface for QuickBooks Time Data using the CData ODBC Driver
Use the SQL Gateway and QuickBooks Time ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create Informatica Mappings From/To a JDBC Data Source for Azure Data Catalog
Create Azure Data Catalog data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to use SQLAlchemy ORM to access NASA Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of NASA.
-
Getting Started with the CData Excel Add-In for Planio
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Planio.
-
Viewing Wave Financial Data in RAD Studio Data Explorer
How to view Wave Financial in RAD Studio Data Explorer using the CData ODBC Driver for Wave Financial.
-
Automated Continuous ConvertKit Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable ConvertKit replication to Apache Cassandra.
-
How to Seamlessly Import Wrike Data into IBM SPSS Modeler
Integrate Wrike data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to Work with Zendesk Data in AWS Glue Jobs Using JDBC
Connect to Zendesk from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate with Amazon Marketplace Data in JReport Designer
Create charts and reports based on Amazon Marketplace in JReport Designer.
-
Replicate Cloudflare Data in Heroku for Use in Salesforce Connect
Replicate Cloudflare to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate Raisers Edge NXT with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Raisers Edge NXT with External Services.
-
Access Zoho CRM Data from MySQL in PHP
Connect to Zoho CRM through the standard MySQL libraries in PHP.
-
Connect to Certinia Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Certinia Data and connect to Certinia in Akorbi Digital RunMyProcess.
-
DataBind Controls to Oracle HCM Cloud Data in Delphi
DataBind to Oracle HCM Cloud in Delphi with standard data access components and controls.
-
Connect to Shippo Data in Aqua Data Studio
Access Shippo from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Validate QuickBooks Data with QuerySurge
Access and validate QuickBooks Desktop in QuerySurge using the CData JDBC Driver.
-
Quickbase Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Quickbase through CData Connect AI using different applications and tools.
-
Build Gong-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Gong and build Gong-connected web apps with Axios.
-
Getting Started with the CData Tableau Connector for Nuclia
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Publish MailerLite-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live MailerLite.
-
Build Dashboards with Flowlu Data in DBxtra
Create dynamic dashboards and perform analytics based on Flowlu in DBxtra.
-
Automate ChargeOver Data Replication to Couchbase
Use CData Sync to Customize and automate ChargeOver replication to Couchbase.
-
How to connect to Adobe Analytics Data with Squirrel SQL client
Connect to Adobe Analytics and execute queries in the Squirrel SQL Client.
-
Analyze Zoho Projects Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Zoho Projects with the CData JDBC Driver for Zoho Projects.
-
Connect to CloudConvert Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for CloudConvert and the SQL Gateway to access CloudConvert from Google Apps Script.
-
Automated Continuous Azure DevOps Replication to MongoDB
Use CData Sync for automated, continuous, customizable Azure DevOps replication to MongoDB.
-
Write a Simple Go Application to work with Zoho Inventory Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Zoho Inventory.
-
Use Biml to Build SSIS Tasks to Replicate Campaigner Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Campaigner to SQL Server.
-
Build Microsoft OneDrive-Connected Apps in Choreo
Use CData Connect AI to connect to Microsoft OneDrive Data from Choreo and build custom apps using live Microsoft OneDrive.
-
Write a Simple Go Application to work with Oracle Eloqua Reporting Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Oracle Eloqua Reporting.
-
Automated Continuous Unbounce Replication to SQL Server
Use CData Sync for automated, continuous, customizable Unbounce replication to SQL Server.
-
Access ZohoSubscriptions 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 ZohoSubscriptions.
-
DataBind Charts to SAP Business One Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SAP Business One 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.
-
Feed AgileCRM Data into FineReport
How to set AgileCRM as a JDBC data source in FineReport.
-
How to Connect to Live OData Services in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live OData without replication.
-
Create Reports with Hive Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Apache Hive.
-
Automated Continuous Exa Replication to Databricks
Use CData Sync for automated, continuous, customizable Exa replication to Databricks.
-
Create Informatica Mappings From/To an ODBC Data Source for Shippo
Create an ODBC connection to Shippo in Informatica and browse and transfer Shippo.
-
How to Easily Query RabbitMQ Data in OpenOffice Base
Connect to RabbitMQ data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Analyze Azure Analysis Services Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Azure Analysis Services from Power Pivot. You will use the Table Import Wizard to load Azure Analysis Services. You can visually build the import query or use any SQL supported by the driver.
-
Create Datasets from Attio in Domo Workbench and Build Visualizations of Attio Data in Domo
Use the CData Software ODBC Driver for Attio to create datasets from Attio in Domo Workbench and then build visualizations in the Domo service.
-
Provide OData Services of Humanity Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Humanity by developing a WCF Service Application.
-
Create Apify Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Apify data access from reports, embedded analytics, and more.
-
Import Real-Time Beeminder Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Beeminder in ColdFusion.
-
How to Query Live Phoenix Data in Perplexity MacOS Desktop
Connect to and query live Phoenix Data in Perplexity Desktop using CData MCP Server.
-
Migrating data from Microsoft Exchange to Databricks using CData SSIS Components.
Easily push Microsoft Exchange to Databricks using the CData SSIS Tasks for Microsoft Exchange and Databricks.
-
Access Printify Data from MySQL in Amazon QuickSight
Connect to Printify and build visualizations of Printify using a MySQL Connection in Amazon QuickSight.
-
Analyze ActiveCampaign Data in Looker
Use CData Connect AI to connect to ActiveCampaign Data from Looker and build custom apps using live ActiveCampaign.
-
Moving Data from Klaviyo to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Klaviyo data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Replicate SendGrid Data to Multiple Databases via the CData Sync CLI
Replicate SendGrid to disparate databases with a single configuration.
-
Moving Data from Google Calendar to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Google Calendar data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Create Smartsheet-Connected Applications in Appsmith
Connect to Smartsheet Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Smartsheet.