CData Software - Knowledge Base
Recent Articles
-
Connect to Chargebee from a Connection Pool in WebLogic
Use the CData JDBC Driver for Chargebee to connect to Chargebee from Web applications running on WebLogic.
-
Use the CData SSIS Components to Insert New or Update Existing Acumatica Records from SQL Server
Easily push SQL Server data to Acumatica using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Acumatica or update existing records with data from a SQL Server database.
-
Connect to Cloudant Data from Crystal Reports
Use CData Connect AI to connect to and report on live IBM Cloudant from Crystal Reports.
-
Analyze Twitter Ads Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Twitter Ads and visualize Twitter Ads in SAP Analytics Cloud.
-
Establish a Live Connection with Close Data using Tableau Bridge
The CData ODBC Driver for Close enables you to integrate live Close into Tableau Cloud dashboards using the Tableau Bridge.
-
Rapidly Develop ZohoMarketingHub-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 ZohoMarketingHub.
-
Build a Simple VCL Application for MongoDB Data
How to build a simple VCL Application to view MongoDB in RAD Studio using the CData ODBC Driver for MongoDB.
-
Easily Integrate Confluence Data in Lazarus Pascal IDE
Learn how to easily integrate live Atlassian Confluence in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Access PabblySubscriptions Data from MySQL in Amazon QuickSight
Connect to PabblySubscriptions and build visualizations of PabblySubscriptions using a MySQL Connection in Amazon QuickSight.
-
Access Power BI XMLA 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 Power BI XMLA.
-
Publish Crystal Reports on iContact Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date iContact.
-
Working with Mailgun Data in LINQPad
Execute LINQ queries to Mailgun in LINQPad.
-
How to load Instantly data into Elasticsearch via Logstash
Introducing a simple method to load Instantly data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Access Live SAP Hybris C4C Data in Excel 365 Online (Excel for the web)
Connect to SAP Hybris C4C from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Migrating data from Microsoft OneDrive to Snowflake using CData SSIS Components.
Easily push Microsoft OneDrive to Snowflake using the CData SSIS Tasks for Microsoft OneDrive and Snowflake.
-
Automate Email Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Email and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
How to connect SharePoint with Dynamics 365 Data through external lists
Provide Microsoft Dynamics 365 to SharePoint users as an external list.
-
Automated Continuous NetSuite Replication to SQLite
Use CData Sync for automated, continuous, customizable NetSuite replication to SQLite.
-
Publish Reports with Aircall Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Aircall.
-
Automate PabblySubscriptions Data Replication to Couchbase
Use CData Sync to Customize and automate PabblySubscriptions replication to Couchbase.
-
Query Qualaroo Data in DataGrip
Create a Data Source for Qualaroo in DataGrip and use SQL to query live Qualaroo.
-
Use JayDeBeApi to access LionDesk Data in Python
Use standard Python scripting and the development environment of your choice to access live LionDesk.
-
Query Microsoft Ads Data as a MySQL Database in Node.js
Execute MySQL queries against Microsoft Ads from Node.js.
-
How to Seamlessly Import Printful Data into IBM SPSS Modeler
Integrate Printful data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Replicate Hubstaff Data in Heroku for Use in Salesforce Connect
Replicate Hubstaff to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Prepare, Blend, and Analyze Microsoft Planner Data in Alteryx Designer (ODBC)
Build workflows to access live Microsoft Planner for self-service data analytics.
-
How to load Mailjet data into Elasticsearch via Logstash
Introducing a simple method to load Mailjet data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Moving Data from Parquet to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Parquet data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Deploy the ADO.NET Provider for Cvent on an SSRS Report Server
Connect to Cvent from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Query Missive Data in DataGrip
Create a Data Source for Missive in DataGrip and use SQL to query live Missive.
-
How to Connect to Live Paylocity Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Paylocity securely in real time.
-
Build a PostgreSQL Interface for Microsoft Dataverse Data using the CData JDBC Driver
Use the Remoting features of the Microsoft Dataverse JDBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Zuora Data in Tableau
The CData ODBC driver for Zuora enables you integrate Zuora into Tableau dashboards.
-
Migrating data from BambooHR to Snowflake using CData SSIS Components.
Easily push BambooHR to Snowflake using the CData SSIS Tasks for BambooHR and Snowflake.
-
Access Clockify Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Clockify from your Oracle system.
-
Build MVC Applications with Connectivity to Slack Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Slack from an ASP.NET MVC application.
-
How to Design Redshift Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Redshift from mobile and tablet Power Apps.
-
Viewing ConvertAPI Data in RAD Studio Data Explorer
How to view ConvertAPI in RAD Studio Data Explorer using the CData ODBC Driver for ConvertAPI.
-
How to integrate Excel Online with Apache Airflow
Access and process Microsoft Excel Online in Apache Airflow using the CData JDBC Driver.
-
How to Build an ETL App for SAP Fieldglass Data in Python with CData Connect AI
Build ETL pipelines that read and write live SAP Fieldglass in Python with petl and the CData Connect AI Python SDK.
-
Build RSS-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for RSS to explore live RSS Feeds in Cursor to assist with building RSS-powered applications.
-
Build Charts with Toggl Data in Clear Analytics
Create dynamic charts and perform analytics based on Toggl in Clear Analytics.
-
Stream Mailgun Data into Apache Kafka Topics
Access and stream Mailgun in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connecting Mastra with Tally Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Tally ERP, no replication required.
-
Connect to and Visualize Live Productboard Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Productboard.
-
Query Monday.com Data as a SQL Server Database in Node.js
Execute SQL Server queries against Monday.com from Node.js.
-
Getting Started with the CData ODBC Driver for Databricks
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Databricks.
-
Validate Deel Data with QuerySurge
Access and validate Deel in QuerySurge using the CData JDBC Driver.
-
Manage Salesforce CRM Analytics Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Salesforce CRM Analytics.
-
Automated Continuous API Replication to Databricks
Use CData Sync for automated, continuous, customizable API replication to Databricks.
-
Access Live Neo4J Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Neo4J from your Excel spreadsheets.
-
Use Biml to Build SSIS Tasks to Replicate Workable Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Workable to SQL Server.
-
Build Workday-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Workday to explore live Workday Data in Gemini Code Assist to assist with building Workday-powered applications.
-
How to Connect the Power BI Service to Productboard: Complete Guide
Connect to the CData Software Power BI Connector for Productboard from PowerBI.com to provide real-time Productboard across the organization.
-
Automated Continuous PivotalTracker Replication to IBM DB2
Use CData Sync for automated, continuous, customizable PivotalTracker replication to IBM DB2.
-
Write a Simple Go Application to work with MySQL Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to MySQL.
-
Getting Started with the CData Connect AI Python SDK for Microsoft Entra ID
Install the CData Connect AI Python SDK to read and write live Microsoft Entra ID with standard DB-API 2.0 Python code.
-
Viewing Oracle HCM Cloud Data in RAD Studio Data Explorer
How to view Oracle HCM Cloud in RAD Studio Data Explorer using the CData ODBC Driver for Oracle HCM Cloud.
-
Use the CData ODBC Driver for Couchbase from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Couchbase to connect to Couchbase from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Couchbase in Excel.
-
Connect to Shopify from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Shopify, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to Gumroad Data from PowerBuilder via ADO.NET
This article demonstrates how to access Gumroad from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect to Live MariaDB Data in PostGresSQL Interface through CData Connect AI
Create a live connection to MariaDB in CData Connect AI and connect to your MariaDB from PostgreSQL.
-
How to Create Power BI Visual Reports with Real-Time Cvent Data
Use CData Power BI Connectors to visualize Cvent in Power BI.
-
Integrate with SQL Server Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Microsoft SQL Server in SnapLogic.
-
Build a Singer.io Tap for Omnisend With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Omnisend data using
-
Integrating Antigravity CLI with SAP Fieldglass via CData CLI
Connect SAP Fieldglass to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Create Informatica Mappings From/To an ODBC Data Source for Google Tasks
Create an ODBC connection to Google Tasks in Informatica and browse and transfer Google Tasks.
-
Visualize Clockify Data in Sisense
Create an ElastiCube in Sisense app with access to Clockify.
-
Connecting Mastra with Facebook Ads Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Facebook Ads, no replication required.
-
Connect to and Visualize Live LDAP Objects in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live LDAP.
-
How to Build an ETL App for eBay Data in Python with CData
Create ETL applications and real-time data pipelines for eBay in Python with petl.
-
How to Connect the Power BI Service to CSV: Complete Guide
Connect to the CData Software Power BI Connector for CSV from PowerBI.com to provide real-time CSV/TSV Files across the organization.
-
Connect to ClickTime Data in RapidMiner
Integrate ClickTime with standard components and data source configuration wizards in RapidMiner Studio.
-
Build Dashboards with Attio Data in Dundas BI
Create dynamic dashboards and perform analytics based on Attio in Dundas BI.
-
How to import SurveyMonkey Data into Apache Solr
Use the CData Software JDBC Driver for SurveyMonkey in Data Import Handler and create an automated import of SurveyMonkey to Apache Solr Enterprise Search platform.
-
Access Live Klipfolio Data in AWS Lambda
Connect to live Klipfolio in AWS Lambda using the CData JDBC Driver.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for JotForm
Provide connectivity to JotForm through an SAP BusinessObjects universe.
-
Automated Continuous Rebilly Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Rebilly replication to AlloyDB.
-
How to Connect the Power BI Service to Notion: Complete Guide
Connect to the CData Software Power BI Connector for Notion from PowerBI.com to provide real-time Notion across the organization.
-
Import and Visualize Retently Data in Power View
Create data visualizations based on Retently in Excel.
-
Getting Started with the CData SSIS Components for Freshteam
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Freshteam.
-
How to create Neo4J federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Neo4J in MySQL .
-
How to Connect to Live eBay Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your eBay through natural language.
-
Build AI/ML Models with Live Cassandra Data using Dataiku
Connect Cassandra Data with Dataiku using the CData JDBC Driver for Cassandra.
-
Access Live Workable Data in AWS Lambda
Connect to live Workable in AWS Lambda using the CData JDBC Driver.
-
Validate Google Tasks Data with QuerySurge
Access and validate Google Tasks in QuerySurge using the CData JDBC Driver.
-
BenchmarkEmail Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on BenchmarkEmail facts in real time.
-
Connect to Real-Time HubDB Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for HubDB and Dataflow to import and use HubDB in Power Apps.
-
Build Dashboards with Bitly Data in DBxtra
Create dynamic dashboards and perform analytics based on Bitly in DBxtra.
-
Automated Continuous Avaza Replication to MongoDB
Use CData Sync for automated, continuous, customizable Avaza replication to MongoDB.
-
Automated Continuous Drip Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Drip replication to AlloyDB.
-
Build AI/ML Models with Live Webflow Data using Dataiku
Connect Webflow Data with Dataiku using the CData API Driver for JDBC.
-
LINQ to Cassandra 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 Cassandra Data Provider.
-
A PostgreSQL Interface for AlloyDB Data using the CData ODBC Driver
Use the SQL Gateway and AlloyDB ODBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze Moosend Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Moosend from Power Pivot. You will use the Table Import Wizard to load Moosend. You can visually build the import query or use any SQL supported by the driver.
-
Create Dynamics 365 Business Central-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Dynamics 365 Business Central Data from Klipfolio and build custom visualizations using live Dynamics 365 Business Central.
-
Use Dash to Build Web Apps on Vertica Data via CData Connect AI
Build interactive Dash web apps on live Vertica using pandas and the CData Connect AI Python SDK.
-
Build MVC Applications with Connectivity to ChartMogul Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access ChartMogul from an ASP.NET MVC application.
-
Getting Started with the CData ODBC Driver for eBay
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for eBay.
-
Automated Continuous ClickTime Replication to SQL Server
Use CData Sync for automated, continuous, customizable ClickTime replication to SQL Server.