CData Software - Knowledge Base
Recent Articles
-
Analyze Quaderno Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Quaderno with the CData JDBC Driver for Quaderno.
-
Object-Relational Mapping (ORM) with Gmail Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Gmail into a Java-based ORM framework, Hibernate.
-
Query Avalara AvaTax Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Avalara AvaTax and perform CRUD operations on Avalara AvaTax from Node.js.
-
Connect to Accelo Data from PowerBuilder via ADO.NET
This article demonstrates how to access Accelo from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Getting Started with the CData SSIS Components for Delighted
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Delighted.
-
Use Manus AI to Talk to Your SAS Data Sets 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 SAS Data Sets.
-
Automated Continuous Microsoft Dataverse Replication to SQL Server
Use CData Sync for automated, continuous, customizable Microsoft Dataverse replication to SQL Server.
-
Automated Continuous SAP Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable SAP replication to Azure SQL Database.
-
How to connect to Oracle Data from IntelliJ
Integrate connectivity to Oracle Database with wizards in IntelliJ.
-
Integrating OpenCode Terminal with MYOB AccountRight 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 Asana to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Asana using the CData Python MCP Server.
-
Replicate Google Ad Manager Data in Heroku for Use in Salesforce Connect
Replicate Google Ad Manager to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to create Sage 300 federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Sage 300 in MySQL .
-
Analyze BambooHR Data in Cognos Analytics
Use CData Connect AI to connect to BambooHR Data from Cognos Analytics and analyze live BambooHR.
-
A PostgreSQL Interface for NetSuite Data (MySQL Remoting via JDBC)
Use the Remoting features of the NetSuite JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate with live QuickBooks Online Data in Jitterbit
Use CData Connect AI to connect to and integrate live QuickBooks Online in Jitterbit.
-
Connect to SAP Hybris C4C Data in JRuby
Create a simple JRuby app with access to live SAP Hybris C4C.
-
Create Dynamic Suadeo Grids Using the Infragistics XamDataGrid
Learn how you can connect Suadeo to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Real-Time MailerLite Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use MailerLite in Power Apps.
-
Extract, Transform, and Load QuickBooks Online Data in Informatica PowerCenter
Create a simple Workflow for QuickBooks Online in Informatica PowerCenter.
-
Create Informatica Mappings From/To a JDBC Data Source for Hubstaff
Create Hubstaff data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to create an RPA flow for Qualaroo Data in UiPath Studio
Use the Qualaroo ODBC Driver to create workflows that access real-time Qualaroo without any coding.
-
Automated Freshteam Data Replication to Teradata
Use CData Sync to Customize and automate Freshteam replication to Teradata.
-
Build a Simple VCL Application for Ontraport Data
How to build a simple VCL Application to view Ontraport in RAD Studio using the CData ODBC Driver for Ontraport.
-
Publish Reports with Coda Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Coda.
-
Create Informatica Mappings From/To an ODBC Data Source for LaunchDarkly
Create an ODBC connection to LaunchDarkly in Informatica and browse and transfer LaunchDarkly.
-
Query Short.io Data as a MySQL Database in Node.js
Execute MySQL queries against Short.io from Node.js.
-
Connect to BigQuery Data in HULFT Integrate
Connect to BigQuery as a JDBC data source in HULFT Integrate
-
Getting Started with the CData JDBC Driver for Bitly
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Bitly.
-
Create Reports with Stack Exchange Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Stack Exchange.
-
Connect to Cosmos DB Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Azure Cosmos DB.
-
How to Access Live Teradata Data in Visual Studio Code via Cline
Run CData MCP Server for Teradata on Windows Subsytem for Linux (WSL) and connect to live Teradata from the Cline extension in Visual Studio Code.
-
Access Live Confluence Data in Excel 365 Online (Excel for the web)
Connect to Atlassian Confluence from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Automated Continuous Microsoft OneLake Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Microsoft OneLake replication to Amazon Redshift.
-
Build Automated Workflows with Live QuickBooks Online Data in Workato
Use CData Connect AI to connect to live QuickBooks Online and build automated workflows in Workato.
-
Build Voice Agents in ElevenLabs with access to Live Avalara AvaTax Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Avalara AvaTax.
-
Consume Zuora OData Feeds in PowerBuilder
This article demonstrates how to consume Zuora as OData feeds from PowerBuilder using the API Server.
-
Connect to Zoho Projects 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 Zoho Projects.
-
Automated Continuous Greenplum Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Pivotal GreenPlum replication to OneLake in Microsoft Fabric.
-
How to Create Power BI Visual Reports with Real-Time ClickUp Data
Use CData Power BI Connectors to visualize ClickUp in Power BI.
-
Integrating Cursor CLI with Mailgun 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 to Codat Data from Spring Boot
Connect to Codat in a Spring Boot Application using the CData API Driver for JDBC
-
Connect to PostgreSQL in SpagoBI
Create reports featuring live PostgreSQL in SpagoBI Studio. Host PostgreSQL reports on SpagoBI Server.
-
Automate SAP Ariba Source Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SAP Ariba Source from PowerShell? This article demonstrates how to utilize the SAP Ariba Source Cmdlets for tasks like connecting to SAP Ariba Source, automating operations, downloading data, and more.
-
Connect to FHIR Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live FHIR.
-
Build Azure Data Lake Storage Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Azure Data Lake Storage and build visualizations in Tableau.
-
Amazon S3 Reporting in OBIEE with the Amazon S3 JDBC Driver
Deploy the Amazon S3 JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to TaxJar Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for TaxJar to connect to TaxJar and execute queries in PowerBuilder.
-
Visualize Live Blackbaud FE NXT Data in the Power BI Service
Use CData Connect AI to connect to live Blackbaud FE NXT and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Visualize Live Jodoo Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Jodoo using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Query Live Oracle Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Oracle Database data in natural language using Python.
-
Publish Reports with eBay Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date eBay.
-
How to Query Amazon Marketplace Data in MySQL Workbench
Execute MySQL queries against live Amazon Marketplace from MySQL Workbench.
-
Getting Started with the CData SSIS Components for Google Search
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Google Search.
-
Connect to SAP SuccessFactors LMS Data in DBeaver
Use the CData ODBC Driver to connect to SAP SuccessFactors LMS in DBeaver.
-
Getting Started with the CData JDBC Driver for Access
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Access.
-
Integrate Zoom Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Zoom from Informatica Cloud.
-
Build Automated Slack-Connected Workflows in Zapier
Use CData Connect AI to connect to live Slack and build automated workflows in Zapier.
-
How to Design Databricks Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Databricks from mobile and tablet Power Apps.
-
Replicate Adobe Analytics Data to Multiple Databases
Replicate Adobe Analytics to disparate databases with a point-and-click configuration.
-
How to connect and process Outreach.io from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Outreach.io.
-
Process & Analyze Bitbucket Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Bitbucket Data.
-
Rapidly Develop Certinia-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 Certinia.
-
Feed Todoist Data into FineReport
How to set Todoist as a JDBC data source in FineReport.
-
Build Visualizations of Beeminder Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Beeminder in Birst.
-
Use the CData Software ODBC Driver for Superchat in MicroStrategy
Connect to Superchat in MicroStrategy Developer using the CData Software ODBC Driver for Superchat.
-
How to work with Missive Data in Apache Spark using SQL
Access and process Missive Data in Apache Spark using the CData Software JDBC Driver.
-
Automated Continuous WordPress Replication to Oracle
Use CData Sync for automated, continuous, customizable WordPress replication to Oracle.
-
Use Dash to Build Web Apps on Adobe Commerce Data via CData Connect AI
Build interactive Dash web apps on live Adobe Commerce using pandas and the CData Connect AI Python SDK.
-
DataBind AgileCRM Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide AgileCRM to a chart.
-
Use the CData Software JDBC Driver for Exact Online in MicroStrategy Web
Connect to Exact Online in MicroStrategy Web using the CData Software JDBC Driver for Exact Online.
-
Automate Zoho CRM Data Replication to SAP HANA
Use CData Sync to customize and automate Zoho CRM replication to SAP HANA.
-
Integrating LangChain with BigCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on BigCommerce within automated workflows.
-
Publish Crystal Reports on Rootly Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Rootly.
-
Use the CData Software ODBC Driver for Testmonitor in MicroStrategy Desktop
Connect to Testmonitor in MicroStrategy Desktop using the CData Software ODBC Driver for Testmonitor.
-
Replicate Vercel Data from PowerShell
Write a quick PowerShell script to query Vercel. Use connectivity to the live data to replicate Vercel to SQL Server.
-
Build a Simple VCL Application for Gorgias Data
How to build a simple VCL Application to view Gorgias in RAD Studio using the CData ODBC Driver for Gorgias.
-
Integrate Theia IDE with Live Zendesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Connect to Testmonitor Data in DBArtisan
Use wizards in DBArtisan to configure Testmonitor as a data source.
-
Build Data Flows from Azure Data Lake Storage to SQL Server using SSIS
Easily back up Azure Data Lake Storage to SQL Server using the SSIS components for Azure Data Lake Storage.
-
Operational Reporting on Printify Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Printify.
-
Create Salesforce CRM Analytics-Connected Dashboards in Grafana
Connect to Salesforce CRM Analytics Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Salesforce CRM Analytics.
-
Automated Continuous Nethunt Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Nethunt replication to Google BigQuery.
-
Viewing Clio Data in RAD Studio Data Explorer
How to view Clio in RAD Studio Data Explorer using the CData ODBC Driver for Clio.
-
Working with Nuclia Data in LINQPad
Execute LINQ queries to Nuclia in LINQPad.
-
Getting Started with the CData Power BI Connector for Typeform
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connecting Mastra with Amazon DynamoDB 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 Amazon DynamoDB, no replication required.
-
Integrate Goose with Live Presto Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Presto from within the local AI agent.
-
Import Real-Time Bitbucket Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Bitbucket in ColdFusion.
-
DataBind Controls to Workday Data in C++Builder
DataBind to Workday in C++Builder with standard components and controls.
-
Create Apps from Excel Online Data in Qlik Sense Cloud
Use CData Connect AI to connect to Excel Online Data and build apps from live Microsoft Excel Online in Qlik Sense Cloud.
-
Automate ClickUp Data Replication to SAP HANA
Use CData Sync to customize and automate ClickUp replication to SAP HANA.
-
A PostgreSQL Interface for ZohoPeople Data using the CData ODBC Driver
Use the SQL Gateway and ZohoPeople ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automate BigCommerce Integration Tasks from PowerShell
Are you in search of a quick and easy way to access BigCommerce from PowerShell? This article demonstrates how to utilize the BigCommerce Cmdlets for tasks like connecting to BigCommerce, automating operations, downloading data, and more.
-
Build Data Flows from SAS xpt to SQL Server using SSIS
Easily back up SAS XPORT to SQL Server using the SSIS components for SAS xpt.
-
Access Live Highrise Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Highrise CRM from your Google Sheets.
-
Create Sybase IQ-Connected Dashboards in Grafana
Connect to Sybase IQ Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Sybase IQ.
-
Getting Started with the CData Tableau Connector for Suadeo
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Suadeo.
-
Import and Visualize GraphQL Data in Power View
Create data visualizations based on GraphQL in Excel.
-
Use the CData Software JDBC Driver for Basecamp in MicroStrategy Web
Connect to Basecamp in MicroStrategy Web using the CData Software JDBC Driver for Basecamp.