CData Software - Knowledge Base
Recent Articles
-
How to Connect to & Open SAP Business One Data in Microsoft Excel
This article uses the CData ODBC driver for SAP Business One to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Consume Phoenix OData Feeds in PowerBuilder
This article demonstrates how to consume Phoenix data as OData feeds from PowerBuilder using the API Server.
-
How to Visualize Oracle Eloqua Reporting Data in Python with pandas
Use pandas and other modules to analyze and visualize live Oracle Eloqua Reporting data in Python.
-
Load Retently Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Retently data to a database.
-
Search External GetResponse Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of GetResponse data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create GetResponse Data objects that you can access from apps and the dashboard.
-
Access GitHub Data from MySQL in PHP
Connect to GitHub through the standard MySQL libraries in PHP.
-
Connect to Moosend Data from a Connection Pool in JBoss
Integrate Moosend data into Java servlets: Use the Management Console in JBoss to install the Moosend JDBC Driver.
-
How to connect to Reckon Data in DBVisualizer
Integrate Reckon data with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect ZohoInvoice to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live ZohoInvoice data using the CData Python MCP Server.
-
Build Visualizations of Todoist Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Todoist data in Birst.
-
How to work with Parallel Data in Apache Spark using SQL
Access and process Parallel Data in Apache Spark using the CData Software JDBC Driver.
-
Build Microsoft Exchange-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Microsoft Exchange Data and create custom apps in Mendix.
-
Natively Connect to FreshBooks Data in PHP
The CData ODBC driver for FreshBooks enables you to create PHP applications with connectivity to FreshBooks data. Leverage the native support for ODBC in PHP.
-
Connect to SAP Ariba Procurement from Asprova with CData Software ODBC Driver for SAP Ariba Procurement
This article shows how to connect faster to SAP Ariba Procurement data from Asprova.
-
Build Data Flows from DocuSign to SQL Server using SSIS
Easily back up DocuSign data to SQL Server using the SSIS components for DocuSign.
-
Integrating Kiro with Okta 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 Sage Cloud Accounting Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to PostgreSQL.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for OpenWeatherMap
Provide connectivity to OpenWeatherMap data through an SAP BusinessObjects universe.
-
Connect to Sybase IQ Data in JRuby
Create a simple JRuby app with access to live Sybase IQ data.
-
Automate Workable Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Workable data from PowerShell? This article demonstrates how to utilize the Workable Cmdlets for tasks like connecting to Workable data, automating operations, downloading data, and more.
-
Integrate with live eBay Data in Jitterbit
Use CData Connect AI to connect to and integrate live eBay data in Jitterbit.
-
Create Dynamic Strava Grids Using the Infragistics XamDataGrid
Learn how you can connect Strava to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Strava Data in Ruby
Connect to Strava data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous Browserless Replication to MySQL
Use CData Sync for automated, continuous, customizable Browserless replication to MySQL.
-
Create Data Visualizations Based On Mode Data in Mode
Use CData Connect AI to connect to Mode Data from Mode and build visualizations using live Mode data.
-
Automated Continuous Google Tasks Replication to MySQL
Use CData Sync for automated, continuous, customizable Google Tasks replication to MySQL.
-
Automate LDAP Objects Replication to SAP HANA
Use CData Sync to customize and automate LDAP objects replication to SAP HANA.
-
Visualize Hive Data in TIBCO Spotfire through ADO.NET
Integrate Hive data into dashboards in TIBCO Spotfire.
-
Import Reckon Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Reckon Data and provide access to live Reckon data for custom reports in the Power BI Service.
-
Access Live Raisers Edge NXT Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Raisers Edge NXT data through MCP integration.
-
Model Greenplum Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Greenplum, enabling the direct import of real-time Greenplum data.
-
Bridge Zoho CRM Connectivity with Apache NiFi
Access and process Zoho CRM data in Apache NiFi using the CData JDBC Driver.
-
Connect to ConvertAPI Data in RapidMiner
Integrate ConvertAPI data with standard components and data source configuration wizards in RapidMiner Studio.
-
Access Live AfterShip Data in AWS Lambda (with IntelliJ IDEA)
Connect to live AfterShip data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrating Antigravity CLI with Asana data via CData CLI
Connect Asana data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automated Continuous SendPulse Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SendPulse replication to Apache Kafka.
-
LINQ to Teradata Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Teradata Data Provider.
-
Deploy the ADO.NET Provider for SuiteCRM on an SSRS Report Server
Connect to SuiteCRM data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Getting Started with the CData JDBC Driver for Microsoft Dataverse
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Microsoft Dataverse.
-
Visualize Live Salesforce Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Salesforce data into custom reports in Power BI.
-
Import Real-Time OnePageCrm Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use OnePageCrm data in ColdFusion.
-
Connecting Moonlit Workflow with Jira Assets Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Jira Assets data in real time.
-
Connecting to Any ODBC Data Source as a Linked Server
Use the TDS Remoting feature of the SQL Gateway to set up a linked server for any CData ODBC data source.
-
Connect to and Query LinkedIn Ads Data in QlikView over ODBC
Create data visualizations with LinkedIn Ads data in QlikView.
-
Connect to Microsoft OneDrive Data from AWS Glue
Use CData Connect AI to gain access to live Microsoft OneDrive data from your AWS Glue jobs.
-
Using the CData Software ODBC Driver for Teradata in PyCharm
Connect to Teradata as an ODBC data source in PyCharm using the CData Software ODBC Driver for Teradata.
-
How to Connect Slack 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 Slack data in real time using natural language.
-
Use Dash to Build to Web Apps on Tickspot Data
Create Python applications that use pandas and Dash to build Tickspot-connected web apps.
-
Connect to Dynamics NAV Data in RapidMiner
Integrate Dynamics NAV data with standard components and data source configuration wizards in RapidMiner Studio.
-
Access Live HubSpot Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live HubSpot data through MCP integration.
-
Integrate Theia IDE with Live eBay Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live eBay data from within the development environment.
-
Connect to Onfleet Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Onfleet to connect to Onfleet data and execute queries in PowerBuilder.
-
Create MailerLite-Connected Business Apps in AppSheet
Connect to MailerLite Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to MailerLite data.
-
Prepare, Blend, and Analyze LinkedIn Data in Alteryx Designer (Connect AI)
Build workflows to access live LinkedIn data for self-service data analytics.
-
Integrate Google's Vertex AI Agent with Live eBay Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live eBay Analytics data within intelligent workflows.
-
Integrate Cline with Live Sendwithus Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Sendwithus data from within your IDE.
-
Connect to Testmonitor Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Testmonitor and work with Testmonitor data in your FileMaker applications.
-
Query Parquet Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Parquet data from Node.js.
-
Create SAP Netweaver Gateway-Connected Dashboards in Grafana
Connect to SAP Netweaver Gateway Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to SAP Netweaver Gateway data.
-
Automate Parallel Data Replication to Azure Data Lake
Use CData Sync to customize and automate Parallel data replication to Azure Data Lake.
-
Automated Continuous Sage Intacct Replication to SQLite
Use CData Sync for automated, continuous, customizable Sage Intacct replication to SQLite.
-
Connecting Pipedream with Zoom Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Zoom data in real time.
-
Import Impala Data Using Azure Data Factory
Use CData Connect AI to connect to Impala Data from Azure Data Factory and import live Impala data.
-
Visualize Zoho Projects Data in Tableau
The CData ODBC driver for Zoho Projects enables you integrate Zoho Projects data into Tableau dashboards.
-
Creating Cosmos DB-Connected Applications in Unqork
You can use CData Connect AI to feed Cosmos DB data to Unqork and build custom business apps.
-
Access Live Spark Data in AWS Lambda
Connect to live Spark data in AWS Lambda using the CData JDBC Driver.
-
How to Connect DBeaver to Asana via a JDBC Driver
Manage Asana data with visual tools in DBeaver like the query browser.
-
Build Agents in Relevance AI with Access to Live Zoho CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Zoho CRM data within intelligent agent workflows.
-
Create Informatica Mappings From/To an ODBC Data Source for MailChimp
Create an ODBC connection to MailChimp in Informatica and browse and transfer MailChimp data.
-
Getting Started with the CData ODBC Driver for SQL Analysis Services
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SQL Analysis Services.
-
Build QuickBooks Online-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live QuickBooks Online data.
-
Automated Continuous Deel Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Deel replication to Amazon S3.
-
Replicate ShipEngine Data to Multiple Databases
Replicate ShipEngine data to disparate databases with a point-and-click configuration.
-
Analyze SAP SuccessFactors Data in Looker
Use CData Connect AI to connect to SAP SuccessFactors Data from Looker and build custom apps using live SAP SuccessFactors data.
-
Integrate Snapchat Ads Data into Power Automate Desktop using CData Connect
CData Connect for Snapchat Ads Data enables you to integrate Snapchat Ads data into workflows built using Microsoft Power Automate Desktop.
-
Connect to and Query Harvest Data in QlikView over ODBC
Create data visualizations with Harvest data in QlikView.
-
Automated Continuous JotForm Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable JotForm replication to PostgreSQL.
-
Integrate BigQuery Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live BigQuery data from Informatica Cloud.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Microsoft Ads
Provide connectivity to Microsoft Ads data through an SAP BusinessObjects universe.
-
Create Zendesk-Connected Applications in Appsmith
Connect to Zendesk Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Zendesk data.
-
How to connect and process Klipfolio data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Klipfolio data.
-
Connect to Dynamics 365 Business Central Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Dynamics 365 Business Central to connect to Dynamics 365 Business Central data and execute queries in PowerBuilder.
-
Create Data Visualizations Based On PolarTeamPro Data in Mode
Use CData Connect AI to connect to PolarTeamPro Data from Mode and build visualizations using live PolarTeamPro data.
-
Create Reports with Vercel Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Vercel data.
-
Integrate Trello Data in the Pentaho Report Designer
Publish reports based on Trello data in the Pentaho BI tool.
-
Analyze Certinia Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Certinia data and visualize Certinia data in SAP Analytics Cloud.
-
Connect to Accelo Data in NetBeans
Connect to Accelo data in NetBeans with the data source configuration wizard.
-
Easily Integrate SAP Concur Data in Lazarus Pascal IDE
Learn how to easily integrate live SAP Concur data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Getting Started with the CData ADO.NET Provider for Reckon
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Reckon.
-
Connect to Exact Online Data in HULFT Integrate
Connect to Exact Online as a JDBC data source in HULFT Integrate
-
Use the CData Software ODBC Driver for ShipEngine in SAS for Real-Time Reporting and Analytics
Connect to real-time ShipEngine data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ShipEngine.
-
Automated Continuous Outreach.io Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Outreach.io replication to PostgreSQL.
-
Connect to Real-Time HBase Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for HBase and Dataflow to import and use HBase data in Power Apps.
-
Use Azure AI Foundry to Talk to Your Amazon S3 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 Amazon S3 data for you.
-
Eventbrite Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Eventbrite facts in real time.
-
Build Reckon Accounts Hosted-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Reckon Accounts Hosted Data and create custom apps in Bubble.
-
Create Data Visualizations in Cognos BI with HubSpot Data
Access HubSpot data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Connect to Live Gong 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 Gong data for you.
-
Automate Retently Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Retently data from PowerShell? This article demonstrates how to utilize the Retently Cmdlets for tasks like connecting to Retently data, automating operations, downloading data, and more.
-
Create Informatica Mappings From/To a JDBC Data Source for Splunk
Create Splunk data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.