CData Software - Knowledge Base
Recent Articles
-
Extract, Transform, and Load Suadeo Data in Informatica PowerCenter
Create a simple Workflow for Suadeo data in Informatica PowerCenter.
-
Visualize Exact Online Data in TIBCO Spotfire through OData
Integrate Exact Online data into dashboards in TIBCO Spotfire.
-
Use Dash to Build to Web Apps on Paymo Data
Create Python applications that use pandas and Dash to build Paymo-connected web apps.
-
Visualize Live Adobe Experience Manager Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Adobe Experience Manager data into custom reports in Power BI.
-
Replicate Pipeline CRM Data in Heroku for Use in Salesforce Connect
Replicate Pipeline CRM data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Working with Paylocity Data in LINQPad
Execute LINQ queries to Paylocity data in LINQPad.
-
Getting Started with the CData ADO.NET Provider for SAP HANA
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for SAP HANA.
-
Automated Continuous Office 365 Replication to Databricks
Use CData Sync for automated, continuous, customizable Office 365 replication to Databricks.
-
Getting Started with the CData ADO.NET Provider for Teradata
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Teradata.
-
Visualize Short.io Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Short.io data.
-
Automated Continuous Datadog Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Datadog replication to Google Cloud SQL.
-
Manage Strava Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Strava.
-
How to load Chargebee data into Elasticsearch via Logstash
Introducing a simple method to load Chargebee data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Connect to Microsoft Ads Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Microsoft Ads data. Leverage the pyodbc module for ODBC in Python.
-
Prepare, Blend, and Analyze Okta Data in Alteryx Designer (Connect AI)
Build workflows to access live Okta data for self-service data analytics.
-
Establish a Live Connection with Box Data using Tableau Bridge
The CData ODBC Driver for Box enables you to integrate live Box data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to SAP Data from a Connection Pool in Jetty
The SAP JDBC Driver supports connection pooling: This article shows how to connect faster to SAP data from Web apps in Jetty.
-
Connect to Factorial in SpagoBI
Create reports featuring live Factorial data in SpagoBI Studio. Host Factorial reports on SpagoBI Server.
-
Publish Reports with Salesloft Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Salesloft data.
-
Connect to Reply.io in SpagoBI
Create reports featuring live Reply.io data in SpagoBI Studio. Host Reply.io reports on SpagoBI Server.
-
How to connect to Egnyte Data with Squirrel SQL client
Connect to Egnyte data and execute queries in the Squirrel SQL Client.
-
Build AI Agents with FHIR Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live FHIR data through CData Connect AI.
-
Getting Started with the CData Python Connector for Jodoo
Learn to install and license the CData Python Connector and configure a connection to live Jodoo data.
-
Using the CData Software ODBC Driver for Front in PyCharm
Connect to Front as an ODBC data source in PyCharm using the CData Software ODBC Driver for Front.
-
Integrate Factorial Data in the Pentaho Report Designer
Publish reports based on Factorial data in the Pentaho BI tool.
-
Automated Continuous Azure DevOps Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Azure DevOps replication to Google Cloud SQL.
-
Analyze Apollo Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Apollo data with the CData JDBC Driver for Apollo.
-
DataBind Azure Synapse Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Azure Synapse with the DevExpress Windows Forms and Web controls to provide Azure Synapse data to a chart.
-
Using the CData Software ODBC Driver for Bannerbear in PyCharm
Connect to Bannerbear as an ODBC data source in PyCharm using the CData Software ODBC Driver for Bannerbear.
-
Process & Analyze ConvertKit Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live ConvertKit Data.
-
Integrate Live SQL Server Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live SQL Server data to Blue Prism using the CData ODBC Driver for SQL Server to create automated workflows for repetitive business tasks.
-
Integrating LangGraph with SAP ByDesign Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on SAP ByDesign data within automated workflows.
-
Build PDFMonkey-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live PDFMonkey data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Microsoft Exchange
Provide connectivity to Microsoft Exchange data through an SAP BusinessObjects universe.
-
Connect Vercel Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Vercel data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Seamlessly Import Avalara AvaTax Data into IBM SPSS Modeler
Integrate Avalara AvaTax data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Sybase Data in DBArtisan
Use wizards in DBArtisan to configure Sybase data as a data source.
-
Connecting GenSpark with Zoho CRM Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Zoho CRM data without any replication or custom integration required.
-
Analyze Google Forms Data in Cognos Analytics
Use CData Connect AI to connect to Google Forms Data from Cognos Analytics and analyze live Google Forms data.
-
How to Visualize MongoDB Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live MongoDB data in Python.
-
Automated Continuous Perplexity Replication to Oracle
Use CData Sync for automated, continuous, customizable Perplexity replication to Oracle.
-
Natively Connect to Google Analytics Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Google Analytics data. Leverage the native support for ODBC in PHP.
-
Connecting Moonlit Workflow with Hive 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 Hive data in real time.
-
Automate Pipeline CRM Data Replication to Azure Data Lake
Use CData Sync to customize and automate Pipeline CRM data replication to Azure Data Lake.
-
Automated Continuous Jumpseller Replication to Databricks
Use CData Sync for automated, continuous, customizable Jumpseller replication to Databricks.
-
How to Connect DBeaver to SAP Ariba Procurement via a JDBC Driver
Manage SAP Ariba Procurement data with visual tools in DBeaver like the query browser.
-
Easily Integrate Samanage Data in Lazarus Pascal IDE
Learn how to easily integrate live Samanage data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Access Sendwithus Data from MySQL in Amazon QuickSight
Connect to Sendwithus and build visualizations of Sendwithus data using a MySQL Connection in Amazon QuickSight.
-
Integrating Claude Code CLI with Vercel 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.
-
Build CircleCI-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live CircleCI data.
-
Write a Simple Go Application to work with Google Drive Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Google Drive data.
-
Connect to Clari Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Clari and the SQL Gateway to access Clari data from Google Apps Script.
-
Automated Continuous Close Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Close replication to PostgreSQL.
-
Integrate Dify with Live Gong Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Gong data.
-
Automated Continuous IBM Informix Replication to IBM DB2
Use CData Sync for automated, continuous, customizable IBM Informix replication to IBM DB2.
-
Build MVC Applications with Connectivity to NetSuite Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access NetSuite from an ASP.NET MVC application.
-
Query Live Microsoft Exchange Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Microsoft Exchange data through a conversational interface.
-
Replicate Twilio Data to Multiple Databases
Replicate Twilio data to disparate databases with a point-and-click configuration.
-
Use the CData Software ODBC Driver for Productboard in MicroStrategy
Connect to Productboard data in MicroStrategy Developer using the CData Software ODBC Driver for Productboard.
-
Operational Reporting on Access Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Access data.
-
Access Live Zendesk Data in Coginiti Pro
Connect to and query live Zendesk data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Load Omnisend Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Omnisend data to a database.
-
Integrating Boomi Agentstudio with SageHR Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to SageHR data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to Access Toggl Data Using Entity Framework
This article shows how to access Toggl data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Rebilly Data in DBArtisan
Use wizards in DBArtisan to configure Rebilly data as a data source.
-
How to connect to JDBC-ODBC Bridge Data from IntelliJ
Integrate connectivity to JDBC-ODBC Bridge data with wizards in IntelliJ.
-
Query Zoho Inventory Data as a MySQL Database in Node.js
Execute MySQL queries against Zoho Inventory data from Node.js.
-
Access Live Marketo Data in Coginiti Pro
Connect to and query live Marketo data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Natively Connect to Quickbase Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Quickbase data. Leverage the native support for ODBC in PHP.
-
Connect to Jumpseller Data from PowerBuilder via ADO.NET
This article demonstrates how to access Jumpseller data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Automated eBay Data Replication to Teradata
Use CData Sync to Customize and automate eBay data replication to Teradata.
-
Choosing the Best Method to Connect Deel to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Deel data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Continuous Browserless Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Browserless data replication to OneLake in Microsoft Fabric.
-
How to Connect to Live Dynamics 365 Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Dynamics 365 data without replication.
-
Rapidly Develop SingleStore-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by SingleStore.
-
Build Facebook Ads-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Facebook Ads data.
-
Visualize Xero Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Xero data.
-
Connect to Qualaroo from a Connection Pool in WebLogic
Use the CData JDBC Driver for Qualaroo to connect to Qualaroo data from Web applications running on WebLogic.
-
Use ChatGPT to Talk to Your Mailjet Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Mailjet data for you.
-
Getting Started with the CData ODBC Driver for Microsoft Planner
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Microsoft Planner.
-
Build a Singer.io Tap for Coda With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Coda data using the CData Python Connector.
-
Connect to Live SAS xpt Data in MicroStrategy through CData Connect AI
Create a live connection to SAS xpt Data in CData Connect AI and connect to your SAS xpt data from MicroStrategy.
-
Connect Microsoft Entra ID to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Microsoft Entra ID with IBM WebSphere for seamless data integration and connectivity.
-
Create SSAS Tabular Models from Insightly Data
How to build a SQL Server Analysis Service Tabular Model from Insightly data using CData drivers.
-
Connect to Slack Data from PowerBuilder via ADO.NET
This article demonstrates how to access Slack data from Appeon PowerBuilder using the CData ADO.NET Provider for Slack.
-
Connect to ActiveCampaign Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for ActiveCampaign data.
-
Bridge Quickbase Connectivity with Apache NiFi
Access and process Quickbase data in Apache NiFi using the CData JDBC Driver.
-
How to work with Harvest Data in Apache Spark using SQL
Access and process Harvest Data in Apache Spark using the CData Software JDBC Driver.
-
Query Azure Analysis Services Data in ColdFusion
Write standard ColdFusion data access code to connect to Azure Analysis Services data.
-
Visualize Live Greenplum Data in the Power BI Service
Use CData Connect AI to connect to live Greenplum data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Connect to Freshsales Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Freshsales data. Leverage the pyodbc module for ODBC in Python.
-
How to Work with Lakebase Data in AWS Glue Jobs Using JDBC
Connect to Lakebase from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Query Sendwithus Data as a SQL Server Database in Node.js
Execute SQL Server queries against Sendwithus data from Node.js.
-
Excel Spreadsheet Automation on Salesforce Data with the QUERY Formula
Pull data from Salesforce, automate spreadsheets, and more with the QUERY formula.
-
Connect to Zendesk Data in Aqua Data Studio
Access Zendesk data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect SuiteCRM to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SuiteCRM data using the CData Python MCP Server.
-
Connect to Google Tasks Data from PowerBuilder via JDBC
This article demonstrates how to access Google Tasks data from PowerBuilder using the Google Tasks JDBC Driver.
-
Build Salesforce Pardot-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Salesforce Pardot data.
-
Use ChatGPT to Talk to Your LDAP Objects via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your LDAP objects for you.
-
Build MVC Applications with Connectivity to Vercel Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Vercel from an ASP.NET MVC application.