CData Software - Knowledge Base
Recent Articles
-
Automated Continuous LeadDesk Replication to SingleStore
Use CData Sync for automated, continuous, customizable LeadDesk replication to SingleStore.
-
How to Connect to Live Google Cloud Storage 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 Google Cloud Storage for you.
-
How to Query Live Act-On Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Act-On data in natural language using Python.
-
Query Tally Data as a MySQL Database in Node.js
Execute MySQL queries against Tally ERP from Node.js.
-
How to connect to FTP Data from Spring Boot
Connect to FTP in a Spring Boot Application using the CData JDBC Driver for FTP
-
Moving Data from RabbitMQ to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live RabbitMQ data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Getting Started with the CData JDBC Driver for Bright Data
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Bright Data.
-
Build Amazon Marketplace-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Amazon Marketplace Data and create custom apps in Mendix.
-
Getting Started with the CData Python Connector for Anaplan
Learn to install and license the CData Python Connector
-
Integrate Goose with Live Google Ad Manager Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Google Ad Manager from within the local AI agent.
-
Load Google Drive Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google Drive to a database.
-
Connect to Yelp Data in HULFT Integrate
Connect to Yelp as a JDBC data source in HULFT Integrate
-
Create Reports with Brex Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Brex.
-
Use Dash to Build to Web Apps on Paylocity Data
Create Python applications that use pandas and Dash to build Paylocity-connected web apps.
-
LINQ to SAP Business Warehouse 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 SAP Business Warehouse Data Provider.
-
How to Access Marketo Data Using Entity Framework
This article shows how to access Marketo using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Create Power BI Reports on Real-Time Microsoft Exchange Data
Use the CData ODBC Driver for Microsoft Exchange to visualize Microsoft Exchange in Power BI Desktop.
-
Replicate ZohoSubscriptions Data in Heroku for Use in Salesforce Connect
Replicate ZohoSubscriptions to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Publish Crystal Reports on Instagram Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Instagram.
-
Build PabblySubscriptions-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to PabblySubscriptions and build web apps with connectivity to live PabblySubscriptions.
-
How to Work with Salesforce CRM Analytics Data in AWS Glue Jobs Using JDBC
Connect to Salesforce CRM Analytics from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Configure the CData JDBC Driver for Access in a Connection Pool in Tomcat
Connect to Microsoft Access from a connection pool in Tomcat.
-
Integrate with live Redis Data in Jitterbit
Use CData Connect AI to connect to and integrate live Redis in Jitterbit.
-
Migrating data from Gong to Google BigQuery using CData SSIS Components.
Easily push Gong to Google BigQuery using the CData SSIS Tasks for Gong and Google BigQuery.
-
Prepare, Blend, and Analyze ActiveCampaign Data in Alteryx Designer (Connect AI)
Build workflows to access live ActiveCampaign for self-service data analytics.
-
DataBind Controls to Float Data in C++Builder
DataBind to Float in C++Builder with standard components and controls.
-
Build a Singer.io Tap for Parallel With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Parallel data using
-
Automated Continuous FHIR Replication to Amazon S3
Use CData Sync for automated, continuous, customizable FHIR replication to Amazon S3.
-
Connect to Sentry in SpagoBI
Create reports featuring live Sentry in SpagoBI Studio. Host Sentry reports on SpagoBI Server.
-
Getting Started with the CData Connect AI Python SDK for Google Analytics
Install the CData Connect AI Python SDK to read and write live Google Analytics with standard DB-API 2.0 Python code.
-
Integrating Dataiku with Exact Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Exact Online.
-
Work with Box Data in FoxPro
Load Box into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for CSV
Provide connectivity to CSV/TSV Files through an SAP BusinessObjects universe.
-
Automate Microsoft Exchange Data Replication to Couchbase
Use CData Sync to Customize and automate Microsoft Exchange replication to Couchbase.
-
Publish DB2-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live IBM DB2.
-
How to import Hugging Face Data into Apache Solr
Use the CData Software JDBC Driver for Hugging Face in Data Import Handler and create an automated import of Hugging Face to Apache Solr Enterprise Search platform.
-
Analyze Oracle Financials Cloud Data in Looker
Use CData Connect AI to connect to Oracle Financials Cloud Data from Looker and build custom apps using live Oracle Financials Cloud.
-
A PostgreSQL Interface for Pipeliner CRM Data using the CData ODBC Driver
Use the SQL Gateway and Pipeliner CRM ODBC Driver to create a PostgreSQL entry-point for data access.
-
Publish Reports with Billsby Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Billsby.
-
Use the CData API Server to Access Microsoft Ads Data in Microsoft PowerPivot
Use the CData API Server to connect to live Microsoft Ads in the Power Pivot business intelligence tool.
-
Replicate Multiple Oracle Accounts
Replicate multiple Oracle accounts to one or many databases.
-
Integrating GitHub Copilot CLI with AdRoll 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.
-
How to connect PolyBase to Hive
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Apache Hive.
-
Integrate Qualaroo with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Qualaroo with External Services.
-
Build AI Agents with Active Directory Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Active Directory through CData Connect AI.
-
DataBind Freshservice Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Freshservice to a chart.
-
Create Lakebase-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Lakebase Data from OutSystems and build custom enterprise apps using live Lakebase.
-
Integrate Live HCL Domino Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Aweber
Provide connectivity to Aweber through an SAP BusinessObjects universe.
-
Migrating data from Avalara AvaTax to Snowflake using CData SSIS Components.
Easily push Avalara AvaTax to Snowflake using the CData SSIS Tasks for Avalara AvaTax and Snowflake.
-
Write a Simple Go Application to work with Perplexity Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Perplexity.
-
Feed ScrapingBee Data into FineReport
How to set ScrapingBee as a JDBC data source in FineReport.
-
How to work with Azure Table Data in Apache Spark using SQL
Access and process Azure Table Data in Apache Spark using the CData Software JDBC Driver.
-
How to Import Data from QuickBooks Time into Google Sheets
Import QuickBooks Time into a Google spreadsheet that is automatically refreshed.
-
DataBind Controls to WordPress Data in C++Builder
DataBind to WordPress in C++Builder with standard components and controls.
-
Query LinkedIn Data as a SQL Server Database in Node.js
Execute SQL Server queries against LinkedIn from Node.js.
-
Connect to and Visualize Live Square Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Square.
-
Connect to eBay Analytics Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for eBay Analytics and the SQL Gateway to access eBay Analytics from Google Apps Script.
-
Easily Integrate Attio Data in Lazarus Pascal IDE
Learn how to easily integrate live Attio in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to integrate Auth0 with Apache Airflow
Access and process Auth0 in Apache Airflow using the CData JDBC Driver.
-
Connect to Quickbase Data in Aqua Data Studio
Access Quickbase from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Explore Geographical Relationships in WordPress Data with Power Map
Create data visualizations with WordPress in Power Map.
-
Automated Continuous SendGrid Replication to SQL Server
Use CData Sync for automated, continuous, customizable SendGrid replication to SQL Server.
-
Access Live REST Data in Coginiti Pro
Connect to and query live REST from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create Data Visualizations in Cognos BI with NASA Data
Access NASA as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrating Claude Code CLI with Superchat 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 Stripe Accounts via the CData Sync CLI
Replicate multiple Stripe accounts to one or many databases.
-
Query SAP HANA Data in DataGrip
Create a Data Source for SAP HANA in DataGrip and use SQL to query live SAP HANA.
-
Integrate Amazon S3 Data in the Pentaho Report Designer
Publish reports based on Amazon S3 in the Pentaho BI tool.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Clio
Provide connectivity to Clio through an SAP BusinessObjects universe.
-
Connect to Drip Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Drip as an External Source in Dremio.
-
Rapidly Develop RSS-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 RSS.
-
How to Seamlessly Import ShipStation Data into IBM SPSS Modeler
Integrate ShipStation data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate Cursor with Live Azure DevOps Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Azure DevOps from within the editor.
-
Connect to LinkedIn Data in DBArtisan
Use wizards in DBArtisan to configure LinkedIn as a data source.
-
Connect to Epicor Kinetic Data from Crystal Reports
Use CData Connect AI to connect to and report on live Epicor Kinetic from Crystal Reports.
-
Visualize Amazon S3 Data in TIBCO Spotfire through ADO.NET
Integrate Amazon S3 into dashboards in TIBCO Spotfire.
-
Replicate Eventbrite Data to Multiple Databases via the CData Sync CLI
Replicate Eventbrite to disparate databases with a single configuration.
-
How to connect and process Jira Assets from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Jira Assets.
-
Create Datasets from Strava in Domo Workbench and Build Visualizations of Strava Data in Domo
Use the CData Software ODBC Driver for Strava to create datasets from Strava in Domo Workbench and then build visualizations in the Domo service.
-
Connect Copper to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Copper using the CData Python MCP Server.
-
Connect to LeadDesk Data in Jaspersoft Studio
Execute SQL to remote LeadDesk in Jaspersoft Studio.
-
DataBind Copper Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Copper to a chart.
-
Integrate Exa with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Exa with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Exa.
-
How to Connect to Live eBay Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your eBay for you.
-
Publish Wistia-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Wistia.
-
Build Charts with Freshservice Data in Clear Analytics
Create dynamic charts and perform analytics based on Freshservice in Clear Analytics.
-
Working with FTP Data in LINQPad
Execute LINQ queries to FTP Servers in LINQPad.
-
Back Up Microsoft SharePoint to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SharePoint. In this article, we will employ an SSIS workflow to populate a database with Microsoft SharePoint data.
-
Connect to XML Data in DBeaver
Use the CData ODBC Driver to connect to XML Files in DBeaver.
-
Natively Connect to MongoDB Data in PHP
The CData ODBC driver for MongoDB enables you to create PHP applications with connectivity to MongoDB. Leverage the native support for ODBC in PHP.
-
Create Datasets from Oracle Financials Cloud in Domo Workbench and Build Visualizations of Oracle Financials Cloud Data in Domo
Use the CData Software ODBC Driver for Oracle Financials Cloud to create datasets from Oracle Financials Cloud in Domo Workbench and then build visualizations in the Domo service.
-
Integrate with Anaplan Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Anaplan to a JSON file on disk.
-
Build Dashboards with SpaceX Data in DBxtra
Create dynamic dashboards and perform analytics based on SpaceX in DBxtra.
-
Connecting Pipedream with Amazon S3 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 Amazon S3 data in real time.
-
Back Up Apache Avro to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Avro. In this article, we will employ an SSIS workflow to populate a database with Apache Avro data.
-
How to Work with SurveyMonkey Data in AWS Glue Jobs Using JDBC
Connect to SurveyMonkey from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Add PDFMonkey Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for PDFMonkey with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to create Oracle SCM federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Oracle SCM in MySQL .
-
Establish a Live Connection with Salesforce Data 360 Data using Tableau Bridge
The CData ODBC Driver for Salesforce Data 360 enables you to integrate live Salesforce Data 360 into Tableau Cloud dashboards using the Tableau Bridge.