CData Software - Knowledge Base
Recent Articles
-
Easily Integrate FHIR in Lazarus Pascal IDE
Learn how to easily integrate live FHIR in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Use ChatGPT to Talk to Your Salesforce Marketing via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Salesforce Marketing Cloud for you.
-
Build AI Agents with Zoho Creator Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can
-
Access Azure DevOps from MySQL in PHP
Connect to Azure DevOps through the standard MySQL libraries in PHP.
-
Access Live SAP SuccessFactors in AWS Lambda (with IntelliJ IDEA)
Connect to live SAP SuccessFactors in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Explore Geographical Relationships in Square with Power Map
Create data visualizations with Square in Power Map.
-
Use Biml to Build SSIS Tasks to Replicate SAP Business One to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SAP Business One to SQL Server.
-
Connect to Trello from HeidiSQL
Use CData Connect AI to connect to and query live Trello from HeidiSQL.
-
Build Visualizations of Adobe Target in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Adobe Target in Birst.
-
Create SSAS Tabular Models from SAP SuccessFactors LMS
How to build a SQL Server Analysis Service Tabular Model from SAP SuccessFactors LMS using CData drivers.
-
Replicate XML to Multiple Databases via the CData Sync CLI
Replicate XML Files to disparate databases with a single configuration.
-
FTP Reporting in OBIEE with the FTP JDBC Driver
Deploy the FTP JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Rapidly Develop MongoDB-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Build AI Agents with IBM Informix Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can
-
Access Live CSV in AWS Lambda (with IntelliJ IDEA)
Connect to live CSV/TSV Files in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Import Data from Zuora into Google Sheets
Import Zuora into a Google spreadsheet that is automatically refreshed.
-
Build BigQuery-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Google BigQuery and build web apps with connectivity to live Google BigQuery.
-
Cvent Reporting in OBIEE with the Cvent JDBC Driver
Deploy the Cvent JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Access Live Office 365 Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Office 365 data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Access Live Azure Active Directory in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Azure Active Directory from your Excel spreadsheets.
-
Automated Continuous Sage 300 Replication to MySQL
Use CData Sync for automated, continuous, customizable Sage 300 replication to MySQL.
-
Build Greenplum-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Pivotal GreenPlum.
-
A PostgreSQL Interface for Shippo using the CData ODBC Driver
Use the SQL Gateway and Shippo ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to and Visualize Live Shippo in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Shippo.
-
How to Import Data from Sage 300 into Google Sheets
Import Sage 300 into a Google spreadsheet that is automatically refreshed.
-
Use the CData Software JDBC Driver for Paylocity in MicroStrategy Desktop
Connect to Paylocity in MicroStrategy Desktop using the CData Software JDBC Driver for Paylocity.
-
Connect to Sage 200 in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Sage 200 in Airbyte.
-
How to Connect the Power BI Service to Greenhouse: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Automated Continuous Certinia Replication to MySQL
Use CData Sync for automated, continuous, customizable Certinia replication to MySQL.
-
Connect to Salesforce Marketing in RapidMiner
Integrate Salesforce Marketing Cloud with standard components and data source configuration wizards in RapidMiner Studio.
-
How to connect SharePoint with JSON Services through external lists
Provide JSON to SharePoint users as an external list.
-
Automated Continuous WooCommerce Replication to IBM DB2
Use CData Sync for automated, continuous, customizable WooCommerce replication to IBM DB2.
-
How to Connect to Live Sage 200 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 Sage 200 for you.
-
Connect to Cloudant from PowerBuilder via ADO.NET
This article demonstrates how to access IBM Cloudant from Appeon PowerBuilder using the CData ADO.NET Provider for Cloudant.
-
Build SAP BusinessObjects BI Visualizations in Tableau Desktop
Use CData Connect AI to connect to live SAP BusinessObjects BI and build visualizations in Tableau.
-
DataBind Controls to Bitbucket in Delphi
DataBind to Bitbucket in Delphi with standard data access components and controls.
-
Rapidly Develop Smartsheet-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Connect to Raisers Edge NXT from a Connection Pool in WebLogic
Use the CData JDBC Driver for Raisers Edge NXT to connect to Raisers Edge NXT from Web applications running on WebLogic.
-
A PostgreSQL Interface for Typeform (MySQL Remoting via JDBC)
Use the Remoting features of the Typeform JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Live Outreach.io 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 Outreach.io for you.
-
Automate SharePoint Excel Services Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live SharePoint Excel Services and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Dynamics 365 Business Central Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Dynamics 365 Business Central through CData Connect AI using different applications and tools.
-
Build Dashboards with Sage 200 in DBxtra
Create dynamic dashboards and perform analytics based on Sage 200 in DBxtra.
-
Model Sugar CRM Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Sugar CRM, enabling the direct import of real-time Sugar CRM.
-
Integrate with Email using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Email to a JSON file on disk.
-
DataBind Controls to Reckon in C++Builder
DataBind to Reckon in C++Builder with standard components and controls.
-
Build Pipelines with Live ADP in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to ADP from Google Cloud Data Fusion, enabling the integration of live ADP into the building and management of effective data pipelines.
-
Integrating Gumloop with Zoho Books via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Zoho Books within automated workflows.
-
Connect to Azure DevOps in DBArtisan
Use wizards in DBArtisan to configure Azure DevOps as a data source.
-
Create PayPal-Connected Nintex Workflows
Use CData Connect AI to connect to PayPal from Nintex Workflow Cloud and build custom workflows using live PayPal.
-
Connect to Outreach.io as an External Source in Dremio
Use the CData JDBC Driver to connect to Outreach.io as an External Source in Dremio.
-
Create Oracle SCM Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Access Live Adobe Analytics in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Adobe Analytics from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Access Live Act-On Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Act-On data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Access Live CSV Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live CSV data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Automated Continuous eBay Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable eBay replication to PostgreSQL.
-
Integrate Google Spanner with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Google Spanner with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Google Spanner.
-
Connect to Google Ads through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Google Ads using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Back Up Quickbase to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Quickbase. In this article, we will employ an SSIS workflow to populate a database with Quickbase data.
-
How to load Oracle Eloqua data into Elasticsearch via Logstash
Introducing a simple method to load Oracle Eloqua data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Active Directory from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Active Directory using standard SQL.
-
Connect GitHub to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live GitHub using the CData Python MCP Server.
-
Migrating data from SAS Data Sets to Google BigQuery using CData SSIS Components.
Easily push SAS Data Sets to Google BigQuery using the CData SSIS Tasks for SAS Data Sets and Google BigQuery.
-
Connect to Sybase IQ in Jaspersoft Studio
Execute SQL to remote Sybase IQ in Jaspersoft Studio.
-
Connecting Mastra with Outreach.io 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 data across 300+ enterprise sources no replication required.
-
Work with SAP Fieldglass in FoxPro
Load SAP Fieldglass into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build a PostgreSQL Interface for SFTP using the CData JDBC Driver
Use the Remoting features of the SFTP JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software JDBC Driver for Sugar CRM in MicroStrategy Desktop
Connect to Sugar CRM in MicroStrategy Desktop using the CData Software JDBC Driver for Sugar CRM.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Avalara AvaTax
Provide connectivity to Avalara AvaTax through an SAP BusinessObjects universe.
-
Access Live Google Directory in AWS Lambda (with IntelliJ IDEA)
Connect to live Google Directory in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Consume Exact Online OData Feeds in PowerBuilder
This article demonstrates how to consume Exact Online as OData feeds from PowerBuilder using the API Server.
-
Automated Continuous Klaviyo Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Klaviyo replication to AlloyDB.
-
Connect Zoho Creator to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Zoho Creator with IBM WebSphere for seamless data integration and connectivity.
-
Connect to Workday in HULFT Integrate
Connect to Workday as a JDBC data source in HULFT Integrate
-
Connecting GenSpark with Twitter Ads via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to enterprise data across 300+ systems without any replication or custom integration required.
-
Automate Tasks in Power Automate Using the CData API Server
Automate actions like sending emails to a contact list, posting to social media, or syncing CRM and ERP.
-
Connect to Oracle HCM Cloud from PowerBuilder via JDBC
This article demonstrates how to access Oracle HCM Cloud from PowerBuilder using the Oracle HCM Cloud JDBC Driver.
-
Connect to Jira Service Management in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Use the CData Software JDBC Driver for DB2 in MicroStrategy Desktop
Connect to IBM DB2 in MicroStrategy Desktop using the CData Software JDBC Driver for DB2.
-
Connect to Oracle Financials Cloud in ACL Analytics
Connect to Oracle Financials Cloud via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Oracle Financials Cloud.
-
How to Connect to Live SAP Business One Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live SAP Business One securely in real time.
-
Use Dash to Build to Web Apps on SAP Business One
Create Python applications that use pandas and Dash to build SAP Business One-connected web apps.
-
Visualize Calendly in Tableau
The CData ODBC driver for Calendly enables you integrate Calendly into Tableau dashboards.
-
Use Dash to Build to Web Apps on SendGrid
Create Python applications that use pandas and Dash to build SendGrid-connected web apps.
-
Connect to EventBrite in DBArtisan
Use wizards in DBArtisan to configure Eventbrite as a data source.
-
Build Greenhouse-Powered Applications in Claude Code with CData Code Assist MCP
-