CData Software - Knowledge Base
Recent Articles
-
How to create Visio diagrams from Zendesk Data
Automatically update Zendesk with the changes you make to Visio master shapes.
-
Connect to SAP Business Warehouse Data in Ruby
Connect to SAP Business Warehouse in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to IBM Cloud Object Storage Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live IBM Cloud Object Storage.
-
Connect to LaunchDarkly Data in DBeaver
Use the CData ODBC Driver to connect to LaunchDarkly in DBeaver.
-
Connect to Excel Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Excel and the SQL Gateway to access Microsoft Excel from Google Apps Script.
-
Create Informatica Mappings From/To a JDBC Data Source for Chargebee
Create Chargebee data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to create an RPA flow for Cvent Data in UiPath Studio
Use the Cvent ODBC Driver to create workflows that access real-time Cvent without any coding.
-
Analyze Zoom Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Zoom and visualize Zoom in SAP Analytics Cloud.
-
Automated Xero Data Replication to Teradata
Use CData Sync to Customize and automate Xero Accounting replication to Teradata.
-
Access Microsoft Dataverse 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 Microsoft Dataverse (CDS).
-
Integrating Kiro CLI with Trello 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.
-
A PostgreSQL Interface for EmailOctopus Data (MySQL Remoting via JDBC)
Use the Remoting features of the EmailOctopus JDBC Driver to create a PostgreSQL entry-point for data access.
-
Using the CData Software ODBC Driver for Bitly in PyCharm
Connect to Bitly as an ODBC data source in PyCharm using the CData Software ODBC Driver for Bitly.
-
Configure the CData JDBC Driver for Adobe Commerce in a Connection Pool in Tomcat
Connect to Adobe Commerce from a connection pool in Tomcat.
-
Viewing Printify Data in RAD Studio Data Explorer
How to view Printify in RAD Studio Data Explorer using the CData ODBC Driver for Printify.
-
Automated Continuous ChargeOver Replication to Oracle
Use CData Sync for automated, continuous, customizable ChargeOver replication to Oracle.
-
Visualize Live OpenWeatherMap Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live OpenWeatherMap using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access Teamgate 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 Teamgate.
-
Use the CData Software JDBC Driver for Salesforce Data 360 in MicroStrategy Web
Connect to Salesforce Data 360 in MicroStrategy Web using the CData Software JDBC Driver for Salesforce Data 360.
-
Automated Continuous Outreach.io Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Outreach.io replication to Google Cloud SQL.
-
Connect to Salesloft Data in NetBeans
Connect to Salesloft in NetBeans with the data source configuration wizard.
-
Visualize Live JSON Services of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live JSON using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Using the CData Software ODBC Driver for Coda in PyCharm
Connect to Coda as an ODBC data source in PyCharm using the CData Software ODBC Driver for Coda.
-
How to Visualize Zoho Inventory 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 Zoho Inventory in Python.
-
Slowly Changing Dimensions (SCD): A No-Code Approach
This article introduces SCD and demonstrates implementing SCDs using CData Sync with CDC, dbt, and ELT.
-
Access Live SAP Hybris C4C Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP Hybris C4C from your Excel spreadsheets.
-
Connect to Spark Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Spark as an External Source in Dremio.
-
Replicate Mailgun Data from PowerShell
Write a quick PowerShell script to query Mailgun. Use connectivity to the live data to replicate Mailgun to SQL Server.
-
Integrate Azure Synapse Data into Power Automate Desktop using CData Connect
CData Connect for Azure Synapse Data enables you to integrate Azure Synapse into workflows built using Microsoft Power Automate Desktop.
-
Build Charts with Neo4J Data in Clear Analytics
Create dynamic charts and perform analytics based on Neo4J in Clear Analytics.
-
Build a PostgreSQL Interface for Oracle HCM Cloud Data using the CData JDBC Driver
Use the Remoting features of the Oracle HCM Cloud JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Asana Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Asana to connect to Asana and execute queries in PowerBuilder.
-
Access Front Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Front from your Oracle system.
-
Send Messages to a Specified Microsoft Teams Channel with CData Drivers
Learn how to load CSV files into Airtable through CData Airtable SyncCSV stored procedure in DBeaver.
-
Access Live Oracle Service Cloud Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Oracle Service Cloud into the statistical analysis tools available in SAS JMP. This article shows how to use Oracle Service Cloud in the Graph Builder and Query Builder.
-
Automated Continuous LDAP Replication to SQL Server
Use CData Sync for automated, continuous, customizable LDAP replication to SQL Server.
-
Using the CData Software ODBC Driver for Excel in PyCharm
Connect to Excel as an ODBC data source in PyCharm using the CData Software ODBC Driver for Excel.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Pivotal GreenPlum to Power BI dashboards. Simply drag and drop Pivotal GreenPlum into data visuals on the Power BI canvas.
-
Build Apps with Live Microsoft SharePoint in Adalo using CData Connect AI
Use CData Connect AI to integrate live Microsoft SharePoint into the Adalo platform and build custom mobile and web applications with real-time Microsoft SharePoint.
-
Getting Started with the CData SSIS Components for eBay Analytics
Complete guide to installing, licensing, and connecting with the CData SSIS Components for eBay Analytics.
-
How to Connect to Live Redis Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Redis securely in real time.
-
How to Access Live SAP SuccessFactors LMS Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SAP SuccessFactors LMS enables you to integrate SAP SuccessFactors LMS into workflows built using Microsoft Power Automate Desktop.
-
Analyze Redshift Data in Looker
Use CData Connect AI to connect to Redshift Data from Looker and build custom apps using live Amazon Redshift.
-
Create Power BI Reports on Real-Time ClickTime Data
Use the CData ODBC Driver for ClickTime to visualize ClickTime in Power BI Desktop.
-
Create Data Visualizations Based On Elasticsearch Data in Mode
Use CData Connect AI to connect to Elasticsearch Data from Mode and build visualizations using live
-
Integrate with XML Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy XML Files to a JSON file on disk.
-
How to Work with Oracle Sales Data in ETL Validator JDBC
Connect to Oracle Sales from ETL Validator jobs using the CData Software JDBC Driver.
-
How to connect and process JSON from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live JSON.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live eBay within intelligent workflows.
-
Integrating Kiro CLI with MailerSend 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.
-
Automated Continuous Todoist Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Todoist replication to delimited files (CSV/TSV).
-
How to Work with EnterpriseDB Data in ETL Validator JDBC
Connect to EnterpriseDB from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Zoho Projects Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Zoho Projects.
-
Connect to Pipeline CRM Data in HULFT Integrate
Connect to Pipeline CRM as a JDBC data source in HULFT Integrate
-
Publish ZohoExpense-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live ZohoExpense.
-
Build Charts with Coda Data in Clear Analytics
Create dynamic charts and perform analytics based on Coda in Clear Analytics.
-
Create Reports with Landbot Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Landbot.
-
Prepare, Blend, and Analyze LinkedIn Data in Alteryx Designer (ODBC)
Build workflows to access live LinkedIn for self-service data analytics.
-
Integrate LibreChat with Live SAP SuccessFactors LMS Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live SAP SuccessFactors LMS from within the chat interface.
-
Integrate Google Ad Manager Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Google Ad Manager and integrate live Google Ad Manager into your Power Automate tasks.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for PagerDuty
Provide connectivity to PagerDuty through an SAP BusinessObjects universe.
-
Create Reports from WooCommerce Data in Looker Studio
Use CData Connect AI to gain access to live WooCommerce and create custom reports in Looker Studio.
-
Build ShipEngine-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live ShipEngine.
-
Use the CData API Server to Access Power BI XMLA Data in Microsoft PowerPivot
Use the CData API Server to connect to live Power BI XMLA in the Power Pivot business intelligence tool.
-
Access Live eBay Data in Excel 365 Online (Excel for the web)
Connect to eBay from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Object-Relational Mapping (ORM) with Zoho Creator 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 Zoho Creator into a Java-based ORM framework, Hibernate.
-
Feed eBay Data into FineReport
How to set eBay as a JDBC data source in FineReport.
-
Integrating Claude Code with SAP Fieldglass Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on SAP Fieldglass within assisted coding and automated development workflows.
-
DataBind Controls to Aha! Data in Delphi
DataBind to Aha! in Delphi with standard data access components and controls.
-
Seamlessly Bring Amazon DynamoDB Data into Retool Using CData Connect AI
Integrate Amazon DynamoDB data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Build MongoDB-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to MongoDB and build web apps with connectivity to live MongoDB.
-
Visualize Microsoft Teams Data in Sisense
Create an ElastiCube in Sisense app with access to Microsoft Teams.
-
Create Reports with Google Tasks Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Tasks.
-
Import Real-Time MailerSend Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use MailerSend in ColdFusion.
-
Visualize ZohoExpense Data in TIBCO Spotfire through ADO.NET
Integrate ZohoExpense into dashboards in TIBCO Spotfire.
-
Build Sybase-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Sybase.
-
How to Import Data from Monday.com into Google Sheets
Import Monday.com into a Google spreadsheet that is automatically refreshed.
-
How to connect PolyBase to Blackbaud FE NXT
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Blackbaud FE NXT.
-
Sage 200 Reporting in OBIEE with the Sage 200 JDBC Driver
Deploy the Sage 200 JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous Grafana Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Grafana replication to Google Cloud SQL.
-
Connect to IBM Cloud Object Storage Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for IBM Cloud Object Storage.
-
Automated Continuous SAP Netweaver Gateway Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SAP Netweaver Gateway replication to Google BigQuery.
-
Build Amazon S3-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Amazon S3 and build Amazon S3-connected web apps with Axios.
-
Automated Continuous MYOB AccountRight Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to Apache Cassandra.
-
How to create an RPA flow for Amazon Athena Data in UiPath Studio
Use the Amazon Athena ODBC Driver to create workflows that access real-time Amazon Athena without any coding.
-
Access ZohoPeople Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live ZohoPeople from HeidiSQL.
-
Access SingleStore Data from MySQL in Amazon QuickSight
Connect to SingleStore and build visualizations of SingleStore using a MySQL Connection in Amazon QuickSight.
-
Create Informatica Mappings From/To an ODBC Data Source for MailerSend
Create an ODBC connection to MailerSend in Informatica and browse and transfer MailerSend.
-
Use the CData Software JDBC Driver for Superchat in MicroStrategy Web
Connect to Superchat in MicroStrategy Web using the CData Software JDBC Driver for Superchat.
-
Edit and Search Avalara AvaTax External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Avalara AvaTax to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Avalara AvaTax objects that you can access from apps and the dashboard.
-
Getting Started with the CData SSIS Components for Nethunt
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Nethunt.
-
How to Access Live CloudConvert Data in Power Automate Desktop via ODBC
The CData ODBC Driver for CloudConvert enables you to integrate CloudConvert into workflows built using Microsoft Power Automate Desktop.
-
A PostgreSQL Interface for Jumpseller Data using the CData ODBC Driver
Use the SQL Gateway and Jumpseller ODBC Driver to create a PostgreSQL entry-point for data access.
-
SurveyMonkey Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SurveyMonkey facts in real time.
-
Automate Humanity Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Humanity from PowerShell? This article demonstrates how to utilize the Humanity Cmdlets for tasks like connecting to Humanity, automating operations, downloading data, and more.
-
Automated Continuous ZohoExpense Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable ZohoExpense replication to Apache Cassandra.
-
Migrating data from Wave Financial to Google BigQuery using CData SSIS Components.
Easily push Wave Financial to Google BigQuery using the CData SSIS Tasks for Wave Financial and Google BigQuery.
-
Automated Continuous Typeform Replication to Databricks
Use CData Sync for automated, continuous, customizable Typeform replication to Databricks.
-
Import Real-Time HubDB Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use HubDB in ColdFusion.
-
Create a Data Access Object for OnePageCrm Data using JDBI
A brief overview of creating a SQL Object API for OnePageCrm in JDBI.