CData Software - Knowledge Base
Recent Articles
-
Connect to Access Data in DBeaver
Use the CData ODBC Driver to connect to Microsoft Access in DBeaver.
-
How to Seamlessly Import Clockify Data into IBM SPSS Modeler
Integrate Clockify data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Use the CData Software JDBC Driver for Spotify in MicroStrategy Desktop
Connect to Spotify in MicroStrategy Desktop using the CData Software JDBC Driver for Spotify.
-
Configure the CData JDBC Driver for Google Contacts in a Connection Pool in Tomcat
Connect to Google Contacts from a connection pool in Tomcat.
-
Integrate Cassandra Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Apache Cassandra from Informatica Cloud.
-
Connect to Bitbucket Data in RapidMiner
Integrate Bitbucket with standard components and data source configuration wizards in RapidMiner Studio.
-
Build Data Flows from Avro to SQL Server using SSIS
Easily back up Apache Avro to SQL Server using the SSIS components for Avro.
-
Create Informatica Mappings From/To a JDBC Data Source for Rebilly
Create Rebilly data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Access Mode Data Using Entity Framework
This article shows how to access Mode using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Replicate Autopilot Data in Heroku for Use in Salesforce Connect
Replicate Autopilot to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Splunk Data from PowerBuilder via JDBC
This article demonstrates how to access Splunk from PowerBuilder using the Splunk JDBC Driver.
-
Access Azure Data Lake Storage Data from MySQL in Amazon QuickSight
Connect to Azure Data Lake Storage and build visualizations of Azure Data Lake Storage using a MySQL Connection in Amazon QuickSight.
-
MarkLogic Reporting in OBIEE with the MarkLogic JDBC Driver
Deploy the MarkLogic JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Access Live PagerDuty Data in Coginiti Pro
Connect to and query live PagerDuty from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use Dash to Build Web Apps on Gmail Data via CData Connect AI
Build interactive Dash web apps on live Gmail using pandas and the CData Connect AI Python SDK.
-
Import and Visualize Everhour Data in Power View
Create data visualizations based on Everhour in Excel.
-
DataBind Controls to HelloSign Data in Delphi
DataBind to HelloSign in Delphi with standard data access components and controls.
-
Use Dash to Build Web Apps on MarkLogic Data via CData Connect AI
Build interactive Dash web apps on live MarkLogic using pandas and the CData Connect AI Python SDK.
-
Query SAP Business Warehouse Data in DataGrip
Create a Data Source for SAP Business Warehouse in DataGrip and use SQL to query live SAP Business Warehouse.
-
Integrate Shortcut Data in Pentaho Data Integration
Build ETL pipelines based on Shortcut in the Pentaho Data Integration tool.
-
How to work with Cvent Data in Apache Spark using SQL
Access and process Cvent Data in Apache Spark using the CData Software JDBC Driver.
-
Integrate Tally Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Tally ERP from Informatica Cloud.
-
Connect Zuora Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Zuora using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for MYOB AccountRight
Provide connectivity to MYOB AccountRight through an SAP BusinessObjects universe.
-
Build Keap-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Keap.
-
Automate Google Translate Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Google Translate from PowerShell? This article demonstrates how to utilize the Google Translate Cmdlets for tasks like connecting to Google Translate, automating operations, downloading data, and more.
-
How to Connect to Live SAP Ariba Procurement 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 SAP Ariba Procurement for you.
-
Automated Continuous Cloudflare Replication to Snowflake
Use CData Sync for automated, continuous, customizable Cloudflare replication to Snowflake.
-
How to create an RPA flow for Salesforce Data 360 Data in UiPath Studio
Use the Salesforce Data 360 ODBC Driver to create workflows that access real-time Salesforce Data 360 without any coding.
-
Query EnterpriseDB Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume EnterpriseDB entities in PHP by modeling them as objects.
-
Replicate MYOB AccountRight Data to Multiple Databases
Replicate MYOB AccountRight to disparate databases with a point-and-click configuration.
-
How to Connect to Live Twilio Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Twilio through natural language.
-
Create Monday.com Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Monday.com from PowerBI.com to create Power BI Dataflows with real-time data.
-
Rapidly Develop Contentful-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 Contentful.
-
How to Connect DBeaver to ElevenLabs via a JDBC Driver
Manage ElevenLabs with visual tools in DBeaver like the query browser.
-
Analyze SAP Business One Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of SAP Business One and visualize live SAP Business One in Infragistics Reveal.
-
How to Work with ChartMogul Data in ETL Validator JDBC
Connect to ChartMogul from ETL Validator jobs using the CData Software JDBC Driver.
-
Automate ZohoExpense Data Replication to Azure Data Lake
Use CData Sync to customize and automate ZohoExpense replication to Azure Data Lake.
-
How to Connect DBeaver to Microsoft Ads via a JDBC Driver
Manage Microsoft Ads with visual tools in DBeaver like the query browser.
-
Replicate Mixpanel Data from PowerShell
Write a quick PowerShell script to query Mixpanel. Use connectivity to the live data to replicate Mixpanel to SQL Server.
-
Integrate OneNote Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Microsoft OneNote and integrate live Microsoft OneNote into your Power Automate tasks.
-
Build Dashboards with Tickspot Data in DBxtra
Create dynamic dashboards and perform analytics based on Tickspot in DBxtra.
-
Integrating Dataiku with Google Campaign Manager 360 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Google Campaign Manager 360.
-
Perform Batch Operations with Microsoft Teams Data in Apache NiFi
Connect to Microsoft Teams and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Prepare, Blend, and Analyze Airtable Data in Alteryx Designer (Connect AI)
Build workflows to access live Airtable for self-service data analytics.
-
How to connect to GraphQL Data in DBVisualizer
Integrate GraphQL with visual data analysis tools and data connection wizards in DBVisualizer
-
Automate Customer.io Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Customer.io from PowerShell? This article demonstrates how to utilize the Customer.io Cmdlets for tasks like connecting to Customer.io, automating operations, downloading data, and more.
-
How to use SQLAlchemy ORM to access Zoho Inventory Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Zoho Inventory.
-
Prepare, Blend, and Analyze Redis Data in Alteryx Designer (ODBC)
Build workflows to access live Redis for self-service data analytics.
-
Access Live Oracle Sales Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Oracle Sales from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Access Live Act-On Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Act-On data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Build Okta-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Okta to explore live Okta Data in Gemini Code Assist to assist with building Okta-powered applications.
-
Analyze Gorgias Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Gorgias with the CData JDBC Driver for Gorgias.
-
Analyze Neo4J Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Neo4J and visualize live Neo4J in Infragistics Reveal.
-
Connect to Live FTP Data in MicroStrategy through CData Connect AI
Create a live connection to FTP Data in CData Connect AI and connect to your FTP Servers from MicroStrategy.
-
Connect to Coda Data in JRuby
Create a simple JRuby app with access to live Coda.
-
Getting Started with the CData ODBC Driver for SAP HANA
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SAP HANA.
-
Bidirectional Access to QuickBooks Time Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate QuickBooks Time in Filemaker Pro for Mac or Windows.
-
Integrating Claude Code CLI with Facebook 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 Mailgun to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Mailgun using the CData Python MCP Server.
-
Build LDAP-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for LDAP to explore live LDAP Objects in Cursor to assist with building LDAP-powered applications.
-
Integrate Cline with Live Authorize.Net Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Authorize.Net from within your IDE.
-
Integrating Antigravity CLI with NASA via CData CLI
Connect NASA to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Stream Confluence Data into Apache Kafka Topics
Access and stream Atlassian Confluence in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous Optimizely Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Optimizely replication to delimited files (CSV/TSV).
-
Create Power BI Reports on Real-Time SQL Analysis Services Data
Use the CData ODBC Driver for SQL Analysis Services to visualize SQL Analysis Services in Power BI Desktop.
-
How to Connect the Power BI Service to Zendesk: Complete Guide
Connect to the CData Software Power BI Connector for Zendesk from PowerBI.com to provide real-time Zendesk across the organization.
-
Connect to DocuSign Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time DocuSign using standard SQL.
-
DataBind Charts to LinkedIn Ads Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to LinkedIn Ads 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.
-
Enable the Databricks JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Databricks.
-
Publish Crystal Reports on Google Cloud Storage Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Google Cloud Storage.
-
DataBind PostgreSQL Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for PostgreSQL with the DevExpress Windows Forms and Web controls to provide PostgreSQL to a chart.
-
Build Apps with Live Parallel Data Using the Low-Code Development Platform of Mendix
Connect Parallel with Mendix to build apps using the CData API Driver for JDBC.
-
Access SAP Hybris C4C Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for SAP Hybris C4C.
-
How to Access Live Outreach.io Data in Visual Studio Code via Cline
Run CData MCP Server for Outreach.io on Windows Subsytem for Linux (WSL) and connect to live Outreach.io from the Cline extension in Visual Studio Code.
-
How to Query Paymo Data in MySQL Workbench
Execute MySQL queries against live Paymo from MySQL Workbench.
-
Access HBase Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Apache HBase from HeidiSQL.
-
Build a Singer.io Tap for Telegram With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Telegram data using
-
Consume Microsoft Exchange OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Microsoft Exchange feeds that reflect any changes in SAP Lumira.
-
Getting Started with the CData Connect AI Python SDK for Google Ads
Install the CData Connect AI Python SDK to read and write live Google Ads with standard DB-API 2.0 Python code.
-
Visualize CSV 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 CSV/TSV Files into TIBCO Spotfire.
-
Integrate Printful Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Printful from Informatica Cloud.
-
Access Zoho Projects Data from MySQL in PHP
Connect to Zoho Projects through the standard MySQL libraries in PHP.
-
Use the CData Software ODBC Driver for Testmonitor in SAS for Real-Time Reporting and Analytics
Connect to real-time Testmonitor in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Testmonitor.
-
Automated Continuous Amazon Marketplace Replication to Oracle
Use CData Sync for automated, continuous, customizable Amazon Marketplace replication to Oracle.
-
How to Work with Coda Data in AWS Glue Jobs Using JDBC
Connect to Coda from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Keap Data from PowerBuilder via JDBC
This article demonstrates how to access Keap from PowerBuilder using the Keap JDBC Driver.
-
How to integrate Metabase with Kintone Data
Use CData Connect AI to connect to live Kintone and create an interactive dashboard in Metabase from Kintone.
-
How to Connect to Live BigQuery Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Google BigQuery through natural language.
-
How to Connect Flowise AI Agents to Live Oracle Financials Cloud 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 Oracle Financials Cloud without replication.
-
Connect and Query Live Microsoft Ads Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Microsoft Ads into Databricks
-
Use the CData Software JDBC Driver for iContact in MicroStrategy Web
Connect to iContact in MicroStrategy Web using the CData Software JDBC Driver for iContact.
-
Use JayDeBeApi to access OnePageCrm Data in Python
Use standard Python scripting and the development environment of your choice to access live OnePageCrm.
-
Build Authorize.Net-Connected Apps in Choreo
Use CData Connect AI to connect to Authorize.Net Data from Choreo and build custom apps using live Authorize.Net.
-
How to Connect Gmail 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 Gmail data in real time using natural language.
-
Import and Visualize SAP Fieldglass Data in Power View
Create data visualizations based on SAP Fieldglass in Excel.
-
How to Query QuickBooks Time Data in MySQL Workbench
Execute MySQL queries against live QuickBooks Time from MySQL Workbench.
-
Analyze Mailgun Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Mailgun in Microsoft R Open.
-
Getting Started with the CData Connect AI Python SDK for Azure Analysis Services
Install the CData Connect AI Python SDK to read and write live Azure Analysis Services with standard DB-API 2.0 Python code.
-
Visualize Amplitude Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Amplitude.