CData Software - Knowledge Base
Recent Articles
-
Connect to WordPress Data from PowerBuilder via ADO.NET
This article demonstrates how to access WordPress from Appeon PowerBuilder using the CData ADO.NET Provider for WordPress.
-
How to Connect to Live Sage Intacct 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 Sage Intacct for you.
-
How to Connect to IBM Cloud Object Storage Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to IBM Cloud Object Storage. Leverage the pyodbc module for ODBC in Python.
-
How to work with ActiveCampaign Data in Apache Spark using SQL
Access and process ActiveCampaign Data in Apache Spark using the CData Software JDBC Driver.
-
Cvent Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Cvent facts in real time.
-
How to connect PolyBase to Google Calendar
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google Calendar.
-
Use Biml to Build SSIS Tasks to Replicate BigQuery Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Google BigQuery to SQL Server.
-
Build MariaDB-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live MariaDB.
-
Visualize ShipStation Data in Sisense
Create an ElastiCube in Sisense app with access to ShipStation.
-
Stream Egnyte Data into Apache Kafka Topics
Access and stream Egnyte in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate QuickBooks Online Data in Pentaho Data Integration
Build ETL pipelines based on QuickBooks Online in the Pentaho Data Integration tool.
-
Getting Started with the CData ADO.NET Provider for EmailOctopus
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
SAP Concur Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SAP Concur facts in real time.
-
Create Twitter Ads Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Twitter Ads from PowerBI.com to create Power BI Dataflows with real-time data.
-
Manage CampaignMonitor Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for CampaignMonitor.
-
Use the CData ODBC Driver for Qualaroo in Microsoft Power Query
You can use the CData Qualaroo ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Qualaroo into Microsoft Power Query.
-
Deploy the ADO.NET Provider for Parquet on an SSRS Report Server
Connect to Apache Parquet 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.
-
Query Procore Data in ColdFusion
Write standard ColdFusion data access code to connect to Procore.
-
Create a Data Access Object for Neo4J Data using JDBI
A brief overview of creating a SQL Object API for Neo4J in JDBI.
-
Use ChatGPT to Talk to Your Azure Table Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Azure Table Storage for you.
-
How to connect and process Nuclia from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Nuclia.
-
Connect to Drift Data in Jaspersoft Studio
Execute SQL to remote Drift in Jaspersoft Studio.
-
Bidirectional Access to Amazon DynamoDB Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Amazon DynamoDB in Filemaker Pro for Mac or Windows.
-
Build Semantic Layer Views for Redshift Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Amazon Redshift.
-
Getting Started with the CData Power BI Connector for SurveyMonkey
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for SurveyMonkey.
-
Connect to RabbitMQ Data from PowerBuilder via JDBC
This article demonstrates how to access RabbitMQ from PowerBuilder using the RabbitMQ JDBC Driver.
-
Getting Started with the CData Tableau Connector for SurveyMonkey
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for SurveyMonkey.
-
Visualize Cvent Data in Tableau
The CData ODBC driver for Cvent enables you integrate Cvent into Tableau dashboards.
-
Connect to NetSuite Data in RazorSQL
Connect to NetSuite from wizards and query NetSuite CRM & ERP from the GUI in the RazorSQL database management tool.
-
Publish TigerGraph-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live TigerGraph.
-
Automated Continuous Google Search Replication to Oracle
Use CData Sync for automated, continuous, customizable Google Search replication to Oracle.
-
Prepare, Blend, and Analyze Autopilot Data in Alteryx Designer (ODBC)
Build workflows to access live Autopilot for self-service data analytics.
-
Import Real-Time Close Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Close in ColdFusion.
-
Write a Simple Go Application to work with GitHub Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to GitHub.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Miro
Provide connectivity to Miro through an SAP BusinessObjects universe.
-
Getting Started with the CData SSIS Components for Sybase
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Sybase.
-
Automate Optimizely Data Replication to Couchbase
Use CData Sync to Customize and automate Optimizely replication to Couchbase.
-
Integrate with NASA Data in JReport Designer
Create charts and reports based on NASA in JReport Designer.
-
Create Cosmos DB-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Cosmos DB Data from Klipfolio and build custom visualizations using live Azure Cosmos DB.
-
Build Visualizations of Mouseflow Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Mouseflow in Birst.
-
How to Connect to & Open Mailgun Data in Microsoft Excel
This article uses the CData ODBC driver for Mailgun to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Enable the Mixpanel JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Mixpanel.
-
Integrate with Factorial Data in JReport Designer
Create charts and reports based on Factorial in JReport Designer.
-
Access PDFMonkey Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live PDFMonkey from HeidiSQL.
-
Analyze Bullhorn CRM Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Bullhorn CRM and visualize Bullhorn CRM in SAP Analytics Cloud.
-
Create Dynamic Acumatica Grids Using the Infragistics XamDataGrid
Learn how you can connect Acumatica to Infragistics XamDataGrid to build dynamic grids.
-
Work with SFTP Data in FoxPro
Load SFTP into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Access Azure Table Data Using Entity Framework
This article shows how to access Azure Table Storage using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrate Live Miro Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Miro to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to Apollo Data in RapidMiner
Integrate Apollo with standard components and data source configuration wizards in RapidMiner Studio.
-
Query, Visualize, and Share live Adobe Analytics Data in Redash
Use CData Connect AI to connect to live Adobe Analytics in Redash for querying, visualizing, and sharing.
-
Build Pipelines with Live API Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to API from Google Cloud Data Fusion, enabling the integration of live API into the building and management of effective data pipelines.
-
Integrating LangGraph with SendGrid Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on SendGrid within automated workflows.
-
Natively Connect to Facebook Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Facebook. Leverage the native support for ODBC in PHP.
-
Use the CData Software JDBC Driver for LinkedIn in MicroStrategy Desktop
Connect to LinkedIn in MicroStrategy Desktop using the CData Software JDBC Driver for LinkedIn.
-
Import and Visualize Discord Data in Power View
Create data visualizations based on Discord in Excel.
-
Automated Continuous Flowlu Replication to MySQL
Use CData Sync for automated, continuous, customizable Flowlu replication to MySQL.
-
Visualize Live Active Directory Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Active Directory.
-
Automated Continuous iContact Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable iContact replication to delimited files (CSV/TSV).
-
Connect to Impala Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Apache Impala using standard SQL.
-
Easily Integrate Grafana Data in Lazarus Pascal IDE
Learn how to easily integrate live Grafana in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connecting Mastra with ShipStation Data 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 ShipStation, no replication required.
-
How to connect Amazon QuickSight to Cvent Data
Create a connection to Cvent in CData Connect AI and insert Cvent into Amazon QuickSight SPICE to build interactive dashboards.
-
Integrating Codex CLI with Shortcut 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.
-
Visualize Live NASA Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live NASA.
-
Import NetSuite SuiteAnalytics Data Using Azure Data Factory
Use CData Connect AI to connect to NetSuite SuiteAnalytics Data from Azure Data Factory and import live NetSuite SuiteAnalytics.
-
Natively Connect to Microsoft Dataverse Data in PHP
The CData ODBC driver for Microsoft Dataverse enables you to create PHP applications with connectivity to Microsoft Dataverse (CDS). Leverage the native support for ODBC in PHP.
-
Automated Continuous AfterShip Replication to AlloyDB
Use CData Sync for automated, continuous, customizable AfterShip replication to AlloyDB.
-
Load Paddle Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Paddle to a database.
-
Feed Adobe Commerce Data into FineReport
How to set Adobe Commerce as a JDBC data source in FineReport.
-
Publish Helpscout-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Helpscout.
-
Integrate Airtable with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Airtable with External Services.
-
Connect to Workday Data in Jaspersoft Studio
Execute SQL to remote Workday in Jaspersoft Studio.
-
How to Access Live Mistral AI Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Mistral AI enables you to integrate Mistral AI into workflows built using Microsoft Power Automate Desktop.
-
Use the CData Software ODBC Driver for Close in MicroStrategy
Connect to Close in MicroStrategy Developer using the CData Software ODBC Driver for Close.
-
Visualize FormSite 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 FormSite into TIBCO Spotfire.
-
Use the CData Software JDBC Driver for PivotalTracker in MicroStrategy
Connect to PivotalTracker in MicroStrategy Developer using the CData Software JDBC Driver for PivotalTracker.
-
Replicate SendInBlue Data to Multiple Databases
Replicate SendInBlue to disparate databases with a point-and-click configuration.
-
Write a Simple Go Application to work with Hubstaff Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Hubstaff.
-
Connect to Hugging Face Data in CloverDX (formerly CloverETL)
Transfer Hugging Face using the visual workflow in the CloverDX data integration tool.
-
Publish Reports with QuickBooks Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date QuickBooks Desktop.
-
A PostgreSQL Interface for Shortcut Data (MySQL Remoting via JDBC)
Use the Remoting features of the Shortcut JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Semantic Layer Views for eBay Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for eBay.
-
Migrating data from Elasticsearch to Google BigQuery using CData SSIS Components.
Easily push Elasticsearch to Google BigQuery using the CData SSIS Tasks for Elasticsearch and Google BigQuery.
-
How to Connect to & Open Zoom Data in Microsoft Excel
This article uses the CData ODBC driver for Zoom to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Working with Salesforce Marketing Data in LINQPad
Execute LINQ queries to Salesforce Marketing Cloud in LINQPad.
-
Connect to Suadeo Data in CloverDX (formerly CloverETL)
Transfer Suadeo using the visual workflow in the CloverDX data integration tool.
-
View Reports on Real-Time MailerLite Data in Power BI Report Server
Use the CData ODBC Driver for MailerLite to visualize MailerLite in Power BI Desktop and then publish them to Power BI Report Server.
-
Create Datasets from Spotify in Domo Workbench and Build Visualizations of Spotify Data in Domo
Use the CData Software ODBC Driver for Spotify to create datasets from Spotify in Domo Workbench and then build visualizations in the Domo service.
-
Analyze Google Calendar Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Google Calendar in Microsoft R Open.
-
How to connect PolyBase to Amplitude
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Amplitude.
-
Create Informatica Mappings From/To an ODBC Data Source for Retently
Create an ODBC connection to Retently in Informatica and browse and transfer Retently.
-
Query Twitter Ads Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Twitter Ads entities in PHP by modeling them as objects.
-
Connect to Oracle Financials Cloud Data in Ruby
Connect to Oracle Financials Cloud in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Access Live SAP SuccessFactors LMS Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live SAP SuccessFactors LMS from your Excel spreadsheets.
-
Build Beeminder-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Beeminder.
-
How to Connect the Power BI Service to FormSite: Complete Guide
Connect to the CData Software Power BI Connector for FormSite from PowerBI.com to provide real-time FormSite across the organization.
-
Excel Spreadsheet Automation on Outreach.io Data with the QUERY Formula
Pull data from Outreach.io, automate spreadsheets, and more with the QUERY formula.
-
Enable the Google Ad Manager JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Google Ad Manager.
-
Connect to and Visualize Live Microsoft Teams Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Microsoft Teams.