CData Software - Knowledge Base
Recent Articles
-
Seamlessly Bring Amazon Marketplace Data into Retool Using CData Connect AI
Integrate Amazon Marketplace data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Automated Continuous Spark Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Spark replication to delimited files (CSV/TSV).
-
Bridge Clio Connectivity with Apache NiFi
Access and process Clio data in Apache NiFi using the CData JDBC Driver.
-
Query Live Epicor Kinetic 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 Epicor Kinetic data through a conversational interface.
-
Integrate Dify with Live NetSuite 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 NetSuite data.
-
Use the CData Software JDBC Driver for Kintone in MicroStrategy
Connect to Kintone data in MicroStrategy Developer using the CData Software JDBC Driver for Kintone.
-
Create Power BI Reports on Real-Time Productboard Data
Use the CData ODBC Driver for Productboard to visualize Productboard data in Power BI Desktop.
-
How to Build an ETL App for xBase Data in Python with CData
Create ETL applications and real-time data pipelines for xBase data in Python with petl.
-
Integrate Google's Antigravity Agent with Live Amazon S3 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Amazon S3 data using the Model Context Protocol.
-
Use the CData Software ODBC Driver for Templated in MicroStrategy Desktop
Connect to Templated data in MicroStrategy Desktop using the CData Software ODBC Driver for Templated.
-
Connect to HelloSign Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to HelloSign and work with HelloSign data in your FileMaker applications.
-
LINQ to Deel 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 Deel Data Provider.
-
Access Live Twitter Ads Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Twitter Ads data through MCP integration.
-
Create Reports from SAP Business One Data in Looker Studio
Use CData Connect AI to gain access to live SAP Business One data and create custom reports in Looker Studio.
-
Build a PostgreSQL Interface for ActiveCampaign Data using the CData JDBC Driver
Use the Remoting features of the ActiveCampaign JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous NetSuite Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable NetSuite replication to PostgreSQL.
-
Automated Continuous Oracle Service Cloud Replication to SQLite
Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to SQLite.
-
Getting Started with the CData ODBC Driver for Bitbucket
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Bitbucket.
-
Use Claude to Talk to Your iContact 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 iContact data for you.
-
Access JSON Services from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live JSON services from HeidiSQL.
-
Build Apps with Live MarkLogic Data Using the Low-Code Development Platform of Mendix
Connect MarkLogic data with Mendix to build apps using the CData JDBC Driver for MarkLogic.
-
Use Microsoft Copilot Studio to talk to your BambooHR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your BambooHR data for you.
-
Use the CData Software JDBC Driver for Google Search in MicroStrategy Desktop
Connect to Google Search results in MicroStrategy Desktop using the CData Software JDBC Driver for Google Search.
-
Create a Data Access Object for Sybase Data using JDBI
A brief overview of creating a SQL Object API for Sybase data in JDBI.
-
Replicate Productboard Data to Multiple Databases via the CData Sync CLI
Replicate Productboard data to disparate databases with a single configuration.
-
Automated Continuous MailerSend Replication to SQL Server
Use CData Sync for automated, continuous, customizable MailerSend replication to SQL Server.
-
Integrate Live Adobe Commerce Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Adobe Commerce data to Blue Prism using the CData ODBC Driver for Adobe Commerce to create automated workflows for repetitive business tasks.
-
Interact with Live Power BI XMLA Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Power BI XMLA data.
-
Automated Continuous VWO Replication to SQL Server
Use CData Sync for automated, continuous, customizable VWO replication to SQL Server.
-
Build Data Flows from Spark to SQL Server using SSIS
Easily back up Spark data to SQL Server using the SSIS components for Spark.
-
Easily Integrate PayPal Data in Lazarus Pascal IDE
Learn how to easily integrate live PayPal data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create SSAS Tabular Models from Optimizely Data
How to build a SQL Server Analysis Service Tabular Model from Optimizely data using CData drivers.
-
Connect to OpenWeatherMap Data as an External Source in Dremio
Use the CData JDBC Driver to connect to OpenWeatherMap as an External Source in Dremio.
-
Create Informatica Mappings From/To a JDBC Data Source for Aweber
Create Aweber data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrating Antigravity CLI with GitHub data via CData CLI
Connect GitHub data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to integrate AdRoll with Apache Airflow
Access and process AdRoll data in Apache Airflow using the CData JDBC Driver.
-
Automated Continuous Recurly Replication to SQL Server
Use CData Sync for automated, continuous, customizable Recurly replication to SQL Server.
-
Query Discord Data in ColdFusion
Write standard ColdFusion data access code to connect to Discord data.
-
Build Charts with Supabase Data in Clear Analytics
Create dynamic charts and perform analytics based on Supabase data in Clear Analytics.
-
Connect to Oracle HCM Cloud Data in Ruby
Connect to Oracle HCM Cloud data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Access HCL Domino Data Using Entity Framework
This article shows how to access HCL Domino data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to AgileCRM Data in Ruby
Connect to AgileCRM data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Connect DBeaver to LaunchDarkly via a JDBC Driver
Manage LaunchDarkly data with visual tools in DBeaver like the query browser.
-
Access Live TaxJar Data in AWS Lambda (with IntelliJ IDEA)
Connect to live TaxJar data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Bidirectional Access to Redshift Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Redshift data in Filemaker Pro for Mac or Windows.
-
Connect to SAP BusinessObjects BI Data from Crystal Reports
Use CData Connect AI to connect to and report on live SAP BusinessObjects BI data from Crystal Reports.
-
Replicate Wistia Data in Heroku for Use in Salesforce Connect
Replicate Wistia data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to ShipEngine Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with ShipEngine Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Integrate Xero Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Xero data from Informatica Cloud.
-
Visualize Live Outlook Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Outlook data.
-
Connecting Pipedream with Tally Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Tally data in real time.
-
Migrating data from Excel Online to Google BigQuery using CData SSIS Components.
Easily push Excel Online data to Google BigQuery using the CData SSIS Tasks for Excel Online and Google BigQuery.
-
Integrate Google Translate with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Google Translate with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Google Translate data.
-
ETL Scrapfly in Oracle Data Integrator
This article shows how to transfer Scrapfly data into a data warehouse using Oracle Data Integrator.
-
How to connect to Shortcut Data in DBVisualizer
Integrate Shortcut data with visual data analysis tools and data connection wizards in DBVisualizer
-
Use the CData Software ODBC Driver for Box in MicroStrategy Desktop
Connect to Box data in MicroStrategy Desktop using the CData Software ODBC Driver for Box.
-
Create Apps from Salesforce CRM Analytics Data in Qlik Sense Cloud
Use CData Connect AI to connect to Salesforce CRM Analytics Data and build apps from live Salesforce CRM Analytics data in Qlik Sense Cloud.
-
How to Connect to Live eBay Analytics Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your eBay Analytics data for you.
-
Automated Continuous Datadog Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Datadog replication to Amazon Redshift.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SAP Business One
Provide connectivity to SAP Business One data through an SAP BusinessObjects universe.
-
Connect to ZohoMarketingHub Data in ACL Analytics
Connect to ZohoMarketingHub data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to ZohoMarketingHub data.
-
How to work with PolarTeamPro Data in Apache Spark using SQL
Access and process PolarTeamPro Data in Apache Spark using the CData Software JDBC Driver.
-
Getting Started with the CData Excel Add-In for Pinecone
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Pinecone.
-
How to Connect Google Sheets 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 Google Sheets data in real time using natural language.
-
Connecting Moonlit Workflow with Twilio 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 Twilio data in real time.
-
Access Facebook 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 Facebook data.
-
Getting Started with the CData Tableau Connector for Landbot
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
How to Build an ETL App for Salesforce CRM Analytics Data in Python with CData
Create ETL applications and real-time data pipelines for Salesforce CRM Analytics data in Python with petl.
-
Create Data Visualizations Based On Confluence Data in Mode
Use CData Connect AI to connect to Confluence Data from Mode and build visualizations using live Confluence data.
-
Automate Shortcut Data Replication to Azure Data Lake
Use CData Sync to customize and automate Shortcut data replication to Azure Data Lake.
-
ZohoMarketingHub Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on ZohoMarketingHub facts in real time.
-
Connect to Opsgenie Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Opsgenie and the SQL Gateway to access Opsgenie data from Google Apps Script.
-
How to Easily Query Everhour Data in OpenOffice Base
Connect to Everhour data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to use SQLAlchemy ORM to access Jumpseller Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Jumpseller data.
-
Automated Continuous Shopify Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Shopify replication to PostgreSQL.
-
Access CampaignMonitor Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access CampaignMonitor data from your Oracle system.
-
Access Live Cvent Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Cvent data from your Excel spreadsheets.
-
Connect to Azure Data Lake Storage Data in HULFT Integrate
Connect to Azure Data Lake Storage as a JDBC data source in HULFT Integrate
-
Integrating LlamaIndex with Supabase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Supabase data in real time.
-
Design BIRT Reports on Acumatica Data
Provide current Acumatica data to your embedded analytics.
-
Build WordPress-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live WordPress data.
-
How to create Azure Synapse federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Azure Synapse data in MySQL .
-
A PostgreSQL Interface for Salesforce Pardot Data (MySQL Remoting via JDBC)
Use the Remoting features of the Salesforce Pardot JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Discord Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Discord replication to Apache Kafka.
-
Import SAP Business One Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to SAP Business One Data and provide access to live SAP Business One data for custom reports in the Power BI Service.
-
Build Dashboards with eBay Data in DBxtra
Create dynamic dashboards and perform analytics based on eBay data in DBxtra.
-
Integrate with live Procore Data in Jitterbit
Use CData Connect AI to connect to and integrate live Procore data in Jitterbit.
-
Automated Continuous Azure Synapse Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Azure Synapse replication to Amazon Redshift.
-
Visualize ZohoDesk Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to ZohoDesk data.
-
Create Data Visualizations in Cognos BI with Intercom Data
Access Intercom data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connecting Pipedream with Facebook Ads Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Facebook Ads data in real time.
-
Integrating LlamaIndex with Outreach.io Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Outreach.io data in real time.
-
Getting Started with the CData SSIS Components for Jodoo
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Jodoo.
-
Back Up Microsoft OneDrive data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Microsoft OneDrive. In this article, we will employ an SSIS workflow to populate a database with Microsoft OneDrive data data.
-
DataBind Controls to Instagram Data in Delphi
DataBind to Instagram data in Delphi with standard data access components and controls.
-
How to work with Bannerbear Data in Apache Spark using SQL
Access and process Bannerbear Data in Apache Spark using the CData Software JDBC Driver.
-
Build Semantic Layer Views for iContact Data in APOS Live Data Gateway
Use the CData Connector for iContact in APOS Live Data Gateway to build Semantic Layer Views for iContact data.
-
Design BIRT Reports on Amazon S3 Data
Provide current Amazon S3 data to your embedded analytics.
-
Connect to Dropbox Data in JRuby
Create a simple JRuby app with access to live Dropbox data.
-
Connect to Shippo Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Shippo to connect to Shippo data and execute queries in PowerBuilder.