CData Software - Knowledge Base
Recent Articles
-
Analyze Greenhouse Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Greenhouse from Power Pivot. You will use the Table Import Wizard to load Greenhouse. You can visually build the import query or use any SQL supported by the driver.
-
How to Connect DBeaver to YouTube Analytics via a JDBC Driver
Manage YouTube Analytics with visual tools in DBeaver like the query browser.
-
Connect to CapsuleCRM Data in Aqua Data Studio
Access CapsuleCRM from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Tanda Data from PowerBuilder via ADO.NET
This article demonstrates how to access Tanda from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to Import Data from Microsoft OneDrive into Google Sheets
Import Microsoft OneDrive into a Google spreadsheet that is automatically refreshed.
-
Natively Connect to Paylocity Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Paylocity. Leverage the native support for ODBC in PHP.
-
Connect to SpaceX Data from PowerBuilder via JDBC
This article demonstrates how to access SpaceX from PowerBuilder using the SpaceX JDBC Driver.
-
How to Create Power BI Visual Reports with Real-Time Dynamics NAV Data
Use CData Power BI Connectors to visualize Microsoft Dynamics NAV in Power BI.
-
Automated Continuous Zoho Projects Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Zoho Projects replication to Apache Cassandra.
-
Connect to QuickBooks Online Data in Aqua Data Studio
Access QuickBooks Online from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Create Power BI Visual Reports with Real-Time AfterShip Data
Use CData Power BI Connectors to visualize AfterShip in Power BI.
-
Build Microsoft Entra ID-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Microsoft Entra ID to explore live Microsoft Entra ID Data in Claude Code to assist with building Microsoft Entra ID-powered applications.
-
Create Informatica Mappings From/To an ODBC Data Source for ZohoSubscriptions
Create an ODBC connection to ZohoSubscriptions in Informatica and browse and transfer ZohoSubscriptions.
-
Automated Continuous Oracle HCM Cloud Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Oracle HCM Cloud replication to Google BigQuery.
-
Access Redis Data from MySQL in Amazon QuickSight
Connect to Redis and build visualizations of Redis using a MySQL Connection in Amazon QuickSight.
-
Working with PDFMonkey Data in LINQPad
Execute LINQ queries to PDFMonkey in LINQPad.
-
Integrate with live Exact Online Data in Jitterbit
Use CData Connect AI to connect to and integrate live Exact Online in Jitterbit.
-
Getting Started with the CData Tableau Connector for MailerSend
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Publish Sugar CRM-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Sugar CRM.
-
Use CData Connect AI to Access Square Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Square in the Power Pivot business intelligence tool.
-
Build Dynamics 365-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Dynamics 365 Data from Zoho Analytics and import live Microsoft Dynamics 365.
-
How to connect to Browserless Data from IntelliJ
Integrate connectivity to Browserless with wizards in IntelliJ.
-
Integrating Gumloop with DocuSign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on DocuSign within automated workflows.
-
Build Automated Google Calendar-Connected Workflows in Zapier
Use CData Connect AI to connect to live Google Calendar and build automated workflows in Zapier.
-
Build MVC Applications with Connectivity to IBM Cloud Object Storage Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access IBM Cloud Object Storage from an ASP.NET MVC application.
-
How to update ADP from Excel
This article explains how to transfer data from Excel to ADP using the Excel Add-In for ADP.
-
Query Salesforce Data 360 Data in DataGrip
Create a Data Source for Salesforce Data 360 in DataGrip and use SQL to query live Salesforce Data 360.
-
Access Office 365 Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Microsoft Office 365 from HeidiSQL.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Email within intelligent workflows.
-
Migrating data from Zoho Creator to Databricks using CData SSIS Components.
Easily push Zoho Creator to Databricks using the CData SSIS Tasks for Zoho Creator and Databricks.
-
Access Instagram Data from MySQL in PHP
Connect to Instagram through the standard MySQL libraries in PHP.
-
Use the CData ODBC Driver for Outreach.io in Microsoft Power Query
You can use the CData Outreach.io ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Outreach.io into Microsoft Power Query.
-
Automated Continuous Perplexity Replication to Vertica
Use CData Sync for automated, continuous, customizable Perplexity replication to Vertica.
-
Establish a Live Connection with Marketo Data using Tableau Bridge
The CData ODBC Driver for Marketo enables you to integrate live Marketo into Tableau Cloud dashboards using the Tableau Bridge.
-
Query Planio Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Planio from Node.js.
-
Import Real-Time Toggl Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Toggl in ColdFusion.
-
Access Live ZohoSubscriptions Data in AWS Lambda
Connect to live ZohoSubscriptions in AWS Lambda using the CData JDBC Driver.
-
Choosing the Best Method to Connect SAP SuccessFactors LMS to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SAP SuccessFactors LMS from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to connect to Optimizely Data in DBVisualizer
Integrate Optimizely with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Datasets from Drip in Domo Workbench and Build Visualizations of Drip Data in Domo
Use the CData Software ODBC Driver for Drip to create datasets from Drip in Domo Workbench and then build visualizations in the Domo service.
-
How to integrate SuiteCRM with Apache Airflow
Access and process SuiteCRM in Apache Airflow using the CData JDBC Driver.
-
How to publish and share FormSite Data dashboards with Tableau Server
The CData ODBC driver for FormSite enables you integrate FormSite into Tableau dashboards.
-
Connect to Planio Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Planio as an External Source in Dremio.
-
Connect to Helpscout Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Helpscout and the SQL Gateway to access Helpscout from Google Apps Script.
-
Moving Data from AgileCRM to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live AgileCRM data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automate Kafka Data Replication to Azure Data Lake
Use CData Sync to customize and automate Apache Kafka replication to Azure Data Lake.
-
Build an OLAP Cube in SSAS from Google Search Results
Establish a connection to Google Search data from SQL Server Analysis Services, and use the Google Search Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to LionDesk Data from a Connection Pool in JBoss
Integrate LionDesk into Java servlets: Use the Management Console in JBoss to install the LionDesk JDBC Driver.
-
Connect to Drift Data from PowerBuilder via ADO.NET
This article demonstrates how to access Drift from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect to MySQL from Asprova with CData Software ODBC Driver for MySQL
This article shows how to connect faster to MySQL data from Asprova.
-
Connect to ADP Data in RazorSQL
Connect to ADP from wizards and query ADP from the GUI in the RazorSQL database management tool.
-
How to Connect to Google Cloud Storage Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Google Cloud Storage. Leverage the pyodbc module for ODBC in Python.
-
Build Greenplum-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Greenplum to explore live Greenplum Data in Claude Code to assist with building Greenplum-powered applications.
-
Back Up Float to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Float data.
-
Replicate Multiple Sybase Accounts
Replicate multiple Sybase accounts to one or many databases.
-
How to Visualize Bitly Data in Python with pandas
Use pandas and other modules to analyze and visualize live Bitly in Python.
-
Connect to Basecamp Data from AWS Glue
Use CData Connect AI to gain access to live Basecamp from your AWS Glue jobs.
-
Getting Started with the CData Excel Add-In for ZarMoney
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for ZarMoney.
-
Choosing the Best Method to Connect EnterpriseDB to SQL Server: 5 Options Explained
Discover multiple ways to connect and use EnterpriseDB from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use the CData Software ODBC Driver for ZohoSubscriptions in SAS for Real-Time Reporting and Analytics
Connect to real-time ZohoSubscriptions in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ZohoSubscriptions.
-
Connect to Hugging Face Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Integrating Claude Code CLI with Teamgate 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.
-
Automate Deel Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Deel from PowerShell? This article demonstrates how to utilize the Deel Cmdlets for tasks like connecting to Deel, automating operations, downloading data, and more.
-
Replicate Multiple ZendeskSell Accounts
Replicate multiple ZendeskSell accounts to one or many databases.
-
DataBind Sentry Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Sentry to a chart.
-
Connect to Vercel Data from PowerBuilder via ADO.NET
This article demonstrates how to access Vercel from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to work with Clari Data in Apache Spark using SQL
Access and process Clari Data in Apache Spark using the CData Software JDBC Driver.
-
How to Connect the Power BI Service to NASA: Complete Guide
Connect to the CData Software Power BI Connector for NASA from PowerBI.com to provide real-time NASA across the organization.
-
Replicate Multiple XML Accounts
Replicate multiple XML accounts to one or many databases.
-
Getting Started with the CData Power BI Connector for Box
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Box.
-
Integrating Kiro CLI with Klipfolio 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.
-
Prepare, Blend, and Analyze Mixpanel Data in Alteryx Designer (ODBC)
Build workflows to access live Mixpanel for self-service data analytics.
-
Automate ServiceNow Data Replication to Azure Synapse
Use CData Sync to customize and automate ServiceNow replication to Azure Synapse.
-
Connecting Pipedream with Zoho Projects 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 Zoho Projects data in real time.
-
Extract, Transform, and Load Google Forms Data in Informatica PowerCenter
Create a simple Workflow for Google Forms in Informatica PowerCenter.
-
Create Datasets from Google Forms in Domo Workbench and Build Visualizations of Google Forms Data in Domo
Use the CData Software ODBC Driver for Google Forms to create datasets from Google Forms in Domo Workbench and then build visualizations in the Domo service.
-
Integrate Guru with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Guru with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Guru.
-
Moving Data from Neo4J to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Neo4J data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Access Live Autopilot Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Autopilot into the statistical analysis tools available in SAS JMP. This article shows how to use Autopilot in the Graph Builder and Query Builder.
-
Replicate Multiple Google Ad Manager Accounts via the CData Sync CLI
Replicate multiple Google Ad Manager accounts to one or many databases.
-
Automated Continuous Dotmailer Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Dotmailer replication to Google Cloud SQL.
-
How to Import Data from Vault CRM into Google Sheets
Import Veeva Vault & Vault CRM into a Google spreadsheet that is automatically refreshed.
-
Integrating LangChain with Odoo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Odoo ERP within automated workflows.
-
Integrate with Azure Synapse Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Azure Synapse in SnapLogic.
-
How to Query Live Oracle SCM Data in Perplexity MacOS Desktop
Connect to and query live Oracle SCM Data in Perplexity Desktop using CData MCP Server.
-
Automated Continuous Sendwithus Replication to MongoDB
Use CData Sync for automated, continuous, customizable Sendwithus replication to MongoDB.
-
Integrate FHIR with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate FHIR with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to FHIR.
-
Integrate Live Power BI XMLA Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Power BI XMLA from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Power BI XMLA.
-
Working with GitLab Data in LINQPad
Execute LINQ queries to GitLab in LINQPad.
-
Create Reports with Supabase Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Supabase.
-
Automated Continuous Confluence Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Confluence replication to delimited files (CSV/TSV).
-
Automated Continuous Vault CRM Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Vault CRM replication to Apache Kafka.
-
Integrate Open WebUI with Live Paylocity Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Paylocity from within the chat interface.
-
Integrate Live SparkPost Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live SparkPost to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to Accelo Data in JRuby
Create a simple JRuby app with access to live Accelo.
-
Getting Started with the CData SSIS Components for CSV
Complete guide to installing, licensing, and connecting with the CData SSIS Components for CSV.
-
Automate eBay Data Replication to Couchbase
Use CData Sync to Customize and automate eBay replication to Couchbase.
-
Connect Bright Data to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Bright Data with IBM WebSphere for seamless data integration and connectivity.
-
How to work with Amazon Marketplace Data in Apache Spark using SQL
Access and process Amazon Marketplace Data in Apache Spark using the CData Software JDBC Driver.
-
Integrate Open WebUI with Live Elasticsearch Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Elasticsearch from within the chat interface.