CData Software - Knowledge Base
Recent Articles
-
Automated Continuous HubSpot Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable HubSpot replication to Google BigQuery.
-
Build IBM Cloud Object Storage-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for IBM Cloud Object Storage to explore live IBM Cloud Object Storage Data in Gemini Code Assist to assist with building IBM Cloud Object Storage-powered applications.
-
How to import SpaceX Data into Apache Solr
Use the CData Software JDBC Driver for SpaceX in Data Import Handler and create an automated import of SpaceX to Apache Solr Enterprise Search platform.
-
Connect to Office 365 Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Office 365 Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to ZohoMarketingHub Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to ZohoMarketingHub and work with ZohoMarketingHub in your FileMaker applications.
-
Create Jodoo Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Jodoo data access from reports, embedded analytics, and more.
-
Connect to Dynamics CRM Data in ACL Analytics
Connect to Microsoft Dynamics CRM via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Microsoft Dynamics CRM.
-
Create SAP Business One Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SAP Business One from PowerBI.com to create Power BI Dataflows with real-time data.
-
SharePoint Reporting in OBIEE with the SharePoint JDBC Driver
Deploy the SharePoint JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrating Kiro CLI with Postmark 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.
-
Import Neo4J Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Neo4J Data and provide access to live Neo4J for custom reports in the Power BI Service.
-
How to load Cloudflare data into Elasticsearch via Logstash
Introducing a simple method to load Cloudflare data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Viewing PDFMonkey Data in RAD Studio Data Explorer
How to view PDFMonkey in RAD Studio Data Explorer using the CData ODBC Driver for PDFMonkey.
-
Connect to Zoom Data from HeidiSQL
Use CData Connect AI to connect to and query live Zoom from HeidiSQL.
-
Visualize Live HDFS Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Apache HDFS.
-
Query Bannerbear Data as a MySQL Database in Node.js
Execute MySQL queries against Bannerbear from Node.js.
-
Integrate Live SFTP Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live SFTP to Blue Prism using the CData ODBC Driver for SFTP to create automated workflows for repetitive business tasks.
-
Getting Started with the CData Python Connector for SAS xpt
Learn to install and license the CData Python Connector
-
How to connect and process PDFMonkey from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live PDFMonkey.
-
Integrate Goose with Live Apollo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Apollo from within the local AI agent.
-
Replicate FHIR Data in Heroku for Use in Salesforce Connect
Replicate FHIR to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create Apollo-Connected Dashboards in Grafana
Connect to Apollo Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Apollo.
-
How to Connect to Live Amazon S3 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 Amazon S3 through natural language.
-
Integrate Theia IDE with Live Salesforce CRM Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Use the CData ODBC Driver for Auth0 from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Auth0 to connect to Auth0 from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Auth0 in Excel.
-
Connect to SAP SuccessFactors LMS Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Visualize Pushbullet Data in Sisense
Create an ElastiCube in Sisense app with access to Pushbullet.
-
Operational Reporting on Jira Assets Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Jira Assets.
-
Analyze HubSpot Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for HubSpot from Power Pivot. You will use the Table Import Wizard to load HubSpot. You can visually build the import query or use any SQL supported by the driver.
-
Use the CData Software JDBC Driver for Google Directory in MicroStrategy Desktop
Connect to Google Directory in MicroStrategy Desktop using the CData Software JDBC Driver for Google Directory.
-
Analyze NetSuite Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of NetSuite CRM & ERP and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Create Dashboards and Visualize Live Box Data in Geckoboard
Use CData Connect AI to connect to live Box and create dashboards for real-time monitoring and visualization in Geckoboard.
-
DataBind Controls to TaxJar Data in Delphi
DataBind to TaxJar in Delphi with standard data access components and controls.
-
Connect to GitHub Data in ACL Analytics
Connect to GitHub via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to GitHub.
-
Publish Crystal Reports on Redshift Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Amazon Redshift.
-
Create Dynamic DB2 Grids Using the Infragistics XamDataGrid
Learn how you can connect DB2 to Infragistics XamDataGrid to build dynamic grids.
-
Integrating Codex CLI with Templated 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.
-
Viewing SAP BusinessObjects BI Data in RAD Studio Data Explorer
How to view SAP BusinessObjects BI in RAD Studio Data Explorer using the CData ODBC Driver for SAP BusinessObjects BI.
-
Integrating Boomi Agentstudio with Lakebase Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Lakebase, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Create Vault CRM-Connected Dashboards in Grafana
Connect to Vault CRM Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Veeva Vault & Vault CRM.
-
Build Apps with Live Rootly Data Using the Low-Code Development Platform of Mendix
Connect Rootly with Mendix to build apps using the CData API Driver for JDBC.
-
Use the CData Software JDBC Driver for Gorgias in MicroStrategy Desktop
Connect to Gorgias in MicroStrategy Desktop using the CData Software JDBC Driver for Gorgias.
-
Use the CData SSIS Components to Insert New or Update Existing LDAP Records from SQL Server
Easily push SQL Server data to LDAP using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into LDAP or update existing records with data from a SQL Server database.
-
Accelo Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Accelo facts in real time.
-
Stream Klaviyo Data into Apache Kafka Topics
Access and stream Klaviyo in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Salesforce CRM Analytics Data in Jaspersoft Studio
Execute SQL to remote Salesforce CRM Analytics in Jaspersoft Studio.
-
How to Seamlessly Import LDAP Data into IBM SPSS Modeler
Integrate LDAP data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Query Pushbullet Data in DataGrip
Create a Data Source for Pushbullet in DataGrip and use SQL to query live Pushbullet.
-
How to create SendInBlue federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SendInBlue in MySQL .
-
Integrating Salesforce Marketing Data in Talend Cloud Data Management Platform
Connect Salesforce Marketing Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Salesforce Marketing.
-
Getting Started with the CData ADO.NET Provider for Bitly
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Automated Continuous Power BI XMLA Replication to SingleStore
Use CData Sync for automated, continuous, customizable Power BI XMLA replication to SingleStore.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Azure Synapse actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
How to Access LightSpeedRetail Data Using Entity Framework
This article shows how to access LightSpeedRetail using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Create Greenhouse-Connected Applications in Appsmith
Connect to Greenhouse Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Greenhouse.
-
Connect to Coinbase Data from PowerBuilder via JDBC
This article demonstrates how to access Coinbase from PowerBuilder using the Coinbase JDBC Driver.
-
Connect to Microsoft Dataverse Data in RazorSQL
Connect to Microsoft Dataverse from wizards and query Microsoft Dataverse (CDS) from the GUI in the RazorSQL database management tool.
-
DataBind Pushbullet Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Pushbullet to a chart.
-
Access Perplexity Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Perplexity from HeidiSQL.
-
Access Live ZeroBounce Data in AWS Lambda
Connect to live ZeroBounce in AWS Lambda using the CData JDBC Driver.
-
Connect to Campaigner Data in DBeaver
Use the CData ODBC Driver to connect to Campaigner in DBeaver.
-
Viewing Airtable Data in RAD Studio Data Explorer
How to view Airtable in RAD Studio Data Explorer using the CData ODBC Driver for Airtable.
-
Visualize Stack Exchange Data in Tableau
The CData ODBC driver for Stack Exchange enables you integrate Stack Exchange into Tableau dashboards.
-
Connect to Google Calendar Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Google Calendar to connect to Google Calendar and execute queries in PowerBuilder.
-
Use the CData Software JDBC Driver for ChartMogul in MicroStrategy Desktop
Connect to ChartMogul in MicroStrategy Desktop using the CData Software JDBC Driver for ChartMogul.
-
How to Access BambooHR Data Using Entity Framework
This article shows how to access BambooHR using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Connect to Live Paylocity Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Paylocity for you.
-
Visualize Live SAP Ariba Procurement Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SAP Ariba Procurement using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Dashboards with Adobe Experience Manager Data in Dundas BI
Create dynamic dashboards and perform analytics based on Adobe Experience Manager in Dundas BI.
-
Build MailChimp-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to MailChimp and build web apps with connectivity to live MailChimp.
-
Load Email Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Email to a database.
-
Build a Simple VCL Application for Freshteam Data
How to build a simple VCL Application to view Freshteam in RAD Studio using the CData ODBC Driver for Freshteam.
-
Access HDFS Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Apache HDFS from your Oracle system.
-
Create Trello-Connected Nintex Workflows
Use CData Connect AI to connect to Trello Data from Nintex Workflow Cloud and build custom workflows using live Trello.
-
Bidirectional Access to Discourse Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Discourse in Filemaker Pro for Mac or Windows.
-
Explore Geographical Relationships in Tally Data with Power Map
Create data visualizations with Tally ERP in Power Map.
-
Connect to and Query ShipStation Data in QlikView over ODBC
Create data visualizations with ShipStation in QlikView.
-
Integrate LibreChat with Live Excel Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Microsoft Excel Online from within the chat interface.
-
How to connect to Tickspot Data in DBVisualizer
Integrate Tickspot with visual data analysis tools and data connection wizards in DBVisualizer
-
Visualize Typeform Data in Sisense
Create an ElastiCube in Sisense app with access to Typeform.
-
DataBind Controls to ZohoExpense Data in C++Builder
DataBind to ZohoExpense in C++Builder with standard components and controls.
-
Create Odoo-Connected Nintex Workflows
Use CData Connect AI to connect to Odoo Data from Nintex Workflow Cloud and build custom workflows using live Odoo ERP.
-
Create MailerLite Dataflows on PowerBI.com
Connect to the CData Power BI Connector for MailerLite from PowerBI.com to create Power BI Dataflows with real-time data.
-
Visualize Anaplan Data in Sisense
Create an ElastiCube in Sisense app with access to Anaplan.
-
Integrate Helpscout Data in Pentaho Data Integration
Build ETL pipelines based on Helpscout in the Pentaho Data Integration tool.
-
Connect to Gorgias Data in Aqua Data Studio
Access Gorgias from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to PingOne Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for PingOne.
-
Automate Tasks in Power Automate Using the CData API Server
Automate QuickBooks actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Getting Started with the CData Power BI Connector for Bullhorn CRM
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Bullhorn CRM.
-
Getting Started with the CData ADO.NET Provider for Kintone
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Kintone.
-
Connect to xBase Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Add GetResponse Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for GetResponse with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Connect Excel Online 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 Excel Online data in real time using natural language.
-
Connect to SAP Ariba Source Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for SAP Ariba Source in Airbyte.
-
Connecting Mastra with SAP HANA 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 SAP HANA, no replication required.
-
Embedded Web Server (.NET) - Potential Medium Security Vulnerability
CData is aware of a potential security issue that affects customers of CData applications who are running on Windows and using the .NET Embedded Web Server.
-
Integrate Goose with Live SingleStore Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live SingleStore from within the local AI agent.
-
Connect to PivotalTracker Data in Ruby
Connect to PivotalTracker in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous Snapchat Ads Replication to SQL Server
Use CData Sync for automated, continuous, customizable Snapchat Ads replication to SQL Server.
-
Integrating Kiro CLI with Ontraport 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.