CData Software - Knowledge Base
Recent Articles
-
Connect to Placid Data in JRuby
Create a simple JRuby app with access to live Placid.
-
How to Create Power BI Visual Reports with Real-Time DocuSign Data
Use CData Power BI Connectors to visualize DocuSign in Power BI.
-
Natively Connect to Cosmos DB Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Azure Cosmos DB. Leverage the native support for ODBC in PHP.
-
Prepare, Blend, and Analyze Twilio Data in Alteryx Designer (Connect AI)
Build workflows to access live Twilio for self-service data analytics.
-
Automated ShipEngine Data Replication to Teradata
Use CData Sync to Customize and automate ShipEngine replication to Teradata.
-
Replicate Google Campaign Manager 360 Data to Multiple Databases
Replicate Google Campaign Manager 360 to disparate databases with a point-and-click configuration.
-
Feed Redis Data into FineReport
How to set Redis as a JDBC data source in FineReport.
-
DataBind Controls to TigerGraph Data in C++Builder
DataBind to TigerGraph in C++Builder with standard components and controls.
-
How to Import Data from IBM Cloud Object Storage into Google Sheets
Import IBM Cloud Object Storage into a Google spreadsheet that is automatically refreshed.
-
Connect ZohoDesk to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live ZohoDesk using the CData Python MCP Server.
-
A PostgreSQL Interface for EnterpriseDB Data using the CData ODBC Driver
Use the SQL Gateway and EnterpriseDB ODBC Driver to create a PostgreSQL entry-point for data access.
-
Rapidly Develop Pinecone-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 Pinecone.
-
Manage Rootly Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Rootly.
-
Connect to MYOB AccountRight Data in Jaspersoft Studio
Execute SQL to remote MYOB AccountRight in Jaspersoft Studio.
-
Analyze Reckon Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Reckon with the CData JDBC Driver for Reckon.
-
Connect to Real-Time Microsoft Planner Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Microsoft Planner and Dataflow to import and use Microsoft Planner in Power Apps.
-
Connect to and Query SAP Business One Data in QlikView over ODBC
Create data visualizations with SAP Business One in QlikView.
-
How to connect to Webflow Data in DBVisualizer
Integrate Webflow with visual data analysis tools and data connection wizards in DBVisualizer
-
Access SharePoint Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Microsoft SharePoint from your Oracle system.
-
Integrate with Live PostgreSQL Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to PostgreSQL from the MuleSoft Anypoint Platform to integrate live PostgreSQL into custom reports and dashboards.
-
Integrate Pinterest Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Pinterest from Informatica Cloud.
-
How to Connect to Invoiced Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Invoiced. Leverage the pyodbc module for ODBC in Python.
-
How to create an RPA flow for Printful Data in UiPath Studio
Use the Printful ODBC Driver to create workflows that access real-time Printful without any coding.
-
Access Microsoft Teams Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Microsoft Teams from HeidiSQL.
-
Analyze Beeminder Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Beeminder from Power Pivot. You will use the Table Import Wizard to load Beeminder. You can visually build the import query or use any SQL supported by the driver.
-
Create Dynamic Campaigner Grids Using the Infragistics XamDataGrid
Learn how you can connect Campaigner to Infragistics XamDataGrid to build dynamic grids.
-
Connect to RabbitMQ Data from a Connection Pool in JBoss
Integrate RabbitMQ into Java servlets: Use the Management Console in JBoss to install the RabbitMQ JDBC Driver.
-
Bridge GitHub Connectivity with Apache NiFi
Access and process GitHub in Apache NiFi using the CData JDBC Driver.
-
Using the CData Software ODBC Driver for Microsoft Dataverse in PyCharm
Connect to Microsoft Dataverse as an ODBC data source in PyCharm using the CData Software ODBC Driver for Microsoft Dataverse.
-
Build a Singer.io Tap for SAP Ariba Procurement With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SAP Ariba Procurement data using
-
Automate Excel Data Replication to SAP HANA
Use CData Sync to customize and automate Microsoft Excel replication to SAP HANA.
-
Integrating Antigravity CLI with Acumatica ERP via CData CLI
Connect Acumatica ERP to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Easily Integrate Amazon Athena Data in Lazarus Pascal IDE
Learn how to easily integrate live Amazon Athena in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous Dynamics CRM Replication to Snowflake
Use CData Sync for automated, continuous, customizable Dynamics CRM replication to Snowflake.
-
Use JayDeBeApi to access Couchbase Data in Python
Use standard Python scripting and the development environment of your choice to access live Couchbase.
-
Visualize Egnyte 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 Egnyte into TIBCO Spotfire.
-
Visualize Oracle Data in TIBCO Spotfire through OData
Integrate Oracle Database into dashboards in TIBCO Spotfire.
-
Query Chargebee Data in DataGrip
Create a Data Source for Chargebee in DataGrip and use SQL to query live Chargebee.
-
Integrating OpenCode Terminal with ZarMoney 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.
-
Extend Google Sheets with NetSuite Data
Make calls to NetSuite from Google Apps Script via the API Server.
-
Object-Relational Mapping (ORM) with ZohoPeople 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 ZohoPeople into a Java-based ORM framework, Hibernate.
-
Use Claude to Talk to Your Active Directory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Active Directory for you.
-
Build AI/ML Models with Live Adobe Analytics Data using Dataiku
Connect Adobe Analytics Data with Dataiku using the CData JDBC Driver for Adobe Analytics.
-
Integrate Live Timely Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Timely to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to Microsoft Dataverse Data in DBArtisan
Use wizards in DBArtisan to configure Microsoft Dataverse (CDS) as a data source.
-
Publish Clari-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Clari.
-
Create Dashboards and Visualize Live Google Cloud Storage Data in Geckoboard
Use CData Connect AI to connect to live Google Cloud Storage and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect to Outlook Data from PowerBuilder via ADO.NET
This article demonstrates how to access Outlook from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Getting Started with the CData Python Connector for Greenplum
Learn to install and license the CData Python Connector
-
How to work with Airtable Data in Apache Spark using SQL
Access and process Airtable Data in Apache Spark using the CData Software JDBC Driver.
-
How to use SQLAlchemy ORM to access SpaceX Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SpaceX.
-
Replicate Acumatica Data in Heroku for Use in Salesforce Connect
Replicate Acumatica ERP to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Replicate Campaigner Data to Multiple Databases via the CData Sync CLI
Replicate Campaigner to disparate databases with a single configuration.
-
Connect to AfterShip Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time AfterShip using standard SQL.
-
Integrating Codex CLI with MariaDB 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.
-
Configure the CData JDBC Driver for Pipeline CRM in a Connection Pool in Tomcat
Connect to Pipeline CRM from a connection pool in Tomcat.
-
Use CData Connect AI to Access Act-On Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Act-On in the Power Pivot business intelligence tool.
-
Visualize Elorus 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 Elorus into TIBCO Spotfire.
-
Automated Continuous Freshteam Replication to Snowflake
Use CData Sync for automated, continuous, customizable Freshteam replication to Snowflake.
-
Build a Simple VCL Application for Basecamp Data
How to build a simple VCL Application to view Basecamp in RAD Studio using the CData ODBC Driver for Basecamp.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for xBase
Provide connectivity to xBase through an SAP BusinessObjects universe.
-
Create Informatica Mappings From/To an ODBC Data Source for Google Search
Create an ODBC connection to Google Search in Informatica and browse and transfer Google Search.
-
DataBind Controls to Greenplum Data in C++Builder
DataBind to Pivotal GreenPlum in C++Builder with standard components and controls.
-
Query Hive Data in DataGrip
Create a Data Source for Hive in DataGrip and use SQL to query live Apache Hive.
-
How to connect to Lakebase Data from IntelliJ
Integrate connectivity to Lakebase with wizards in IntelliJ.
-
Integrating Gumloop with LinkedIn Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on LinkedIn within automated workflows.
-
Create SSAS Tabular Models from SAP Business One Data
How to build a SQL Server Analysis Service Tabular Model from SAP Business One using CData drivers.
-
Access Live Okta Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Okta data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Getting Started with the CData SSIS Components for SAP Business Warehouse
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SAP Business Warehouse.
-
Configure the CData JDBC Driver for Highrise in a Connection Pool in Tomcat
Connect to Highrise CRM from a connection pool in Tomcat.
-
Connect to GraphQL from Asprova with CData Software ODBC Driver for GraphQL
This article shows how to connect faster to GraphQL data from Asprova.
-
Import and Visualize Figshare Data in Power View
Create data visualizations based on Figshare in Excel.
-
Operational Reporting on Freshservice Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Freshservice.
-
Connect Aha! Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Aha! using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build Facebook Ads-Connected Apps in Choreo
Use CData Connect AI to connect to Facebook Ads Data from Choreo and build custom apps using live Facebook Ads.
-
Natively Connect to Box Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Box. Leverage the native support for ODBC in PHP.
-
Automated Continuous Airtable Replication to SQLite
Use CData Sync for automated, continuous, customizable Airtable replication to SQLite.
-
Automated Continuous Hubstaff Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Hubstaff replication to delimited files (CSV/TSV).
-
Load Redshift Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Amazon Redshift to a database.
-
Build Azure Synapse-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Azure Synapse Data and create custom apps in Bubble.
-
Integrating GitHub Copilot CLI with IBM Cloudant 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.
-
Build Charts with Campaigner Data in Clear Analytics
Create dynamic charts and perform analytics based on Campaigner in Clear Analytics.
-
How to Work with SharePoint Data in ETL Validator JDBC
Connect to SharePoint from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Lakebase Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Lakebase.
-
Integrate LibreChat with Live MYOB AccountRight Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live MYOB AccountRight from within the chat interface.
-
Analyze Moosend Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Moosend with the CData JDBC Driver for Moosend.
-
Access Live Short.io Data in AWS Lambda
Connect to live Short.io in AWS Lambda using the CData JDBC Driver.
-
Provide OData Services of Teamwork Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Teamwork by developing a WCF Service Application.
-
Create Reports with HBase Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Apache HBase.
-
Create Bullhorn CRM-Connected Applications in Appsmith
Connect to Bullhorn CRM Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Bullhorn CRM.
-
View Reports on Real-Time Google Sheets Data in Power BI Report Server
Use the CData ODBC Driver for Google Sheets to visualize Google Sheets in Power BI Desktop and then publish them to Power BI Report Server.
-
Create Planio Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Planio data access from reports, embedded analytics, and more.
-
Connecting Moonlit Workflow with YouTube Analytics Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your YouTube Analytics in real time.
-
Connect to Monday.com Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Design BIRT Reports on Oracle HCM Cloud Data
Provide current Oracle HCM Cloud to your embedded analytics.
-
A PostgreSQL Interface for Tanda Data (MySQL Remoting via JDBC)
Use the Remoting features of the Tanda JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Zuora Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Zuora from Filemaker Pro on Mac.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Zoho CRM using the Model Context Protocol.
-
Query MySQL Data in DataGrip
Create a Data Source for MySQL in DataGrip and use SQL to query live MySQL.
-
Model, Search, and Visualize Live Dynamics 365 Data in ThoughtSpot
Use CData Connect AI to connect to live Microsoft Dynamics 365 for modeling, searching, and visualizing.