CData Software - Knowledge Base
Recent Articles
-
Visualize Oracle Data in Tableau
The CData ODBC driver for Oracle enables you integrate Oracle data into Tableau dashboards.
-
How to publish and share Oracle Eloqua Reporting Data dashboards with Tableau Server
The CData ODBC driver for Oracle Eloqua Reporting enables you integrate Oracle Eloqua Reporting data into Tableau dashboards.
-
Integrating Antigravity CLI with Figshare data via CData CLI
Connect Figshare data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to Connect DBeaver to Google Spanner via a JDBC Driver
Manage Google Spanner data with visual tools in DBeaver like the query browser.
-
Integrate Live Zoho Creator Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Zoho Creator data from within the IDE.
-
Integrate Live Redshift Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Redshift from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Redshift data.
-
How to Connect Flowise AI Agents to Live SAP Hybris C4C Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live SAP Hybris C4C data without replication.
-
Connect to Google Calendar Data from Crystal Reports
Use CData Connect AI to connect to and report on live Google Calendar data from Crystal Reports.
-
Use Manus AI to Talk to Your JSON Services via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on JSON services.
-
Build ZohoDesk-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to ZohoDesk data and build web apps with connectivity to live ZohoDesk data.
-
Seamlessly Bring SAP Hybris C4C Data into Retool Using CData Connect AI
Integrate SAP Hybris C4C data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect to Tickspot Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Tickspot and the SQL Gateway to access Tickspot data from Google Apps Script.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for CampaignMonitor
Provide connectivity to CampaignMonitor data through an SAP BusinessObjects universe.
-
Use the CData Software JDBC Driver for xBase in MicroStrategy Desktop
Connect to xBase data in MicroStrategy Desktop using the CData Software JDBC Driver for xBase.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Wrike
Provide connectivity to Wrike data through an SAP BusinessObjects universe.
-
Getting Started with the CData Python Connector for Tavily
Learn to install and license the CData Python Connector and configure a connection to live Tavily data.
-
Operational Reporting on Dropbox Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Dropbox data.
-
Configuring Incremental Replication in CData Sync
This entry covers how to set up incremental replication for Data Sync.
-
Automated Continuous Amazon Athena Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Amazon Athena replication to IBM DB2.
-
Create Kafka-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Kafka Data from OutSystems and build custom enterprise apps using live Kafka data.
-
Integrate Dify with Live Google Campaign Manager 360 Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Google Campaign Manager 360 data.
-
Stream Sage 300 Data into Apache Kafka Topics
Access and stream Sage 300 data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate Open WebUI with Live Raisers Edge NXT Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Raisers Edge NXT data from within the chat interface.
-
Create Outreach.io-Connected Business Apps in AppSheet
Connect to Outreach.io Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Outreach.io data.
-
Interact with Live Pipedrive Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Pipedrive data.
-
Integrating Kiro with LinkedIn Ads 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 Snapchat Ads Replication to Vertica
Use CData Sync for automated, continuous, customizable Snapchat Ads replication to Vertica.
-
Replicate Paylocity Data to Multiple Databases
Replicate Paylocity data to disparate databases with a point-and-click configuration.
-
How to Query QuickBooks Online Data in MySQL Workbench
Execute MySQL queries against live QuickBooks Online data from MySQL Workbench.
-
Automate Bitbucket Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Bitbucket data from PowerShell? This article demonstrates how to utilize the Bitbucket Cmdlets for tasks like connecting to Bitbucket data, automating operations, downloading data, and more.
-
Connect to Real-Time Harvest Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Harvest data in Power Apps.
-
Integrating Codex with Avaza 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.
-
Provide OData Services of Stack Exchange Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Stack Exchange data by developing a WCF Service Application.
-
Integrate Raisers Edge NXT Data in the Pentaho Report Designer
Publish reports based on Raisers Edge NXT data in the Pentaho BI tool.
-
Create Data Visualizations in Cognos BI with SQL Analysis Services Data
Access SQL Analysis Services data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automated Continuous CloudConvert Replication to Snowflake
Use CData Sync for automated, continuous, customizable CloudConvert replication to Snowflake.
-
Natively Connect to Rebilly Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Rebilly data. Leverage the native support for ODBC in PHP.
-
Access Live ZendeskSell Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate ZendeskSell data into the statistical analysis tools available in SAS JMP. This article shows how to use ZendeskSell data in the Graph Builder and Query Builder.
-
How to connect to Hacker News Data in DBVisualizer
Integrate Hacker News data with visual data analysis tools and data connection wizards in DBVisualizer
-
Visualize Tally 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 Tally data into TIBCO Spotfire.
-
Build Pipelines with Live Coda Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Coda from Google Cloud Data Fusion, enabling the integration of live Coda data into the building and management of effective data pipelines.
-
Getting Started with the CData ADO.NET Provider for Stack Exchange
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Build DB2-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to DB2 data and build web apps with connectivity to live DB2 data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Humanity
Provide connectivity to Humanity data through an SAP BusinessObjects universe.
-
Integrating OpenCode with CockroachDB 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.
-
Connect to iContact from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from iContact data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Creating Avro-Connected Applications in Unqork
You can use CData Connect AI to feed Avro data to Unqork and build custom business apps.
-
Build Automated Workflows with Live Marketo Data in Workato
Use CData Connect AI to connect to live Marketo data and build automated workflows in Workato.
-
Create Oracle Financials Cloud Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Oracle Financials Cloud data access from reports, embedded analytics, and more.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Campaigner
Provide connectivity to Campaigner data through an SAP BusinessObjects universe.
-
Replicate Avalara AvaTax Data in Heroku for Use in Salesforce Connect
Replicate Avalara AvaTax data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use the CData Software JDBC Driver for NASA in MicroStrategy Web
Connect to NASA data in MicroStrategy Web using the CData Software JDBC Driver for NASA.
-
Connect to IBM Cloud Object Storage Data in DBArtisan
Use wizards in DBArtisan to configure IBM Cloud Object Storage data as a data source.
-
How to use SQLAlchemy ORM to access Templated Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Templated data.
-
Analyze Xero Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Xero data and visualize Xero data in SAP Analytics Cloud.
-
Connecting GenSpark with Airtable Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Airtable data without any replication or custom integration required.
-
Build MVC Applications with Connectivity to Workday Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Workday from an ASP.NET MVC application.
-
Replicate Multiple FormSite Accounts via the CData Sync CLI
Replicate multiple FormSite accounts to one or many databases.
-
Integrate OpenCode with Live Greenplum Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Greenplum data from within your AI coding agent.
-
Connect to NetSuite Data in DBeaver
Use the CData ODBC Driver to connect to NetSuite data in DBeaver.
-
Work with MailerLite Data in FoxPro
Load MailerLite data into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to connect to Rootly Data with Squirrel SQL client
Connect to Rootly data and execute queries in the Squirrel SQL Client.
-
Build a PostgreSQL Interface for Amazon Athena Data using the CData JDBC Driver
Use the Remoting features of the Amazon Athena JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use ChatGPT to Talk to Your IBM Cloud Object Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your IBM Cloud Object Storage data for you.
-
Create Power BI Reports on Real-Time CircleCI Data
Use the CData ODBC Driver for CircleCI to visualize CircleCI data in Power BI Desktop.
-
Integrate with eBay Data in SnapLogic
Use CData Connect AI to connect to and integrate with live eBay data in SnapLogic.
-
Natively Connect to Grafana Data in PHP
The CData ODBC driver for Grafana enables you to create PHP applications with connectivity to Grafana data. Leverage the native support for ODBC in PHP.
-
Import Xero Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Xero Data and provide access to live Xero data for custom reports in the Power BI Service.
-
Connect to Snowflake Data in NetBeans
Connect to Snowflake data in NetBeans with the data source configuration wizard.
-
How to Query Live Avro Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Avro data data in natural language using Python.
-
Integrate LibreChat with Live Neo4J Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Neo4J data from within the chat interface.
-
How to update Dynamics 365 Business Central from Excel
This article explains how to transfer data from Excel to Dynamics 365 Business Central using the Excel Add-In for Dynamics 365 Business Central.
-
Automated Continuous Foursquare Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Foursquare replication to IBM DB2.
-
DataBind Charts to ClickTime Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to ClickTime data 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.
-
Connect to Email Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Email as an External Source in Dremio.
-
How to connect Amazon QuickSight to Typeform Data
Create a connection to Typeform data in CData Connect AI and insert Typeform data into Amazon QuickSight SPICE to build interactive dashboards.
-
How to Use a Microsoft Access Database to Update AlloyDB Data in Real Time
Update AlloyDB data by creating a linked table in Microsoft Access with the CData AlloyDB ODBC Driver.
-
How to Connect to Live IBM Informix Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your IBM Informix data through natural language.
-
How to Connect Pipedrive 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 Pipedrive data in real time using natural language.
-
Visualize PayPal Data in TIBCO Spotfire through OData
Integrate PayPal data into dashboards in TIBCO Spotfire.
-
Analyze SAP Concur Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SAP Concur data in Microsoft R Open.
-
Automated Continuous Dynamics 365 Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Dynamics 365 data replication to OneLake in Microsoft Fabric.
-
How to Work with Google Sheets Data in AWS Glue Jobs Using JDBC
Connect to Google Sheets from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Live Cosmos DB Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Cosmos DB in CData Connect AI and connect to your Cosmos DB data from PostgreSQL.
-
Query Greenplum Data in ColdFusion
Write standard ColdFusion data access code to connect to Greenplum data.
-
Integrate with Apify Data in JReport Designer
Create charts and reports based on Apify data in JReport Designer.
-
Enable the Google Ads JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Google Ads data.
-
Easily Integrate Clockify Data in Lazarus Pascal IDE
Learn how to easily integrate live Clockify data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connecting GenSpark with Redshift Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Redshift data without any replication or custom integration required.
-
How to integrate Kintone with Apache Airflow
Access and process Kintone data in Apache Airflow using the CData JDBC Driver.
-
Create Dynamic Toggl Grids Using the Infragistics XamDataGrid
Learn how you can connect Toggl to Infragistics XamDataGrid to build dynamic grids.
-
Integrating LlamaIndex with IBM Cloud Object Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on IBM Cloud Object Storage data in real time.
-
Build Data Flows from Suadeo to SQL Server using SSIS
Easily back up Suadeo data to SQL Server using the SSIS components for Suadeo.
-
Access Splunk 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 Splunk data.
-
Integrate Devin with Live Salesforce Data 360 Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Salesforce Data 360 data.
-
Easily Integrate Box Data in Lazarus Pascal IDE
Learn how to easily integrate live Box data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create Power BI Reports on Real-Time Shippo Data
Use the CData ODBC Driver for Shippo to visualize Shippo data in Power BI Desktop.
-
Connect to Adobe Target Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Adobe Target data.
-
Replicate Hive Data in Heroku for Use in Salesforce Connect
Replicate Hive data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Automated Continuous PostgreSQL Replication to Vertica
Use CData Sync for automated, continuous, customizable PostgreSQL replication to Vertica.