CData Software - Knowledge Base
Recent Articles
-
Design BIRT Reports on Insightly Data
Provide current Insightly to your embedded analytics.
-
Automated Continuous Greenplum Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Greenplum replication to Amazon Redshift.
-
Feed Gumroad Data into FineReport
How to set Gumroad as a JDBC data source in FineReport.
-
Integrate Instagram Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Instagram and integrate live Instagram into your Power Automate tasks.
-
Access Live Tally Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Tally ERP from your Google Sheets.
-
How to Seamlessly Import FreshBooks Data into IBM SPSS Modeler
Integrate FreshBooks data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Prepare, Blend, and Analyze Jira Assets Data in Alteryx Designer (Connect AI)
Build workflows to access live Jira Assets for self-service data analytics.
-
Access ScrapingBee 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 ScrapingBee.
-
Connect to Real-Time Excel Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Excel and Dataflow to import and use Microsoft Excel in Power Apps.
-
Edit and Search External Microsoft Planner Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Microsoft Planner to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Microsoft Planner Data objects that you can access from apps and the dashboard.
-
Automate Act-On Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Act-On and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Create Data Visualizations in Cognos BI with ClickTime Data
Access ClickTime as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automated JotForm Data Replication to Teradata
Use CData Sync to Customize and automate JotForm replication to Teradata.
-
Automated Continuous Moosend Replication to Databricks
Use CData Sync for automated, continuous, customizable Moosend replication to Databricks.
-
Use the CData Software ODBC Driver for Zoho Creator in MicroStrategy
Connect to Zoho Creator in MicroStrategy Developer using the CData Software ODBC Driver for Zoho Creator.
-
Moving Data from Bannerbear to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Bannerbear data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to work with AfterShip Data in Apache Spark using SQL
Access and process AfterShip Data in Apache Spark using the CData Software JDBC Driver.
-
Design BIRT Reports on Excel Online Data
Provide current Microsoft Excel Online to your embedded analytics.
-
How to Easily Query Stripe Data in OpenOffice Base
Connect to Stripe data in OpenOffice Base using the CData ODBC Driver for Stripe and generate reports with live data insights.
-
Connect to Anaplan Data in HULFT Integrate
Connect to Anaplan as a JDBC data source in HULFT Integrate
-
Explore Geographical Relationships in xBase Data with Power Map
Create data visualizations with xBase in Power Map.
-
How to integrate Qualaroo with Apache Airflow
Access and process Qualaroo in Apache Airflow using the CData JDBC Driver.
-
Connect Yelp to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Yelp with IBM WebSphere for seamless data integration and connectivity.
-
A PostgreSQL Interface for Copper Data using the CData ODBC Driver
Use the SQL Gateway and Copper ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connecting GenSpark with MailChimp Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to MailChimp without any replication or custom integration required.
-
Manage Workday Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Workday.
-
Create SSAS Tabular Models from ClickTime Data
How to build a SQL Server Analysis Service Tabular Model from ClickTime using CData drivers.
-
Create Dashboards and Visualize Live BigQuery Data in Geckoboard
Use CData Connect AI to connect to live Google BigQuery and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Extract, Transform, and Load Microsoft Entra ID Data in Informatica PowerCenter
Create a simple Workflow for Microsoft Entra ID in Informatica PowerCenter.
-
How to create PhantomBuster federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for PhantomBuster in MySQL .
-
Use the CData Software ODBC Driver for SAP Business One in MicroStrategy
Connect to SAP Business One in MicroStrategy Developer using the CData Software ODBC Driver for SAP Business One.
-
How to load WordPress data into Elasticsearch via Logstash
Introducing a simple method to load WordPress data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build MVC Applications with Connectivity to Demio Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Demio from an ASP.NET MVC application.
-
Automated Continuous Office 365 Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Office 365 replication to Google BigQuery.
-
Manage JobNimbus Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for JobNimbus.
-
How to Query Live CouchDB Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Apache CouchDB data in natural language using Python.
-
Rapidly Develop Salesforce Data 360-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 Salesforce Data 360.
-
Automated Continuous MongoDB Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable MongoDB replication to Apache Kafka.
-
Connect to SAP BusinessObjects BI Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live SAP BusinessObjects BI.
-
How to Visualize SAP Fieldglass Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live SAP Fieldglass in Python.
-
Connect to SAS xpt Data in JRuby
Create a simple JRuby app with access to live SAS XPORT.
-
Access Live Procore Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Procore in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Building Dynamic Web Pages with Square Data Using AngularJS
Create single-page applications with live connectivity to Square using the CData API Server.
-
How to Connect to Float Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Float. Leverage the pyodbc module for ODBC in Python.
-
Connect to Snowflake Data in Claris FileMaker Pro
Use the CData ODBC Driver for Snowflake in FileMaker Pro to connect to Snowflake and work with Snowflake in your FileMaker applications.
-
Connect to Slack Data in Ruby
Connect to Slack in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Coda Data in DBArtisan
Use wizards in DBArtisan to configure Coda as a data source.
-
How to Connect MySQL 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 MySQL data in real time using natural language.
-
How to connect to Azure Data Catalog Data in DBVisualizer
Integrate Azure Data Catalog with visual data analysis tools and data connection wizards in DBVisualizer
-
DataBind Charts to Hugging Face Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Hugging Face 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.
-
Create Dynamic Amazon S3 Grids Using the Infragistics XamDataGrid
Learn how you can connect Amazon S3 to Infragistics XamDataGrid to build dynamic grids.
-
Import Microsoft Exchange Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Microsoft Exchange Data and provide access to live Microsoft Exchange for custom reports in the Power BI Service.
-
Bridge Perplexity Connectivity with Apache NiFi
Access and process Perplexity in Apache NiFi using the CData JDBC Driver.
-
Automate MongoDB Integration Tasks from PowerShell
Are you in search of a quick and easy way to access MongoDB from PowerShell? This article demonstrates how to utilize the MongoDB Cmdlets for tasks like connecting to MongoDB, automating operations, downloading data, and more.
-
Visualize Google Drive 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 Google Drive into TIBCO Spotfire.
-
Create Timely Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Timely from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous ServiceNow Replication to MySQL
Use CData Sync for automated, continuous, customizable ServiceNow replication to MySQL.
-
Integrating Gumloop with Oracle Financials Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Oracle Financials Cloud within automated workflows.
-
How to Easily Query SharePoint Data in OpenOffice Base
Connect to SharePoint data in OpenOffice Base using the CData ODBC Driver for SharePoint and generate reports with live data insights.
-
Create Data Visualizations in Cognos BI with Google Calendar Data
Access Google Calendar as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Extract, Transform, and Load Pipeline CRM Data in Informatica PowerCenter
Create a simple Workflow for Pipeline CRM in Informatica PowerCenter.
-
Create Reports with Presto Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Presto.
-
Creating Google Ad Manager-Connected Applications in Unqork
You can use CData Connect AI to feed Google Ad Manager to Unqork and build custom business apps.
-
Configure the CData JDBC Driver for Demio in a Connection Pool in Tomcat
Connect to Demio from a connection pool in Tomcat.
-
Establish a Live Connection with Stripe Data using Tableau Bridge
The CData ODBC Driver for Stripe enables you to integrate live Stripe into Tableau Cloud dashboards using the Tableau Bridge.
-
Build Dashboards with Oracle Data in Dundas BI
Create dynamic dashboards and perform analytics based on Oracle Database in Dundas BI.
-
Create Humanity Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Humanity data access from reports, embedded analytics, and more.
-
Analyze SAP HANA Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of SAP HANA and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Deploy the ADO.NET Provider for Google Search on an SSRS Report Server
Connect to Google Search 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.
-
Create ServiceDesk Plus Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time ServiceDesk Plus data access from reports, embedded analytics, and more.
-
How to connect PolyBase to Jodoo
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Jodoo.
-
How to Visualize Browserless Data in Python with pandas
Use pandas and other modules to analyze and visualize live Browserless in Python.
-
Access ZendeskSell Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live ZendeskSell from HeidiSQL.
-
Query Kintone Data as a MySQL Database in Node.js
Execute MySQL queries against Kintone from Node.js.
-
Access Live ADP Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to ADP from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Use the CData Software ODBC Driver for Google Tasks in SAS for Real-Time Reporting and Analytics
Connect to real-time Google Tasks in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Google Tasks.
-
Create Browserless Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Browserless data access from reports, embedded analytics, and more.
-
How to Connect to Live Oracle Sales Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Oracle Sales for you.
-
Create a Data Access Object for Figshare Data using JDBI
A brief overview of creating a SQL Object API for Figshare in JDBI.
-
Connect to Pipedrive Data from PowerBuilder via ADO.NET
This article demonstrates how to access Pipedrive from Appeon PowerBuilder using the CData ADO.NET Provider for Pipedrive.
-
Extract, Transform, and Load Oracle Data in Informatica PowerCenter
Create a simple Workflow for Oracle Database in Informatica PowerCenter.
-
Import Smartsheet Data Using Azure Data Factory
Use CData Connect AI to connect to Smartsheet Data from Azure Data Factory and import live Smartsheet.
-
Query RSS Feeds in DataGrip
Create a Data Source for RSS in DataGrip and use SQL to query live RSS Feeds.
-
Use Dash to Build Web Apps on OneNote Data via CData Connect AI
Build interactive Dash web apps on live Microsoft OneNote using pandas and the CData Connect AI Python SDK.
-
Connect to Reckon Accounts Hosted Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Migrating data from Oracle Eloqua to Databricks using CData SSIS Components.
Easily push Oracle Eloqua to Databricks using the CData SSIS Tasks for Oracle Eloqua and Databricks.
-
Getting Started with the CData JDBC Driver for PivotalTracker
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for PivotalTracker.
-
Access PivotalTracker Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access PivotalTracker from your Oracle system.
-
Connect to Real-Time Avalara AvaTax Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Avalara AvaTax and Dataflow to import and use Avalara AvaTax in Power Apps.
-
Bind Live Cvent Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Cvent data
-
Connect to SharePoint Excel Services Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SharePoint Excel Services to connect to SharePoint Excel Services and execute queries in PowerBuilder.
-
Connect to Splunk Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Splunk Data and connect to Splunk in Akorbi Digital RunMyProcess.
-
Connect to Bright Data Data from a Connection Pool in JBoss
Integrate Bright Data into Java servlets: Use the Management Console in JBoss to install the Bright Data JDBC Driver.
-
Getting Started with the CData ODBC Driver for Exa
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Exa.
-
Integrating Claude Code CLI with Airtable 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.
-
Getting Started with the CData Excel Add-In for Smartsheet
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Smartsheet.
-
Connect to Excel Data in JRuby
Create a simple JRuby app with access to live Microsoft Excel.
-
How to connect to CSV Data with Squirrel SQL client
Connect to CSV/TSV Files and execute queries in the Squirrel SQL Client.
-
Create Power BI Reports on Real-Time Lakebase Data
Use the CData ODBC Driver for Lakebase to visualize Lakebase in Power BI Desktop.
-
Prepare, Blend, and Analyze MySQL Data in Alteryx Designer (ODBC)
Build workflows to access live MySQL for self-service data analytics.