CData Software - Knowledge Base
Recent Articles
-
How to load ServiceDesk Plus data into Elasticsearch via Logstash
Introducing a simple method to load ServiceDesk Plus data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Bind Live Active Directory Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Active Directory data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Connect to Parquet Data in NetBeans
Connect to Parquet data in NetBeans with the data source configuration wizard.
-
Create Informatica Mappings From/To a JDBC Data Source for Parquet
Create Parquet data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to connect PolyBase to Hubstaff
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Hubstaff data.
-
Use the CData ODBC Driver for Amazon Marketplace in Microsoft Power Query
You can use the CData Amazon Marketplace ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Amazon Marketplace data into Microsoft Power Query.
-
Replicate Hugging Face Data in Heroku for Use in Salesforce Connect
Replicate Hugging Face data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Natively Connect to Attio Data in PHP
The CData ODBC driver for Attio enables you to create PHP applications with connectivity to Attio data. Leverage the native support for ODBC in PHP.
-
Automate Landbot Data Replication to SAP HANA
Use CData Sync to customize and automate Landbot data replication to SAP HANA.
-
Stack Exchange Reporting in OBIEE with the Stack Exchange JDBC Driver
Deploy the Stack Exchange JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous CouchDB Replication to AlloyDB
Use CData Sync for automated, continuous, customizable CouchDB replication to AlloyDB.
-
DataBind Charts to Stack Exchange Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Stack Exchange data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Connect Teamgate Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Teamgate data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to update Freshdesk from Excel
This article explains how to transfer data from Excel to Freshdesk using the Excel Add-In for Freshdesk.
-
Build SAP Business Warehouse-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live SAP Business Warehouse data.
-
Connect to Excel Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Excel as an External Source in Dremio.
-
Query Google Drive Data in DataGrip
Create a Data Source for Google Drive in DataGrip and use SQL to query live Google Drive data.
-
How to Work with Egnyte Data in ETL Validator JDBC
Connect to Egnyte from ETL Validator jobs using the CData Software JDBC Driver.
-
How to connect and process ChartMogul data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live ChartMogul data.
-
Connect to Wrike Data in Jaspersoft Studio
Execute SQL to remote Wrike data in Jaspersoft Studio.
-
Integrating Kiro with SFTP 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.
-
Publish Crystal Reports on Snowflake Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Snowflake data.
-
Link Freshsales with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Freshsales data in Filemaker Pro for Mac or Windows.
-
Automated Continuous SharePoint Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable SharePoint replication to Amazon Redshift.
-
How to integrate Zoho Projects with Apache Airflow
Access and process Zoho Projects data in Apache Airflow using the CData JDBC Driver.
-
View Reports on Real-Time Excel Data in Power BI Report Server
Use the CData ODBC Driver for Excel to visualize Excel data in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Square Data from AWS Glue
Use CData Connect AI to gain access to live Square data from your AWS Glue jobs.
-
Choosing the Best Method to Connect iContact to SQL Server: 5 Options Explained
Discover multiple ways to connect and use iContact data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Validate Telegram Data with QuerySurge
Access and validate Telegram data in QuerySurge using the CData JDBC Driver.
-
Build AI/ML Models with Live Cloudflare Data using Dataiku
Connect Cloudflare Data with Dataiku using the CData API Driver for JDBC.
-
Use JayDeBeApi to access Pipeliner CRM Data in Python
Use standard Python scripting and the development environment of your choice to access live Pipeliner CRM data.
-
How to Connect DBeaver to Raisers Edge NXT via a JDBC Driver
Manage Raisers Edge NXT data with visual tools in DBeaver like the query browser.
-
Visualize Live Access Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Access data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating LlamaIndex with SAP Concur Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on SAP Concur data in real time.
-
Prepare, Blend, and Analyze Microsoft OneDrive Data in Alteryx Designer (ODBC)
Build workflows to access live Microsoft OneDrive data for self-service data analytics.
-
Build Kintone Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Kintone data and build visualizations in Tableau.
-
How to Work with Active Directory Data in AWS Glue Jobs Using JDBC
Connect to Active Directory from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Connect Flowise AI Agents to Live Couchbase 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 Couchbase data without replication.
-
Create AfterShip-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to AfterShip Data from OutSystems and build custom enterprise apps using live AfterShip data.
-
Create Datasets from Neo4J in Domo Workbench and Build Visualizations of Neo4J Data in Domo
Use the CData Software ODBC Driver for Neo4J to create datasets from Neo4J data in Domo Workbench and then build visualizations in the Domo service.
-
Visualize Pushbullet Data in Tableau
The CData ODBC driver for Pushbullet enables you integrate Pushbullet data into Tableau dashboards.
-
Integrating Kiro 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.
-
Connect to Avalara AvaTax Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Avalara AvaTax data using standard SQL.
-
Access Printful Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Printful data from HeidiSQL.
-
Integrating BenchmarkEmail Data in Talend Cloud Data Management Platform
Connect BenchmarkEmail Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Connect to Elorus Data in RapidMiner
Integrate Elorus data with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous Spotify Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Spotify replication to Apache Cassandra.
-
Getting Started with the CData Python Connector for Beeminder
Learn to install and license the CData Python Connector and configure a connection to live Beeminder data.
-
Create Microsoft Entra ID-Connected Business Apps in AppSheet
Connect to Microsoft Entra ID Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Microsoft Entra ID data.
-
Create Reports with JSON Services in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date JSON services.
-
Model, Search, and Visualize Live Avro Data in ThoughtSpot
Use CData Connect AI to connect to live Avro data for modeling, searching, and visualizing.
-
Natively Connect to Gumroad Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Gumroad data. Leverage the native support for ODBC in PHP.
-
How to Connect to & Open Flowlu Data in Microsoft Excel
This article uses the CData ODBC driver for Flowlu to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Migrating data from Pinecone to Databricks using CData SSIS Components.
Easily push Pinecone data to Databricks using the CData SSIS Tasks for Pinecone and Databricks.
-
Prepare, Blend, and Analyze ClickTime Data in Alteryx Designer (ODBC)
Build workflows to access live ClickTime data for self-service data analytics.
-
Integrating Antigravity CLI with Guru data via CData CLI
Connect Guru data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Getting Started with the CData ADO.NET Provider for Grafana
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
DataBind Controls to Productboard Data in C++Builder
DataBind to Productboard data in C++Builder with standard components and controls.
-
Integrating Antigravity CLI with Bitly data via CData CLI
Connect Bitly data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automated Continuous Planio Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Planio replication to PostgreSQL.
-
Connect Browserless to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Browserless data using the CData Python MCP Server.
-
Work with CircleCI Data in FoxPro
Load CircleCI data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrating Cursor with Hacker News 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.
-
Automated Continuous Bitbucket Replication to SQL Server
Use CData Sync for automated, continuous, customizable Bitbucket replication to SQL Server.
-
Use the CData SSIS Components to Insert New or Update Existing Google Directory Records from SQL Server
Easily push SQL Server data to Google Directory using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Google Directory or update existing records with data from a SQL Server database.
-
How to connect to Mistral AI Data with Squirrel SQL client
Connect to Mistral AI data and execute queries in the Squirrel SQL Client.
-
How to Connect to Procore Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Procore data. Leverage the pyodbc module for ODBC in Python.
-
Validate Microsoft Ads Data with QuerySurge
Access and validate Microsoft Ads data in QuerySurge using the CData JDBC Driver.
-
Connect to SageHR Data in Ruby
Connect to SageHR data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Easily Query AfterShip Data in OpenOffice Base
Connect to AfterShip data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Moving Data from Cloudant to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Cloudant data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Kafka Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Kafka data through CData Connect AI using different applications and tools.
-
Build Act-On-Connected Apps in Choreo
Use CData Connect AI to connect to Act-On Data from Choreo and build custom apps using live Act-On data.
-
Import Real-Time Harvest Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Harvest data in ColdFusion.
-
Extract, Transform, and Load Clockify Data in Informatica PowerCenter
Create a simple Workflow for Clockify data in Informatica PowerCenter.
-
Automated Continuous Epicor Kinetic Replication to Vertica
Use CData Sync for automated, continuous, customizable Epicor Kinetic replication to Vertica.
-
Connect Tanda to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Tanda data using the CData Python MCP Server.
-
Prepare, Blend, and Analyze CockroachDB Data in Alteryx Designer (ODBC)
Build workflows to access live CockroachDB data for self-service data analytics.
-
Visualize Snowflake Data in Tableau
The CData ODBC driver for Snowflake enables you integrate Snowflake data into Tableau dashboards.
-
Automated Continuous Typeform Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Typeform replication to Amazon S3.
-
Connect to SAP SuccessFactors Data in Ruby
Connect to SAP SuccessFactors data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to HubDB Data in CloverDX (formerly CloverETL)
Transfer HubDB data using the visual workflow in the CloverDX data integration tool.
-
Build Semantic Layer Views for Amazon Marketplace Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Amazon Marketplace data.
-
Visualize MySQL Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to MySQL data.
-
Import and Visualize Active Directory Data in Power View
Create data visualizations based on Active Directory data in Excel.
-
Build Apps with Live Pipedrive data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Pipedrive data into the Adalo platform and build custom mobile and web applications with real-time Pipedrive data.
-
Use the CData Software ODBC Driver for ZeroBounce in MicroStrategy
Connect to ZeroBounce data in MicroStrategy Developer using the CData Software ODBC Driver for ZeroBounce.
-
Automated Continuous Google Forms Replication to Databricks
Use CData Sync for automated, continuous, customizable Google Forms replication to Databricks.
-
Automated Continuous Amazon DynamoDB Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Amazon DynamoDB replication to Apache Kafka.
-
Integrating Cursor with Microsoft OneDrive 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.
-
Creating AgileCRM-Connected Applications in Unqork
You can use CData Connect AI to feed AgileCRM data to Unqork and build custom business apps.
-
Process & Analyze Sendwithus Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Sendwithus Data.
-
Connect to SparkPost Data from a Connection Pool in Jetty
The SparkPost JDBC Driver supports connection pooling: This article shows how to connect faster to SparkPost data from Web apps in Jetty.
-
Use the CData Software JDBC Driver for WooCommerce in MicroStrategy Desktop
Connect to WooCommerce data in MicroStrategy Desktop using the CData Software JDBC Driver for WooCommerce.
-
Integrate with MailChimp Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy MailChimp data to a JSON file on disk.
-
Analyze HubSpot Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of HubSpot data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Automated Continuous Zuora Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Zuora replication to Amazon S3.
-
Use the CData ODBC Driver for Cloudflare in Microsoft Power Query
You can use the CData Cloudflare ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Cloudflare data into Microsoft Power Query.
-
Use Manus AI to Talk to Your Google Cloud Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Google Cloud Storage data.
-
Automated Continuous Basecamp Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Basecamp replication to Google Cloud SQL.