CData Software - Knowledge Base
Recent Articles
-
Bridge Databricks Connectivity with Apache NiFi
Access and process Databricks in Apache NiFi using the CData JDBC Driver.
-
How to Connect the Power BI Service to Microsoft Exchange: Complete Guide
Connect to the CData Software Power BI Connector for Microsoft Exchange from PowerBI.com to provide real-time Microsoft Exchange across the organization.
-
How to Access Cosmos DB Data Using Entity Framework
This article shows how to access Azure Cosmos DB using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Migrating data from Mouseflow to Google BigQuery using CData SSIS Components.
Easily push Mouseflow to Google BigQuery using the CData SSIS Tasks for Mouseflow and Google BigQuery.
-
Automated Continuous Azure Data Lake Storage Replication to Databricks
Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to Databricks.
-
Publish Shippo-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Shippo.
-
Create Power BI Reports on Real-Time Nuclia Data
Use the CData ODBC Driver for Nuclia to visualize Nuclia in Power BI Desktop.
-
Connect to LightSpeedRetail Data as an External Source in Dremio
Use the CData JDBC Driver to connect to LightSpeedRetail as an External Source in Dremio.
-
How to load QuickBooks data into Elasticsearch via Logstash
Introducing a simple method to load QuickBooks data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate Live Xero Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Xero from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Xero Accounting.
-
Use Azure AI Foundry to Talk to Your Adobe Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Adobe Analytics for you.
-
Extract, Transform, and Load Flowlu Data in Informatica PowerCenter
Create a simple Workflow for Flowlu in Informatica PowerCenter.
-
Integrating Cursor CLI with Teradata 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.
-
Access Live Perplexity Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Perplexity in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrating Gumloop with SurveyMonkey Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on SurveyMonkey within automated workflows.
-
Create Datasets from SAP ByDesign in Domo Workbench and Build Visualizations of SAP ByDesign Data in Domo
Use the CData Software ODBC Driver for SAP ByDesign to create datasets from SAP Business ByDesign in Domo Workbench and then build visualizations in the Domo service.
-
Use the CData Software ODBC Driver for Azure DevOps in MicroStrategy Desktop
Connect to Azure DevOps in MicroStrategy Desktop using the CData Software ODBC Driver for Azure DevOps.
-
Prepare, Blend, and Analyze Dynamics 365 Data in Alteryx Designer (Connect AI)
Build workflows to access live Microsoft Dynamics 365 for self-service data analytics.
-
Import Real-Time MarkLogic Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use MarkLogic in ColdFusion.
-
Connect to Float Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Automate LDAP Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live LDAP and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Use the CData Software JDBC Driver for MailerSend in MicroStrategy Desktop
Connect to MailerSend in MicroStrategy Desktop using the CData Software JDBC Driver for MailerSend.
-
Query MongoDB Data in ColdFusion
Write standard ColdFusion data access code to connect to MongoDB.
-
Integrating Codex CLI with Amazon Redshift 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.
-
Migrating data from Quickbase to Snowflake using CData SSIS Components.
Easily push Quickbase to Snowflake using the CData SSIS Tasks for Quickbase and Snowflake.
-
How to connect to DB2 Data in DBVisualizer
Integrate IBM DB2 with visual data analysis tools and data connection wizards in DBVisualizer
-
A PostgreSQL Interface for Avaza Data (MySQL Remoting via JDBC)
Use the Remoting features of the Avaza JDBC Driver to create a PostgreSQL entry-point for data access.
-
Feed Amazon DynamoDB Data into FineReport
How to set Amazon DynamoDB as a JDBC data source in FineReport.
-
Edit and Search Microsoft Planner External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Microsoft Planner to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Microsoft Planner objects that you can access from apps and the dashboard.
-
Create Google Contacts-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Google Contacts Data from OutSystems and build custom enterprise apps using live Google Contacts.
-
Access Live Avalara AvaTax Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Avalara AvaTax from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Access Live Amazon S3 Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Amazon S3 from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
LINQ to HCL Domino 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 HCL Domino Data Provider.
-
Integrating Claude Code CLI with Instagram 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 Dynamics NAV-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Microsoft Dynamics NAV.
-
Query Yelp Data in DataGrip
Create a Data Source for Yelp in DataGrip and use SQL to query live Yelp.
-
Build Voice Agents in ElevenLabs with access to Live IBM Informix Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live IBM Informix.
-
Automated Continuous ClickUp Replication to Amazon S3
Use CData Sync for automated, continuous, customizable ClickUp replication to Amazon S3.
-
Automated Continuous Mode Replication to Snowflake
Use CData Sync for automated, continuous, customizable Mode replication to Snowflake.
-
DataBind Controls to Typeform Data in C++Builder
DataBind to Typeform in C++Builder with standard components and controls.
-
Connect to Apollo Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Apollo.
-
Access Live Google Drive Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Google Drive into the statistical analysis tools available in SAS JMP. This article shows how to use Google Drive in the Graph Builder and Query Builder.
-
Connect to Outlook Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Outlook and the SQL Gateway to access Outlook from Google Apps Script.
-
Excel Spreadsheet Automation on Elasticsearch Data with the QUERY Formula
Pull data from Elasticsearch, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous Elasticsearch Replication to SQL Server
Use CData Sync for automated, continuous, customizable Elasticsearch replication to SQL Server.
-
Visualize Act CRM Data in Sisense
Create an ElastiCube in Sisense app with access to Act CRM.
-
Connect to Hive Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Apache Hive using standard SQL.
-
Design BIRT Reports on Paylocity Data
Provide current Paylocity to your embedded analytics.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Perplexity
Provide connectivity to Perplexity through an SAP BusinessObjects universe.
-
Connect to Cassandra Data from PowerBuilder via JDBC
This article demonstrates how to access Apache Cassandra from PowerBuilder using the Cassandra JDBC Driver.
-
Automated Continuous MessageBird Replication to MongoDB
Use CData Sync for automated, continuous, customizable MessageBird replication to MongoDB.
-
Use JayDeBeApi to access GraphQL Data in Python
Use standard Python scripting and the development environment of your choice to access live GraphQL.
-
Integrating Claude Code CLI with FreeAgent 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 Google Spanner Data from a Connection Pool in JBoss
Integrate Google Spanner into Java servlets: Use the Management Console in JBoss to install the Google Spanner JDBC Driver.
-
Automated Continuous FreshBooks Replication to SingleStore
Use CData Sync for automated, continuous, customizable FreshBooks replication to SingleStore.
-
How to create Google Contacts federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Google Contacts in MySQL .
-
Connecting Moonlit Workflow with Azure Synapse 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 Azure Synapse in real time.
-
Automated Continuous REST Replication to Snowflake
Use CData Sync for automated, continuous, customizable REST replication to Snowflake.
-
Build Automated MarkLogic-Connected Workflows in Zapier
Use CData Connect AI to connect to live MarkLogic and build automated workflows in Zapier.
-
Use Dash to Build to Web Apps on Cassandra Data
Create Python applications that use pandas and Dash to build Cassandra-connected web apps.
-
Build a Singer.io Tap for GetResponse With the CData Python Connector
Learn how to easily build a Singer.io Tap for live GetResponse data using
-
Integrate Codat Data in the Pentaho Report Designer
Publish reports based on Codat in the Pentaho BI tool.
-
Deploy the ADO.NET Provider for Pingdom on an SSRS Report Server
Connect to Pingdom 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.
-
Connect to Box Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Box Data and connect to Box in Akorbi Digital RunMyProcess.
-
A PostgreSQL Interface for Chargebee Data using the CData ODBC Driver
Use the SQL Gateway and Chargebee ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build a PostgreSQL Interface for Toggl Data using the CData JDBC Driver
Use the Remoting features of the Toggl JDBC Driver to create a PostgreSQL entry-point for data access.
-
Process & Analyze Rootly Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Rootly Data.
-
Connect Couchbase Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Couchbase using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Operational Reporting on Oracle Eloqua Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Oracle Eloqua.
-
Access Live Dynamics 365 Business Central Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Dynamics 365 Business Central from your Google Sheets.
-
Easily Integrate Jira Data in Lazarus Pascal IDE
Learn how to easily integrate live Atlassian Jira in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Getting Started with the CData Power BI Connector for Elasticsearch
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Elasticsearch.
-
Automated Continuous Sendwithus Replication to MySQL
Use CData Sync for automated, continuous, customizable Sendwithus replication to MySQL.
-
Visualize Float Data in Tableau
The CData ODBC driver for Float enables you integrate Float into Tableau dashboards.
-
Integrate Freshsales Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Freshsales from Informatica Cloud.
-
Work with Samanage Data in FoxPro
Load Samanage into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous ZohoExpense Replication to SQLite
Use CData Sync for automated, continuous, customizable ZohoExpense replication to SQLite.
-
Automated Continuous Delighted Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Delighted replication to Apache Kafka.
-
Connect to Kafka Data in RapidMiner
Integrate Apache Kafka with standard components and data source configuration wizards in RapidMiner Studio.
-
Replicate Highrise Data to Multiple Databases
Replicate Highrise CRM to disparate databases with a point-and-click configuration.
-
Use the CData Software ODBC Driver for Bitbucket in MicroStrategy Web
Connect to Bitbucket in MicroStrategy Web using the CData Software ODBC Driver for Bitbucket.
-
Replicate Multiple Moosend Accounts
Replicate multiple Moosend accounts to one or many databases.
-
How to Build an ETL App for Adobe Analytics Data in Python with CData
Create ETL applications and real-time data pipelines for Adobe Analytics in Python with petl.
-
Publish Crystal Reports on CloudConvert Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date CloudConvert.
-
Connect to Smartsheet Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Smartsheet.
-
Connect to Calendly Data in DBArtisan
Use wizards in DBArtisan to configure Calendly as a data source.
-
How to integrate Metabase with FreshBooks Data
Use CData Connect AI to connect to live FreshBooks and create an interactive dashboard in Metabase from FreshBooks.
-
Import Asana Data Using Azure Data Factory
Use CData Connect AI to connect to Asana Data from Azure Data Factory and import live Asana.
-
Create Dynamic Zoho Books Grids Using the Infragistics XamDataGrid
Learn how you can connect Zoho Books to Infragistics XamDataGrid to build dynamic grids.
-
Build Dashboards with Stack Exchange Data in DBxtra
Create dynamic dashboards and perform analytics based on Stack Exchange in DBxtra.
-
How to Connect to Live Google Cloud Storage 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 Google Cloud Storage through natural language.
-
Replicate Oracle Service Cloud Data from PowerShell
Write a quick PowerShell script to query Oracle Service Cloud. Use connectivity to the live data to replicate Oracle Service Cloud to SQL Server.
-
How to Connect to Live NetSuite SuiteAnalytics Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live NetSuite SuiteAnalytics without replication.
-
How to Connect to Live Xero 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 Xero Accounting for you.
-
Write a Simple Go Application to work with Shippo Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Shippo.
-
Connect to Qualaroo Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Qualaroo to connect to Qualaroo and execute queries in PowerBuilder.
-
Stream Instagram Data into Apache Kafka Topics
Access and stream Instagram in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Easily Integrate Teamgate Data in Lazarus Pascal IDE
Learn how to easily integrate live Teamgate in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to QuickBooks Time Data from a Connection Pool in JBoss
Integrate QuickBooks Time into Java servlets: Use the Management Console in JBoss to install the QuickBooks Time JDBC Driver.
-
Connect to Live Cosmos DB Data in MicroStrategy through CData Connect AI
Create a live connection to Cosmos DB Data in CData Connect AI and connect to your Azure Cosmos DB from MicroStrategy.