CData Software - Knowledge Base
Recent Articles
-
Back Up Sybase IQ to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Sybase IQ. In this article, we will employ an SSIS workflow to populate a database with Sybase IQ data.
-
Build Semantic Layer Views for Teamwork Data in APOS Live Data Gateway
Use the CData Connector for Teamwork in APOS Live Data Gateway to build Semantic Layer Views for Teamwork.
-
Automated Continuous Toggl Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Toggl replication to OneLake in Microsoft Fabric.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Outreach.io using the Model Context Protocol.
-
Connect to Azure Table from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Azure Table Storage, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to MailChimp Data in Claris FileMaker Pro
Use the CData ODBC Driver for MailChimp in FileMaker Pro to connect to MailChimp and work with MailChimp in your FileMaker applications.
-
Replicate Multiple Active Directory Accounts
Replicate multiple Active Directory accounts to one or many databases.
-
Build Apps with Live Twilio Data Using the Low-Code Development Platform of Mendix
Connect Twilio with Mendix to build apps using the CData JDBC Driver for Twilio.
-
Publish ZohoInvoice-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live ZohoInvoice.
-
Integrating Codex CLI with Bright 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.
-
Visualize Discourse 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 Discourse into TIBCO Spotfire.
-
Create a Data Access Object for Paylocity Data using JDBI
A brief overview of creating a SQL Object API for Paylocity in JDBI.
-
Automated Continuous Klipfolio Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Klipfolio replication to Amazon S3.
-
How to Connect DBeaver to GitHub via a JDBC Driver
Manage GitHub with visual tools in DBeaver like the query browser.
-
A PostgreSQL Interface for SAP Concur Data (MySQL Remoting via JDBC)
Use the Remoting features of the SAP Concur JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automate Oracle Financials Cloud Data Replication to SAP HANA
Use CData Sync to customize and automate Oracle Financials Cloud replication to SAP HANA.
-
Automated Continuous Sage Cloud Accounting Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to AlloyDB.
-
Access Webex Data from MySQL in Amazon QuickSight
Connect to Webex and build visualizations of Webex using a MySQL Connection in Amazon QuickSight.
-
Getting Started with the CData Excel Add-In for WooCommerce
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for WooCommerce.
-
Integrating Codex CLI with Yelp 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 Oracle Sales Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Oracle Sales replication to Apache Kafka.
-
Integrate Live Certinia Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Certinia to Blue Prism using the CData ODBC Driver for Certinia to create automated workflows for repetitive business tasks.
-
Replicate Facebook Data from PowerShell
Write a quick PowerShell script to query Facebook. Use connectivity to the live data to replicate Facebook to SQL Server.
-
Integrate Live Eventbrite Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Eventbrite to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Automated Continuous Slack Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Slack replication to IBM DB2.
-
Build Data Flows from Salesforce Data 360 to SQL Server using SSIS
Easily back up Salesforce Data 360 to SQL Server using the SSIS components for Salesforce Data 360.
-
Automated Continuous Perplexity Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Perplexity replication to Google BigQuery.
-
Build an OLAP Cube in SSAS from ServiceDesk Plus Data
Establish a connection to ServiceDesk Plus data from SQL Server Analysis Services, and use the ServiceDesk Plus Data Provider to build OLAP cubes for use in analytics and reporting.
-
DataBind Charts to Confluence Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Atlassian Confluence 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.
-
Integrate QuickBooks Time Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live QuickBooks Time from Informatica Cloud.
-
Build MVC Applications with Connectivity to Mouseflow Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Mouseflow from an ASP.NET MVC application.
-
Automate Billsby Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Billsby from PowerShell? This article demonstrates how to utilize the Billsby Cmdlets for tasks like connecting to Billsby, automating operations, downloading data, and more.
-
Seamlessly Bring Lakebase Data into Retool Using CData Connect AI
Integrate Lakebase data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Seamlessly Bring WordPress Data into Retool Using CData Connect AI
Integrate WordPress data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to Visualize Supabase Data in Python with pandas
Use pandas and other modules to analyze and visualize live Supabase in Python.
-
Integrating Codex CLI with SAP Fieldglass 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 SSAS Tabular Models from GitLab Data
How to build a SQL Server Analysis Service Tabular Model from GitLab using CData drivers.
-
Integrating GitHub Copilot CLI with Azure DevOps 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 Cursor with Live FHIR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live FHIR from within the editor.
-
How to Connect DBeaver to Zoho Projects via a JDBC Driver
Manage Zoho Projects with visual tools in DBeaver like the query browser.
-
Use CData Connect AI to Access Oracle HCM Cloud Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Oracle HCM Cloud in the Power Pivot business intelligence tool.
-
How to Connect to EnterpriseDB Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to EnterpriseDB. Leverage the pyodbc module for ODBC in Python.
-
Visualize Live Bullhorn CRM Data in the Power BI Service
Use CData Connect AI to connect to live Bullhorn CRM and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Load Mode Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Mode to a database.
-
Create SSAS Tabular Models from Pipeline CRM Data
How to build a SQL Server Analysis Service Tabular Model from Pipeline CRM using CData drivers.
-
Stream Calendly Data into Apache Kafka Topics
Access and stream Calendly in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build a PostgreSQL Interface for Intercom Data using the CData JDBC Driver
Use the Remoting features of the Intercom JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating OpenCode Terminal with Insightly 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 Trello Data from PowerBuilder via ADO.NET
This article demonstrates how to access Trello from Appeon PowerBuilder using the CData ADO.NET Provider for Trello.
-
DataBind Confluence Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Confluence with the DevExpress Windows Forms and Web controls to provide Atlassian Confluence to a chart.
-
DataBind Charts to Authorize.Net Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Authorize.Net 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.
-
Integrate Live Splunk Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Splunk to Blue Prism using the CData ODBC Driver for Splunk to create automated workflows for repetitive business tasks.
-
Access Live ShipStation Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to ShipStation from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Analyze Cohere Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Cohere with the CData JDBC Driver for Cohere.
-
Build a Singer.io Tap for Pipeliner CRM With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Pipeliner CRM data using
-
How to Access Bright Data Data Using Entity Framework
This article shows how to access Bright Data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Getting Started with the CData ADO.NET Provider for Short.io
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
ETL ZohoExpense in Oracle Data Integrator
This article shows how to transfer ZohoExpense into a data warehouse using Oracle Data Integrator.
-
Automate Zoom Data Replication to Azure Data Lake
Use CData Sync to customize and automate Zoom replication to Azure Data Lake.
-
Model, Search, and Visualize Live Zendesk Data in ThoughtSpot
Use CData Connect AI to connect to live Zendesk for modeling, searching, and visualizing.
-
Analyze SendPulse Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SendPulse in Microsoft R Open.
-
Analyze IBM Cloud Object Storage Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze IBM Cloud Object Storage in Microsoft R Open.
-
Integrating Antigravity CLI with SAP Ariba Source via CData CLI
Connect SAP Ariba Source to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Bidirectional Access to Basecamp Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Basecamp in Filemaker Pro for Mac or Windows.
-
How to create an RPA flow for ClickUp Data in UiPath Studio
Use the ClickUp ODBC Driver to create workflows that access real-time ClickUp without any coding.
-
Connect Invoiced to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Invoiced with IBM WebSphere for seamless data integration and connectivity.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Microsoft Dataverse (CDS) within intelligent workflows.
-
How to Connect to Live Vault CRM 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 Veeva Vault & Vault CRM for you.
-
Work with ServiceNow Data in FoxPro
Load ServiceNow into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create Informatica Mappings From/To a JDBC Data Source for Zoho Books
Create Zoho Books data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect and Visualize Live Office 365 Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Microsoft Office 365 into the Databricks platform and create visualization dashboards with real-time Microsoft Office 365.
-
Connect to ADP Data in CloverDX (formerly CloverETL)
Transfer ADP using the visual workflow in the CloverDX data integration tool.
-
Connect to YouTube Analytics Data from PowerBuilder via JDBC
This article demonstrates how to access YouTube Analytics from PowerBuilder using the YouTube Analytics JDBC Driver.
-
Choosing the Best Method to Connect TaxJar to SQL Server: 5 Options Explained
Discover multiple ways to connect and use TaxJar from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Getting Started with the CData Power BI Connector for Email
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Email.
-
DataBind Controls to Eventbrite Data in C++Builder
DataBind to Eventbrite in C++Builder with standard components and controls.
-
Create SSAS Tabular Models from Campaigner Data
How to build a SQL Server Analysis Service Tabular Model from Campaigner using CData drivers.
-
Integrate Live Zuora Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Build Dashboards with Parallel Data in DBxtra
Create dynamic dashboards and perform analytics based on Parallel in DBxtra.
-
Connect to eBay Analytics Data in CloverDX (formerly CloverETL)
Transfer eBay Analytics using the visual workflow in the CloverDX data integration tool.
-
Query CloudConvert Data through ODBC in Node.js
Use node-odbc to execute SQL queries against CloudConvert from Node.js.
-
Automated Continuous Google Spanner Replication to MySQL
Use CData Sync for automated, continuous, customizable Google Spanner replication to MySQL.
-
Getting Started with the CData Python Connector for eBay
Learn to install and license the CData Python Connector
-
Integrating LlamaIndex with Act-On Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Act-On in real time.
-
How to Connect to Live LinkedIn Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live LinkedIn without replication.
-
Consume Outreach.io OData Feeds in PowerBuilder
This article demonstrates how to consume Outreach.io as OData feeds from PowerBuilder using the API Server.
-
Access Live Stripe Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Stripe from your Excel spreadsheets.
-
Connect to BambooHR Data in Google Apps Script via Connect AI
Use CData Connect AI to access BambooHR in Google Apps Script.
-
Import Sage 200 Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Sage 200. In this article, you will use the OData format to import Sage 200 into Microsoft Power Query.
-
Integrate Live Excel Online Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Microsoft Excel Online to Blue Prism using the CData ODBC Driver for Excel Online to create automated workflows for repetitive business tasks.
-
Integrating Cursor CLI with Postmark 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.
-
Access Live Elasticsearch Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Elasticsearch in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Access Live Impala Data in Visual Studio Code via Cline
Run CData MCP Server for Impala on Windows Subsytem for Linux (WSL) and connect to live Apache Impala from the Cline extension in Visual Studio Code.
-
Replicate Amazon S3 Data to Multiple Databases via the CData Sync CLI
Replicate Amazon S3 to disparate databases with a single configuration.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Pivotal GreenPlum within intelligent workflows.
-
How to Seamlessly Import Cvent Data into IBM SPSS Modeler
Integrate Cvent data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Replicate Microsoft Teams Data in Heroku for Use in Salesforce Connect
Replicate Microsoft Teams to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Access Coinbase Data from MySQL in PHP
Connect to Coinbase through the standard MySQL libraries in PHP.
-
How to Connect Sugar CRM 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 Sugar CRM data in real time using natural language.
-
How to create an RPA flow for Oracle Sales Data in UiPath Studio
Use the Oracle Sales ODBC Driver to create workflows that access real-time Oracle Sales without any coding.