CData Software - Knowledge Base
Recent Articles
-
Integrating GitHub Copilot CLI with ZarMoney 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.
-
Configure the CData JDBC Driver for Amazon Marketplace in a Connection Pool in Tomcat
Connect to Amazon Marketplace from a connection pool in Tomcat.
-
A PostgreSQL Interface for SurveyMonkey Data (MySQL Remoting via JDBC)
Use the Remoting features of the SurveyMonkey JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software JDBC Driver for Xero in MicroStrategy
Connect to Xero Accounting in MicroStrategy Developer using the CData Software JDBC Driver for Xero.
-
Stream SAP Data into Apache Kafka Topics
Access and stream SAP ERP/NetWeaver in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create MailChimp-Connected Business Apps in AppSheet
Connect to MailChimp Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to MailChimp.
-
Integrate BambooHR Data in Pentaho Data Integration
Build ETL pipelines based on BambooHR in the Pentaho Data Integration tool.
-
Integrating LangGraph with GitLab Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on GitLab within automated workflows.
-
Create Informatica Mappings From/To a JDBC Data Source for Omnisend
Create Omnisend data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Access Live Mouseflow Data in AWS Lambda
Connect to live Mouseflow in AWS Lambda using the CData JDBC Driver.
-
Automate LeadDesk Data Replication to Azure Data Lake
Use CData Sync to customize and automate LeadDesk replication to Azure Data Lake.
-
Publish Reports with Beeminder Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Beeminder.
-
DataBind Controls to QuickBooks Data in Delphi
DataBind to QuickBooks Desktop in Delphi with standard data access components and controls.
-
How to Create Power BI Visual Reports with Real-Time SAS xpt Data
Use CData Power BI Connectors to visualize SAS XPORT in Power BI.
-
Feed MailChimp Data into FineReport
How to set MailChimp as a JDBC data source in FineReport.
-
How to Connect to Live Zuora 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 Zuora without replication.
-
How to Query Live Epicor Kinetic Data in Perplexity MacOS Desktop
Connect to and query live Epicor Kinetic Data in Perplexity Desktop using CData MCP Server.
-
Connect to Cvent Data in HULFT Integrate
Connect to Cvent as a JDBC data source in HULFT Integrate
-
Publish BambooHR-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live BambooHR.
-
Connect Google Search to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Google Search with IBM WebSphere for seamless data integration and connectivity.
-
Integrate Cvent Data in the Pentaho Report Designer
Publish reports based on Cvent in the Pentaho BI tool.
-
Analyze Helpscout Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Helpscout and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Import and Visualize Cohere Data in Power View
Create data visualizations based on Cohere in Excel.
-
Access Live Aweber Data in AWS Lambda
Connect to live Aweber in AWS Lambda using the CData JDBC Driver.
-
Integrating OpenCode Terminal with Mocean 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.
-
Integrating Cursor CLI with iContact 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 Oracle Eloqua-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Oracle Eloqua Data and create custom apps in Bubble.
-
Connect to Sage Intacct Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Sage Intacct in Airbyte.
-
Replicate Multiple VWO Accounts via the CData Sync CLI
Replicate multiple VWO accounts to one or many databases.
-
How to Build an ETL App for Microsoft Exchange Data in Python with CData
Create ETL applications and real-time data pipelines for Microsoft Exchange in Python with petl.
-
Access Live Codat Data in Coginiti Pro
Connect to and query live Codat from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Import Real-Time Microsoft Planner Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Microsoft Planner in ColdFusion.
-
Build Avaza-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Avaza and build web apps with connectivity to live Avaza.
-
How to Work with LightSpeedRetail Data in AWS Glue Jobs Using JDBC
Connect to LightSpeedRetail from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Connect to Live Lakebase Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Lakebase through natural language.
-
Publish Gorgias-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Gorgias.
-
How to connect to Harvest Data from IntelliJ
Integrate connectivity to Harvest with wizards in IntelliJ.
-
How to publish and share Google Ad Manager Data dashboards with Tableau Server
The CData ODBC driver for Google Ad Manager enables you integrate Google Ad Manager into Tableau dashboards.
-
Use the CData Software JDBC Driver for Paymo in MicroStrategy Desktop
Connect to Paymo in MicroStrategy Desktop using the CData Software JDBC Driver for Paymo.
-
Faster Reporting using the CData Provider for Salesforce
The CData ADO.NET Provider for Salesforce features advanced caching capabilities. The Auto Cache feature of the Data Provider can be used to execute expensive queries against a local, automatically updated cache.
-
Build PostgreSQL-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for PostgreSQL Data and create custom apps in Bubble.
-
Model eBay Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and eBay, enabling the direct import of real-time eBay.
-
Connect to and Query Float Data in QlikView over ODBC
Create data visualizations with Float in QlikView.
-
Use Dash to Build to Web Apps on Greenhouse Data
Create Python applications that use pandas and Dash to build Greenhouse-connected web apps.
-
Create a Data Access Object for Shippo Data using JDBI
A brief overview of creating a SQL Object API for Shippo in JDBI.
-
Analyze Cosmos DB Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Azure Cosmos DB and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Bind Live Printful Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Printful data
-
Use the CData ODBC Driver for Rootly in Microsoft Power Query
You can use the CData Rootly ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Rootly into Microsoft Power Query.
-
Use Claude to Talk to Your BambooHR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your BambooHR for you.
-
Seamlessly Bring Oracle Financials Cloud Data into Retool Using CData Connect AI
Integrate Oracle Financials Cloud data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Migrating data from Oracle SCM to Databricks using CData SSIS Components.
Easily push Oracle SCM to Databricks using the CData SSIS Tasks for Oracle SCM and Databricks.
-
Access Live ServiceDesk Plus Data in AWS Lambda (with IntelliJ IDEA)
Connect to live ServiceDesk Plus in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Analyze OneNote Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Microsoft OneNote and visualize live Microsoft OneNote in Infragistics Reveal.
-
Connect to WordPress Data in Jaspersoft Studio
Execute SQL to remote WordPress in Jaspersoft Studio.
-
How to Connect to Live Sage Cloud Accounting Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Sage Business Cloud Accounting through natural language.
-
Build a Simple VCL Application for OneNote Data
How to build a simple VCL Application to view Microsoft OneNote in RAD Studio using the CData ODBC Driver for OneNote.
-
Integrating Claude Code with Airtable Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Airtable within assisted coding and automated development workflows.
-
Replicate ServiceNow Data from PowerShell
Write a quick PowerShell script to query ServiceNow. Use connectivity to the live data to replicate ServiceNow to SQL Server.
-
Connect to Dynamics 365 Business Central Data from PowerBuilder via JDBC
This article demonstrates how to access Dynamics 365 Business Central from PowerBuilder using the Dynamics 365 Business Central JDBC Driver.
-
Build Dashboards with FTP Data in Dundas BI
Create dynamic dashboards and perform analytics based on FTP Servers in Dundas BI.
-
Analyze Presto Data in Cognos Analytics
Use CData Connect AI to connect to Presto Data from Cognos Analytics and analyze live Presto.
-
Create Wistia Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Wistia data access from reports, embedded analytics, and more.
-
Build Semantic Layer Views for Highrise Data in APOS Live Data Gateway
Use the CData Connector for Highrise in APOS Live Data Gateway to build Semantic Layer Views for Highrise CRM.
-
Use Biml to Build SSIS Tasks to Replicate ConvertKit Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate ConvertKit to SQL Server.
-
Prepare, Blend, and Analyze Oracle Data in Alteryx Designer (Connect AI)
Build workflows to access live Oracle Database for self-service data analytics.
-
Connect to HubSpot Data as an External Source in Dremio
Use the CData JDBC Driver to connect to HubSpot as an External Source in Dremio.
-
View Reports on Real-Time Jodoo Data in Power BI Report Server
Use the CData ODBC Driver for Jodoo to visualize Jodoo in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Query Live CouchDB Data in Claude Desktop
Connect to and query live CouchDB Data in Claude Desktop using CData MCP Server.
-
Connect to MailerLite Data in DBArtisan
Use wizards in DBArtisan to configure MailerLite as a data source.
-
Build Semantic Layer Views for Excel Online Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Microsoft Excel Online.
-
Build Apps with Live SAP HANA in Adalo using CData Connect AI
Use CData Connect AI to integrate live SAP HANA into the Adalo platform and build custom mobile and web applications with real-time SAP HANA.
-
How to Access Live Lakebase Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Lakebase enables you to integrate Lakebase into workflows built using Microsoft Power Automate Desktop.
-
Feed Apollo Data into FineReport
How to set Apollo as a JDBC data source in FineReport.
-
How to load Azure Data Catalog data into Elasticsearch via Logstash
Introducing a simple method to load Azure Data Catalog data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrating Codex CLI with Clockify 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 with Gong Data in JReport Designer
Create charts and reports based on Gong in JReport Designer.
-
Automated Continuous DB2 Replication to Amazon S3
Use CData Sync for automated, continuous, customizable DB2 replication to Amazon S3.
-
A PostgreSQL Interface for Todoist Data using the CData ODBC Driver
Use the SQL Gateway and Todoist ODBC Driver to create a PostgreSQL entry-point for data access.
-
Choosing the Best Method to Connect Accelo to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Accelo from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automate Mailjet Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Mailjet and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
How to Connect the Power BI Service to SAS Data Sets: Complete Guide
Connect to the CData Software Power BI Connector for SAS Data Sets from PowerBI.com to provide real-time SAS Data Sets across the organization.
-
Active Directory Reporting in OBIEE with the Active Directory JDBC Driver
Deploy the Active Directory JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Getting Started with the CData SSIS Components for Salesloft
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Salesloft.
-
Import and Visualize Suadeo Data in Power View
Create data visualizations based on Suadeo in Excel.
-
How to connect PolyBase to Oracle Service Cloud
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Oracle Service Cloud.
-
Connect to XML Data from a Connection Pool in Jetty
The XML JDBC Driver supports connection pooling: This article shows how to connect faster to XML Files from Web apps in Jetty.
-
How to Query Live Sendwithus Data in Perplexity MacOS Desktop
Connect to and query live Sendwithus Data in Perplexity Desktop using CData MCP Server.
-
Enable the Microsoft Ads JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Microsoft Ads.
-
Automated Omnisend Data Replication to Teradata
Use CData Sync to Customize and automate Omnisend replication to Teradata.
-
Use Claude to Talk to Your GraphQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your GraphQL for you.
-
Automated Continuous Pipedrive Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Pipedrive replication to Azure SQL Database.
-
Integrate Mailjet Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Mailjet from Informatica Cloud.
-
Create Sugar CRM-Connected Applications in Appsmith
Connect to Sugar CRM Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Sugar CRM.
-
Create Phoenix-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Phoenix Data from OutSystems and build custom enterprise apps using live Apache Phoenix.
-
Automated Continuous ADP Replication to MongoDB
Use CData Sync for automated, continuous, customizable ADP replication to MongoDB.
-
Use the CData Software JDBC Driver for SharePoint in MicroStrategy Desktop
Connect to Microsoft SharePoint in MicroStrategy Desktop using the CData Software JDBC Driver for SharePoint.
-
Integrating Boomi Agentstudio with Dynamics 365 Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Microsoft Dynamics 365, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect SAP Ariba Source Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SAP Ariba Source using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create Authorize.Net-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Authorize.Net Data from OutSystems and build custom enterprise apps using live Authorize.Net.
-
Consume ConvertAPI OData Feeds in SAP Lumira
Use the API Server to create data visualizations on ConvertAPI feeds that reflect any changes in SAP Lumira.