CData Software - Knowledge Base
Recent Articles
-
Write a Simple Go Application to work with Power BI XMLA Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Power BI XMLA.
-
Create Outlook Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Outlook data access from reports, embedded analytics, and more.
-
Connect to MailerLite Data from a Connection Pool in JBoss
Integrate MailerLite into Java servlets: Use the Management Console in JBoss to install the MailerLite JDBC Driver.
-
How to Access Instantly Data Using Entity Framework
This article shows how to access Instantly using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrating OpenCode Terminal with TaxJar 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.
-
Build Pipelines with Live Dropbox Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Dropbox from Google Cloud Data Fusion, enabling the integration of live Dropbox into the building and management of effective data pipelines.
-
Automated Continuous Office 365 Replication to MongoDB
Use CData Sync for automated, continuous, customizable Office 365 replication to MongoDB.
-
How to publish and share Box Data dashboards with Tableau Server
The CData ODBC driver for Box enables you integrate Box into Tableau dashboards.
-
Manage Azure Synapse Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Azure Synapse.
-
Rapidly Develop Opsgenie-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 Opsgenie.
-
Automated Continuous Google Spanner Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Google Spanner replication to Apache Kafka.
-
Automated Continuous SageHR Replication to SQL Server
Use CData Sync for automated, continuous, customizable SageHR replication to SQL Server.
-
Connect to Basecamp Data in Ruby
Connect to Basecamp in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Consume Avro OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Avro feeds that reflect any changes in SAP Lumira.
-
Build Automated Tally-Connected Workflows in Zapier
Use CData Connect AI to connect to live Tally ERP and build automated workflows in Zapier.
-
Bridge Reckon Connectivity with Apache NiFi
Access and process Reckon in Apache NiFi using the CData JDBC Driver.
-
Access Live Mailgun Data in AWS Lambda
Connect to live Mailgun in AWS Lambda using the CData JDBC Driver.
-
How to Visualize SAS xpt Data in Python with pandas
Use pandas and other modules to analyze and visualize live SAS XPORT in Python.
-
Connect to Power BI XMLA Data in CloverDX (formerly CloverETL)
Transfer Power BI XMLA using the visual workflow in the CloverDX data integration tool.
-
Bidirectional Access to LeadDesk Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate LeadDesk in Filemaker Pro for Mac or Windows.
-
Create Data Visualizations Based On Twilio Data in Mode
Use CData Connect AI to connect to Twilio Data from Mode and build visualizations using live
-
Access Live Mocean Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Mocean in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use the CData Software JDBC Driver for RabbitMQ in MicroStrategy Web
Connect to RabbitMQ in MicroStrategy Web using the CData Software JDBC Driver for RabbitMQ.
-
Connect to Vault CRM Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Vault CRM and the SQL Gateway to access Veeva Vault & Vault CRM from Google Apps Script.
-
Migrating data from Acumatica to Databricks using CData SSIS Components.
Easily push Acumatica ERP to Databricks using the CData SSIS Tasks for Acumatica and Databricks.
-
Connect to Salesforce CRM Analytics Data in Aqua Data Studio
Access Salesforce CRM Analytics from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Query ClickUp Data in ColdFusion
Write standard ColdFusion data access code to connect to ClickUp.
-
Integrating Paymo Data in Talend Cloud Data Management Platform
Connect Paymo Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Create Amplitude Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Amplitude from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to connect to BigQuery Data from Spring Boot
Connect to BigQuery in a Spring Boot Application using the CData JDBC Driver for BigQuery
-
Use JayDeBeApi to access Tanda Data in Python
Use standard Python scripting and the development environment of your choice to access live Tanda.
-
Integrating OpenCode Terminal with Rootly 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 Planio Data in AWS Lambda
Connect to live Planio in AWS Lambda using the CData JDBC Driver.
-
Create Apps from Asana Data in Qlik Sense Cloud
Use CData Connect AI to connect to Asana Data and build apps from live Asana in Qlik Sense Cloud.
-
Build MVC Applications with Connectivity to Gmail Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Gmail from an ASP.NET MVC application.
-
Create MarkLogic-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to MarkLogic Data from OutSystems and build custom enterprise apps using live MarkLogic.
-
Create SSAS Tabular Models from YouTube Analytics Data
How to build a SQL Server Analysis Service Tabular Model from YouTube Analytics using CData drivers.
-
Automated Continuous HubSpot Replication to IBM DB2
Use CData Sync for automated, continuous, customizable HubSpot replication to IBM DB2.
-
How to create Visio diagrams from Microsoft Entra ID Data
Automatically update Microsoft Entra ID with the changes you make to Visio master shapes.
-
Connect to JotForm Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to Calendly Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Calendly and the SQL Gateway to access Calendly from Google Apps Script.
-
Write a Simple Go Application to work with Oracle Sales Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Oracle Sales.
-
DataBind Controls to XML Data in Delphi
DataBind to XML Files in Delphi with standard data access components and controls.
-
Integrate Live MailChimp Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live MailChimp to Blue Prism using the CData ODBC Driver for MailChimp to create automated workflows for repetitive business tasks.
-
How to publish and share Mocean Data dashboards with Tableau Server
The CData ODBC driver for Mocean enables you integrate Mocean into Tableau dashboards.
-
Process & Analyze Power BI XMLA Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Power BI XMLA Data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Google Analytics
Provide connectivity to Google Analytics through an SAP BusinessObjects universe.
-
How to Connect to & Open ChargeOver Data in Microsoft Excel
This article uses the CData ODBC driver for ChargeOver to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Use a Microsoft Access Database to Update Presto Data in Real Time
Update Presto data by creating a linked table in Microsoft Access with the CData Presto ODBC Driver.
-
Replicate Klipfolio Data to Multiple Databases
Replicate Klipfolio to disparate databases with a point-and-click configuration.
-
Connect and Visualize Live Acumatica Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Acumatica ERP into the Databricks platform and create visualization dashboards with real-time Acumatica ERP.
-
Automated Continuous AfterShip Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable AfterShip replication to Google BigQuery.
-
Deploy the ADO.NET Provider for Adobe Experience Manager on an SSRS Report Server
Connect to Adobe Experience Manager 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.
-
Integrate Live MailChimp Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Connect to Sybase Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Sybase.
-
Query BigCommerce Data as a MySQL Database in Node.js
Execute MySQL queries against BigCommerce from Node.js.
-
Integrate WooCommerce Data into Power Automate Desktop using CData Connect
CData Connect for WooCommerce Data enables you to integrate WooCommerce into workflows built using Microsoft Power Automate Desktop.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for FormSite
Provide connectivity to FormSite through an SAP BusinessObjects universe.
-
Use the CData Software ODBC Driver for Aweber in MicroStrategy Web
Connect to Aweber in MicroStrategy Web using the CData Software ODBC Driver for Aweber.
-
Visualize Sentry Data in TIBCO Spotfire through ADO.NET
Integrate Sentry into dashboards in TIBCO Spotfire.
-
Getting Started with the CData SSIS Components for QuickBooks Time
Complete guide to installing, licensing, and connecting with the CData SSIS Components for QuickBooks Time.
-
Build Dashboards with SuiteCRM Data in Dundas BI
Create dynamic dashboards and perform analytics based on SuiteCRM in Dundas BI.
-
Connect to Dynamics NAV Data in Aqua Data Studio
Access Microsoft Dynamics NAV from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Data Flows from Clari to SQL Server using SSIS
Easily back up Clari to SQL Server using the SSIS components for Clari.
-
Excel Spreadsheet Automation on AfterShip Data with the QUERY Formula
Pull data from AfterShip, automate spreadsheets, and more with the QUERY formula.
-
Choosing the Best Method to Connect MarkLogic to SQL Server: 5 Options Explained
Discover multiple ways to connect and use MarkLogic from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Edit and Search Shopify External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Shopify to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Shopify objects that you can access from apps and the dashboard.
-
Integrating Antigravity CLI with Suadeo via CData CLI
Connect Suadeo to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrating Codex CLI with JobNimbus 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 HelloSign Data from MySQL in Amazon QuickSight
Connect to HelloSign and build visualizations of HelloSign using a MySQL Connection in Amazon QuickSight.
-
Create Power BI Reports on Real-Time Clio Data
Use the CData ODBC Driver for Clio to visualize Clio in Power BI Desktop.
-
Connect to Retently Data in DBeaver
Use the CData ODBC Driver to connect to Retently in DBeaver.
-
Automated Continuous Campaigner Replication to SQL Server
Use CData Sync for automated, continuous, customizable Campaigner replication to SQL Server.
-
How to Connect to Live JSON Services 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 JSON for you.
-
Trigger Google Spanner IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Google Spanner with standard wizards in Logic Apps.
-
Build Semantic Layer Views for Snapchat Ads Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Snapchat Ads.
-
How to Connect to Live Microsoft Planner Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Microsoft Planner securely in real time.
-
Connect to Real-Time SendInBlue Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use SendInBlue in Power Apps.
-
Publish Campaigner-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Campaigner.
-
Connect to Landbot Data from a Connection Pool in JBoss
Integrate Landbot into Java servlets: Use the Management Console in JBoss to install the Landbot JDBC Driver.
-
How to Access Live ShipStation Data in Power Automate Desktop via ODBC
The CData ODBC Driver for ShipStation enables you to integrate ShipStation into workflows built using Microsoft Power Automate Desktop.
-
How to Seamlessly Import OData Data into IBM SPSS Modeler
Integrate OData data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Semantic Layer Views for LightSpeedRetail Data in APOS Live Data Gateway
Use the CData Connector for LightSpeedRetail in APOS Live Data Gateway to build Semantic Layer Views for LightSpeedRetail.
-
Visualize Live Stripe Data in the Power BI Service
Use CData Connect AI to connect to live Stripe and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Gmail Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Gmail and build visualizations in Tableau.
-
Viewing CockroachDB Data in RAD Studio Data Explorer
How to view CockroachDB in RAD Studio Data Explorer using the CData ODBC Driver for CockroachDB.
-
LINQ to ActiveCampaign 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 ActiveCampaign Data Provider.
-
Automated Continuous OneNote Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable OneNote replication to delimited files (CSV/TSV).
-
How to import CampaignMonitor Data into Apache Solr
Use the CData Software JDBC Driver for CampaignMonitor in Data Import Handler and create an automated import of CampaignMonitor to Apache Solr Enterprise Search platform.
-
Automate Basecamp Data Replication to SAP HANA
Use CData Sync to customize and automate Basecamp replication to SAP HANA.
-
Use the CData Software ODBC Driver for Act CRM in MicroStrategy
Connect to Act CRM in MicroStrategy Developer using the CData Software ODBC Driver for Act CRM.
-
Build Acumatica-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Acumatica Data and create custom apps in Mendix.
-
Build Zendesk-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Zendesk Data and create custom apps in Mendix.
-
Prepare, Blend, and Analyze Insightly Data in Alteryx Designer (ODBC)
Build workflows to access live Insightly for self-service data analytics.
-
Connect to Couchbase Data in Jaspersoft Studio
Execute SQL to remote Couchbase in Jaspersoft Studio.
-
Create LeadDesk Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time LeadDesk data access from reports, embedded analytics, and more.
-
Publish Reports with Toggl Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Toggl.
-
Connect to Teamwork Data from PowerBuilder via ADO.NET
This article demonstrates how to access Teamwork from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect to EnterpriseDB Data in JRuby
Create a simple JRuby app with access to live EnterpriseDB.
-
View Reports on Real-Time AfterShip Data in Power BI Report Server
Use the CData ODBC Driver for AfterShip to visualize AfterShip in Power BI Desktop and then publish them to Power BI Report Server.