CData Software - Knowledge Base
Recent Articles
-
Automated Continuous FreshBooks Replication to Databricks
Use CData Sync for automated, continuous, customizable FreshBooks replication to Databricks.
-
Stream Dropbox Data into Apache Kafka Topics
Access and stream Dropbox in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous HubSpot Replication to MongoDB
Use CData Sync for automated, continuous, customizable HubSpot replication to MongoDB.
-
Integrating Dataiku with Snowflake Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Snowflake.
-
Getting Started with the CData Excel Add-In for Microsoft Planner
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Microsoft Planner.
-
Build Sugar CRM-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Sugar CRM Data and create custom apps in Mendix.
-
Integrate Sybase IQ with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Sybase IQ with External Services.
-
How to Work with DB2 Data in ETL Validator JDBC
Connect to DB2 from ETL Validator jobs using the CData Software JDBC Driver.
-
How to create Visio diagrams from Oracle Sales Data
Automatically update Oracle Sales with the changes you make to Visio master shapes.
-
How to Connect to Live Microsoft Planner Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Microsoft Planner for you.
-
Automated Continuous CSV Replication to MySQL
Use CData Sync for automated, continuous, customizable CSV replication to MySQL.
-
Use the CData Software JDBC Driver for Clari in MicroStrategy
Connect to Clari in MicroStrategy Developer using the CData Software JDBC Driver for Clari.
-
Connect to Redis Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Redis.
-
Getting Started with the CData ADO.NET Provider for Oracle HCM Cloud
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Oracle HCM Cloud.
-
Getting Started with the CData Power BI Connector for Adobe Experience Manager
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Adobe Experience Manager.
-
Build JobNimbus-Powered Applications in Claude Code with CData MCP Server
Use the CData API Driver for MCP Server to explore live JobNimbus Data in Claude Code to assist with building JobNimbus-powered applications.
-
Build Dashboards with Guru Data in DBxtra
Create dynamic dashboards and perform analytics based on Guru in DBxtra.
-
Integrate Live Gmail Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Gmail from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Gmail.
-
How to Easily Query SAP Netweaver Gateway Data in OpenOffice Base
Connect to SAP Netweaver Gateway data in OpenOffice Base using the CData ODBC Driver for SAP Netweaver Gateway and generate reports with live data insights.
-
Integrate Jira Assets with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Jira Assets with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Jira Assets.
-
Automated Continuous Dynamics 365 Business Central Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to Amazon Redshift.
-
Replicate SharePoint Data to Multiple Databases via the CData Sync CLI
Replicate Microsoft SharePoint to disparate databases with a single configuration.
-
Visualize Live FHIR Data in the Power BI Service
Use CData Connect AI to connect to live FHIR and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous Paylocity Replication to Oracle
Use CData Sync for automated, continuous, customizable Paylocity replication to Oracle.
-
Process & Analyze Sage 200 Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Sage 200 Data.
-
Connect to DocuSign Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for DocuSign in the Denodo Virtual DataPort Administrator.
-
Visualize LionDesk Data in TIBCO Spotfire through OData
Integrate LionDesk into dashboards in TIBCO Spotfire.
-
Create a Data Access Object for Freshdesk Data using JDBI
A brief overview of creating a SQL Object API for Freshdesk in JDBI.
-
How to connect to Billsby Data from IntelliJ
Integrate connectivity to Billsby with wizards in IntelliJ.
-
Analyze Sendwithus Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Sendwithus with the CData JDBC Driver for Sendwithus.
-
Getting Started with the CData Excel Add-In for Aircall
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Aircall.
-
Create Smartsheet-Connected Business Apps in AppSheet
Connect to Smartsheet Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Smartsheet.
-
Provide OData Services of Amazon Marketplace Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Amazon Marketplace by developing a WCF Service Application.
-
Use the CData Software JDBC Driver for Instantly in MicroStrategy
Connect to Instantly in MicroStrategy Developer using the CData Software JDBC Driver for Instantly.
-
Integrate Authorize.Net with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Authorize.Net with External Services.
-
Visualize Live Planio Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Planio using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to integrate Metabase with Redshift Data
Use CData Connect AI to connect to live Amazon Redshift and create an interactive dashboard in Metabase from Amazon Redshift.
-
How to Work with Opsgenie Data in ETL Validator JDBC
Connect to Opsgenie from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect and Query Live Basecamp Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Basecamp into Databricks
-
Query Everhour Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Everhour and perform CRUD operations on Everhour from Node.js.
-
Configure the CData JDBC Driver for ZeroBounce in a Connection Pool in Tomcat
Connect to ZeroBounce from a connection pool in Tomcat.
-
How to Work with Greenplum Data in AWS Glue Jobs Using JDBC
Connect to Greenplum from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Query Live Salesforce CRM Analytics Data in Claude Desktop
Connect to and query live Salesforce CRM Analytics Data in Claude Desktop using CData MCP Server.
-
How to Access Live Ontraport Data in Visual Studio Code via Cline
Run CData API Driver for MCP Server on Windows Subsytem for Linux (WSL) and connect to live Ontraport from the Cline extension in Visual Studio Code.
-
Connect to Wistia Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Wistia in the Denodo Virtual DataPort Administrator.
-
Connect to SAP Netweaver Gateway Data in Google Apps Script via Connect AI
Use CData Connect AI to access SAP Netweaver Gateway in Google Apps Script.
-
Connect to Sage 300 Data in DBeaver
Use the CData ODBC Driver to connect to Sage 300 in DBeaver.
-
Visualize Live SAS xpt Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live SAS XPORT into custom reports in Power BI.
-
Integrating LangGraph with Shopify Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Shopify within automated workflows.
-
Object-Relational Mapping (ORM) with Perplexity 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 Perplexity into a Java-based ORM framework, Hibernate.
-
Create Spark-Connected Dashboards in Grafana
Connect to Spark Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Apache Spark SQL.
-
Automated Continuous Everhour Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Everhour replication to delimited files (CSV/TSV).
-
Use Dash to Build to Web Apps on Google Contacts Data
Create Python applications that use pandas and Dash to build Google Contacts-connected web apps.
-
Connect to Workday in SpagoBI
Create reports featuring live Workday in SpagoBI Studio. Host Workday reports on SpagoBI Server.
-
Edit and Search External Email Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Email to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Email Data objects that you can access from apps and the dashboard.
-
Create SSAS Tabular Models from ZohoExpense Data
How to build a SQL Server Analysis Service Tabular Model from ZohoExpense using CData drivers.
-
IBM Informix Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to IBM Informix through CData Connect AI using different applications and tools.
-
Use the CData API Server to Access Jumpseller Data in Microsoft PowerPivot
Use the CData API Server to connect to live Jumpseller in the Power Pivot business intelligence tool.
-
Replicate Multiple Chargebee Accounts
Replicate multiple Chargebee accounts to one or many databases.
-
Create Reports with Rebilly Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Rebilly.
-
ETL Google Spanner in Oracle Data Integrator
This article shows how to transfer Google Spanner into a data warehouse using Oracle Data Integrator.
-
Automate Teamwork Data Replication to Azure Data Lake
Use CData Sync to customize and automate Teamwork replication to Azure Data Lake.
-
Visualize Act CRM Data in TIBCO Spotfire through ADO.NET
Integrate Act CRM into dashboards in TIBCO Spotfire.
-
Visualize SAP Ariba Source 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 SAP Ariba Source into TIBCO Spotfire.
-
How to create an RPA flow for ZohoSubscriptions Data in UiPath Studio
Use the ZohoSubscriptions ODBC Driver to create workflows that access real-time ZohoSubscriptions without any coding.
-
Connect to Sage Intacct Data in RazorSQL
Connect to Sage Intacct from wizards and query Sage Intacct from the GUI in the RazorSQL database management tool.
-
Create Avro-Connected Business Apps in AppSheet
Connect to Avro Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Apache Avro.
-
Create Avro Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Avro from PowerBI.com to create Power BI Dataflows with real-time data.
-
Import Real-Time GraphQL Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use GraphQL in ColdFusion.
-
Create Informatica Mappings From/To a JDBC Data Source for Google Search
Create Google Search data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Exa Data in RapidMiner
Integrate Exa with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to SageHR in SpagoBI
Create reports featuring live SageHR in SpagoBI Studio. Host SageHR reports on SpagoBI Server.
-
Connect to DocuSign Data in RazorSQL
Connect to DocuSign from wizards and query DocuSign from the GUI in the RazorSQL database management tool.
-
Visualize Live Act-On Data in the Power BI Service
Use CData Connect AI to connect to live Act-On and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Agents in Relevance AI with Access to Live Microsoft Exchange Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Microsoft Exchange within intelligent agent workflows.
-
Access Live EmailOctopus Data in Coginiti Pro
Connect to and query live EmailOctopus from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
SendInBlue Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SendInBlue facts in real time.
-
Query SAP HANA XS Advanced Data from Node.js
Use the OData endpoint of the CData API Server to connect to your SAP HANA XS Advanced and perform CRUD operations on SAP HANA XS Advanced from Node.js.
-
Visualize Live ServiceNow Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live ServiceNow.
-
Access Live Redis Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Redis from your Google Sheets.
-
Build Automated Sugar CRM-Connected Workflows in Zapier
Use CData Connect AI to connect to live Sugar CRM and build automated workflows in Zapier.
-
How to Seamlessly Import Adobe Commerce Data into IBM SPSS Modeler
Integrate Adobe Commerce data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Data Flows from JotForm to SQL Server using SSIS
Easily back up JotForm to SQL Server using the SSIS components for JotForm.
-
Replicate Paddle Data from PowerShell
Write a quick PowerShell script to query Paddle. Use connectivity to the live data to replicate Paddle to SQL Server.
-
Migrating data from Trello to Snowflake using CData SSIS Components.
Easily push Trello to Snowflake using the CData SSIS Tasks for Trello and Snowflake.
-
Integrate Live MessageBird Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live MessageBird to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrate Sage Cloud Accounting Data in the Pentaho Report Designer
Publish reports based on Sage Business Cloud Accounting in the Pentaho BI tool.
-
Connect to and Query Zoho Inventory Data in QlikView over ODBC
Create data visualizations with Zoho Inventory in QlikView.
-
Query Twilio Data in ColdFusion
Write standard ColdFusion data access code to connect to Twilio.
-
Use JayDeBeApi to access iContact Data in Python
Use standard Python scripting and the development environment of your choice to access live iContact.
-
Automated Continuous Freshsales Replication to Vertica
Use CData Sync for automated, continuous, customizable Freshsales replication to Vertica.
-
Build Semantic Layer Views for Spark Data in APOS Live Data Gateway
Use the CData Connector for Spark in APOS Live Data Gateway to build Semantic Layer Views for Apache Spark SQL.
-
Integrating EnterpriseDB Data in Talend Cloud Data Management Platform
Connect EnterpriseDB Data with Talend Cloud Data Management Platform using the CData JDBC Driver for EnterpriseDB.
-
Process & Analyze Productboard Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Productboard Data.
-
Integrating LangGraph with Klaviyo Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Klaviyo within automated workflows.
-
Connect to Pushbullet Data in DBArtisan
Use wizards in DBArtisan to configure Pushbullet as a data source.
-
Visualize Live Yelp Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Yelp.
-
Integrate Pinterest with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Pinterest with External Services.
-
How to Build an ETL App for Google Drive Data in Python with CData
Create ETL applications and real-time data pipelines for Google Drive in Python with petl.
-
How to Connect to Live Bullhorn CRM Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Bullhorn CRM for you.