CData Software - Knowledge Base
Recent Articles
-
How to import WordPress Data into Apache Solr
Use the CData Software JDBC Driver for WordPress in Data Import Handler and create an automated import of WordPress to Apache Solr Enterprise Search platform.
-
Migrating data from Rebilly to Snowflake using CData SSIS Components.
Easily push Rebilly to Snowflake using the CData SSIS Tasks for Rebilly and Snowflake.
-
Build a Singer.io Tap for Smartsheet With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Smartsheet data using
-
Edit and Search External SendGrid Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of SendGrid to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SendGrid Data objects that you can access from apps and the dashboard.
-
Automated Continuous SuiteCRM Replication to Snowflake
Use CData Sync for automated, continuous, customizable SuiteCRM replication to Snowflake.
-
Access Typeform 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 Typeform.
-
How to Connect to Live SharePoint Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Microsoft SharePoint for you.
-
Getting Started with the CData Power BI Connector for CouchDB
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for CouchDB.
-
Connect to Cosmos DB Data in HULFT Integrate
Connect to Cosmos DB as a JDBC data source in HULFT Integrate
-
Build Dashboards with Office 365 Data in Dundas BI
Create dynamic dashboards and perform analytics based on Microsoft Office 365 in Dundas BI.
-
Integrating Antigravity CLI with Tavily via CData CLI
Connect Tavily to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to create an RPA flow for SQL Analysis Services Data in UiPath Studio
Use the SQL Analysis Services ODBC Driver to create workflows that access real-time SQL Analysis Services without any coding.
-
Migrating data from Browserless to Google BigQuery using CData SSIS Components.
Easily push Browserless to Google BigQuery using the CData SSIS Tasks for Browserless and Google BigQuery.
-
Integrating Cursor CLI with Azure Synapse 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.
-
How to connect PolyBase to Landbot
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Landbot.
-
Operational Reporting on Timely Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Timely.
-
Access Live Reckon Data in AWS Lambda
Connect to live Reckon in AWS Lambda using the CData JDBC Driver.
-
Create Informatica Mappings From/To a JDBC Data Source for Egnyte
Create Egnyte data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Bind Live Lakebase Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Lakebase data
-
Import and Visualize Bugsnag Data in Power View
Create data visualizations based on Bugsnag in Excel.
-
Integrating Cassandra Data in Talend Cloud Data Management Platform
Connect Cassandra Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Cassandra.
-
Connect to Tanda Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Tanda.
-
Connect to SAS Data Sets Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live SAS Data Sets.
-
Connect to Nethunt Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Nethunt using standard SQL.
-
Connect to CSV 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 CSV/TSV Files.
-
Integrate with ActiveCampaign Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ActiveCampaign to a JSON file on disk.
-
Getting Started with the CData Power BI Connector for Google Analytics
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Google Analytics.
-
Publish Crystal Reports on Helpscout Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Helpscout.
-
Query Live BigCommerce Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live BigCommerce directly from the development environment.
-
Query Webex Data in DataGrip
Create a Data Source for Webex in DataGrip and use SQL to query live Webex.
-
Build MVC Applications with Connectivity to HBase Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access HBase from an ASP.NET MVC application.
-
Integrate Live HCL Domino Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live HCL Domino to Blue Prism using the CData ODBC Driver for HCL Domino to create automated workflows for repetitive business tasks.
-
Integrating LangChain with PostgreSQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on PostgreSQL within automated workflows.
-
Replicate Billsby Data to Multiple Databases via the CData Sync CLI
Replicate Billsby to disparate databases with a single configuration.
-
Use the CData ODBC Driver for RSS in Microsoft Power Query
You can use the CData RSS ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import RSS Feeds into Microsoft Power Query.
-
How to Visualize SendGrid Data in Python with pandas
Use pandas and other modules to analyze and visualize live SendGrid in Python.
-
Getting Started with the CData ODBC Driver for FreshBooks
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for FreshBooks.
-
Connect to PivotalTracker Data from a Connection Pool in Jetty
The PivotalTracker JDBC Driver supports connection pooling: This article shows how to connect faster to PivotalTracker from Web apps in Jetty.
-
Analyze ZendeskSell Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for ZendeskSell from Power Pivot. You will use the Table Import Wizard to load ZendeskSell. You can visually build the import query or use any SQL supported by the driver.
-
Build a Singer.io Tap for HelloSign With the CData Python Connector
Learn how to easily build a Singer.io Tap for live HelloSign data using
-
Query, Visualize, and Share live Excel Online Data in Redash
Use CData Connect AI to connect to live Microsoft Excel Online in Redash for querying, visualizing, and sharing.
-
ETL Teamwork in Oracle Data Integrator
This article shows how to transfer Teamwork into a data warehouse using Oracle Data Integrator.
-
Model MYOB AccountRight Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and MYOB AccountRight, enabling the direct import of real-time MYOB AccountRight.
-
How to Query Mixpanel Data in MySQL Workbench
Execute MySQL queries against live Mixpanel from MySQL Workbench.
-
Create Informatica Mappings From/To a JDBC Data Source for Act CRM
Create Act CRM data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Rapidly Develop Harvest-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 Harvest.
-
Access Live Power BI XMLA Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Power BI XMLA from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Automated Continuous Yelp Replication to SQLite
Use CData Sync for automated, continuous, customizable Yelp replication to SQLite.
-
How to Connect CouchDB Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live CouchDB data in real time using natural language.
-
Perform Batch Operations with SQL Server Data in Apache NiFi
Connect to Microsoft SQL Server and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Work with Azure Table Data in FoxPro
Load Azure Table Storage into a FoxPro database. This article includes full code and a walk-through of the process.
-
Viewing Salesforce Data 360 Data in RAD Studio Data Explorer
How to view Salesforce Data 360 in RAD Studio Data Explorer using the CData ODBC Driver for Salesforce Data 360.
-
How to Easily Query Bitly Data in OpenOffice Base
Connect to Bitly data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SAP HANA
Provide connectivity to SAP HANA through an SAP BusinessObjects universe.
-
Access Live OneNote Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Microsoft OneNote through MCP integration.
-
Connect to Discourse Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Discourse as an External Source in Dremio.
-
Create Data Visualizations in Cognos BI with Jira Assets Data
Access Jira Assets as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Publish Klaviyo-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Klaviyo.
-
Connect to QuickBooks Online Data in Ruby
Connect to QuickBooks Online in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Access Live Reckon Data in TIBCO Data Virtualization
Use the Reckon Tibco DV Adapter to create a Reckon data source in TIBCO Data Virtualization Studio and gain access to live Reckon from your TDV Server.
-
Work with Live Dropbox Data in Power Query
Use CData Connect AI to connect to Dropbox and work with live Dropbox in Microsoft Power Query.
-
Integrate with Miro Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Miro to a JSON file on disk.
-
Integrating Codex CLI with Snowflake 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 Access Live Tally Data in Visual Studio Code via Cline
Run CData MCP Server for Tally on Windows Subsytem for Linux (WSL) and connect to live Tally ERP from the Cline extension in Visual Studio Code.
-
Explore Geographical Relationships in Highrise Data with Power Map
Create data visualizations with Highrise CRM in Power Map.
-
Analyze Facebook Ads Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Facebook Ads and visualize live Facebook Ads in Infragistics Reveal.
-
Use the CData Software JDBC Driver for EmailOctopus in MicroStrategy Web
Connect to EmailOctopus in MicroStrategy Web using the CData Software JDBC Driver for EmailOctopus.
-
Use ChatGPT to Talk to Your Trello Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Trello for you.
-
DataBind Controls to SparkPost Data in C++Builder
DataBind to SparkPost in C++Builder with standard components and controls.
-
Connect to Azure Data Lake Storage Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Azure Data Lake Storage.
-
Publish Crystal Reports on Klipfolio Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Klipfolio.
-
Google Analytics GA4: Default Date Filters
CData Drivers & Connectors for Google Analytics (GA4) now include support for default date filters for certain views.
-
Access Live ShipStation Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live ShipStation data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Connect to HDFS Data as an External Source in Dremio
Use the CData JDBC Driver to connect to HDFS as an External Source in Dremio.
-
How to Visualize Tally Data in Python with pandas
Use pandas and other modules to analyze and visualize live Tally ERP in Python.
-
Visualize Zoho CRM Data in TIBCO Spotfire through ADO.NET
Integrate Zoho CRM into dashboards in TIBCO Spotfire.
-
Use the CData Software JDBC Driver for HDFS in MicroStrategy Desktop
Connect to Apache HDFS in MicroStrategy Desktop using the CData Software JDBC Driver for HDFS.
-
Integrate with Salesforce CRM Analytics Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Salesforce CRM Analytics to a JSON file on disk.
-
Use JayDeBeApi to access Todoist Data in Python
Use standard Python scripting and the development environment of your choice to access live Todoist.
-
Visualize Live IBM Informix Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live IBM Informix into custom reports in Power BI.
-
Viewing Anaplan Data in RAD Studio Data Explorer
How to view Anaplan in RAD Studio Data Explorer using the CData ODBC Driver for Anaplan.
-
Configure the CData JDBC Driver for Apollo in a Connection Pool in Tomcat
Connect to Apollo from a connection pool in Tomcat.
-
Build Dashboards with PagerDuty Data in Dundas BI
Create dynamic dashboards and perform analytics based on PagerDuty in Dundas BI.
-
Integrating Kiro CLI with AfterShip 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 Box-Connected Applications in Unqork
You can use CData Connect AI to feed Box to Unqork and build custom business apps.
-
Integrating Cursor CLI with ChartMogul 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.
-
Integrate Live Zoho CRM Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Integrate Azure DevOps Data in Pentaho Data Integration
Build ETL pipelines based on Azure DevOps in the Pentaho Data Integration tool.
-
Connect to Apify in SpagoBI
Create reports featuring live Apify in SpagoBI Studio. Host Apify reports on SpagoBI Server.
-
Analyze BigCommerce Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze BigCommerce with the CData JDBC Driver for BigCommerce.
-
Automated Continuous Klipfolio Replication to Databricks
Use CData Sync for automated, continuous, customizable Klipfolio replication to Databricks.
-
Choosing the Best Method to Connect BambooHR to SQL Server: 5 Options Explained
Discover multiple ways to connect and use BambooHR from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Office 365 Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Microsoft Office 365 using standard SQL.
-
Connect to Qualaroo Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Qualaroo and work with Qualaroo in your FileMaker application.
-
Connect to Sage Intacct Data in CloverDX (formerly CloverETL)
Transfer Sage Intacct using the visual workflow in the CloverDX data integration tool.
-
Build Charts with Superchat Data in Clear Analytics
Create dynamic charts and perform analytics based on Superchat in Clear Analytics.
-
Build Okta Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Okta and build visualizations in Tableau.
-
Connect to Onfleet Data from a Connection Pool in JBoss
Integrate Onfleet into Java servlets: Use the Management Console in JBoss to install the Onfleet JDBC Driver.
-
Access Live Shopify Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Shopify into the statistical analysis tools available in SAS JMP. This article shows how to use Shopify in the Graph Builder and Query Builder.
-
Automate ShipEngine Integration Tasks from PowerShell
Are you in search of a quick and easy way to access ShipEngine from PowerShell? This article demonstrates how to utilize the ShipEngine Cmdlets for tasks like connecting to ShipEngine, automating operations, downloading data, and more.