CData Software - Knowledge Base
Recent Articles
-
Create Excel Online Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Excel Online data access from reports, embedded analytics, and more.
-
How to connect to Zendesk Data in DBVisualizer
Integrate Zendesk data with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate Live QuickBooks Online Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live QuickBooks Online data to Blue Prism using the CData ODBC Driver for QuickBooks Online to create automated workflows for repetitive business tasks.
-
Connect to Zoho Inventory from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Zoho Inventory data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Write a Simple Go Application to work with JotForm Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to JotForm data.
-
Connect to SharePoint Excel Services Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SharePoint Excel Services as an External Source in Dremio.
-
Automated Continuous Dotmailer Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Dotmailer replication to PostgreSQL.
-
Access FormSite Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live FormSite data from HeidiSQL.
-
Build Agents in Relevance AI with Access to Live HDFS Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on HDFS data within intelligent agent workflows.
-
Use JayDeBeApi to access Zoho CRM Data in Python
Use standard Python scripting and the development environment of your choice to access live Zoho CRM data.
-
Consume Salesforce Marketing OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Salesforce Marketing feeds that reflect any changes in SAP Lumira.
-
ETL Perigon in Oracle Data Integrator
This article shows how to transfer Perigon data into a data warehouse using Oracle Data Integrator.
-
How to Work with Supabase Data in AWS Glue Jobs Using JDBC
Connect to Supabase from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Publish Crystal Reports on Amazon Athena Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Amazon Athena data.
-
Analyze FreshBooks Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for FreshBooks from Power Pivot. You will use the Table Import Wizard to load FreshBooks data. You can visually build the import query or use any SQL supported by the driver.
-
Link Ontraport with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Ontraport data in Filemaker Pro for Mac or Windows.
-
Build Dynamics CRM-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Dynamics CRM data.
-
Automated Continuous Twitter Ads Replication to Oracle
Use CData Sync for automated, continuous, customizable Twitter Ads replication to Oracle.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Aha!
Provide connectivity to Aha! data through an SAP BusinessObjects universe.
-
Build Visualizations of Authorize.Net Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Authorize.Net data in Birst.
-
How to Visualize Gumroad Data in Python with pandas
Use pandas and other modules to analyze and visualize live Gumroad data in Python.
-
How to connect to ZeroBounce Data in DBVisualizer
Integrate ZeroBounce data with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Freshteam-Connected Dashboards in Grafana
Connect to Freshteam Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Freshteam data.
-
Connect to and Query MessageBird Data in QlikView over ODBC
Create data visualizations with MessageBird data in QlikView.
-
Integrating LangGraph with QuickBooks Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on QuickBooks data within automated workflows.
-
Configure the CData JDBC Driver for Contentful in a Connection Pool in Tomcat
Connect to Contentful data from a connection pool in Tomcat.
-
Access Live OneNote Data in AWS Lambda
Connect to live OneNote data in AWS Lambda using the CData JDBC Driver.
-
Aircall Reporting in OBIEE with the Aircall JDBC Driver
Deploy the Aircall JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Replicate Autopilot Data to Multiple Databases
Replicate Autopilot data to disparate databases with a point-and-click configuration.
-
Use Biml to Build SSIS Tasks to Replicate Figshare Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Figshare data to SQL Server.
-
Prepare, Blend, and Analyze SQL Analysis Services Data in Alteryx Designer (ODBC)
Build workflows to access live SQL Analysis Services data for self-service data analytics.
-
Build MVC Applications with Connectivity to Excel Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Excel from an ASP.NET MVC application.
-
Interact with Live SAP BusinessObjects BI Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live SAP BusinessObjects BI data.
-
Use the CData Software ODBC Driver for ClickUp in MicroStrategy Web
Connect to ClickUp data in MicroStrategy Web using the CData Software ODBC Driver for ClickUp.
-
Build Attio-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Attio Data and create custom apps in Mendix.
-
Visualize PagerDuty Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to PagerDuty data.
-
View Reports on Real-Time Wistia Data in Power BI Report Server
Use the CData ODBC Driver for Wistia to visualize Wistia data in Power BI Desktop and then publish them to Power BI Report Server.
-
Analyze SAS Data Sets Data in Looker
Use CData Connect AI to connect to SAS Data Sets Data from Looker and build custom apps using live SAS Data Sets data.
-
Create Reports with SAP SuccessFactors LMS Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP SuccessFactors LMS data.
-
Create a Data Access Object for Dynamics 365 Business Central Data using JDBI
A brief overview of creating a SQL Object API for Dynamics 365 Business Central data in JDBI.
-
How to work with Wrike Data in Apache Spark using SQL
Access and process Wrike Data in Apache Spark using the CData Software JDBC Driver.
-
Create Data Visualizations in Cognos BI with xBase Data
Access xBase data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Bidirectional Access to Salesforce Marketing Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Salesforce Marketing data in Filemaker Pro for Mac or Windows.
-
How to create Gumroad federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Gumroad data in MySQL .
-
Analyze Highrise Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Highrise data and visualize live Highrise data in Infragistics Reveal.
-
Automated Continuous Lakebase Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Lakebase replication to delimited files (CSV/TSV).
-
Create ZarMoney Dataflows on PowerBI.com
Connect to the CData Power BI Connector for ZarMoney from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Kafka Data in Google Apps Script via Connect AI
Use CData Connect AI to access Kafka data in Google Apps Script.
-
Visualize CircleCI Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to CircleCI data.
-
Bridge LDAP Connectivity with Apache NiFi
Access and process LDAP objects in Apache NiFi using the CData JDBC Driver.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Templated
Provide connectivity to Templated data through an SAP BusinessObjects universe.
-
Connect to FTP Data in HULFT Integrate
Connect to FTP as a JDBC data source in HULFT Integrate
-
Use Biml to Build SSIS Tasks to Replicate ChargeOver Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate ChargeOver data to SQL Server.
-
How to Access Google Ads Data Using Entity Framework
This article shows how to access Google Ads data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrate with Oracle Financials Cloud Data in JReport Designer
Create charts and reports based on Oracle Financials Cloud data in JReport Designer.
-
How to import Optimizely Data into Apache Solr
Use the CData Software JDBC Driver for Optimizely in Data Import Handler and create an automated import of Optimizely data to Apache Solr Enterprise Search platform.
-
Stream Snapchat Ads Data into Apache Kafka Topics
Access and stream Snapchat Ads data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Visualize ZohoInvoice Data in Python with pandas
Use pandas and other modules to analyze and visualize live ZohoInvoice data in Python.
-
How to Connect to Live Active Directory 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 Active Directory data for you.
-
Connect to MailerLite Data in Jaspersoft Studio
Execute SQL to remote MailerLite data in Jaspersoft Studio.
-
Access Live Cohere Data in AWS Lambda
Connect to live Cohere data in AWS Lambda using the CData JDBC Driver.
-
How to connect Amazon QuickSight to Snowflake Data
Create a connection to Snowflake data in CData Connect AI and insert Snowflake data into Amazon QuickSight SPICE to build interactive dashboards.
-
How to work with Zoho Creator Data in Apache Spark using SQL
Access and process Zoho Creator Data in Apache Spark using the CData Software JDBC Driver.
-
Create Dynamic Sage Cloud Accounting Grids Using the Infragistics XamDataGrid
Learn how you can connect Sage Cloud Accounting to Infragistics XamDataGrid to build dynamic grids.
-
Use Azure AI Foundry to Talk to Your SAP Ariba Source Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your SAP Ariba Source data for you.
-
Use the CData Software JDBC Driver for Monday.com in MicroStrategy Web
Connect to Monday.com data in MicroStrategy Web using the CData Software JDBC Driver for Monday.com.
-
How to Seamlessly Import SendInBlue Data into IBM SPSS Modeler
Integrate SendInBlue data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automated Continuous Sage 300 Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Sage 300 replication to Amazon Redshift.
-
Automated Continuous Trello Replication to SQL Server
Use CData Sync for automated, continuous, customizable Trello replication to SQL Server.
-
Visualize Datadog Data in TIBCO Spotfire through ADO.NET
Integrate Datadog data into dashboards in TIBCO Spotfire.
-
How to Access Timely Data Using Entity Framework
This article shows how to access Timely data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Prepare, Blend, and Analyze Oracle HCM Cloud Data in Alteryx Designer (Connect AI)
Build workflows to access live Oracle HCM Cloud data for self-service data analytics.
-
How to use SQLAlchemy ORM to access Freshservice Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Freshservice data.
-
Query FreshBooks Data as a MySQL Database in Node.js
Execute MySQL queries against FreshBooks data from Node.js.
-
Connect to Power BI XMLA Data in DBeaver
Use the CData ODBC Driver to connect to Power BI XMLA data in DBeaver.
-
Use Dash to Build to Web Apps on FormSite Data
Create Python applications that use pandas and Dash to build FormSite-connected web apps.
-
How to create an RPA flow for Presto Data in UiPath Studio
Use the Presto ODBC Driver to create workflows that access real-time Presto data without any coding.
-
Replicate Multiple ZeroBounce Accounts via the CData Sync CLI
Replicate multiple ZeroBounce accounts to one or many databases.
-
How to load HDFS data into Elasticsearch via Logstash
Introducing a simple method to load HDFS data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Xero from Asprova with CData Software ODBC Driver for Xero
This article shows how to connect faster to Xero data from Asprova.
-
Build AI/ML Models with Live Dynamics 365 Data using Dataiku
Connect Dynamics 365 Data with Dataiku using the CData JDBC Driver for Dynamics 365.
-
How to import Teamgate Data into Apache Solr
Use the CData Software JDBC Driver for Teamgate in Data Import Handler and create an automated import of Teamgate data to Apache Solr Enterprise Search platform.
-
Build Semantic Layer Views for Coinbase Data in APOS Live Data Gateway
Use the CData Connector for Coinbase in APOS Live Data Gateway to build Semantic Layer Views for Coinbase data.
-
DataBind Controls to HubSpot Data in C++Builder
DataBind to HubSpot data in C++Builder with standard components and controls.
-
Access Zoho Creator Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Zoho Creator data from your Oracle system.
-
Natively Connect to WordPress Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to WordPress data. Leverage the native support for ODBC in PHP.
-
How to work with FTP Data in Apache Spark using SQL
Access and process FTP Data in Apache Spark using the CData Software JDBC Driver.
-
Operational Reporting on GitHub Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote GitHub data.
-
Integrate with Redshift Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Redshift data to a JSON file on disk.
-
Replicate Multiple Google Cloud Storage Accounts via the CData Sync CLI
Replicate multiple Google Cloud Storage accounts to one or many databases.
-
Access Quaderno 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 Quaderno data.
-
Connect to Acumatica Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Acumatica as an External Source in Dremio.
-
Create Data Visualizations Based On Google Analytics Data in Mode
Use CData Connect AI to connect to Google Analytics Data from Mode and build visualizations using live Google Analytics data.
-
Publish HCL Domino-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live HCL Domino data.
-
Use the CData ODBC Driver for Microsoft Ads from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Microsoft Ads to connect to Microsoft Ads data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Microsoft Ads data in Excel.
-
Creating Oracle-Connected Applications in Unqork
You can use CData Connect AI to feed Oracle data to Unqork and build custom business apps.
-
Create Google Campaign Manager 360-Connected Applications in Appsmith
Connect to Google Campaign Manager 360 Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Google Campaign Manager 360 data.
-
Replicate Sage Intacct Data to Multiple Databases via the CData Sync CLI
Replicate Sage Intacct data to disparate databases with a single configuration.
-
Connect to Printify Data from PowerBuilder via JDBC
This article demonstrates how to access Printify data from PowerBuilder using the Printify JDBC Driver.
-
DataBind Controls to Epicor Kinetic Data in Delphi
DataBind to Epicor Kinetic data in Delphi with standard data access components and controls.