CData Software - Knowledge Base
Recent Articles
-
Connect to PostgreSQL in DBeaver
Use the CData ODBC Driver to connect to PostgreSQL in DBeaver.
-
How to connect SharePoint with Salesforce Pardot through external lists
Provide Salesforce Pardot to SharePoint users as an external list.
-
Use the CData Software ODBC Driver for Invoiced in MicroStrategy Desktop
Connect to Invoiced in MicroStrategy Desktop using the CData Software ODBC Driver for Invoiced.
-
Access Live Highrise Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Highrise data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
How to publish and share CSV dashboards with Tableau Server
The CData ODBC driver for CSV enables you integrate CSV/TSV Files into Tableau dashboards.
-
Migrating data from Procore to Google BigQuery using CData SSIS Components.
Easily push Procore to Google BigQuery using the CData SSIS Tasks for Procore and Google BigQuery.
-
How to connect SharePoint with Workday through external lists
Provide Workday to SharePoint users as an external list.
-
Publish Crystal Reports on ADP
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ADP.
-
How to Connect to Live Bullhorn CRM from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Bullhorn CRM for you.
-
Consume Zoho Creator OData Feeds in PowerBuilder
This article demonstrates how to consume Zoho Creator as OData feeds from PowerBuilder using the API Server.
-
How to connect and process Amazon DynamoDB from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Amazon DynamoDB.
-
Build Semantic Layer Views for Coinbase in APOS Live Data Gateway
Use the CData Connector for Coinbase in APOS Live Data Gateway to build Semantic Layer Views for Coinbase.
-
Use Dash to Build to Web Apps on Pinterest
Create Python applications that use pandas and Dash to build Pinterest-connected web apps.
-
Automated Continuous LinkedIn Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable LinkedIn replication to Google BigQuery.
-
Replicate Multiple Amazon S3 Accounts
Replicate multiple Amazon S3 accounts to one or many databases.
-
Connecting Mastra with Adobe Analytics 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.
-
How to Connect to Live PostgreSQL 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 PostgreSQL through natural language.
-
Bridge Oracle SCM Connectivity with Apache NiFi
Access and process Oracle SCM in Apache NiFi using the CData JDBC Driver.
-
Connect to and Visualize Live Paylocity in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Paylocity.
-
Create Impala Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build Gmail-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Gmail and build web apps with connectivity to live Gmail.
-
Automated Continuous Facebook Ads Replication to SQL Server
Use CData Sync for automated, continuous, customizable Facebook Ads replication to SQL Server.
-
How to Build an ETL App for Amazon DynamoDB in Python with CData
Create ETL applications and real-time data pipelines for Amazon DynamoDB in Python with petl.
-
Import and Visualize Excel Online in Power View
Create data visualizations based on Microsoft Excel Online in Excel.
-
Replicate Google Calendar in Heroku for Use in Salesforce Connect
Replicate Google Calendar to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Easily Integrate Printful in Lazarus Pascal IDE
Learn how to easily integrate live Printful in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Access SingleStore from MySQL in Amazon QuickSight
Connect to SingleStore and build visualizations of SingleStore using a MySQL Connection in Amazon QuickSight.
-
Connect to Excel in JRuby
Create a simple JRuby app with access to live Microsoft Excel.
-
Feed EnterpriseDB into FineReport
How to set EnterpriseDB as a JDBC data source in FineReport.
-
Publish Reports with Confluence in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Atlassian Confluence.
-
Automated Continuous CockroachDB Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable CockroachDB replication to Amazon Redshift.
-
Connect to SendGrid in DBArtisan
Use wizards in DBArtisan to configure SendGrid as a data source.
-
Connecting GenSpark with Jira Service Management 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.
-
Connect and Query Live Impala Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Apache Impala into Databricks
-
Feed Basecamp into FineReport
How to set Basecamp as a JDBC data source in FineReport.
-
Publish Reports with SAP Ariba Procurement in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP Ariba Procurement.
-
Access Live SAP Business One in AWS Lambda (with IntelliJ IDEA)
Connect to live SAP Business One in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to SAP Hybris C4C in Ruby
Connect to SAP Hybris C4C in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrate GraphQL into Power Automate Desktop using CData Connect
CData Connect for GraphQL enables you to integrate GraphQL into workflows built using Microsoft Power Automate Desktop.
-
Integrate Real-Time Access to Access in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Microsoft Access in real time.
-
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.
-
Build Dashboards with Workday in DBxtra
Create dynamic dashboards and perform analytics based on Workday in DBxtra.
-
Connect to Vault CRM in Ruby
Connect to Veeva Vault & Vault CRM in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous Azure Active Directory Replication to Databricks
Use CData Sync for automated, continuous, customizable Azure Active Directory replication to Databricks.
-
Import Real-Time AlloyDB via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Google AlloyDB in ColdFusion.
-
Rapidly Develop Blackbaud FE NXT-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.
-
Integrate Impala in Pentaho Data Integration
Build ETL pipelines based on Apache Impala in the Pentaho Data Integration tool.
-
How to Connect to & Open MariaDB in Microsoft Excel
This article uses the CData ODBC driver for MariaDB to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to update Microsoft Project from Excel
This article explains how to transfer data from Excel to Microsoft Project using the Excel Add-In for Microsoft Project.
-
Connect to QuickBooks in RapidMiner
Integrate QuickBooks Desktop with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Clio in RapidMiner
Integrate Clio with standard components and data source configuration wizards in RapidMiner Studio.
-
Visualize Live Lakebase in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Lakebase.
-
DataBind Controls to Sage 200 in C++Builder
DataBind to Sage 200 in C++Builder with standard components and controls.
-
How to Import Data from Oracle Financials Cloud into Google Sheets
Import Oracle Financials Cloud into a Google spreadsheet that is automatically refreshed.
-
Working with Zoho Projects in LINQPad
Execute LINQ queries to Zoho Projects in LINQPad.
-
Use Claude to Talk to Your Marketo via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Marketo for you.
-
Consume EventBrite OData Feeds in PowerBuilder
This article demonstrates how to consume Eventbrite as OData feeds from PowerBuilder using the API Server.
-
Design BIRT Reports on Cloudant
Provide current IBM Cloudant to your embedded analytics.
-
DataBind Controls to Hive in C++Builder
DataBind to Apache Hive in C++Builder with standard components and controls.
-
View Reports on Real-Time Dynamics CRM in Power BI Report Server
Use the CData ODBC Driver for Dynamics CRM to visualize Microsoft Dynamics CRM in Power BI Desktop and then publish them to Power BI Report Server.
-
Access Calendly as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Calendly from your Oracle system.
-
Load Dropbox to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Dropbox to a database.
-
Integrate SendGrid with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SendGrid with External Services.
-
Automate Microsoft OneLake Replication to Azure Data Lake
Use CData Sync to customize and automate Microsoft OneLake replication to Azure Data Lake.
-
Use Microsoft Copilot Studio to talk to your Oracle HCM Cloud via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Oracle HCM Cloud for you.
-
Integrate Live Adobe Analytics into Blue Prism for Intelligent Robotic Process Automation (RPA)
-