CData Software - Knowledge Base
Recent Articles
-
How to Build an ETL App for Microsoft Ads Data in Python with CData
Create ETL applications and real-time data pipelines for Microsoft Ads data in Python with petl.
-
Use Claude to Talk to Your HubSpot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your HubSpot data for you.
-
Create Informatica Mappings From/To an ODBC Data Source for Oracle SCM
Create an ODBC connection to Oracle SCM in Informatica and browse and transfer Oracle SCM data.
-
Connect to QuickBooks Time Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with QuickBooks Time Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to Hubstaff Data in DBeaver
Use the CData ODBC Driver to connect to Hubstaff data in DBeaver.
-
Analyze MariaDB Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of MariaDB data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Access Live Attio Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Attio data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Work with Sybase Data in ETL Validator JDBC
Connect to Sybase from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Azure Data Catalog Data in DBeaver
Use the CData ODBC Driver to connect to Azure Data Catalog data in DBeaver.
-
Manage Trello Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Trello.
-
Automated Continuous Coinbase Replication to Oracle
Use CData Sync for automated, continuous, customizable Coinbase replication to Oracle.
-
Use Agno to Talk to Your Figshare 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 Figshare data for you.
-
How to Seamlessly Import Figshare Data into IBM SPSS Modeler
Integrate Figshare data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect Campaigner to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Campaigner with IBM WebSphere for seamless data integration and connectivity.
-
How to Connect Flowise AI Agents to Live CouchDB 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 CouchDB data without replication.
-
Getting Started with the CData Python Connector for SFTP
Learn to install and license the CData Python Connector and configure a connection to live SFTP data.
-
Access Live Perplexity Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Perplexity data from your Excel spreadsheets.
-
Connect to Google Campaign Manager 360 Data from Crystal Reports
Use CData Connect AI to connect to and report on live Google Campaign Manager 360 data from Crystal Reports.
-
Enable the ScrapingBee JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with ScrapingBee data.
-
Connect to IBM Informix Data in HULFT Integrate
Connect to IBM Informix as a JDBC data source in HULFT Integrate
-
Automate Acumatica Data Replication to SAP HANA
Use CData Sync to customize and automate Acumatica data replication to SAP HANA.
-
Visualize Microsoft Exchange Data in Sisense
Create an ElastiCube in Sisense app with access to Microsoft Exchange data.
-
Create Datasets from SAP Hybris C4C in Domo Workbench and Build Visualizations of SAP Hybris C4C Data in Domo
Use the CData Software ODBC Driver for SAP Hybris C4C to create datasets from SAP Hybris C4C data in Domo Workbench and then build visualizations in the Domo service.
-
Connect to MailChimp Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live MailChimp data.
-
Getting Started with the CData Tableau Connector for Google Search
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Google Search.
-
How to Connect Flowise AI Agents to Live Mailjet 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 Mailjet data without replication.
-
Import Mailjet Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Mailjet Data and provide access to live Mailjet data for custom reports in the Power BI Service.
-
A PostgreSQL Interface for Keap Data (MySQL Remoting via JDBC)
Use the Remoting features of the Keap JDBC Driver to create a PostgreSQL entry-point for data access.
-
Enable the LaunchDarkly JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with LaunchDarkly data.
-
Automated Continuous AdRoll Replication to Oracle
Use CData Sync for automated, continuous, customizable AdRoll replication to Oracle.
-
Automated Continuous ServiceDesk Plus Replication to MongoDB
Use CData Sync for automated, continuous, customizable ServiceDesk Plus replication to MongoDB.
-
Create Oracle SCM-Connected Dashboards in Grafana
Connect to Oracle SCM Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Oracle SCM data.
-
Connect Flowlu Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Flowlu data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Access Live Gmail Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Gmail data from your Excel spreadsheets.
-
Access Live MariaDB Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live MariaDB data from your Google Sheets.
-
How to Work with PhantomBuster Data in ETL Validator JDBC
Connect to PhantomBuster from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Adobe Commerce Replication to SQLite
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to SQLite.
-
Access Live Office 365 Data in Coginiti Pro
Connect to and query live Office 365 data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous Mixpanel Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Mixpanel replication to AlloyDB.
-
Klipfolio Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Klipfolio data through CData Connect AI using different applications and tools.
-
Build Visualizations of Sage Cloud Accounting Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Sage Cloud Accounting data in Birst.
-
Connect to Qualaroo Data in DBeaver
Use the CData ODBC Driver to connect to Qualaroo data in DBeaver.
-
Build Automated Workflows with Live Adobe Analytics Data in Workato
Use CData Connect AI to connect to live Adobe Analytics data and build automated workflows in Workato.
-
Build Pipelines with Live AlloyDB Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to AlloyDB from Google Cloud Data Fusion, enabling the integration of live AlloyDB data into the building and management of effective data pipelines.
-
Integrating Claude Code CLI with Float 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 Multiple Cosmos DB Accounts
Replicate multiple Cosmos DB accounts to one or many databases.
-
Analyze Box Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Box data with the CData JDBC Driver for Box.
-
Integrate Live Notion Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Notion from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Notion data.
-
Build a Simple VCL Application for Oracle Eloqua Data
How to build a simple VCL Application to view Oracle Eloqua data in RAD Studio using the CData ODBC Driver for Oracle Eloqua.
-
Automated Continuous GraphQL Replication to Databricks
Use CData Sync for automated, continuous, customizable GraphQL replication to Databricks.
-
Integrate Theia IDE with Live DocuSign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live DocuSign data from within the development environment.
-
How to Connect DBeaver to Splunk via a JDBC Driver
Manage Splunk data with visual tools in DBeaver like the query browser.
-
Automated Continuous ClickUp Replication to Databricks
Use CData Sync for automated, continuous, customizable ClickUp replication to Databricks.
-
Connect to Jira Assets Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Jira Assets and the SQL Gateway to access Jira Assets data from Google Apps Script.
-
How to Build an ETL App for Pipedrive Data in Python with CData Connect AI
Build ETL pipelines that read and write live Pipedrive data in Python with petl and the CData Connect AI Python SDK.
-
Query LDAP Objects using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume LDAP entities in PHP by modeling them as objects.
-
Connect to REST Data in Claris FileMaker Pro
Use the CData ODBC Driver for REST in FileMaker Pro to connect to REST and work with REST data in your FileMaker applications.
-
Integrate Live Instantly Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Instantly data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Access SAP Fieldglass Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SAP Fieldglass data from your Oracle system.
-
OneNote Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on OneNote facts in real time.
-
Visualize CloudConvert Data in Sisense
Create an ElastiCube in Sisense app with access to CloudConvert data.
-
Build a PostgreSQL Interface for ShipStation Data using the CData JDBC Driver
Use the Remoting features of the ShipStation JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate with Superchat Data in JReport Designer
Create charts and reports based on Superchat data in JReport Designer.
-
Create Data Visualizations in Cognos BI with Act CRM Data
Access Act CRM data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Access Hive Data Using Entity Framework
This article shows how to access Hive data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Analyze ActiveCampaign Data in Cognos Analytics
Use CData Connect AI to connect to ActiveCampaign Data from Cognos Analytics and analyze live ActiveCampaign data.
-
Automated Continuous Invoiced Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Invoiced replication to Amazon S3.
-
How to create an RPA flow for Datadog Data in UiPath Studio
Use the Datadog ODBC Driver to create workflows that access real-time Datadog data without any coding.
-
Build Voice Agents in ElevenLabs with access to Live SuiteCRM Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live SuiteCRM data.
-
Integrate Live Excel Online Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Excel Online from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Excel Online data.
-
Automated Continuous Facebook Ads Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Facebook Ads replication to Google Cloud SQL.
-
How to load Snapchat Ads data into Elasticsearch via Logstash
Introducing a simple method to load Snapchat Ads data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Vimeo Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Vimeo facts in real time.
-
Build AlloyDB-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for AlloyDB Data and create custom apps in Mendix.
-
Access Google Forms 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 Google Forms data.
-
Connect to WordPress Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for WordPress data.
-
Stream Sage Cloud Accounting Data into Apache Kafka Topics
Access and stream Sage Cloud Accounting data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous Access Replication to Databricks
Use CData Sync for automated, continuous, customizable Access replication to Databricks.
-
Automated Continuous Sage 300 Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Sage 300 replication to IBM DB2.
-
Integrate Theia IDE with Live SAP HANA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live SAP HANA data from within the development environment.
-
Create SSAS Tabular Models from Box Data
How to build a SQL Server Analysis Service Tabular Model from Box data using CData drivers.
-
Connecting GenSpark with Figshare Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Figshare data without any replication or custom integration required.
-
How to connect to Impala Data from IntelliJ
Integrate connectivity to Impala data with wizards in IntelliJ.
-
Automated Continuous SAP Hybris C4C Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to AlloyDB.
-
Query EnterpriseDB Data as a SQL Server Database in Node.js
Execute SQL Server queries against EnterpriseDB data from Node.js.
-
How to Connect to Live Suadeo 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 Suadeo data without replication.
-
Automated Continuous RabbitMQ Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable RabbitMQ replication to Apache Cassandra.
-
Query Google Drive Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Google Drive data from Node.js.
-
Integrating Antigravity CLI with Cloudant data via CData CLI
Connect Cloudant data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrate Dify with Live Reckon 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 Reckon data.
-
Integrating LangGraph with Presto Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Presto data within automated workflows.
-
Replicate Multiple Bugsnag Accounts
Replicate multiple Bugsnag accounts to one or many databases.
-
Natively Connect to Eventbrite Data in PHP
The CData ODBC driver for Eventbrite enables you to create PHP applications with connectivity to Eventbrite data. Leverage the native support for ODBC in PHP.
-
Connect to and Visualize Live HBase Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live HBase data.
-
Moving Data from BigQuery to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live BigQuery data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Stream JDBC-ODBC Bridge Data into Apache Kafka Topics
Access and stream JDBC-ODBC Bridge data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate Live SAP Fieldglass Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SAP Fieldglass from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SAP Fieldglass data.
-
Work with Jodoo Data in FoxPro
Load Jodoo data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Choosing the Best Method to Connect Sage 300 to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Sage 300 data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build MVC Applications with Connectivity to GitHub Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access GitHub from an ASP.NET MVC application.