CData Software - Knowledge Base
Recent Articles
-
Integrate HDFS Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Apache HDFS from Informatica Cloud.
-
Automated Jumpseller Data Replication to Teradata
Use CData Sync to Customize and automate Jumpseller replication to Teradata.
-
Create GraphQL-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to GraphQL Data from OutSystems and build custom enterprise apps using live GraphQL.
-
Design BIRT Reports on Close Data
Provide current Close to your embedded analytics.
-
Automated Continuous TaxJar Replication to Amazon S3
Use CData Sync for automated, continuous, customizable TaxJar replication to Amazon S3.
-
Import Zoho Books Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Zoho Books Data and provide access to live Zoho Books for custom reports in the Power BI Service.
-
Automate Jira Data Replication to Couchbase
Use CData Sync to Customize and automate Atlassian Jira replication to Couchbase.
-
Using the CData Software ODBC Driver for Oracle Sales in PyCharm
Connect to Oracle Sales as an ODBC data source in PyCharm using the CData Software ODBC Driver for Oracle Sales.
-
How to connect PolyBase to Attio
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Attio.
-
Visualize Epicor Kinetic Data in Tableau
The CData ODBC driver for Epicor Kinetic enables you integrate Epicor Kinetic into Tableau dashboards.
-
Analyze Oracle Eloqua Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Oracle Eloqua and visualize live Oracle Eloqua in Infragistics Reveal.
-
Automated Continuous Mailjet Replication to Oracle
Use CData Sync for automated, continuous, customizable Mailjet replication to Oracle.
-
Use Azure AI Foundry to Talk to Your Raisers Edge NXT 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 Raisers Edge NXT for you.
-
Operational Reporting on Omnisend Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Omnisend.
-
Use the CData Software JDBC Driver for ZohoDesk in MicroStrategy Desktop
Connect to ZohoDesk in MicroStrategy Desktop using the CData Software JDBC Driver for ZohoDesk.
-
Connect PolarTeamPro Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your PolarTeamPro using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to connect to MySQL Data with Squirrel SQL client
Connect to MySQL and execute queries in the Squirrel SQL Client.
-
Integrating OpenCode Terminal with SendPulse 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.
-
How to Build an ETL App for Mailgun Data in Python with CData
Create ETL applications and real-time data pipelines for Mailgun in Python with petl.
-
Create Data Visualizations Based On LinkedIn Ads Data in Mode
Use CData Connect AI to connect to LinkedIn Ads Data from Mode and build visualizations using live
-
Integrating Gumloop with MySQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on MySQL within automated workflows.
-
How to Connect to Live Sybase 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 Sybase for you.
-
Integrating Kiro CLI with ZarMoney 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.
-
Create Reports with Delighted Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Delighted.
-
Use the CData Software ODBC Driver for Stack Exchange in MicroStrategy
Connect to Stack Exchange in MicroStrategy Developer using the CData Software ODBC Driver for Stack Exchange.
-
Integrating LlamaIndex with SAP HANA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on SAP HANA in real time.
-
Analyze ConstantContact Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze ConstantContact with the CData JDBC Driver for ConstantContact.
-
How to Import Data from Blackbaud FE NXT into Google Sheets
Import Blackbaud FE NXT into a Google spreadsheet that is automatically refreshed.
-
Automated Continuous Lakebase Replication to Oracle
Use CData Sync for automated, continuous, customizable Lakebase replication to Oracle.
-
How to Easily Query Front Data in OpenOffice Base
Connect to Front data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Building Dynamic Web Pages with SFTP Data Using AngularJS
Create single-page applications with live connectivity to SFTP using the CData API Server.
-
How to Connect the Power BI Service to Billsby: Complete Guide
Connect to the CData Software Power BI Connector for Billsby from PowerBI.com to provide real-time Billsby across the organization.
-
How to connect and process Miro from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Miro.
-
Edit and Search Google Spanner External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Google Spanner to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Google Spanner objects that you can access from apps and the dashboard.
-
Enable the Vimeo JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Vimeo.
-
Build Apps with Live Mixpanel Data Using the Low-Code Development Platform of Mendix
Connect Mixpanel with Mendix to build apps using the CData API Driver for JDBC.
-
Integrate with Salesforce Data 360 Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Salesforce Data 360 to a JSON file on disk.
-
Use Manus AI to Talk to Your Redis Data 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 Redis.
-
Query Printful Data in DataGrip
Create a Data Source for Printful in DataGrip and use SQL to query live Printful.
-
Create Datasets from Zendesk in Domo Workbench and Build Visualizations of Zendesk Data in Domo
Use the CData Software ODBC Driver for Zendesk to create datasets from Zendesk in Domo Workbench and then build visualizations in the Domo service.
-
Automate Raisers Edge NXT Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Raisers Edge NXT from PowerShell? This article demonstrates how to utilize the Raisers Edge NXT Cmdlets for tasks like connecting to Raisers Edge NXT, automating operations, downloading data, and more.
-
Integrate Gmail Data into Power Automate Desktop using CData Connect
CData Connect for Gmail Data enables you to integrate Gmail into workflows built using Microsoft Power Automate Desktop.
-
Visualize Klipfolio 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 Klipfolio into TIBCO Spotfire.
-
Write a Simple Go Application to work with PagerDuty Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to PagerDuty.
-
Connect to SurveyMonkey Data in NetBeans
Connect to SurveyMonkey in NetBeans with the data source configuration wizard.
-
Integrating LangChain with Adobe Commerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Adobe Commerce within automated workflows.
-
Build AI/ML Models with Live Highrise Data using Dataiku
Connect Highrise Data with Dataiku using the CData JDBC Driver for Highrise.
-
Create Informatica Mappings From/To an ODBC Data Source for Acumatica
Create an ODBC connection to Acumatica in Informatica and browse and transfer Acumatica ERP.
-
Automate Unbounce Data Replication to Azure Synapse
Use CData Sync to customize and automate Unbounce replication to Azure Synapse.
-
Create Dashboards and Visualize Live Zoho Inventory Data in Geckoboard
Use CData Connect AI to connect to live Zoho Inventory and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect to Figshare Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Figshare as an External Source in Dremio.
-
Use Dash to Build to Web Apps on Insightly Data
Create Python applications that use pandas and Dash to build Insightly-connected web apps.
-
Getting Started with the CData Excel Add-In for Instantly
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Instantly.
-
How to Connect to Live Vertica 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 Vertica for you.
-
Integrate with Google Analytics Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Google Analytics in SnapLogic.
-
Write a Simple Go Application to work with ZohoPeople Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to ZohoPeople.
-
Extract, Transform, and Load Access Data in Informatica PowerCenter
Create a simple Workflow for Microsoft Access in Informatica PowerCenter.
-
Integrating Cursor CLI with ElevenLabs 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.
-
Build Data Flows from Calendly to SQL Server using SSIS
Easily back up Calendly to SQL Server using the SSIS components for Calendly.
-
How to use SQLAlchemy ORM to access Figshare Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Figshare.
-
Integrating ClickUp Data in Talend Cloud Data Management Platform
Connect ClickUp Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Visualize Live Adobe Analytics Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Adobe Analytics using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Work with OpenWeatherMap Data in ETL Validator JDBC
Connect to OpenWeatherMap from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Connect to & Open EnterpriseDB Data in Microsoft Excel
This article uses the CData ODBC driver for EnterpriseDB to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create Dynamic Supabase Grids Using the Infragistics XamDataGrid
Learn how you can connect Supabase to Infragistics XamDataGrid to build dynamic grids.
-
Access Azure Data Lake Storage 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 Azure Data Lake Storage.
-
Use the CData Software ODBC Driver for Bitly in MicroStrategy Desktop
Connect to Bitly in MicroStrategy Desktop using the CData Software ODBC Driver for Bitly.
-
Explore Geographical Relationships in Salesforce Data 360 Data with Power Map
Create data visualizations with Salesforce Data 360 in Power Map.
-
Publish Crystal Reports on SharePoint Excel Services Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SharePoint Excel Services.
-
Integrate Close with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Close with External Services.
-
Build Google Sheets-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Google Sheets.
-
Connect to and Visualize Live Simplesat Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Simplesat.
-
DataBind Controls to FormSite Data in Delphi
DataBind to FormSite in Delphi with standard data access components and controls.
-
SparkPost Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SparkPost facts in real time.
-
Extract, Transform, and Load Cvent Data in Informatica PowerCenter
Create a simple Workflow for Cvent in Informatica PowerCenter.
-
Connect to ZohoSubscriptions in SpagoBI
Create reports featuring live ZohoSubscriptions in SpagoBI Studio. Host ZohoSubscriptions reports on SpagoBI Server.
-
Build Data Flows from Freshteam to SQL Server using SSIS
Easily back up Freshteam to SQL Server using the SSIS components for Freshteam.
-
Query ZohoMarketingHub Data in ColdFusion
Write standard ColdFusion data access code to connect to ZohoMarketingHub.
-
How to Connect to Live Amazon Marketplace 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 Amazon Marketplace for you.
-
Connect Databricks to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Databricks with IBM WebSphere for seamless data integration and connectivity.
-
Publish Crystal Reports on Pipeliner CRM Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Pipeliner CRM.
-
Query Square Data as a SQL Server Database in Node.js
Execute SQL Server queries against Square from Node.js.
-
Load Highrise Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Highrise CRM to a database.
-
Stream ZohoMarketingHub Data into Apache Kafka Topics
Access and stream ZohoMarketingHub in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build Automated PayPal-Connected Workflows in Zapier
Use CData Connect AI to connect to live PayPal and build automated workflows in Zapier.
-
Operational Reporting on Reckon Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Reckon.
-
Connect to Odoo Data from a Connection Pool in JBoss
Integrate Odoo ERP into Java servlets: Use the Management Console in JBoss to install the Odoo JDBC Driver.
-
Connect to WooCommerce Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for WooCommerce to connect to WooCommerce and execute queries in PowerBuilder.
-
Easily Integrate Presto Data in Lazarus Pascal IDE
Learn how to easily integrate live Presto in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create Data Visualizations in Cognos BI with Mistral AI Data
Access Mistral AI as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Use a Microsoft Access Database to Update FTP Data in Real Time
Update FTP data by creating a linked table in Microsoft Access with the CData FTP ODBC Driver.
-
Use Databricks Agent Bricks to Talk to Your SingleStore Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your SingleStore for you.
-
Choosing the Best Method to Connect Dynamics 365 Business Central to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Dynamics 365 Business Central from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Create Dashboards and Visualize Live Blackbaud FE NXT Data in Geckoboard
Use CData Connect AI to connect to live Blackbaud FE NXT and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Use Azure AI Foundry to Talk to Your CockroachDB 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 CockroachDB for you.
-
Build Presto-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Presto Data and create custom apps in Bubble.
-
Edit and Search SAS xpt External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of SAS XPORT to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create SAS xpt objects that you can access from apps and the dashboard.
-
Create Reports from SAS Data Sets Data in Looker Studio
Use CData Connect AI to gain access to live SAS Data Sets and create custom reports in Looker Studio.
-
Replicate MailChimp Data in Heroku for Use in Salesforce Connect
Replicate MailChimp to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrating GitHub Copilot CLI with SAP Concur 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.