CData Software - Knowledge Base
Recent Articles
-
DataBind XML Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for XML with the DevExpress Windows Forms and Web controls to provide XML Files to a chart.
-
Connect to Certinia Data in Claris FileMaker Pro
Use the CData ODBC Driver for Certinia in FileMaker Pro to connect to Certinia and work with Certinia in your FileMaker applications.
-
Automated Continuous Impala Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Impala replication to Apache Kafka.
-
Automated Continuous Salesforce Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Salesforce replication to Apache Kafka.
-
Build Dashboards with Spark Data in DBxtra
Create dynamic dashboards and perform analytics based on Apache Spark SQL in DBxtra.
-
Getting Started with the CData SSIS Components for Google Drive
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Google Drive.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Paddle
Provide connectivity to Paddle through an SAP BusinessObjects universe.
-
SAP Ariba Source Reporting in OBIEE with the SAP Ariba Source JDBC Driver
Deploy the SAP Ariba Source JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Create Datasets from Amazon S3 in Domo Workbench and Build Visualizations of Amazon S3 Data in Domo
Use the CData Software ODBC Driver for Amazon S3 to create datasets from Amazon S3 in Domo Workbench and then build visualizations in the Domo service.
-
Explore Geographical Relationships in Asana Data with Power Map
Create data visualizations with Asana in Power Map.
-
Manage SAP Ariba Procurement Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SAP Ariba Procurement.
-
How to connect to Elasticsearch Data from IntelliJ
Integrate connectivity to Elasticsearch with wizards in IntelliJ.
-
Integrating LlamaIndex with Dynamics 365 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Microsoft Dynamics 365 in real time.
-
Query Freshsales Data in DataGrip
Create a Data Source for Freshsales in DataGrip and use SQL to query live Freshsales.
-
Connect to PDFMonkey Data in DBArtisan
Use wizards in DBArtisan to configure PDFMonkey as a data source.
-
Access Live Sage 200 Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Sage 200 in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use Dash to Build Web Apps on PostgreSQL Data via CData Connect AI
Build interactive Dash web apps on live PostgreSQL using pandas and the CData Connect AI Python SDK.
-
Connect to Qualaroo Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Qualaroo as an External Source in Dremio.
-
Use the CData Software JDBC Driver for Close in MicroStrategy Web
Connect to Close in MicroStrategy Web using the CData Software JDBC Driver for Close.
-
Visualize Live Pingdom Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Pingdom using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous Tally Replication to SingleStore
Use CData Sync for automated, continuous, customizable Tally replication to SingleStore.
-
Create SSAS Tabular Models from Parallel Data
How to build a SQL Server Analysis Service Tabular Model from Parallel using CData drivers.
-
Create Dynamic Deel Grids Using the Infragistics XamDataGrid
Learn how you can connect Deel to Infragistics XamDataGrid to build dynamic grids.
-
Access Live Instagram Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Instagram from your Google Sheets.
-
Use the CData Software ODBC Driver for Insightly in SAS for Real-Time Reporting and Analytics
Connect to real-time Insightly in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Insightly.
-
Connect SAP Netweaver Gateway Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SAP Netweaver Gateway using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build Microsoft OneDrive-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Microsoft OneDrive to explore live Microsoft OneDrive Data in Cursor to assist with building Microsoft OneDrive-powered applications.
-
Analyze Live Cassandra Data in SAS Viya
Use CData Connect AI to connect to Apache Cassandra from SAS Viya and deploy self-service analytics using live Apache Cassandra.
-
How to connect PolyBase to Dynamics 365 Business Central
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Dynamics 365 Business Central.
-
Automated Continuous Google Forms Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Google Forms replication to AlloyDB.
-
How to connect to Omnisend Data from Spring Boot
Connect to Omnisend in a Spring Boot Application using the CData API Driver for JDBC
-
Use the CData Software ODBC Driver for CampaignMonitor in MicroStrategy Web
Connect to CampaignMonitor in MicroStrategy Web using the CData Software ODBC Driver for CampaignMonitor.
-
Build a Singer.io Tap for AfterShip With the CData Python Connector
Learn how to easily build a Singer.io Tap for live AfterShip data using
-
Connect to Miro Data in RapidMiner
Integrate Miro with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate Adobe Target Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Adobe Target from Informatica Cloud.
-
Connect to SAP SuccessFactors Data in RapidMiner
Integrate SAP SuccessFactors with standard components and data source configuration wizards in RapidMiner Studio.
-
Visualize HelloSign 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 HelloSign into TIBCO Spotfire.
-
Connect to Okta Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Okta to connect to Okta and execute queries in PowerBuilder.
-
Feed ZohoDesk Data into FineReport
How to set ZohoDesk as a JDBC data source in FineReport.
-
Natively Connect to xBase Data in PHP
The CData ODBC driver for xBase enables you to create PHP applications with connectivity to xBase. Leverage the native support for ODBC in PHP.
-
How to import Email Data into Apache Solr
Use the CData Software JDBC Driver for Email in Data Import Handler and create an automated import of Email to Apache Solr Enterprise Search platform.
-
Natively Connect to Coda Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Coda. Leverage the native support for ODBC in PHP.
-
Rapidly Develop Office 365-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 Office 365.
-
Replicate Stripe Data to Multiple Databases via the CData Sync CLI
Replicate Stripe to disparate databases with a single configuration.
-
Connect to Workable Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Workable to connect to Workable and execute queries in PowerBuilder.
-
Use the CData Software ODBC Driver for FTP in MicroStrategy
Connect to FTP Servers in MicroStrategy Developer using the CData Software ODBC Driver for FTP.
-
Connect to Google Cloud Storage Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Integrate with live Databricks Data in Jitterbit
Use CData Connect AI to connect to and integrate live Databricks in Jitterbit.
-
Create Blackbaud FE NXT-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Blackbaud FE NXT Data from Klipfolio and build custom visualizations using live Blackbaud FE NXT.
-
Explore Geographical Relationships in Keap Data with Power Map
Create data visualizations with Keap in Power Map.
-
Migrating data from Qualaroo to Snowflake using CData SSIS Components.
Easily push Qualaroo to Snowflake using the CData SSIS Tasks for Qualaroo and Snowflake.
-
Create Data Visualizations in Cognos BI with Rootly Data
Access Rootly as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Visualize Live Amazon Athena Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Amazon Athena into custom reports in Power BI.
-
Connect to SAP Business One Data in CloverDX (formerly CloverETL)
Transfer SAP Business One using the visual workflow in the CloverDX data integration tool.
-
Getting Started with the CData SSIS Components for Procore
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Procore.
-
Design a Custom SAP Function Module to Circumvent RFC_READ_TABLE Limitations
The RFC_READ_TABLE function enables you to get data from SAP tables, but limits retrieving transaction records to 512 bytes. You can use the CData ADO.NET Provider for SAP to circumvent this by defining a custom SAP function module that will allow to retrieve data as you would with any ADO.NET data source.
-
Use JayDeBeApi to access Guru Data in Python
Use standard Python scripting and the development environment of your choice to access live Guru.
-
View Reports on Real-Time Freshsales Data in Power BI Report Server
Use the CData ODBC Driver for Freshsales to visualize Freshsales in Power BI Desktop and then publish them to Power BI Report Server.
-
Seamlessly Bring Vertica Data into Retool Using CData Connect AI
Integrate Vertica data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Build a Singer.io Tap for Splunk With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Splunk data using
-
Process & Analyze FreeAgent Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live FreeAgent Data.
-
Design BIRT Reports on BambooHR Data
Provide current BambooHR to your embedded analytics.
-
Integrate Neo4J Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Neo4J and integrate live Neo4J into your Power Automate tasks.
-
Connect to Outreach.io Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Outreach.io in Airbyte.
-
Excel Spreadsheet Automation on Front Data with the QUERY Formula
Pull data from Front, automate spreadsheets, and more with the QUERY formula.
-
How to Query Live DB2 Data in Claude Desktop
Connect to and query live DB2 Data in Claude Desktop using CData MCP Server.
-
Query Microsoft Entra ID Data as a MySQL Database in Node.js
Execute MySQL queries against Microsoft Entra ID from Node.js.
-
Access Live xBase Data in TIBCO Data Virtualization
Use the xBase Tibco DV Adapter to create a xBase data source in TIBCO Data Virtualization Studio and gain access to live xBase from your TDV Server.
-
Bind Live Confluence Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Confluence data
-
How to integrate Metabase with SingleStore Data
Use CData Connect AI to connect to live SingleStore and create an interactive dashboard in Metabase from SingleStore.
-
Build Zuora Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Zuora and build visualizations in Tableau.
-
Build a PostgreSQL Interface for Excel Data using the CData JDBC Driver
Use the Remoting features of the Excel JDBC Driver to create a PostgreSQL entry-point for data access.
-
Bind Live EnterpriseDB Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live EnterpriseDB data
-
Automated Continuous Asana Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Asana replication to delimited files (CSV/TSV).
-
Use the CData ODBC Driver for Oracle in Microsoft Power Query
You can use the CData Oracle ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Oracle Database into Microsoft Power Query.
-
Integrate SAP SuccessFactors LMS Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to SAP SuccessFactors LMS and integrate live SAP SuccessFactors LMS into your Power Automate tasks.
-
Import Zoho CRM Data Using Azure Data Factory
Use CData Connect AI to connect to Zoho CRM Data from Azure Data Factory and import live Zoho CRM.
-
Migrating data from PolarTeamPro to Google BigQuery using CData SSIS Components.
Easily push PolarTeamPro to Google BigQuery using the CData SSIS Tasks for PolarTeamPro and Google BigQuery.
-
How to Create Power BI Visual Reports with Real-Time Cloudflare Data
Use CData Power BI Connectors to visualize Cloudflare in Power BI.
-
Connect to Quickbase Data in Google Apps Script via Connect AI
Use CData Connect AI to access Quickbase in Google Apps Script.
-
Getting Started with the CData ADO.NET Provider for Retently
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Create Dynamic Presto Grids Using the Infragistics XamDataGrid
Learn how you can connect Presto to Infragistics XamDataGrid to build dynamic grids.
-
How to create an RPA flow for Zoho Creator Data in UiPath Studio
Use the Zoho Creator ODBC Driver to create workflows that access real-time Zoho Creator without any coding.
-
ETL NetSuite in Oracle Data Integrator
This article shows how to transfer NetSuite CRM & ERP into a data warehouse using Oracle Data Integrator.
-
Access Live QuickBooks Time Data in AWS Lambda (with IntelliJ IDEA)
Connect to live QuickBooks Time in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build HDFS-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for HDFS to explore live HDFS Data in Gemini Code Assist to assist with building HDFS-powered applications.
-
How to Build an ETL App for Apollo Data in Python with CData
Create ETL applications and real-time data pipelines for Apollo in Python with petl.
-
Connect to Real-Time Todoist Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Todoist in Power Apps.
-
Use Agno to Talk to Your Azure Analysis Services Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Azure Analysis Services for you.
-
Connect Perplexity to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Perplexity using the CData Python MCP Server.
-
Automated Continuous ServiceNow Replication to Oracle
Use CData Sync for automated, continuous, customizable ServiceNow replication to Oracle.
-
Getting Started with the CData Power BI Connector for Okta
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Okta.
-
Publish Reports with Demio Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Demio.
-
Connect to GitLab Data in Google Apps Script via Connect AI
Use CData Connect AI to access GitLab in Google Apps Script.
-
Automated Continuous SAP Business One Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SAP Business One replication to delimited files (CSV/TSV).
-
Automate SAP SuccessFactors Data Replication to Couchbase
Use CData Sync to Customize and automate SAP SuccessFactors replication to Couchbase.
-
Build Dashboards with GitHub Data in DBxtra
Create dynamic dashboards and perform analytics based on GitHub in DBxtra.
-
Work with Microsoft Teams Data in FoxPro
Load Microsoft Teams into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to import Attio Data into Apache Solr
Use the CData Software JDBC Driver for Attio in Data Import Handler and create an automated import of Attio to Apache Solr Enterprise Search platform.
-
How to connect SharePoint with Adobe Target Data through external lists
Provide Adobe Target to SharePoint users as an external list.