CData Software - Knowledge Base
Recent Articles
-
Integrate Cline with Live Presto Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Presto from within your IDE.
-
Build Automated Workflows with Live ShipStation in Workato
Use CData Connect AI to connect to live ShipStation and build automated workflows in Workato.
-
A PostgreSQL Interface for Google Cloud Storage (MySQL Remoting via JDBC)
Use the Remoting features of the Google Cloud Storage JDBC Driver to create a PostgreSQL entry-point for data access.
-
Query Drip as a MySQL Database in Node.js
Execute MySQL queries against Drip from Node.js.
-
Analyze Google Ads in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Google Ads and visualize live Google Ads in Infragistics Reveal.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Sage Business Cloud Accounting within intelligent workflows.
-
Integrate Cursor with Live Trello Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Trello from within the editor.
-
How to Connect to Live HCL Domino 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 HCL Domino for you.
-
Connect to SAP Hybris C4C in DBArtisan
Use wizards in DBArtisan to configure SAP Hybris C4C as a data source.
-
Integrate with Azure Data Lake Storage using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Azure Data Lake Storage to a JSON file on disk.
-
How to connect and process Zuora from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Zuora.
-
Use Biml to Build SSIS Tasks to Replicate SAP Ariba Source to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SAP Ariba Source to SQL Server.
-
Work with Live Google Sheets in Power Query
Use CData Connect AI to connect to Google Sheets and work with live Google Sheets in Microsoft Power Query.
-
Build MVC Applications with Connectivity to Harvest
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Harvest from an ASP.NET MVC application.
-
Connect to Microsoft Teams from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Microsoft Teams from Filemaker Pro on Mac.
-
Getting Started with the CData JDBC Driver for Bing Ads
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Bing Ads.
-
Access Typeform from MySQL in Amazon QuickSight
Connect to Typeform and build visualizations of Typeform using a MySQL Connection in Amazon QuickSight.
-
Use Dash to Build to Web Apps on Microsoft OneDrive
Create Python applications that use pandas and Dash to build Microsoft OneDrive-connected web apps.
-
How to Query Live Google Data Catalog in Perplexity MacOS Desktop
Connect to and query live Google Data Catalog in Perplexity Desktop using CData Code Assist MCP.
-
Automated Continuous SAP Concur Replication to Databricks
Use CData Sync for automated, continuous, customizable SAP Concur replication to Databricks.
-
Connect to and Query Square in QlikView over ODBC
Create data visualizations with Square in QlikView.
-
Integrate Basecamp in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Basecamp from Informatica Cloud.
-
Prepare, Blend, and Analyze IBM Informix in Alteryx Designer (ODBC)
Build workflows to access live IBM Informix for self-service data analytics.
-
Connect to SQL Analysis Services from PowerBuilder via JDBC
This article demonstrates how to access SQL Analysis Services from PowerBuilder using the SQL Analysis Services JDBC Driver.
-
Connect to Certinia in RazorSQL
Connect to Certinia from wizards and query Certinia from the GUI in the RazorSQL database management tool.
-
Use the CData Software ODBC Driver for Adobe Analytics in MicroStrategy Web
Connect to Adobe Analytics in MicroStrategy Web using the CData Software ODBC Driver for Adobe Analytics.
-
Connect to Avalara AvaTax in DBeaver
Use the CData ODBC Driver to connect to Avalara AvaTax in DBeaver.
-
Work with SAP HANA in FoxPro
Load SAP HANA into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Sybase in RazorSQL
Connect to Sybase from wizards and query Sybase from the GUI in the RazorSQL database management tool.
-
Use ChatGPT to Talk to Your BigQuery via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Google BigQuery for you.
-
Integrate with Live Active Directory in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Active Directory from the MuleSoft Anypoint Platform to integrate live Active Directory into custom reports and dashboards.
-
Object-Relational Mapping (ORM) with Oracle 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 Oracle Database into a Java-based ORM framework, Hibernate.
-
Explore Geographical Relationships in BambooHR with Power Map
Create data visualizations with BambooHR in Power Map.
-
Use the CData ODBC Driver for Power BI XMLA from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Power BI XMLA to connect to Power BI XMLA from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Power BI XMLA in Excel.
-
Access Oracle Sales from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Oracle Sales from HeidiSQL.
-
Visualize Klipfolio in Tableau
The CData ODBC driver for Klipfolio enables you integrate Klipfolio into Tableau dashboards.
-
Use the CData Software JDBC Driver for Epicor Kinetic in MicroStrategy Desktop
Connect to Epicor Kinetic in MicroStrategy Desktop using the CData Software JDBC Driver for Epicor Kinetic.
-
Working with Typeform in LINQPad
Execute LINQ queries to Typeform in LINQPad.
-
DataBind Controls to Blackbaud FE NXT in C++Builder
DataBind to Blackbaud FE NXT in C++Builder with standard components and controls.
-
Connect to Databricks in Google Apps Script via Connect AI
Use CData Connect AI to access Databricks in Google Apps Script.
-
Build Charts with Zendesk in Clear Analytics
Create dynamic charts and perform analytics based on Zendesk in Clear Analytics.
-
Build an OLAP Cube in SSAS from Salesforce Pardot
Establish a connection to Salesforce Pardot data from SQL Server Analysis Services, and use the Salesforce Pardot Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous Jira Service Management Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Jira Service Management replication to Azure SQL Database.
-
How to Connect to Live Amazon DynamoDB 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 DynamoDB through natural language.
-
Edit and Search Phoenix External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Apache Phoenix to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Phoenix objects that you can access from apps and the dashboard.
-
How to Query Live Google Ads Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Google Ads data in natural language using Python.
-
Build Data Flows from SQL Server to Zoho CRM through SSIS
Easily push SQL Server data to Zoho CRM using the CData SSIS Tasks for Zoho CRM.
-
Build a Simple VCL Application for Azure DevOps
How to build a simple VCL Application to view Azure DevOps in RAD Studio using the CData ODBC Driver for Azure DevOps.
-
Analyze Cvent with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Cvent from Power Pivot. You will use the Table Import Wizard to load Cvent. You can visually build the import query or use any SQL supported by the driver.
-
How to connect to Sage 300 from IntelliJ
Integrate connectivity to Sage 300 with wizards in IntelliJ.
-
Automate Snowflake Replication to Azure Synapse
Use CData Sync to customize and automate Snowflake replication to Azure Synapse.
-
How to update Databricks from Excel
This article explains how to transfer data from Excel to Databricks using the Excel Add-In for Databricks.
-
Visualize Live SAP Ariba Source in the Power BI Service
Use CData Connect AI to connect to live SAP Ariba Source and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Apps with Live Pivotal GreenPlum in Adalo using CData Connect AI
Use CData Connect AI to integrate live Pivotal GreenPlum into the Adalo platform and build custom mobile and web applications with real-time Pivotal GreenPlum.
-
Integrate with Live Azure Analysis Services in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Azure Analysis Services from the MuleSoft Anypoint Platform to integrate live Azure Analysis Services into custom reports and dashboards.
-
Enable the Typeform JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Typeform.
-
Deploy the ADO.NET Provider for Aha on an SSRS Report Server
Connect to Aha! 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.
-
Integrate Real-Time Access to Calendly in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Calendly in real time.
-
How to Work with Invoiced in ETL Validator JDBC
Connect to Invoiced from ETL Validator jobs using the CData Software JDBC Driver.
-
Getting Started with the CData Excel Add-In for Adobe Commerce
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Adobe Commerce.
-
Integrate HubDB with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate HubDB with External Services.
-
Build Google Calendar-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Google Calendar and build web apps with connectivity to live Google Calendar.
-
Automated Continuous Adobe Commerce Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to PostgreSQL.
-
Create SingleStore-Connected Dashboards in Grafana
Connect to SingleStore via CData Connect AI in Grafana and create custom business dashboards with real-time access to SingleStore.
-
Build Voice Agents in ElevenLabs with access to Live Microsoft Project
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Microsoft Project.
-
How to update MongoDB from Excel
This article explains how to transfer data from Excel to MongoDB using the Excel Add-In for MongoDB.
-
Edit and Search AlloyDB External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Google AlloyDB to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create AlloyDB objects that you can access from apps and the dashboard.
-
Printify Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Printify facts in real time.
-
Access Live Zoho Projects 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 Zoho Projects through MCP integration.
-
Import Real-Time Xero via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Xero Accounting in ColdFusion.
-
Automated Jira Service Management Replication to Teradata
Use CData Sync to Customize and automate Atlassian Jira Service Management replication to Teradata.
-
Build a PostgreSQL Interface for Zoho Inventory using the CData JDBC Driver
Use the Remoting features of the Zoho Inventory JDBC Driver to create a PostgreSQL entry-point for data access.
-
Bind Live Excel Online Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Excel Online data
-
Visualize Excel Online in TIBCO Spotfire through OData
Integrate Microsoft Excel Online into dashboards in TIBCO Spotfire.
-
Connect to GitHub Using the Script Function in Claris FileMaker Pro
-