CData Software - Knowledge Base
Recent Articles
-
Use JayDeBeApi to access SendPulse Data in Python
Use standard Python scripting and the development environment of your choice to access live SendPulse.
-
Connect to Azure Synapse Data from PowerBuilder via JDBC
This article demonstrates how to access Azure Synapse from PowerBuilder using the Azure Synapse JDBC Driver.
-
Integrating LangGraph with Cloudant Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on IBM Cloudant within automated workflows.
-
Query ServiceNow Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume ServiceNow entities in PHP by modeling them as objects.
-
Analyze Paylocity Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Paylocity and visualize live Paylocity in Infragistics Reveal.
-
Edit and Search Paylocity External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Paylocity to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Paylocity objects that you can access from apps and the dashboard.
-
Connect and Query Live Avro Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Apache Avro into Databricks
-
Connect to YouTube Analytics Data in DBeaver
Use the CData ODBC Driver to connect to YouTube Analytics in DBeaver.
-
How to Query Google Search Results in MySQL Workbench
Execute MySQL queries against live Google Search from MySQL Workbench.
-
Create Informatica Mappings From/To an ODBC Data Source for Discourse
Create an ODBC connection to Discourse in Informatica and browse and transfer Discourse.
-
Object-Relational Mapping (ORM) with ConstantContact 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 ConstantContact into a Java-based ORM framework, Hibernate.
-
Query LinkedIn Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume LinkedIn entities in PHP by modeling them as objects.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Power BI XMLA using the Model Context Protocol.
-
Integrating GitHub Copilot CLI with Aweber 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.
-
Object-Relational Mapping (ORM) with SparkPost 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 SparkPost into a Java-based ORM framework, Hibernate.
-
Use Agno to Talk to Your IBM Cloud Object Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your IBM Cloud Object Storage for you.
-
How to connect to Gumroad Data with Squirrel SQL client
Connect to Gumroad and execute queries in the Squirrel SQL Client.
-
Create Power BI Reports on Real-Time Rebilly Data
Use the CData ODBC Driver for Rebilly to visualize Rebilly in Power BI Desktop.
-
Access Live Azure Table Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Azure Table Storage from your Excel spreadsheets.
-
Automated Continuous Twilio Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Twilio replication to OneLake in Microsoft Fabric.
-
How to connect to Dynamics 365 Data with Squirrel SQL client
Connect to Microsoft Dynamics 365 and execute queries in the Squirrel SQL Client.
-
Integrate Theia IDE with Live Zoom Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Integrating Dataiku with Zoho CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Zoho CRM.
-
DataBind Spark Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Spark with the DevExpress Windows Forms and Web controls to provide Apache Spark SQL to a chart.
-
Integrate with ZarMoney Data in JReport Designer
Create charts and reports based on ZarMoney in JReport Designer.
-
Automated Continuous CData Connect AI Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable CData Connect AI replication to delimited files (CSV/TSV).
-
Visualize Live MarkLogic Data in the Power BI Service
Use CData Connect AI to connect to live MarkLogic and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating Antigravity CLI with ConstantContact via CData CLI
Connect ConstantContact to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect Microsoft Planner to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Microsoft Planner with IBM WebSphere for seamless data integration and connectivity.
-
Enable the Hubstaff JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Hubstaff.
-
How to connect to Onfleet Data with Squirrel SQL client
Connect to Onfleet and execute queries in the Squirrel SQL Client.
-
Edit and Search External Elasticsearch Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Elasticsearch to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Elasticsearch Data objects that you can access from apps and the dashboard.
-
Access Live SharePoint Data in TIBCO Data Virtualization
Use the SharePoint Tibco DV Adapter to create a Microsoft SharePoint data source in TIBCO Data Virtualization Studio and gain access to live Microsoft SharePoint from your TDV Server.
-
Process & Analyze Rebilly Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Rebilly Data.
-
Load SharePoint Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Microsoft SharePoint to a database.
-
How to publish and share Bitbucket Data dashboards with Tableau Server
The CData ODBC driver for Bitbucket enables you integrate Bitbucket into Tableau dashboards.
-
Connect to and Query Raisers Edge NXT Data in QlikView over ODBC
Create data visualizations with Raisers Edge NXT in QlikView.
-
Import Real-Time Procore Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Procore in ColdFusion.
-
A PostgreSQL Interface for Yelp Data using the CData ODBC Driver
Use the SQL Gateway and Yelp ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build Epicor Kinetic-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Epicor Kinetic to explore live Epicor Kinetic Data in Gemini Code Assist to assist with building Epicor Kinetic-powered applications.
-
Validate Google Campaign Manager 360 Data with QuerySurge
Access and validate Google Campaign Manager 360 in QuerySurge using the CData JDBC Driver.
-
Use the CData Software JDBC Driver for Wistia in MicroStrategy
Connect to Wistia in MicroStrategy Developer using the CData Software JDBC Driver for Wistia.
-
How to connect PolyBase to ChargeOver
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live ChargeOver.
-
Connect to JDBC-ODBC Bridge Data in Aqua Data Studio
Access JDBC-ODBC Bridge from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Import Data from DocuSign into Google Sheets
Import DocuSign into a Google spreadsheet that is automatically refreshed.
-
How to Build an ETL App for QuickBooks Data in Python with CData
Create ETL applications and real-time data pipelines for QuickBooks Desktop in Python with petl.
-
Connect to Google Cloud Storage Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Google Cloud Storage Data and connect to Google Cloud Storage in Akorbi Digital RunMyProcess.
-
Connect to TaxJar Data from PowerBuilder via ADO.NET
This article demonstrates how to access TaxJar from Appeon PowerBuilder using the CData ADO.NET Provider for TaxJar.
-
Connecting Agentforce with ServiceNow 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 ServiceNow for you.
-
Connect to Bullhorn CRM Data in DBeaver
Use the CData ODBC Driver to connect to Bullhorn CRM in DBeaver.
-
Build Act-On-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Act-On Data and create custom apps in Bubble.
-
Design BIRT Reports on Postmark Data
Provide current Postmark to your embedded analytics.
-
Automate Tasks in Power Automate Using the CData API Server
Automate NetSuite actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Integrating PolarTeamPro Data in Talend Cloud Data Management Platform
Connect PolarTeamPro Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Replicate Multiple Printify Accounts
Replicate multiple Printify accounts to one or many databases.
-
How to Connect Flowise AI Agents to Live Blackbaud FE NXT Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Blackbaud FE NXT without replication.
-
Prepare, Blend, and Analyze SAP Data in Alteryx Designer (ODBC)
Build workflows to access live SAP ERP/NetWeaver for self-service data analytics.
-
Query, Visualize, and Share live OneNote Data in Redash
Use CData Connect AI to connect to live Microsoft OneNote in Redash for querying, visualizing, and sharing.
-
Build Phoenix-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Phoenix Data from Zoho Analytics and import live Apache Phoenix.
-
How to Visualize Authorize.Net Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Authorize.Net in Python.
-
How to Create Power BI Visual Reports with Real-Time Twitter Ads Data
Use CData Power BI Connectors to visualize Twitter Ads in Power BI.
-
Access SAP SuccessFactors LMS Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SAP SuccessFactors LMS from HeidiSQL.
-
Access Live WordPress Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live WordPress through MCP integration.
-
Publish ChartMogul-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live ChartMogul.
-
Integrate with ScrapingBee Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ScrapingBee to a JSON file on disk.
-
Use Databricks Agent Bricks to Talk to Your CockroachDB Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your CockroachDB for you.
-
Create SuiteCRM Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SuiteCRM data access from reports, embedded analytics, and more.
-
How to Query Live Zoho Creator Data in Perplexity MacOS Desktop
Connect to and query live Zoho Creator Data in Perplexity Desktop using CData MCP Server.
-
Automated Continuous Aircall Replication to SQLite
Use CData Sync for automated, continuous, customizable Aircall replication to SQLite.
-
Connect to Everhour Data in CloverDX (formerly CloverETL)
Transfer Everhour using the visual workflow in the CloverDX data integration tool.
-
Integrating OpenCode Terminal with Basecamp 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.
-
Connect to Neo4J Data in Aqua Data Studio
Access Neo4J from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Connect Flowise AI Agents to Live Google Sheets Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Google Sheets without replication.
-
Contentful Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Contentful facts in real time.
-
Getting Started with the CData Tableau Connector for Parquet
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Parquet.
-
Connect to LDAP Objects in Claris FileMaker Pro
Use the CData ODBC Driver for LDAP in FileMaker Pro to connect to LDAP and work with LDAP in your FileMaker applications.
-
Create Dynamic Wrike Grids Using the Infragistics XamDataGrid
Learn how you can connect Wrike to Infragistics XamDataGrid to build dynamic grids.
-
Connect ClickUp to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect ClickUp with IBM WebSphere for seamless data integration and connectivity.
-
Publish GitHub-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live GitHub.
-
How to Connect to Live Google Analytics 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 Google Analytics for you.
-
Connect to Vercel from a Connection Pool in WebLogic
Use the CData JDBC Driver for Vercel to connect to Vercel from Web applications running on WebLogic.
-
Integrate with Live Sugar CRM Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Sugar CRM from the MuleSoft Anypoint Platform to integrate live Sugar CRM into custom reports and dashboards.
-
How to Connect to Live Oracle Financials Cloud 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 Oracle Financials Cloud through natural language.
-
Integrating Excel Data in Talend Cloud Data Management Platform
Connect Excel Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Excel.
-
Connect to SAP Hybris C4C Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to Everhour Data from PowerBuilder via JDBC
This article demonstrates how to access Everhour from PowerBuilder using the Everhour JDBC Driver.
-
Create SSAS Tabular Models from Avaza Data
How to build a SQL Server Analysis Service Tabular Model from Avaza using CData drivers.
-
Access Amazon Athena Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Amazon Athena from HeidiSQL.
-
Prepare, Blend, and Analyze SAP Business One Data in Alteryx Designer (ODBC)
Build workflows to access live SAP Business One for self-service data analytics.
-
Build Apps with Live Simplesat Data Using the Low-Code Development Platform of Mendix
Connect Simplesat with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to Presto in SpagoBI
Create reports featuring live Presto in SpagoBI Studio. Host Presto reports on SpagoBI Server.
-
Analyze Google Ad Manager Data in Looker
Use CData Connect AI to connect to Google Ad Manager Data from Looker and build custom apps using live Google Ad Manager.
-
How to connect to Cloudant Data in DBVisualizer
Integrate IBM Cloudant with visual data analysis tools and data connection wizards in DBVisualizer
-
A PostgreSQL Interface for Jodoo Data (MySQL Remoting via JDBC)
Use the Remoting features of the Jodoo JDBC Driver to create a PostgreSQL entry-point for data access.
-
Publish Asana-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Asana.
-
Integrating LlamaIndex with SurveyMonkey Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on SurveyMonkey in real time.
-
Use Grok to Talk to Your Freshservice Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Freshservice for you.
-
How to Work with Humanity Data in ETL Validator JDBC
Connect to Humanity from ETL Validator jobs using the CData Software JDBC Driver.
-
DataBind Controls to eBay Analytics Data in Delphi
DataBind to eBay Analytics in Delphi with standard data access components and controls.
-
Manage Salesforce Data 360 Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Salesforce Data 360.