CData Software - Knowledge Base
Recent Articles
-
Integrate FormSite with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate FormSite with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to FormSite.
-
Rapidly Develop Sugar CRM-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 Sugar CRM.
-
Integrate Cline with Live WooCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live WooCommerce from within your IDE.
-
How to Connect the Power BI Service to Campaigner: Complete Guide
Connect to the CData Software Power BI Connector for Campaigner from PowerBI.com to provide real-time Campaigner across the organization.
-
Integrate Goose with Live IBM Cloud Object Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live IBM Cloud Object Storage from within the local AI agent.
-
Connect to and Query Typeform Data in QlikView over ODBC
Create data visualizations with Typeform in QlikView.
-
Integrating OpenCode Terminal with Sage Intacct 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 ShipStation Data in the Pentaho Report Designer
Publish reports based on ShipStation in the Pentaho BI tool.
-
Easily Integrate Timely Data in Lazarus Pascal IDE
Learn how to easily integrate live Timely in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Visualize MarkLogic Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load MarkLogic into TIBCO Spotfire.
-
How to Access Unbounce Data Using Entity Framework
This article shows how to access Unbounce using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Use the CData Software JDBC Driver for HCL Domino in MicroStrategy Web
Connect to HCL Domino in MicroStrategy Web using the CData Software JDBC Driver for HCL Domino.
-
Analyze Wave Financial Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Wave Financial and visualize live Wave Financial in Infragistics Reveal.
-
Operational Reporting on Google Spanner Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Google Spanner.
-
Create SSAS Tabular Models from eBay Data
How to build a SQL Server Analysis Service Tabular Model from eBay using CData drivers.
-
Easily Integrate SparkPost Data in Lazarus Pascal IDE
Learn how to easily integrate live SparkPost in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build Visualizations of Outlook Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Outlook in Birst.
-
Automated Continuous Dynamics 365 Business Central Replication to Vertica
Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to Vertica.
-
Getting Started with the CData Python Connector for Discord
Learn to install and license the CData Python Connector
-
How to use SQLAlchemy ORM to access Teamgate Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Teamgate.
-
Replicate Multiple Dynamics 365 Accounts via the CData Sync CLI
Replicate multiple Dynamics 365 accounts to one or many databases.
-
Provide OData Services of Teamgate Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Teamgate by developing a WCF Service Application.
-
Build Cvent-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Cvent and build web apps with connectivity to live Cvent.
-
Build Close-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Close and build web apps with connectivity to live Close.
-
Use the CData Software ODBC Driver for ConstantContact in MicroStrategy Desktop
Connect to ConstantContact in MicroStrategy Desktop using the CData Software ODBC Driver for ConstantContact.
-
Stream Sage 200 Data into Apache Kafka Topics
Access and stream Sage 200 in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build a Singer.io Tap for Sybase IQ With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Sybase IQ data using
-
Access Hugging Face 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 Hugging Face.
-
Use the CData Software ODBC Driver for Dotmailer in SAS for Real-Time Reporting and Analytics
Connect to real-time Dotmailer in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Dotmailer.
-
Automated Continuous Bugsnag Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Bugsnag replication to Google Cloud SQL.
-
Connect and Query Live Cosmos DB Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Azure Cosmos DB into Databricks
-
Automated Continuous OnePageCrm Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable OnePageCrm replication to Amazon Redshift.
-
Integrate Cassandra Data in the Pentaho Report Designer
Publish reports based on Apache Cassandra in the Pentaho BI tool.
-
Visualize Live Intercom Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Intercom using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Data Flows from SQL Server to WooCommerce through SSIS
Easily push SQL Server data to WooCommerce using the CData SSIS Tasks for WooCommerce.
-
Publish Crystal Reports on Azure Analysis Services Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Azure Analysis Services.
-
How to Use a Microsoft Access Database to Update eBay Data in Real Time
Update eBay data by creating a linked table in Microsoft Access with the CData eBay ODBC Driver.
-
How to publish and share Zoho Creator Data dashboards with Tableau Server
The CData ODBC driver for Zoho Creator enables you integrate Zoho Creator into Tableau dashboards.
-
How to connect and process Microsoft Dynamics NAV from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Microsoft Dynamics NAV.
-
Connect to EnterpriseDB Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for EnterpriseDB and the SQL Gateway to access EnterpriseDB from Google Apps Script.
-
Consume Vault CRM OData Feeds in PowerBuilder
This article demonstrates how to consume Veeva Vault & Vault CRM as OData feeds from PowerBuilder using the API Server.
-
Build Voice Agents in ElevenLabs with access to Live ShipStation Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live ShipStation.
-
Automated Continuous Oracle Sales Replication to MySQL
Use CData Sync for automated, continuous, customizable Oracle Sales replication to MySQL.
-
Access Apify Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Apify from HeidiSQL.
-
Connect to MariaDB Data in DBArtisan
Use wizards in DBArtisan to configure MariaDB as a data source.
-
Connect to Exa Data from a Connection Pool in Jetty
The Exa JDBC Driver supports connection pooling: This article shows how to connect faster to Exa from Web apps in Jetty.
-
Visualize LaunchDarkly Data in Sisense
Create an ElastiCube in Sisense app with access to LaunchDarkly.
-
How to connect to Wave Financial Data from IntelliJ
Integrate connectivity to Wave Financial with wizards in IntelliJ.
-
Build WooCommerce-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for WooCommerce to explore live WooCommerce Data in Claude Code to assist with building WooCommerce-powered applications.
-
Rapidly Develop LionDesk-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 LionDesk.
-
How to Connect to Live IBM Informix 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 IBM Informix for you.
-
Connect to QuickBooks Time Data from HeidiSQL
Use CData Connect AI to connect to and query live QuickBooks Time from HeidiSQL.
-
Integrating LlamaIndex with Dynamics 365 Business Central Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Dynamics 365 Business Central in real time.
-
Connecting Moonlit Workflow with Impala 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 Apache Impala in real time.
-
Work with Monday.com Data in FoxPro
Load Monday.com into a FoxPro database. This article includes full code and a walk-through of the process.
-
A PostgreSQL Interface for Google Sheets Data (MySQL Remoting via JDBC)
Use the Remoting features of the Google Sheets JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Build an ETL App for Reckon Accounts Hosted Data in Python with CData Connect AI
Build ETL pipelines that read and write live Reckon Accounts Hosted in Python with petl and the CData Connect AI Python SDK.
-
Connect to Mouseflow 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 Mouseflow and work with Mouseflow in your FileMaker application.
-
Use Dash to Build to Web Apps on Short.io Data
Create Python applications that use pandas and Dash to build Short.io-connected web apps.
-
Build a PostgreSQL Interface for Chargebee Data using the CData JDBC Driver
Use the Remoting features of the Chargebee JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Shortcut
Provide connectivity to Shortcut through an SAP BusinessObjects universe.
-
Choosing the Best Method to Connect Oracle Eloqua Reporting to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Oracle Eloqua Reporting from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to connect and process SAP Netweaver Gateway from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live SAP Netweaver Gateway.
-
Use the CData ODBC Driver for PingOne in Microsoft Power Query
You can use the CData PingOne ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import PingOne into Microsoft Power Query.
-
Object-Relational Mapping (ORM) with OData Services 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 OData into a Java-based ORM framework, Hibernate.
-
Replicate SAP Netweaver Gateway Data to Multiple Databases via the CData Sync CLI
Replicate SAP Netweaver Gateway to disparate databases with a single configuration.
-
Automated Continuous Sybase IQ Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Sybase IQ replication to IBM DB2.
-
Publish Amazon DynamoDB-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Amazon DynamoDB.
-
Visualize BambooHR Data in TIBCO Spotfire through ADO.NET
Integrate BambooHR into dashboards in TIBCO Spotfire.
-
Automated Continuous Float Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Float replication to Apache Kafka.
-
Integrate with Intercom Data in JReport Designer
Create charts and reports based on Intercom in JReport Designer.
-
Getting Started with the CData SSIS Components for SAP SuccessFactors
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SAP SuccessFactors.
-
Create Informatica Mappings From/To a JDBC Data Source for Avaza
Create Avaza data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Bind Live SQL Analysis Services Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SQL Analysis Services data
-
Natively Connect to Slack Data in PHP
The CData ODBC driver for Slack enables you to create PHP applications with connectivity to Slack. Leverage the native support for ODBC in PHP.
-
Back Up Hubstaff to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Hubstaff data.
-
Getting Started with the CData Excel Add-In for Float
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Float.
-
Prepare, Blend, and Analyze Azure DevOps Data in Alteryx Designer (ODBC)
Build workflows to access live Azure DevOps for self-service data analytics.
-
Integrate Nuclia Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Nuclia from Informatica Cloud.
-
Load SAP Business One Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SAP Business One to a database.
-
Analyze Google Ads Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Google Ads and visualize live Google Ads in Infragistics Reveal.
-
Build Dashboards with PivotalTracker Data in DBxtra
Create dynamic dashboards and perform analytics based on PivotalTracker in DBxtra.
-
Integrating Cursor CLI with Google Ads 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.
-
Work with Close Data in FoxPro
Load Close into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build AI Agents with SAP HANA Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live SAP HANA through CData Connect AI.
-
Visualize LDAP Objects in TIBCO Spotfire through ADO.NET
Integrate LDAP into dashboards in TIBCO Spotfire.
-
Creating JSON-Connected Applications in Unqork
You can use CData Connect AI to feed JSON to Unqork and build custom business apps.
-
How to Connect to Live Sugar CRM 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 Sugar CRM for you.
-
Connect to FHIR Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time FHIR using standard SQL.
-
How to work with Keap Data in Apache Spark using SQL
Access and process Keap Data in Apache Spark using the CData Software JDBC Driver.
-
How to connect to Parquet Data in DBVisualizer
Integrate Apache Parquet with visual data analysis tools and data connection wizards in DBVisualizer
-
Use the CData Software ODBC Driver for Calendly in SAS for Real-Time Reporting and Analytics
Connect to real-time Calendly in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Calendly.
-
Integrating LDAP Objects in Talend Cloud Data Management Platform
Connect LDAP Objects with Talend Cloud Data Management Platform using the CData JDBC Driver for LDAP.
-
Build Oracle SCM-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Oracle SCM to explore live Oracle SCM Data in GitHub Copilot to assist with building Oracle SCM-powered applications.
-
Import Authorize.Net Data Using Azure Data Factory
Use CData Connect AI to connect to Authorize.Net Data from Azure Data Factory and import live Authorize.Net.
-
Import Real-Time ZeroBounce Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use ZeroBounce in ColdFusion.
-
How to create an RPA flow for Suadeo Data in UiPath Studio
Use the Suadeo ODBC Driver to create workflows that access real-time Suadeo without any coding.
-
How to Connect to Live FreshBooks 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 FreshBooks through natural language.
-
Connect to Parallel Data in Jaspersoft Studio
Execute SQL to remote Parallel in Jaspersoft Studio.
-
Create Redis-Connected Business Apps in AppSheet
Connect to Redis Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Redis.