CData Software - Knowledge Base
Recent Articles
-
DataBind Controls to Google Spanner Data in Delphi
DataBind to Google Spanner in Delphi with standard data access components and controls.
-
Automate MariaDB Integration Tasks from PowerShell
Are you in search of a quick and easy way to access MariaDB from PowerShell? This article demonstrates how to utilize the MariaDB Cmdlets for tasks like connecting to MariaDB, automating operations, downloading data, and more.
-
Create Pipedrive Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Pipedrive data access from reports, embedded analytics, and more.
-
Build Data Flows from Zoom to SQL Server using SSIS
Easily back up Zoom to SQL Server using the SSIS components for Zoom.
-
Work with Live Microsoft Entra ID Data in Power Query
Use CData Connect AI to connect to Microsoft Entra ID and work with live Microsoft Entra ID in Microsoft Power Query.
-
Visualize Email Data in TIBCO Spotfire through OData
Integrate Email into dashboards in TIBCO Spotfire.
-
Automate Tasks in Power Automate Using the CData API Server
Automate HubDB actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Manage Reckon Accounts Hosted Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Reckon Accounts Hosted.
-
Connect to Pipeline CRM Data in CloverDX (formerly CloverETL)
Transfer Pipeline CRM using the visual workflow in the CloverDX data integration tool.
-
Access Zoom Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Zoom from your Oracle system.
-
Analyze PDFMonkey Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for PDFMonkey from Power Pivot. You will use the Table Import Wizard to load PDFMonkey. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Google Calendar Data in RazorSQL
Connect to Google Calendar from wizards and query Google Calendar from the GUI in the RazorSQL database management tool.
-
Integrate Grafana with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Grafana with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Grafana.
-
Build MVC Applications with Connectivity to Omnisend Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Omnisend from an ASP.NET MVC application.
-
Integrating Claude Code with Acumatica Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Acumatica ERP within assisted coding and automated development workflows.
-
Connect to Procore from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Procore, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to Create Power BI Visual Reports with Real-Time OpenWeatherMap Data
Use CData Power BI Connectors to visualize OpenWeatherMap in Power BI.
-
Build Data Flows from Drip to SQL Server using SSIS
Easily back up Drip to SQL Server using the SSIS components for Drip.
-
Integrate Live Acumatica Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Acumatica ERP and integrate live Acumatica ERP into apps built in Microsoft Power Apps.
-
Visualize Avaza Data in Tableau
The CData ODBC driver for Avaza enables you integrate Avaza into Tableau dashboards.
-
Connect to Tickspot Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Tickspot and work with Tickspot in your FileMaker applications.
-
Integrate Real-Time Access to BigCommerce in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to BigCommerce in real time.
-
Publish Aweber-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Aweber.
-
Easily Integrate Zendesk Data in Lazarus Pascal IDE
Learn how to easily integrate live Zendesk in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to ChargeOver from Asprova with CData Software ODBC Driver for ChargeOver
This article shows how to connect faster to ChargeOver data from Asprova.
-
How to Work with Bright Data Data in AWS Glue Jobs Using JDBC
Connect to Bright Data from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Visualize Trello Data in TIBCO Spotfire through ADO.NET
Integrate Trello into dashboards in TIBCO Spotfire.
-
Build an OLAP Cube in SSAS from SAP HANA XS Advanced Data
Establish a connection to SAP HANA XS Advanced data from SQL Server Analysis Services, and use the SAP HANA XS Advanced Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Easily Query Eventbrite Data in OpenOffice Base
Connect to Eventbrite data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Integrate Cline with Live Confluence Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Atlassian Confluence from within your IDE.
-
Import Real-Time RSS Feeds via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use RSS Feeds in ColdFusion.
-
Getting Started with the CData Tableau Connector for WordPress
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for WordPress.
-
How to Connect to Live PostgreSQL Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live PostgreSQL securely in real time.
-
How to integrate Spotify with Apache Airflow
Access and process Spotify in Apache Airflow using the CData JDBC Driver.
-
Connect to ADP Data from Crystal Reports
Use CData Connect AI to connect to and report on live ADP from Crystal Reports.
-
Extract, Transform, and Load SurveyMonkey Data in Informatica PowerCenter
Create a simple Workflow for SurveyMonkey in Informatica PowerCenter.
-
Create Datasets from SendInBlue in Domo Workbench and Build Visualizations of SendInBlue Data in Domo
Use the CData Software ODBC Driver for SendInBlue to create datasets from SendInBlue in Domo Workbench and then build visualizations in the Domo service.
-
Connect to SAP SuccessFactors LMS Data from a Connection Pool in JBoss
Integrate SAP SuccessFactors LMS into Java servlets: Use the Management Console in JBoss to install the SAP SuccessFactors LMS JDBC Driver.
-
Visualize Live IBM Informix Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live IBM Informix using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create Cloudant-Connected Nintex Workflows
Use CData Connect AI to connect to Cloudant Data from Nintex Workflow Cloud and build custom workflows using live IBM Cloudant.
-
Use Microsoft Copilot Studio to talk to your PayPal Data 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 PayPal for you.
-
Access BambooHR 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 BambooHR.
-
Replicate Multiple Microsoft Exchange Accounts via the CData Sync CLI
Replicate multiple Microsoft Exchange accounts to one or many databases.
-
Visualize Jodoo 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 Jodoo into TIBCO Spotfire.
-
Automated Continuous Aweber Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Aweber replication to Azure SQL Database.
-
Migrating data from Sybase to Google BigQuery using CData SSIS Components.
Easily push Sybase to Google BigQuery using the CData SSIS Tasks for Sybase and Google BigQuery.
-
Analyze AfterShip Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for AfterShip from Power Pivot. You will use the Table Import Wizard to load AfterShip. You can visually build the import query or use any SQL supported by the driver.
-
Easily Integrate ConvertAPI Data in Lazarus Pascal IDE
Learn how to easily integrate live ConvertAPI in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Feed Salesforce Pardot Data into FineReport
How to set Salesforce Pardot as a JDBC data source in FineReport.
-
Access Nuclia 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 Nuclia.
-
Connect to Live BigQuery Data in PostGresSQL Interface through CData Connect AI
Create a live connection to BigQuery in CData Connect AI and connect to your Google BigQuery from PostgreSQL.
-
Automated Continuous Amazon DynamoDB Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Amazon DynamoDB replication to delimited files (CSV/TSV).
-
Build Visualizations of ClickUp Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ClickUp in Birst.
-
Integrate Xero Data in Pentaho Data Integration
Build ETL pipelines based on Xero Accounting in the Pentaho Data Integration tool.
-
Excel Spreadsheet Automation on Zoho Inventory Data with the QUERY Formula
Pull data from Zoho Inventory, automate spreadsheets, and more with the QUERY formula.
-
Connect to Gong Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Gong from Filemaker Pro on Mac.
-
Create a Data Access Object for ShipEngine Data using JDBI
A brief overview of creating a SQL Object API for ShipEngine in JDBI.
-
Integrating ADP Data in Talend Cloud Data Management Platform
Connect ADP Data with Talend Cloud Data Management Platform using the CData JDBC Driver for ADP.
-
Automated Continuous Exa Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Exa replication to Google Cloud SQL.
-
Natively Connect to Sendwithus Data in PHP
The CData ODBC driver for Sendwithus enables you to create PHP applications with connectivity to Sendwithus. Leverage the native support for ODBC in PHP.
-
Object-Relational Mapping (ORM) with Todoist 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 Todoist into a Java-based ORM framework, Hibernate.
-
Connect to Invoiced Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Invoiced in the Denodo Virtual DataPort Administrator.
-
Provide OData Services of Landbot Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Landbot by developing a WCF Service Application.
-
How to Seamlessly Import Parallel Data into IBM SPSS Modeler
Integrate Parallel data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build a Simple VCL Application for JSON Services
How to build a simple VCL Application to view JSON in RAD Studio using the CData ODBC Driver for JSON.
-
Connect to SAP Ariba Source Data in RazorSQL
Connect to SAP Ariba Source from wizards and query SAP Ariba Source from the GUI in the RazorSQL database management tool.
-
How to Easily Query Instagram Data in OpenOffice Base
Connect to Instagram data in OpenOffice Base using the CData ODBC Driver for Instagram and generate reports with live data insights.
-
Rapidly Develop Accelo-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 Accelo.
-
Publish Access-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Microsoft Access.
-
Build Dashboards with Gong Data in Dundas BI
Create dynamic dashboards and perform analytics based on Gong in Dundas BI.
-
Connect to PingOne Data in RazorSQL
Connect to PingOne from wizards and query PingOne from the GUI in the RazorSQL database management tool.
-
Deploy the ADO.NET Provider for Eventbrite on an SSRS Report Server
Connect to Eventbrite from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Write a Simple Go Application to work with ClickTime Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to ClickTime.
-
Automate Gorgias Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Gorgias from PowerShell? This article demonstrates how to utilize the Gorgias Cmdlets for tasks like connecting to Gorgias, automating operations, downloading data, and more.
-
Build Apps with Live ShipEngine Data Using the Low-Code Development Platform of Mendix
Connect ShipEngine with Mendix to build apps using the CData API Driver for JDBC.
-
Access Placid Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Placid from HeidiSQL.
-
Seamlessly Bring Facebook Ads Data into Retool Using CData Connect AI
Integrate Facebook Ads data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
SAP Business Warehouse Reporting in OBIEE with the SAP Business Warehouse JDBC Driver
Deploy the SAP Business Warehouse JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to and Visualize Live Trello Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Trello.
-
Connecting Agentforce with Marketo Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Marketo for you.
-
Create a Data Access Object for Tally Data using JDBI
A brief overview of creating a SQL Object API for Tally ERP in JDBI.
-
Build Trello-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Trello and build Trello-connected web apps with Axios.
-
How to work with Paymo Data in Apache Spark using SQL
Access and process Paymo Data in Apache Spark using the CData Software JDBC Driver.
-
Build ConvertAPI-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live ConvertAPI.
-
How to Connect Splunk Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Splunk data in real time using natural language.
-
Getting Started with the CData ADO.NET Provider for Kafka
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Kafka.
-
Access Live Exa Data in AWS Lambda
Connect to live Exa in AWS Lambda using the CData JDBC Driver.
-
Integrate Live Azure Synapse Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Azure Synapse to Blue Prism using the CData ODBC Driver for Azure Synapse to create automated workflows for repetitive business tasks.
-
Create Data Visualizations in Cognos BI with Splunk Data
Access Splunk as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Import Real-Time CloudConvert Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use CloudConvert in ColdFusion.
-
Model CSV Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and CSV, enabling the direct import of real-time CSV/TSV Files.
-
Visualize Short.io Data in Tableau
The CData ODBC driver for Short.io enables you integrate Short.io into Tableau dashboards.
-
Natively Connect to Oracle Service Cloud Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Oracle Service Cloud. Leverage the native support for ODBC in PHP.
-
Automated Continuous XML Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable XML replication to Apache Kafka.
-
How to Connect Microsoft Dataverse Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Microsoft Dataverse data in real time using natural language.
-
Getting Started with the CData Power BI Connector for QuickBooks Online
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for QuickBooks Online.
-
Use Biml to Build SSIS Tasks to Replicate Attio Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Attio to SQL Server.
-
Access Live Oracle Service Cloud Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Oracle Service Cloud from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to WooCommerce Data in Claris FileMaker Pro
Use the CData ODBC Driver for WooCommerce in FileMaker Pro to connect to WooCommerce and work with WooCommerce in your FileMaker applications.
-
Connect to Flowlu Data from PowerBuilder via JDBC
This article demonstrates how to access Flowlu from PowerBuilder using the Flowlu JDBC Driver.