CData Software - Knowledge Base
Recent Articles
-
Load MariaDB Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load MariaDB to a database.
-
Connecting Agentforce with Odoo Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Odoo ERP for you.
-
Automated Continuous Greenhouse Replication to SQL Server
Use CData Sync for automated, continuous, customizable Greenhouse replication to SQL Server.
-
Integrating OpenCode Terminal with ChargeOver 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.
-
Integrate Shippo with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Shippo with External Services.
-
How to connect to Impala Data with Squirrel SQL client
Connect to Apache Impala and execute queries in the Squirrel SQL Client.
-
How to create LightSpeedRetail federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for LightSpeedRetail in MySQL .
-
Automated Timely Data Replication to Teradata
Use CData Sync to Customize and automate Timely replication to Teradata.
-
Integrate SharePoint Excel Services with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SharePoint Excel Services with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SharePoint Excel Services.
-
Automated Continuous GitHub Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable GitHub replication to PostgreSQL.
-
Visualize Live Paylocity Data in the Power BI Service
Use CData Connect AI to connect to live Paylocity and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Import and Visualize Oracle Eloqua Data in Power View
Create data visualizations based on Oracle Eloqua in Excel.
-
How to Work with Gmail Data in AWS Glue Jobs Using JDBC
Connect to Gmail from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build Data Flows from Ontraport to SQL Server using SSIS
Easily back up Ontraport to SQL Server using the SSIS components for Ontraport.
-
Consume Office 365 OData Feeds in PowerBuilder
This article demonstrates how to consume Microsoft Office 365 as OData feeds from PowerBuilder using the API Server.
-
Object-Relational Mapping (ORM) with Mixpanel 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 Mixpanel into a Java-based ORM framework, Hibernate.
-
Configure the CData JDBC Driver for ZohoSubscriptions in a Connection Pool in Tomcat
Connect to ZohoSubscriptions from a connection pool in Tomcat.
-
Visualize Live WooCommerce Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live WooCommerce.
-
Connect to Outreach.io Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Outreach.io and the SQL Gateway to access Outreach.io from Google Apps Script.
-
Connect to Salesforce CRM Analytics Data in Claris FileMaker Pro
Use the CData ODBC Driver for Salesforce CRM Analytics in FileMaker Pro to connect to Salesforce CRM Analytics and work with Salesforce CRM Analytics in your FileMaker applications.
-
Authenticate and Call Salesforce REST APIs with Postman
Easily connect to Salesforce and test APIs without writing code
-
Automated Continuous Azure Data Catalog Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Azure Data Catalog replication to Google BigQuery.
-
Connect to Adobe Analytics from a Connection Pool in WebLogic
Use the CData JDBC Driver for Adobe Analytics to connect to Adobe Analytics from Web applications running on WebLogic.
-
View Reports on Real-Time Sendwithus Data in Power BI Report Server
Use the CData ODBC Driver for Sendwithus to visualize Sendwithus in Power BI Desktop and then publish them to Power BI Report Server.
-
How to publish and share GitLab Data dashboards with Tableau Server
The CData ODBC driver for GitLab enables you integrate GitLab into Tableau dashboards.
-
Build Voice Agents in ElevenLabs with access to Live PayPal Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live PayPal.
-
Use the CData Software ODBC Driver for SingleStore in MicroStrategy Desktop
Connect to SingleStore in MicroStrategy Desktop using the CData Software ODBC Driver for SingleStore.
-
Getting Started with the CData ADO.NET Provider for Xero
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Xero.
-
Create a Data Access Object for Google Directory Data using JDBI
A brief overview of creating a SQL Object API for Google Directory in JDBI.
-
Build Lakebase-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Lakebase.
-
Operational Reporting on Paylocity Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Paylocity.
-
Connect to Jira Data from HeidiSQL
Use CData Connect AI to connect to and query live Atlassian Jira from HeidiSQL.
-
Analyze Avalara AvaTax Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Avalara AvaTax and visualize live Avalara AvaTax in Infragistics Reveal.
-
Automate Dynamics 365 Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Microsoft Dynamics 365 from PowerShell? This article demonstrates how to utilize the Dynamics 365 Cmdlets for tasks like connecting to Microsoft Dynamics 365, automating operations, downloading data, and more.
-
Connect to Live Hive Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Hive in CData Connect AI and connect to your Apache Hive from PostgreSQL.
-
Integrate Open WebUI with Live Oracle HCM Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Oracle HCM Cloud from within the chat interface.
-
Getting Started with the CData Python Connector for Okta
Learn to install and license the CData Python Connector
-
How to Seamlessly Import Salesloft Data into IBM SPSS Modeler
Integrate Salesloft data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Provide OData Services of EmailOctopus Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for EmailOctopus by developing a WCF Service Application.
-
How to Connect to Live NetSuite SuiteAnalytics 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 NetSuite SuiteAnalytics for you.
-
Connect to Teradata in SpagoBI
Create reports featuring live Teradata in SpagoBI Studio. Host Teradata reports on SpagoBI Server.
-
Connect to Clockify Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Clockify and work with Clockify in your FileMaker applications.
-
Build Dashboards with Templated Data in DBxtra
Create dynamic dashboards and perform analytics based on Templated in DBxtra.
-
Analyze Phoenix Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Phoenix from Power Pivot. You will use the Table Import Wizard to load Apache Phoenix. You can visually build the import query or use any SQL supported by the driver.
-
Build Automated LinkedIn Ads-Connected Workflows in Zapier
Use CData Connect AI to connect to live LinkedIn Ads and build automated workflows in Zapier.
-
Build Semantic Layer Views for Retently Data in APOS Live Data Gateway
Use the CData Connector for Retently in APOS Live Data Gateway to build Semantic Layer Views for Retently.
-
Query ServiceNow Data from Node.js
Use the OData endpoint of the CData API Server to connect to your ServiceNow and perform CRUD operations on ServiceNow from Node.js.
-
Use the CData Software JDBC Driver for Vercel in MicroStrategy Desktop
Connect to Vercel in MicroStrategy Desktop using the CData Software JDBC Driver for Vercel.
-
Connect to QuickBooks Online Data in DBeaver
Use the CData ODBC Driver to connect to QuickBooks Online in DBeaver.
-
Connect to CSV Data from HeidiSQL
Use CData Connect AI to connect to and query live CSV/TSV Files from HeidiSQL.
-
Natively Connect to Airtable Data in PHP
The CData ODBC driver for Airtable enables you to create PHP applications with connectivity to Airtable. Leverage the native support for ODBC in PHP.
-
Creating Apollo-Connected Applications in Unqork
You can use CData Connect AI to feed Apollo to Unqork and build custom business apps.
-
Automated Continuous Azure DevOps Replication to MySQL
Use CData Sync for automated, continuous, customizable Azure DevOps replication to MySQL.
-
Use the CData Software JDBC Driver for Workable in MicroStrategy Web
Connect to Workable in MicroStrategy Web using the CData Software JDBC Driver for Workable.
-
Create Acumatica-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Acumatica Data from Klipfolio and build custom visualizations using live Acumatica ERP.
-
Perform Batch Operations with WooCommerce Data in Apache NiFi
Connect to WooCommerce and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
How to Connect to Vercel Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Vercel. Leverage the pyodbc module for ODBC in Python.
-
How to Seamlessly Import SAP SuccessFactors Data into IBM SPSS Modeler
Integrate SAP SuccessFactors data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Create Dynamic Klipfolio Grids Using the Infragistics XamDataGrid
Learn how you can connect Klipfolio to Infragistics XamDataGrid to build dynamic grids.
-
How to load PhantomBuster data into Elasticsearch via Logstash
Introducing a simple method to load PhantomBuster data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate Live SAP SuccessFactors Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Integrate Goose with Live Zendesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Zendesk from within the local AI agent.
-
Working with RSS Feeds in LINQPad
Execute LINQ queries to RSS Feeds in LINQPad.
-
Build MVC Applications with Connectivity to WordPress Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access WordPress from an ASP.NET MVC application.
-
Build OnePageCrm-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to OnePageCrm and build web apps with connectivity to live OnePageCrm.
-
How to connect to Printful Data from IntelliJ
Integrate connectivity to Printful with wizards in IntelliJ.
-
Visualize Live Foursquare Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Foursquare using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Provide OData Services of Xero Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Xero Accounting by developing a WCF Service Application.
-
Connect to Zoho Books Data in DBArtisan
Use wizards in DBArtisan to configure Zoho Books as a data source.
-
Integrate NetSuite SuiteAnalytics Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to NetSuite SuiteAnalytics and integrate live NetSuite SuiteAnalytics into your Power Automate tasks.
-
Connect to WooCommerce Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for WooCommerce in Airbyte.
-
How to Connect to & Open Toggl Data in Microsoft Excel
This article uses the CData ODBC driver for Toggl to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Visualize Live Dynamics 365 Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Microsoft Dynamics 365 into custom reports in Power BI.
-
Use Biml to Build SSIS Tasks to Replicate FreeAgent Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate FreeAgent to SQL Server.
-
How to Connect to Live OneNote Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Microsoft OneNote for you.
-
Build Apps with Live Microsoft Planner in Adalo using CData Connect AI
Use CData Connect AI to integrate live Microsoft Planner into the Adalo platform and build custom mobile and web applications with real-time Microsoft Planner.
-
Connect SharePoint to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Microsoft SharePoint using the CData Python MCP Server.
-
Automate Salesforce Pardot Data Replication to Azure Synapse
Use CData Sync to customize and automate Salesforce Pardot replication to Azure Synapse.
-
Connect Mocean Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Mocean using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrate Zendesk with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Zendesk with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Zendesk.
-
Connecting Pipedream with MySQL 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 MySQL data in real time.
-
Integrate Goose with Live Highrise Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Highrise CRM from within the local AI agent.
-
Query Twitter Ads Data in DataGrip
Create a Data Source for Twitter Ads in DataGrip and use SQL to query live Twitter Ads.
-
Create Dynamic MailerLite Grids Using the Infragistics XamDataGrid
Learn how you can connect MailerLite to Infragistics XamDataGrid to build dynamic grids.
-
Create Reports with Microsoft Teams Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft Teams.
-
Natively Connect to Front Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Front. Leverage the native support for ODBC in PHP.
-
Publish Reports with Timely Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Timely.
-
Connect to Real-Time Pushbullet Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Pushbullet in Power Apps.
-
Access Live Microsoft Teams 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 Microsoft Teams through MCP integration.
-
Create a Data Access Object for Square Data using JDBI
A brief overview of creating a SQL Object API for Square in JDBI.
-
How to Connect Flowise AI Agents to Live Google Directory 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 Google Directory without replication.
-
Integrate Live MySQL Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Connect to SurveyMonkey Data in HULFT Integrate
Connect to SurveyMonkey as a JDBC data source in HULFT Integrate
-
Visualize Harvest Data in Sisense
Create an ElastiCube in Sisense app with access to Harvest.
-
Query Cloudant Data as a MySQL Database in Node.js
Execute MySQL queries against IBM Cloudant from Node.js.
-
Integrating Gumloop with Google Spanner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Google Spanner within automated workflows.
-
Create Gmail Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Gmail data access from reports, embedded analytics, and more.
-
Connect to Google Search Results in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Google Search Results and connect to Google Search in Akorbi Digital RunMyProcess.
-
Analyze SAP Ariba Source Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of SAP Ariba Source and visualize live SAP Ariba Source in Infragistics Reveal.
-
Integrate with Mailgun Data in JReport Designer
Create charts and reports based on Mailgun in JReport Designer.