CData Software - Knowledge Base
Recent Articles
-
Access Oracle Sales 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 Oracle Sales data.
-
Query Live WooCommerce Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live WooCommerce data directly from the development environment.
-
How to Seamlessly Import VWO Data into IBM SPSS Modeler
Integrate VWO data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to use SQLAlchemy ORM to access Aweber Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Aweber data.
-
Connect to Highrise Data in RazorSQL
Connect to Highrise from wizards and query Highrise data from the GUI in the RazorSQL database management tool.
-
How to use SQLAlchemy ORM to access Demio Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Demio data.
-
Create SSAS Tabular Models from Figshare Data
How to build a SQL Server Analysis Service Tabular Model from Figshare data using CData drivers.
-
Create Dashboards and Visualize Live Twitter Ads Data in Geckoboard
Use CData Connect AI to connect to live Twitter Ads data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to integrate Metabase with Vault CRM Data
Use CData Connect AI to connect to live Vault CRM data and create an interactive dashboard in Metabase from Vault CRM data.
-
Automated Continuous Trello Replication to SQLite
Use CData Sync for automated, continuous, customizable Trello replication to SQLite.
-
How to import Box Data into Apache Solr
Use the CData Software JDBC Driver for Box in Data Import Handler and create an automated import of Box data to Apache Solr Enterprise Search platform.
-
How to Work with Vault CRM Data in AWS Glue Jobs Using JDBC
Connect to Vault CRM from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automate Square Data Replication to Couchbase
Use CData Sync to Customize and automate Square data replication to Couchbase.
-
Integrate Aweber Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Aweber data and integrate live Aweber data into your Power Automate tasks.
-
Connect to and Query Nethunt Data in QlikView over ODBC
Create data visualizations with Nethunt data in QlikView.
-
How to connect to AfterShip Data with Squirrel SQL client
Connect to AfterShip data and execute queries in the Squirrel SQL Client.
-
Connect Pipedrive Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Pipedrive data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Stream SAP Ariba Procurement Data into Apache Kafka Topics
Access and stream SAP Ariba Procurement data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Migrating data from Salesloft to Google BigQuery using CData SSIS Components.
Easily push Salesloft data to Google BigQuery using the CData SSIS Tasks for Salesloft and Google BigQuery.
-
Load SAP Fieldglass Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SAP Fieldglass data to a database.
-
How to Work with Google Forms Data in AWS Glue Jobs Using JDBC
Connect to Google Forms from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Model Microsoft Ads Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Microsoft Ads, enabling the direct import of real-time Microsoft Ads data.
-
Use the CData Software ODBC Driver for Sugar CRM in MicroStrategy
Connect to Sugar CRM data in MicroStrategy Developer using the CData Software ODBC Driver for Sugar CRM.
-
Automate Google Search Results Replication to Azure Data Lake
Use CData Sync to customize and automate Google Search results replication to Azure Data Lake.
-
Visualize Discourse Data in Tableau
The CData ODBC driver for Discourse enables you integrate Discourse data into Tableau dashboards.
-
Getting Started with the CData Excel Add-In for SAP SuccessFactors LMS
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SAP SuccessFactors LMS.
-
Integrate LibreChat with Live FTP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live FTP data from within the chat interface.
-
Integrate Bitly Data into Power Automate Desktop using CData Connect
CData Connect for Bitly Data enables you to integrate Bitly data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Hubstaff Data in HULFT Integrate
Connect to Hubstaff as a JDBC data source in HULFT Integrate
-
Automated Continuous Opsgenie Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Opsgenie replication to Amazon S3.
-
Natively Connect to PingOne Data in PHP
The CData ODBC driver for PingOne enables you to create PHP applications with connectivity to PingOne data. Leverage the native support for ODBC in PHP.
-
Analyze Microsoft Exchange Data in Cognos Analytics
Use CData Connect AI to connect to Microsoft Exchange Data from Cognos Analytics and analyze live Microsoft Exchange data.
-
Create Apify-Connected Dashboards in Grafana
Connect to Apify Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Apify data.
-
Getting Started with the CData Power BI Connector for ZohoSubscriptions
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Create Data Visualizations Based On Active Directory Data in Mode
Use CData Connect AI to connect to Active Directory Data from Mode and build visualizations using live Active Directory data.
-
Build Dynamics CRM Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Dynamics CRM data and build visualizations in Tableau Cloud.
-
Query Productboard Data in ColdFusion
Write standard ColdFusion data access code to connect to Productboard data.
-
Explore Geographical Relationships in Acumatica Data with Power Map
Create data visualizations with Acumatica data in Power Map.
-
Load Sage 200 Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Sage 200 data to a database.
-
Automated Continuous Wistia Replication to SQL Server
Use CData Sync for automated, continuous, customizable Wistia replication to SQL Server.
-
How to Connect to & Open Salesforce Data in Microsoft Excel
This article uses the CData ODBC driver for Salesforce to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create Dashboards and Visualize Live Adobe Commerce Data in Geckoboard
Use CData Connect AI to connect to live Adobe Commerce data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Getting Started with the CData SSIS Components for Azure DevOps
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Azure DevOps.
-
Extract, Transform, and Load Sybase Data in Informatica PowerCenter
Create a simple Workflow for Sybase data in Informatica PowerCenter.
-
Build Agents in Relevance AI with Access to Live AfterShip Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on AfterShip data within intelligent agent workflows.
-
Visualize Teamgate Data in Sisense
Create an ElastiCube in Sisense app with access to Teamgate data.
-
Prepare, Blend, and Analyze PayPal Data in Alteryx Designer (Connect AI)
Build workflows to access live PayPal data for self-service data analytics.
-
Integrating Claude Code CLI with ZohoDesk 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.
-
Replicate PagerDuty Data in Heroku for Use in Salesforce Connect
Replicate PagerDuty data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Process & Analyze Mailjet Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Mailjet Data.
-
Automated Continuous Procore Replication to SQL Server
Use CData Sync for automated, continuous, customizable Procore replication to SQL Server.
-
Integrating GitHub Copilot with ZeroBounce 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.
-
Choosing the Best Method to Connect Zuora to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Zuora data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Connect Flowise AI Agents to Live HDFS 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 HDFS data without replication.
-
A PostgreSQL Interface for TigerGraph Data (MySQL Remoting via JDBC)
Use the Remoting features of the TigerGraph JDBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Live Excel Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Excel data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating Boomi Agentstudio with Okta Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Okta data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Getting Started with the CData Python Connector for Clari
Learn to install and license the CData Python Connector and configure a connection to live Clari data.
-
Build AI/ML Models with Live Eventbrite Data using Dataiku
Connect Eventbrite Data with Dataiku using the CData API Driver for JDBC.
-
Replicate Azure Synapse Data to Multiple Databases via the CData Sync CLI
Replicate Azure Synapse data to disparate databases with a single configuration.
-
Integrating Cursor with Sage Intacct 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 SharePoint Excel Services to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SharePoint Excel Services data using the CData Python MCP Server.
-
Integrating LangChain with SAP Ariba Procurement Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on SAP Ariba Procurement data within automated workflows.
-
How to publish and share Perplexity Data dashboards with Tableau Server
The CData ODBC driver for Perplexity enables you integrate Perplexity data into Tableau dashboards.
-
Import Box Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Box Data and provide access to live Box data for custom reports in the Power BI Service.
-
Import Real-Time AlloyDB Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use AlloyDB data in ColdFusion.
-
Import Adobe Commerce Data Using Azure Data Factory
Use CData Connect AI to connect to Adobe Commerce Data from Azure Data Factory and import live Adobe Commerce data.
-
How to Connect Flowise AI Agents to Live Cloudflare 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 Cloudflare data without replication.
-
How to connect to Basecamp Data in DBVisualizer
Integrate Basecamp data with visual data analysis tools and data connection wizards in DBVisualizer
-
Publish Qualaroo-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Qualaroo data.
-
Getting Started with the CData ODBC Driver for Google Tasks
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Google Tasks.
-
Model Confluence Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Confluence, enabling the direct import of real-time Confluence data.
-
Automated Continuous Sentry Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Sentry replication to delimited files (CSV/TSV).
-
Integrate Oracle Financials Cloud with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Oracle Financials Cloud with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Oracle Financials Cloud data.
-
Automated Continuous Sybase Replication to SingleStore
Use CData Sync for automated, continuous, customizable Sybase replication to SingleStore.
-
Automated Continuous LeadDesk Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable LeadDesk replication to Azure SQL Database.
-
Create Snowflake Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Snowflake data access from reports, embedded analytics, and more.
-
Create Power BI Reports on Real-Time SparkPost Data
Use the CData ODBC Driver for SparkPost to visualize SparkPost data in Power BI Desktop.
-
Automated Continuous Clari Replication to Vertica
Use CData Sync for automated, continuous, customizable Clari replication to Vertica.
-
Connect to Cvent in SpagoBI
Create reports featuring live Cvent data in SpagoBI Studio. Host Cvent reports on SpagoBI Server.
-
Build Automated Google Ad Manager-Connected Workflows in Zapier
Use CData Connect AI to connect to live Google Ad Manager data and build automated workflows in Zapier.
-
Use the CData Software ODBC Driver for Sage Cloud Accounting in MicroStrategy Web
Connect to Sage Cloud Accounting data in MicroStrategy Web using the CData Software ODBC Driver for Sage Cloud Accounting.
-
Query ShipStation Data through ODBC in Node.js
Use node-odbc to execute SQL queries against ShipStation data from Node.js.
-
Excel Spreadsheet Automation on QuickBooks Data with the QUERY Formula
Pull data from QuickBooks, automate spreadsheets, and more with the QUERY formula.
-
Connect to Facebook Ads Data from PowerBuilder via JDBC
This article demonstrates how to access Facebook Ads data from PowerBuilder using the Facebook Ads JDBC Driver.
-
Connecting GenSpark with HBase Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to HBase data without any replication or custom integration required.
-
Import and Visualize Vimeo Data in Power View
Create data visualizations based on Vimeo data in Excel.
-
Query Parallel Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Parallel data from Node.js.
-
How to update Klaviyo from Excel
This article explains how to transfer data from Excel to Klaviyo using the Excel Add-In for Klaviyo.
-
Import and Visualize BigQuery Data in Power View
Create data visualizations based on BigQuery data in Excel.
-
Automated Continuous Campaigner Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Campaigner replication to AlloyDB.
-
How to Build an ETL App for Google Calendar Data in Python with CData
Create ETL applications and real-time data pipelines for Google Calendar data in Python with petl.
-
Connect to Teradata Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Teradata Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Query Samanage Data as a SQL Server Database in Node.js
Execute SQL Server queries against Samanage data from Node.js.
-
How to Connect DBeaver to Email via a JDBC Driver
Manage Email data with visual tools in DBeaver like the query browser.
-
Use Agno to Talk to Your MailChimp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your MailChimp data for you.
-
Integrating GitHub Copilot with LinkedIn 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 SAS xpt Data in AWS Lambda (with IntelliJ IDEA)
Connect to live SAS xpt data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Gong Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Gong data and build visualizations in Tableau.
-
Connecting Mastra with Dynamics CRM Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Dynamics CRM data, no replication required.