CData Software - Knowledge Base
Recent Articles
-
Bidirectional Access to Microsoft Ads Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Microsoft Ads in Filemaker Pro for Mac or Windows.
-
Use Grok to Talk to Your Oracle Financials Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Oracle Financials Cloud for you.
-
Connect to Redis Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Redis in Airbyte.
-
Integrate iContact with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate iContact with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to iContact.
-
Connect to Paylocity Data from PowerBuilder via ADO.NET
This article demonstrates how to access Paylocity from Appeon PowerBuilder using the CData ADO.NET Provider for Paylocity.
-
Connect to Instagram Data in ACL Analytics
Connect to Instagram via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Instagram.
-
Integrate with Oracle Service Cloud Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Oracle Service Cloud to a JSON file on disk.
-
Build Apps with Live Dotmailer Data Using the Low-Code Development Platform of Mendix
Connect Dotmailer with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to Toggl Data in DBeaver
Use the CData ODBC Driver to connect to Toggl in DBeaver.
-
Automate Zoho Inventory Data Replication to SAP HANA
Use CData Sync to customize and automate Zoho Inventory replication to SAP HANA.
-
Automated Continuous QuickBooks Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable QuickBooks replication to Google Cloud SQL.
-
Integrate with Google Search Results in SnapLogic
Use CData Connect AI to connect to and integrate with live Google Search in SnapLogic.
-
Connect to Salesforce CRM Analytics Data from PowerBuilder via ADO.NET
This article demonstrates how to access Salesforce CRM Analytics from Appeon PowerBuilder using the CData ADO.NET Provider for Salesforce CRM Analytics.
-
Integrate JotForm with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate JotForm with External Services.
-
Rapidly Develop SAP Fieldglass-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 SAP Fieldglass.
-
Access AgileCRM 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 AgileCRM.
-
Object-Relational Mapping (ORM) with ServiceNow 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 ServiceNow into a Java-based ORM framework, Hibernate.
-
Integrate Goose with Live QuickBooks Time Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live QuickBooks Time from within the local AI agent.
-
Connect to Reckon Accounts Hosted Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Reckon Accounts Hosted from Filemaker Pro on Mac.
-
Build MVC Applications with Connectivity to Neo4J Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Neo4J from an ASP.NET MVC application.
-
Create Reports from MySQL Data in Looker Studio
Use CData Connect AI to gain access to live MySQL and create custom reports in Looker Studio.
-
Integrating GitHub Copilot CLI with Atlassian Jira 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 HCL Domino 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 HCL Domino.
-
Use CData Connect AI to Access API Data in Microsoft Power Pivot
Use CData Connect AI to connect to live API in the Power Pivot business intelligence tool.
-
Automated Continuous LinkedIn Ads Replication to AlloyDB
Use CData Sync for automated, continuous, customizable LinkedIn Ads replication to AlloyDB.
-
How to Access Live Active Directory Data in Visual Studio Code via Cline
Run CData MCP Server for Active Directory on Windows Subsytem for Linux (WSL) and connect to live Active Directory from the Cline extension in Visual Studio Code.
-
Perform Batch Operations with SAP Business One Data in Apache NiFi
Connect to SAP Business One and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Establish a Live Connection with Xero Data using Tableau Bridge
The CData ODBC Driver for Xero enables you to integrate live Xero Accounting into Tableau Cloud dashboards using the Tableau Bridge.
-
Query Live DB2 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 IBM DB2 directly from the development environment.
-
Build Apps with Live Figshare Data Using the Low-Code Development Platform of Mendix
Connect Figshare with Mendix to build apps using the CData API Driver for JDBC.
-
Choosing the Best Method to Connect MYOB AccountRight to SQL Server: 5 Options Explained
Discover multiple ways to connect and use MYOB AccountRight from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
DataBind Controls to Keap Data in C++Builder
DataBind to Keap in C++Builder with standard components and controls.
-
Use ChatGPT to Talk to Your Sybase 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 Sybase for you.
-
Create Dynamic Google Contacts Grids Using the Infragistics XamDataGrid
Learn how you can connect Google Contacts to Infragistics XamDataGrid to build dynamic grids.
-
Use JayDeBeApi to access SAP Data in Python
Use standard Python scripting and the development environment of your choice to access live SAP ERP/NetWeaver.
-
Import Real-Time ZarMoney Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use ZarMoney in ColdFusion.
-
Integrate with Zoho CRM Data in JReport Designer
Create charts and reports based on Zoho CRM in JReport Designer.
-
Automated Continuous Microsoft Dataverse Replication to SingleStore
Use CData Sync for automated, continuous, customizable Microsoft Dataverse replication to SingleStore.
-
Connect Vault CRM to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Vault CRM with IBM WebSphere for seamless data integration and connectivity.
-
Explore Geographical Relationships in SendGrid Data with Power Map
Create data visualizations with SendGrid in Power Map.
-
Connect to and Visualize Live Paymo Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Paymo.
-
Visualize Live Snowflake Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Snowflake using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Azure Analysis Services-Connected Apps in Choreo
Use CData Connect AI to connect to Azure Analysis Services Data from Choreo and build custom apps using live Azure Analysis Services.
-
Seamlessly Bring Office 365 Data into Retool Using CData Connect AI
Integrate Office 365 data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Build Visualizations of Workable Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Workable in Birst.
-
How to use SQLAlchemy ORM to access Vercel Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Vercel.
-
Import Real-Time Webflow Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Webflow in ColdFusion.
-
Connect Instagram to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Instagram with IBM WebSphere for seamless data integration and connectivity.
-
Build Visualizations of Dynamics CRM Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Microsoft Dynamics CRM in Birst.
-
Automated Continuous xBase Replication to MySQL
Use CData Sync for automated, continuous, customizable xBase replication to MySQL.
-
Working with RabbitMQ Data in LINQPad
Execute LINQ queries to RabbitMQ in LINQPad.
-
Integrating Antigravity CLI with Webflow via CData CLI
Connect Webflow to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to Easily Query SuiteCRM Data in OpenOffice Base
Connect to SuiteCRM data in OpenOffice Base using the CData ODBC Driver for SuiteCRM and generate reports with live data insights.
-
Automated Zoho CRM Data Replication to Teradata
Use CData Sync to Customize and automate Zoho CRM replication to Teradata.
-
Integrate REST with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate REST with External Services.
-
Access Notion Data from MySQL in Amazon QuickSight
Connect to Notion and build visualizations of Notion using a MySQL Connection in Amazon QuickSight.
-
Build Semantic Layer Views for SAP SuccessFactors Data in APOS Live Data Gateway
Use the CData Connector for SAP SuccessFactors in APOS Live Data Gateway to build Semantic Layer Views for SAP SuccessFactors.
-
How to Import Data from Paylocity into Google Sheets
Import Paylocity into a Google spreadsheet that is automatically refreshed.
-
Use CData Connect AI to Access Zendesk Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Zendesk in the Power Pivot business intelligence tool.
-
Visualize Live Zoho Inventory Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Zoho Inventory using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Replicate Azure Synapse Data to Multiple Databases
Replicate Azure Synapse to disparate databases with a point-and-click configuration.
-
Import Workday Data Using Azure Data Factory
Use CData Connect AI to connect to Workday Data from Azure Data Factory and import live Workday.
-
Automate Aircall Data Replication to Azure Synapse
Use CData Sync to customize and automate Aircall replication to Azure Synapse.
-
How to Connect the Power BI Service to DocuSign: Complete Guide
Connect to the CData Software Power BI Connector for DocuSign from PowerBI.com to provide real-time DocuSign across the organization.
-
A PostgreSQL Interface for iContact Data using the CData ODBC Driver
Use the SQL Gateway and iContact ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Amazon DynamoDB Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Amazon DynamoDB in Airbyte.
-
Bidirectional Access to Trello Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Trello in Filemaker Pro for Mac or Windows.
-
Query Paddle Data in ColdFusion
Write standard ColdFusion data access code to connect to Paddle.
-
Workday: How to Access Live Data from the WQL for a Workday Report
CData’s Workday Drivers now support querying Workday Reports. Use the CreateWQLSchema Stored Procedure to create a custom schema file that executes a Workday Query Language (WQL) query and retrieves the data.
-
Connect to Intercom Data in JRuby
Create a simple JRuby app with access to live Intercom.
-
Automated Continuous Email Replication to MySQL
Use CData Sync for automated, continuous, customizable Email replication to MySQL.
-
Create Data Visualizations Based On SAS Data Sets Data in Mode
Use CData Connect AI to connect to SAS Data Sets Data from Mode and build visualizations using live
-
How to Work with Klipfolio Data in AWS Glue Jobs Using JDBC
Connect to Klipfolio from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Access Live YouTube Analytics Data in Visual Studio Code via Cline
Run CData MCP Server for YouTube Analytics on Windows Subsytem for Linux (WSL) and connect to live YouTube Analytics from the Cline extension in Visual Studio Code.
-
Access Productboard Data from MySQL in Amazon QuickSight
Connect to Productboard and build visualizations of Productboard using a MySQL Connection in Amazon QuickSight.
-
Build Parallel-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Parallel.
-
Use the CData Software JDBC Driver for Oracle Sales in MicroStrategy Web
Connect to Oracle Sales in MicroStrategy Web using the CData Software JDBC Driver for Oracle Sales.
-
Connect to SQL Server Data in DBeaver
Use the CData ODBC Driver to connect to Microsoft SQL Server in DBeaver.
-
DataBind Controls to ZeroBounce Data in C++Builder
DataBind to ZeroBounce in C++Builder with standard components and controls.
-
Analyze Access Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Microsoft Access and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Query Azure Table Data as a MySQL Database in Node.js
Execute MySQL queries against Azure Table Storage from Node.js.
-
Build Data Flows from Azure DevOps to SQL Server using SSIS
Easily back up Azure DevOps to SQL Server using the SSIS components for Azure DevOps.
-
Build Dashboards with JSON Services in DBxtra
Create dynamic dashboards and perform analytics based on JSON in DBxtra.
-
Create Email-Connected Applications in Appsmith
Connect to Email Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Email.
-
Bridge MongoDB Connectivity with Apache NiFi
Access and process MongoDB in Apache NiFi using the CData JDBC Driver.
-
Integrate Splunk Data into Power Automate Desktop using CData Connect
CData Connect for Splunk Data enables you to integrate Splunk into workflows built using Microsoft Power Automate Desktop.
-
Connect to Confluence Data from a Connection Pool in Jetty
The Confluence JDBC Driver supports connection pooling: This article shows how to connect faster to Atlassian Confluence from Web apps in Jetty.
-
Create BambooHR Dataflows on PowerBI.com
Connect to the CData Power BI Connector for BambooHR from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create Dynamic Dropbox Grids Using the Infragistics XamDataGrid
Learn how you can connect Dropbox to Infragistics XamDataGrid to build dynamic grids.
-
Analyze Avalara AvaTax Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Avalara AvaTax with the CData JDBC Driver for Avalara AvaTax.
-
Build an OLAP Cube in SSAS from Adobe Experience Manager Data
Establish a connection to Adobe Experience Manager data from SQL Server Analysis Services, and use the Adobe Experience Manager Data Provider to build OLAP cubes for use in analytics and reporting.
-
ETL Trello in Oracle Data Integrator
This article shows how to transfer Trello into a data warehouse using Oracle Data Integrator.
-
How to Connect DBeaver to Nethunt via a JDBC Driver
Manage Nethunt with visual tools in DBeaver like the query browser.
-
Connecting Moonlit Workflow with NetSuite SuiteAnalytics 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 NetSuite SuiteAnalytics in real time.
-
Publish Crystal Reports on SAP SuccessFactors Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SAP SuccessFactors.
-
Replicate Onfleet Data from PowerShell
Write a quick PowerShell script to query Onfleet. Use connectivity to the live data to replicate Onfleet to SQL Server.
-
Use Biml to Build SSIS Tasks to Replicate LinkedIn Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate LinkedIn to SQL Server.
-
How to Connect to Live BigQuery Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Google BigQuery for you.
-
Create Zoom-Connected Business Apps in AppSheet
Connect to Zoom Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Zoom.
-
Integrate LibreChat with Live Bullhorn CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Bullhorn CRM from within the chat interface.