CData Software - Knowledge Base
Recent Articles
-
Connect Rebilly to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Rebilly data using the CData Python MCP Server.
-
A PostgreSQL Interface for Salesforce Marketing Data (MySQL Remoting via JDBC)
Use the Remoting features of the Salesforce Marketing JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Paylocity Data from AWS Glue
Use CData Connect AI to gain access to live Paylocity data from your AWS Glue jobs.
-
Use CData Connect AI to Access Shopify Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Shopify data in the Power Pivot business intelligence tool.
-
Natively Connect to Facebook Ads Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Facebook Ads data. Leverage the native support for ODBC in PHP.
-
How to use SQLAlchemy ORM to access Act CRM Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Act CRM data.
-
Integrate Harvest with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Harvest with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Harvest data.
-
Use the CData ODBC Driver for Figshare in Microsoft Power Query
You can use the CData Figshare ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Figshare data into Microsoft Power Query.
-
How to connect Amazon QuickSight to DocuSign Data
Create a connection to DocuSign data in CData Connect AI and insert DocuSign data into Amazon QuickSight SPICE to build interactive dashboards.
-
Publish Crystal Reports on SingleStore Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SingleStore data.
-
Build a Singer.io Tap for PingOne With the CData Python Connector
Learn how to easily build a Singer.io Tap for live PingOne data using the CData Python Connector.
-
A PostgreSQL Interface for Unbounce Data (MySQL Remoting via JDBC)
Use the Remoting features of the Unbounce JDBC Driver to create a PostgreSQL entry-point for data access.
-
Choosing the Best Method to Connect RSS to SQL Server: 5 Options Explained
Discover multiple ways to connect and use RSS feeds from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Reckon Accounts Hosted Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Reckon Accounts Hosted and the Script function in FileMaker Pro to connect to Reckon Accounts Hosted and work with Reckon Accounts Hosted data in your FileMaker application.
-
Automated Continuous OnePageCrm Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable OnePageCrm replication to delimited files (CSV/TSV).
-
Connect to Amazon S3 Data in NetBeans
Connect to Amazon S3 data in NetBeans with the data source configuration wizard.
-
Create a Data Access Object for Calendly Data using JDBI
A brief overview of creating a SQL Object API for Calendly data in JDBI.
-
Query, Visualize, and Share live Odoo Data in Redash
Use CData Connect AI to connect to live Odoo data in Redash for querying, visualizing, and sharing.
-
Replicate LaunchDarkly Data to Multiple Databases
Replicate LaunchDarkly data to disparate databases with a point-and-click configuration.
-
Prepare, Blend, and Analyze Mailjet Data in Alteryx Designer (ODBC)
Build workflows to access live Mailjet data for self-service data analytics.
-
Create Reports with Adobe Commerce Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Adobe Commerce data.
-
Excel Spreadsheet Automation on Zoho Books Data with the QUERY Formula
Pull data from Zoho Books, automate spreadsheets, and more with the QUERY formula.
-
Create Informatica Mappings From/To an ODBC Data Source for Bright Data
Create an ODBC connection to Bright Data in Informatica and browse and transfer Bright Data data.
-
Integrate Live ZohoPeople Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to ZohoPeople from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live ZohoPeople data.
-
Query Office 365 Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Office 365 entities in PHP by modeling them as objects.
-
Provide OData Services of Printful Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Printful data by developing a WCF Service Application.
-
How to integrate Metabase with ZohoExpense Data
Use CData Connect AI to connect to live ZohoExpense data and create an interactive dashboard in Metabase from ZohoExpense data.
-
Import NetSuite Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to NetSuite Data and provide access to live NetSuite data for custom reports in the Power BI Service.
-
DataBind Controls to Outlook Data in C++Builder
DataBind to Outlook data in C++Builder with standard components and controls.
-
Add HDFS Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for HDFS with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to connect to OnePageCrm Data in DBVisualizer
Integrate OnePageCrm data with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous Nethunt Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Nethunt replication to delimited files (CSV/TSV).
-
Query Jira Data as a SQL Server Database in Node.js
Execute SQL Server queries against Jira data from Node.js.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for ConvertKit
Provide connectivity to ConvertKit data through an SAP BusinessObjects universe.
-
Build Reckon Accounts Hosted-Connected Apps in Choreo
Use CData Connect AI to connect to Reckon Accounts Hosted Data from Choreo and build custom apps using live Reckon Accounts Hosted data.
-
Automated Continuous Samanage Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Samanage replication to IBM DB2.
-
Automate SharePoint Excel Services Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SharePoint Excel Services data from PowerShell? This article demonstrates how to utilize the SharePoint Excel Services Cmdlets for tasks like connecting to SharePoint Excel Services data, automating operations, downloading data, and more.
-
Getting Started with the CData SSIS Components for Chargebee
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Chargebee.
-
Integrating GitHub Copilot with Confluence 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.
-
Publish Zendesk-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Zendesk data.
-
Connect to SAP Data in CloverDX (formerly CloverETL)
Transfer SAP data using the visual workflow in the CloverDX data integration tool.
-
Build Voice Agents in ElevenLabs with access to Live CSV Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live CSV data.
-
Build Pipelines with Live Freshteam Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Freshteam from Google Cloud Data Fusion, enabling the integration of live Freshteam data into the building and management of effective data pipelines.
-
How to publish and share MariaDB Data dashboards with Tableau Server
The CData ODBC driver for MariaDB enables you integrate MariaDB data into Tableau dashboards.
-
Model QuickBooks Time Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and QuickBooks Time, enabling the direct import of real-time QuickBooks Time data.
-
Use the CData Software ODBC Driver for Act-On in MicroStrategy
Connect to Act-On data in MicroStrategy Developer using the CData Software ODBC Driver for Act-On.
-
Automated Continuous ZohoExpense Replication to Vertica
Use CData Sync for automated, continuous, customizable ZohoExpense replication to Vertica.
-
Process & Analyze PostgreSQL Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live PostgreSQL Data.
-
Natively Connect to Campaigner Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Campaigner data. Leverage the native support for ODBC in PHP.
-
Use the CData Software JDBC Driver for Everhour in MicroStrategy
Connect to Everhour data in MicroStrategy Developer using the CData Software JDBC Driver for Everhour.
-
Query SAS Data Sets Data as a SQL Server Database in Node.js
Execute SQL Server queries against SAS Data Sets data from Node.js.
-
Integrating Codex with Flowlu 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.
-
Use Biml to Build SSIS Tasks to Replicate Access Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Access data to SQL Server.
-
Integrate Theia IDE with Live SingleStore 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 SingleStore data from within the development environment.
-
Publish Crystal Reports on PayPal Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date PayPal data.
-
Connect to Coda Data in Aqua Data Studio
Access Coda data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Migrating data from Mouseflow to Databricks using CData SSIS Components.
Easily push Mouseflow data to Databricks using the CData SSIS Tasks for Mouseflow and Databricks.
-
Analyze SharePoint Excel Services Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SharePoint Excel Services from Power Pivot. You will use the Table Import Wizard to load SharePoint Excel Services data. You can visually build the import query or use any SQL supported by the driver.
-
How to Access Live Perigon Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Perigon enables you to integrate Perigon data into workflows built using Microsoft Power Automate Desktop.
-
Use Databricks Agent Bricks to Talk to Your Azure Data Lake Storage Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Azure Data Lake Storage data for you.
-
How to Connect to Live Sage 300 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 Sage 300 data for you.
-
Publish Twilio-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Twilio data.
-
Automated Continuous FHIR Replication to IBM DB2
Use CData Sync for automated, continuous, customizable FHIR replication to IBM DB2.
-
Getting Started with the CData Python Connector for Billsby
Learn to install and license the CData Python Connector and configure a connection to live Billsby data.
-
Use JayDeBeApi to access Tickspot Data in Python
Use standard Python scripting and the development environment of your choice to access live Tickspot data.
-
Analyze PolarTeamPro Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of PolarTeamPro data and visualize live PolarTeamPro data in Infragistics Reveal.
-
How to connect to Zoho Projects Data from IntelliJ
Integrate connectivity to Zoho Projects data with wizards in IntelliJ.
-
Connect to CouchDB Data in HULFT Integrate
Connect to CouchDB as a JDBC data source in HULFT Integrate
-
Connect to DocuSign Data from a Connection Pool in JBoss
Integrate DocuSign data into Java servlets: Use the Management Console in JBoss to install the DocuSign JDBC Driver.
-
How to Connect to & Open Microsoft Exchange Data in Microsoft Excel
This article uses the CData ODBC driver for Microsoft Exchange to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Slack Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Slack data from Filemaker Pro on Mac.
-
Access Live SingleStore Data in Coginiti Pro
Connect to and query live SingleStore data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to SAP HANA from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from SAP HANA data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to Adobe Commerce in SpagoBI
Create reports featuring live Adobe Commerce data in SpagoBI Studio. Host Adobe Commerce reports on SpagoBI Server.
-
Connect to REST Data in HULFT Integrate
Connect to REST as a JDBC data source in HULFT Integrate
-
Natively Connect to Perplexity Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Perplexity data. Leverage the native support for ODBC in PHP.
-
Connect to ZohoMarketingHub 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 ZohoMarketingHub data.
-
Integrate with Salesforce Pardot Data in JReport Designer
Create charts and reports based on Salesforce Pardot data in JReport Designer.
-
Automated Continuous Invoiced Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Invoiced replication to IBM DB2.
-
How to connect to Avalara AvaTax Data from IntelliJ
Integrate connectivity to Avalara AvaTax data with wizards in IntelliJ.
-
Connect Shippo to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Shippo with IBM WebSphere for seamless data integration and connectivity.
-
How to Connect Amazon S3 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 Amazon S3 data in real time using natural language.
-
Connect to Invoiced in SpagoBI
Create reports featuring live Invoiced data in SpagoBI Studio. Host Invoiced reports on SpagoBI Server.
-
Create Data Visualizations in Cognos BI with Close Data
Access Close data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Load Pipeliner CRM Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Pipeliner CRM data to a database.
-
How to Connect Flowise AI Agents to Live Twilio 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 Twilio data without replication.
-
Access Live Microsoft Planner 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 Planner data through MCP integration.
-
Integrating Claude Code with Lakebase Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Lakebase data within assisted coding and automated development workflows.
-
Replicate Freshservice Data to Multiple Databases via the CData Sync CLI
Replicate Freshservice data to disparate databases with a single configuration.
-
How to Connect to Productboard Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Productboard data. Leverage the pyodbc module for ODBC in Python.
-
Optimizely Reporting in OBIEE with the Optimizely JDBC Driver
Deploy the Optimizely JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Vercel Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Vercel and the SQL Gateway to access Vercel data from Google Apps Script.
-
Automated Continuous Bannerbear Replication to SQLite
Use CData Sync for automated, continuous, customizable Bannerbear replication to SQLite.
-
Getting Started with the CData Excel Add-In for Pushbullet
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Pushbullet.
-
Connect to Stripe Data in CloverDX (formerly CloverETL)
Transfer Stripe data using the visual workflow in the CloverDX data integration tool.
-
Analyze Procore Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Procore data in Microsoft R Open.
-
Work with Okta Data in FoxPro
Load Okta data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Easily Integrate CouchDB Data in Lazarus Pascal IDE
Learn how to easily integrate live CouchDB data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrating Claude Code with Slack Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Slack data within assisted coding and automated development workflows.
-
How to Access Live EnterpriseDB Data in Power Automate Desktop via ODBC
The CData ODBC Driver for EnterpriseDB enables you to integrate EnterpriseDB data into workflows built using Microsoft Power Automate Desktop.