CData Software - Knowledge Base
Recent Articles
-
Build a Singer.io Tap for Apollo With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Apollo data using
-
Access Acumatica Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Acumatica ERP from your Oracle system.
-
Integrate with live Epicor Kinetic Data in Jitterbit
Use CData Connect AI to connect to and integrate live Epicor Kinetic in Jitterbit.
-
Connect to FreshBooks Data in JRuby
Create a simple JRuby app with access to live FreshBooks.
-
Create Drip Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Drip from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Design Sage Cloud Accounting Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Sage Cloud Accounting from mobile and tablet Power Apps.
-
View Reports on Real-Time Tanda Data in Power BI Report Server
Use the CData ODBC Driver for Tanda to visualize Tanda in Power BI Desktop and then publish them to Power BI Report Server.
-
Analyze Sage Intacct Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Sage Intacct and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Feed Stripe Data into FineReport
How to set Stripe as a JDBC data source in FineReport.
-
Connect to ActiveCampaign Data from PowerBuilder via ADO.NET
This article demonstrates how to access ActiveCampaign from Appeon PowerBuilder using the CData ADO.NET Provider for ActiveCampaign.
-
Build a Singer.io Tap for PabblySubscriptions With the CData Python Connector
Learn how to easily build a Singer.io Tap for live PabblySubscriptions data using
-
How to connect to Pinecone Data with Squirrel SQL client
Connect to Pinecone and execute queries in the Squirrel SQL Client.
-
How to Query Live Azure Table Data in Perplexity MacOS Desktop
Connect to and query live Azure Table Data in Perplexity Desktop using CData MCP Server.
-
Manage Blackbaud FE NXT Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Blackbaud FE NXT.
-
How to Create Power BI Visual Reports with Real-Time BambooHR Data
Use CData Power BI Connectors to visualize BambooHR in Power BI.
-
Use the CData Software JDBC Driver for Zoho Inventory in MicroStrategy
Connect to Zoho Inventory in MicroStrategy Developer using the CData Software JDBC Driver for Zoho Inventory.
-
Query Dropbox Data as a SQL Server Database in Node.js
Execute SQL Server queries against Dropbox from Node.js.
-
Connect to Redshift Data from PowerBuilder via ADO.NET
This article demonstrates how to access Amazon Redshift from Appeon PowerBuilder using the CData ADO.NET Provider for Redshift.
-
Access Front Data from MySQL in PHP
Connect to Front through the standard MySQL libraries in PHP.
-
Use the CData Software JDBC Driver for Sage Cloud Accounting in MicroStrategy Web
Connect to Sage Business Cloud Accounting in MicroStrategy Web using the CData Software JDBC Driver for Sage Cloud Accounting.
-
Build Semantic Layer Views for RSS Feeds in APOS Live Data Gateway
Use the CData Connector for RSS in APOS Live Data Gateway to build Semantic Layer Views for RSS Feeds.
-
Integrating Antigravity CLI with Bugsnag via CData CLI
Connect Bugsnag to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Use Azure AI Foundry to Talk to Your Monday.com 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 Monday.com for you.
-
Import SAP Fieldglass Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to SAP Fieldglass Data and provide access to live SAP Fieldglass for custom reports in the Power BI Service.
-
Integrate with Clockify Data in JReport Designer
Create charts and reports based on Clockify in JReport Designer.
-
Publish Reports with Bannerbear Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Bannerbear.
-
Automated Continuous ZarMoney Replication to IBM DB2
Use CData Sync for automated, continuous, customizable ZarMoney replication to IBM DB2.
-
Connect to Live Redis Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Redis in CData Connect AI and connect to your Redis from PostgreSQL.
-
Access Live Parquet Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Parquet data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Feed Nuclia Data into FineReport
How to set Nuclia as a JDBC data source in FineReport.
-
Integrate Open WebUI with Live MySQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live MySQL from within the chat interface.
-
How to connect to Amazon DynamoDB Data in DBVisualizer
Integrate Amazon DynamoDB with visual data analysis tools and data connection wizards in DBVisualizer
-
Use Manus AI to Talk to Your Greenhouse 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 Greenhouse.
-
Natively Connect to Google Spanner Data in PHP
The CData ODBC driver for Google Spanner enables you to create PHP applications with connectivity to Google Spanner. Leverage the native support for ODBC in PHP.
-
Configure the CData JDBC Driver for Billsby in a Connection Pool in Tomcat
Connect to Billsby from a connection pool in Tomcat.
-
Import Certinia Data Using Azure Data Factory
Use CData Connect AI to connect to Certinia Data from Azure Data Factory and import live Certinia.
-
Build Data Flows from Mode to SQL Server using SSIS
Easily back up Mode to SQL Server using the SSIS components for Mode.
-
Query Live Google Ad Manager 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 Google Ad Manager directly from the development environment.
-
Use the CData Software ODBC Driver for HCL Domino in SAS for Real-Time Reporting and Analytics
Connect to real-time HCL Domino in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for HCL Domino.
-
Publish SAP HANA-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SAP HANA.
-
How to connect PolyBase to Mouseflow
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Mouseflow.
-
Migrating data from Lakebase to Databricks using CData SSIS Components.
Easily push Lakebase to Databricks using the CData SSIS Tasks for Lakebase and Databricks.
-
Integrating OpenCode Terminal with Nuclia 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.
-
Create Facebook Ads-Connected Business Apps in AppSheet
Connect to Facebook Ads Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Facebook Ads.
-
How to Work with Authorize.Net Data in ETL Validator JDBC
Connect to Authorize.Net from ETL Validator jobs using the CData Software JDBC Driver.
-
Getting Started with the CData Excel Add-In for Postmark
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Postmark.
-
Choosing the Best Method to Connect FHIR to SQL Server: 5 Options Explained
Discover multiple ways to connect and use FHIR from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Create eBay Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time eBay data access from reports, embedded analytics, and more.
-
Integrate Cline with Live Trello Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Trello from within your IDE.
-
How to Query Live Okta Data in Claude Desktop
Connect to and query live Okta Data in Claude Desktop using CData MCP Server.
-
Connect to Splunk Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Splunk from Filemaker Pro on Mac.
-
Use the CData Software JDBC Driver for Typeform in MicroStrategy Web
Connect to Typeform in MicroStrategy Web using the CData Software JDBC Driver for Typeform.
-
Getting Started with the CData ADO.NET Provider for MessageBird
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Use the CData Software ODBC Driver for PagerDuty in MicroStrategy Web
Connect to PagerDuty in MicroStrategy Web using the CData Software ODBC Driver for PagerDuty.
-
Analyze Certinia Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Certinia from Power Pivot. You will use the Table Import Wizard to load Certinia. You can visually build the import query or use any SQL supported by the driver.
-
How to Access Live Todoist Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Todoist enables you to integrate Todoist into workflows built using Microsoft Power Automate Desktop.
-
Create Datasets from Hugging Face in Domo Workbench and Build Visualizations of Hugging Face Data in Domo
Use the CData Software ODBC Driver for Hugging Face to create datasets from Hugging Face in Domo Workbench and then build visualizations in the Domo service.
-
Provide OData Services of Mixpanel Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Mixpanel by developing a WCF Service Application.
-
Integrating Antigravity CLI with Sybase via CData CLI
Connect Sybase to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
LINQ to PayPal 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 PayPal Data Provider.
-
Choosing the Best Method to Connect Freshdesk to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Freshdesk from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to publish and share Zoho CRM Data dashboards with Tableau Server
The CData ODBC driver for Zoho CRM enables you integrate Zoho CRM into Tableau dashboards.
-
Analyze HubDB Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of HubDB and visualize live HubDB in Infragistics Reveal.
-
Integrating Codex CLI with VWO 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 Hugging Face Data in the Pentaho Report Designer
Publish reports based on Hugging Face in the Pentaho BI tool.
-
Validate Moosend Data with QuerySurge
Access and validate Moosend in QuerySurge using the CData JDBC Driver.
-
Access Live MailChimp 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 MailChimp through MCP integration.
-
Connect to CircleCI Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to CircleCI and work with CircleCI in your FileMaker applications.
-
Connect and Visualize Live Act-On Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Act-On into the Databricks platform and create visualization dashboards with real-time Act-On.
-
Automated Continuous Kafka Replication to MongoDB
Use CData Sync for automated, continuous, customizable Kafka replication to MongoDB.
-
Connect to Moosend Data in DBArtisan
Use wizards in DBArtisan to configure Moosend as a data source.
-
Getting Started with the CData ADO.NET Provider for Superchat
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Automate OneNote Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Microsoft OneNote from PowerShell? This article demonstrates how to utilize the OneNote Cmdlets for tasks like connecting to Microsoft OneNote, automating operations, downloading data, and more.
-
DataBind Greenplum Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Greenplum with the DevExpress Windows Forms and Web controls to provide Pivotal GreenPlum to a chart.
-
Access Brex Data from MySQL in Amazon QuickSight
Connect to Brex and build visualizations of Brex using a MySQL Connection in Amazon QuickSight.
-
Access CockroachDB 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 CockroachDB.
-
Bridge Excel Online Connectivity with Apache NiFi
Access and process Microsoft Excel Online in Apache NiFi using the CData JDBC Driver.
-
Create Informatica Mappings From/To an ODBC Data Source for Google Ads
Create an ODBC connection to Google Ads in Informatica and browse and transfer Google Ads.
-
How to Connect JSON Services to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live JSON data in real time using natural language.
-
Connect to ActiveCampaign Data in CloverDX (formerly CloverETL)
Transfer ActiveCampaign using the visual workflow in the CloverDX data integration tool.
-
Deploy the ADO.NET Provider for Mixpanel on an SSRS Report Server
Connect to Mixpanel 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.
-
Visualize Workday Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Workday.
-
Automated Continuous Office 365 Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Office 365 replication to IBM DB2.
-
Easily Integrate GitLab Data in Lazarus Pascal IDE
Learn how to easily integrate live GitLab in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to create an RPA flow for Drift Data in UiPath Studio
Use the Drift ODBC Driver to create workflows that access real-time Drift without any coding.
-
Automated Continuous Egnyte Replication to Vertica
Use CData Sync for automated, continuous, customizable Egnyte replication to Vertica.
-
Write a Simple Go Application to work with Couchbase Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Couchbase.
-
Getting Started with the CData ADO.NET Provider for Certinia
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Certinia.
-
How to integrate Email with Apache Airflow
Access and process Email in Apache Airflow using the CData JDBC Driver.
-
Connect to eBay Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for eBay in Airbyte.
-
Rapidly Develop SpaceX-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 SpaceX.
-
How to Connect to Live Authorize.Net 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 Authorize.Net without replication.
-
Integrating SAP Business One Data in Talend Cloud Data Management Platform
Connect SAP Business One Data with Talend Cloud Data Management Platform using the CData JDBC Driver for SAP Business One.
-
Build an OLAP Cube in SSAS from OnePageCrm Data
Establish a connection to OnePageCrm data from SQL Server Analysis Services, and use the OnePageCrm Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrating Google Campaign Manager 360 Data in Talend Cloud Data Management Platform
Connect Google Campaign Manager 360 Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Google Campaign Manager 360.
-
Connect to Teradata Data in Aqua Data Studio
Access Teradata from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automate FHIR Data Replication to Azure Synapse
Use CData Sync to customize and automate FHIR replication to Azure Synapse.
-
Create a Data Access Object for Oracle HCM Cloud Data using JDBI
A brief overview of creating a SQL Object API for Oracle HCM Cloud in JDBI.
-
Viewing Salesforce Marketing Data in RAD Studio Data Explorer
How to view Salesforce Marketing Cloud in RAD Studio Data Explorer using the CData ODBC Driver for Salesforce Marketing.
-
Use JayDeBeApi to access ShipStation Data in Python
Use standard Python scripting and the development environment of your choice to access live ShipStation.