CData Software - Knowledge Base
Recent Articles
-
Create Data Visualizations in Cognos BI with Google Campaign Manager 360 Data
Access Google Campaign Manager 360 as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create API-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to API Data from Klipfolio and build custom visualizations using live API.
-
Build Couchbase-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Couchbase Data and create custom apps in Mendix.
-
Getting Started with the CData ODBC Driver for Toggl
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Toggl.
-
Integrating Sage 300 Data in Talend Cloud Data Management Platform
Connect Sage 300 Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Sage 300.
-
Bridge ActiveCampaign Connectivity with Apache NiFi
Access and process ActiveCampaign in Apache NiFi using the CData JDBC Driver.
-
Analyze SAP Business One Data in Looker
Use CData Connect AI to connect to SAP Business One Data from Looker and build custom apps using live SAP Business One.
-
Create Reports with BambooHR Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date BambooHR.
-
Configure the CData JDBC Driver for Mocean in a Connection Pool in Tomcat
Connect to Mocean from a connection pool in Tomcat.
-
Import and Visualize Quaderno Data in Power View
Create data visualizations based on Quaderno in Excel.
-
Connect to Authorize.Net Data from HeidiSQL
Use CData Connect AI to connect to and query live Authorize.Net from HeidiSQL.
-
Use the CData Software JDBC Driver for Microsoft Planner in MicroStrategy Desktop
Connect to Microsoft Planner in MicroStrategy Desktop using the CData Software JDBC Driver for Microsoft Planner.
-
Getting Started with the CData ADO.NET Provider for Sybase IQ
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Sybase IQ.
-
Automate Bullhorn CRM Data Replication to Couchbase
Use CData Sync to Customize and automate Bullhorn CRM replication to Couchbase.
-
Build Semantic Layer Views for SpaceX Data in APOS Live Data Gateway
Use the CData Connector for SpaceX in APOS Live Data Gateway to build Semantic Layer Views for SpaceX.
-
Automated Continuous EnterpriseDB Replication to Snowflake
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to Snowflake.
-
Create Reports with Placid Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Placid.
-
Create a Data Access Object for Pingdom Data using JDBI
A brief overview of creating a SQL Object API for Pingdom in JDBI.
-
Publish SAP Ariba Procurement-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live SAP Ariba Procurement.
-
How to Connect to Live Office 365 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 Microsoft Office 365 without replication.
-
How to Build an ETL App for Oracle Financials Cloud Data in Python with CData
Create ETL applications and real-time data pipelines for Oracle Financials Cloud in Python with petl.
-
Integrating Antigravity CLI with JobNimbus via CData CLI
Connect JobNimbus to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to Connect to Live SAP Concur Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live SAP Concur securely in real time.
-
Publish Reports with ZohoInvoice Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ZohoInvoice.
-
Query SendInBlue Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SendInBlue from Node.js.
-
Integrate with live Gmail Data in Jitterbit
Use CData Connect AI to connect to and integrate live Gmail in Jitterbit.
-
How to connect to Shopify Data with Squirrel SQL client
Connect to Shopify and execute queries in the Squirrel SQL Client.
-
Integrate with live LinkedIn Data in Jitterbit
Use CData Connect AI to connect to and integrate live LinkedIn in Jitterbit.
-
Automate Xero Data Replication to SAP HANA
Use CData Sync to customize and automate Xero Accounting replication to SAP HANA.
-
Build Instagram-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Instagram.
-
Build Act-On-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Act-On to explore live Act-On Data in Cursor to assist with building Act-On-powered applications.
-
How to load Sentry data into Elasticsearch via Logstash
Introducing a simple method to load Sentry data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate with CockroachDB Data in SnapLogic
Use CData Connect AI to connect to and integrate with live CockroachDB in SnapLogic.
-
Access PayPal Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live PayPal from HeidiSQL.
-
Use JayDeBeApi to access QuickBooks Time Data in Python
Use standard Python scripting and the development environment of your choice to access live QuickBooks Time.
-
LINQ to Zuora Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Zuora Data Provider.
-
Build AI/ML Models with Live SendPulse Data using Dataiku
Connect SendPulse Data with Dataiku using the CData API Driver for JDBC.
-
Integrate LibreChat with Live Klaviyo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Klaviyo from within the chat interface.
-
Use the CData Software JDBC Driver for Supabase in MicroStrategy Web
Connect to Supabase in MicroStrategy Web using the CData Software JDBC Driver for Supabase.
-
Integrate Calendly with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Calendly with External Services.
-
Build an OLAP Cube in SSAS from Discord Data
Establish a connection to Discord data from SQL Server Analysis Services, and use the Discord Data Provider to build OLAP cubes for use in analytics and reporting.
-
Query, Visualize, and Share live Raisers Edge NXT Data in Redash
Use CData Connect AI to connect to live Raisers Edge NXT in Redash for querying, visualizing, and sharing.
-
Connect to and Query Google Analytics Data in QlikView over ODBC
Create data visualizations with Google Analytics in QlikView.
-
Integrating Epicor Kinetic Data in Talend Cloud Data Management Platform
Connect Epicor Kinetic Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Epicor Kinetic.
-
How to connect PolyBase to Google Translate
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google Translate.
-
Analyze eBay Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of eBay and visualize live eBay in Infragistics Reveal.
-
Migrating data from Oracle SCM to Google BigQuery using CData SSIS Components.
Easily push Oracle SCM to Google BigQuery using the CData SSIS Tasks for Oracle SCM and Google BigQuery.
-
Integrate SFTP Data in Pentaho Data Integration
Build ETL pipelines based on SFTP in the Pentaho Data Integration tool.
-
How to integrate Reckon with Apache Airflow
Access and process Reckon in Apache Airflow using the CData JDBC Driver.
-
Integrating Dataiku with Google Calendar 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 Calendar.
-
Publish PayPal-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live PayPal.
-
Automated Continuous Bullhorn CRM Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Bullhorn CRM replication to Apache Cassandra.
-
Moving Data from Klipfolio to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Klipfolio data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automated Continuous PostgreSQL Replication to MongoDB
Use CData Sync for automated, continuous, customizable PostgreSQL replication to MongoDB.
-
Use the CData Software JDBC Driver for Microsoft Planner in MicroStrategy Web
Connect to Microsoft Planner in MicroStrategy Web using the CData Software JDBC Driver for Microsoft Planner.
-
Use Dash to Build Web Apps on Airtable Data via CData Connect AI
Build interactive Dash web apps on live Airtable using pandas and the CData Connect AI Python SDK.
-
Query Oracle Data as a MySQL Database in Node.js
Execute MySQL queries against Oracle Database from Node.js.
-
Connect to Autopilot from Asprova with CData Software ODBC Driver for Autopilot
This article shows how to connect faster to Autopilot data from Asprova.
-
Query SQL Server Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Microsoft SQL Server and perform CRUD operations on SQL Server from Node.js.
-
Work with Deel Data in FoxPro
Load Deel into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate HubSpot Data into Power Automate Desktop using CData Connect
CData Connect for HubSpot Data enables you to integrate HubSpot into workflows built using Microsoft Power Automate Desktop.
-
Viewing Stripe Data in RAD Studio Data Explorer
How to view Stripe in RAD Studio Data Explorer using the CData ODBC Driver for Stripe.
-
Access Live CSV Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live CSV/TSV Files through MCP integration.
-
Natively Connect to Recurly Data in PHP
The CData ODBC driver for Recurly enables you to create PHP applications with connectivity to Recurly. Leverage the native support for ODBC in PHP.
-
Integrate with live Kintone Data in Jitterbit
Use CData Connect AI to connect to and integrate live Kintone in Jitterbit.
-
Use the CData Software ODBC Driver for Amazon DynamoDB in MicroStrategy Desktop
Connect to Amazon DynamoDB in MicroStrategy Desktop using the CData Software ODBC Driver for Amazon DynamoDB.
-
A PostgreSQL Interface for Discourse Data (MySQL Remoting via JDBC)
Use the Remoting features of the Discourse JDBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze Oracle Eloqua Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Oracle Eloqua and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Query Act-On Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Act-On entities in PHP by modeling them as objects.
-
Integrate Cursor with Live Email Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Email from within the editor.
-
Use the CData Software ODBC Driver for Rootly in MicroStrategy
Connect to Rootly in MicroStrategy Developer using the CData Software ODBC Driver for Rootly.
-
Connect to Stack Exchange Data in HULFT Integrate
Connect to Stack Exchange as a JDBC data source in HULFT Integrate
-
Connect Neo4J to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Neo4J using the CData Python MCP Server.
-
Bidirectional Access to Sybase Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Sybase in Filemaker Pro for Mac or Windows.
-
Getting Started with the CData ADO.NET Provider for Front
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Automated Continuous Avalara AvaTax Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to Apache Cassandra.
-
How to load Access data into Elasticsearch via Logstash
Introducing a simple method to load Access data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to MongoDB Data in HULFT Integrate
Connect to MongoDB as a JDBC data source in HULFT Integrate
-
Getting Started with the CData ODBC Driver for Act-On
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Act-On.
-
A PostgreSQL Interface for Contentful Data (MySQL Remoting via JDBC)
Use the Remoting features of the Contentful JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Moosend Data in Ruby
Connect to Moosend in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Using the CData Software ODBC Driver for Sage Cloud Accounting in PyCharm
Connect to Sage Cloud Accounting as an ODBC data source in PyCharm using the CData Software ODBC Driver for Sage Cloud Accounting.
-
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.
-
Replicate Multiple WordPress Accounts
Replicate multiple WordPress accounts to one or many databases.
-
Write a Simple Go Application to work with Unbounce Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Unbounce.
-
Use Grok to Talk to Your Pipedrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Pipedrive for you.
-
Replicate Apify Data to Multiple Databases via the CData Sync CLI
Replicate Apify to disparate databases with a single configuration.
-
How to import PayPal Data into Apache Solr
Use the CData Software JDBC Driver for PayPal in Data Import Handler and create an automated import of PayPal to Apache Solr Enterprise Search platform.
-
Automate SingleStore Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SingleStore from PowerShell? This article demonstrates how to utilize the SingleStore Cmdlets for tasks like connecting to SingleStore, automating operations, downloading data, and more.
-
Integrating OpenCode Terminal with Freshsales 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.
-
Create Informatica Mappings From/To an ODBC Data Source for Okta
Create an ODBC connection to Okta in Informatica and browse and transfer Okta.
-
How to Easily Query CSV Data in OpenOffice Base
Connect to CSV data in OpenOffice Base using the CData ODBC Driver for CSV and generate reports with live data insights.
-
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.
-
Use Azure AI Foundry to Talk to Your Hive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Apache Hive for you.
-
Connect to Zuora Data in ACL Analytics
Connect to Zuora via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Zuora.
-
Using the CData Software ODBC Driver for IBM Informix in PyCharm
Connect to IBM Informix as an ODBC data source in PyCharm using the CData Software ODBC Driver for IBM Informix.
-
Create Reports from Azure DevOps Data in Looker Studio
Use CData Connect AI to gain access to live Azure DevOps and create custom reports in Looker Studio.
-
Connect Opsgenie to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Opsgenie using the CData Python MCP Server.
-
Publish ServiceDesk Plus-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live ServiceDesk Plus.
-
Explore Geographical Relationships in Acumatica Data with Power Map
Create data visualizations with Acumatica ERP in Power Map.