CData Software - Knowledge Base
Recent Articles
-
How to Query Live Cloudant in Claude Desktop
Connect to and query live Cloudant in Claude Desktop using CData Code Assist MCP.
-
Use Dash to Build to Web Apps on Parquet
Create Python applications that use pandas and Dash to build Parquet-connected web apps.
-
How to Connect to MarkLogic in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to MarkLogic. Leverage the pyodbc module for ODBC in Python.
-
Add Cosmos DB to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Cosmos DB with the Informatica Enterprise Data Catalog to classify and organize data.
-
Create Informatica Mappings From/To a JDBC Data Source for QuickBooks Time
Create QuickBooks Time data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automate Google Spanner Replication to Azure Synapse
Use CData Sync to customize and automate Google Spanner replication to Azure Synapse.
-
ETL IBM Cloud Object Storage in Oracle Data Integrator
This article shows how to transfer IBM Cloud Object Storage into a data warehouse using Oracle Data Integrator.
-
Analyze Pinterest in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Pinterest in Microsoft R Open.
-
Access Live HarperDB Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live HarperDB data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Access NetSuite from MySQL in PHP
Connect to NetSuite through the standard MySQL libraries in PHP.
-
How to Query Live Office 365 in Claude Desktop
Connect to and query live Office 365 in Claude Desktop using CData Code Assist MCP.
-
Validate Paylocity with QuerySurge
Access and validate Paylocity in QuerySurge using the CData JDBC Driver.
-
Automated Continuous xBase Replication to SingleStore
Use CData Sync for automated, continuous, customizable xBase replication to SingleStore.
-
How to Work with Azure Table in ETL Validator JDBC
Connect to Azure Table from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Cassandra in SpagoBI
Create reports featuring live Apache Cassandra in SpagoBI Studio. Host Cassandra reports on SpagoBI Server.
-
Create Reports with Act-On in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Act-On.
-
Trigger AlloyDB IFTTT Flows in Azure App Service
This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.
-
How to create Visio diagrams from Google Spanner
Automatically update Google Spanner with the changes you make to Visio master shapes.
-
Natively Connect to BambooHR in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to BambooHR. Leverage the native support for ODBC in PHP.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Gmail using the Model Context Protocol.
-
How to Connect to Live GraphQL in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live GraphQL without replication.
-
Automated Continuous AlloyDB Replication to MySQL
Use CData Sync for automated, continuous, customizable AlloyDB replication to MySQL.
-
Migrating data from BigQuery to Google BigQuery using CData SSIS Components.
Easily push Google BigQuery to Google BigQuery using the CData SSIS Tasks for BigQuery and Google BigQuery.
-
Connect to Outreach.io through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Outreach.io using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Create Datasets from Printful in Domo Workbench and Build Visualizations of Printful in Domo
Use the CData Software ODBC Driver for Printful to create datasets from Printful in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Microsoft Exchange as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Microsoft Exchange.
-
Connect to Airtable from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Airtable to connect to Airtable and execute queries in PowerBuilder.
-
Integrate Monday.com in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Monday.com from Informatica Cloud.
-
Connect to Microsoft Teams in the Denodo Platform
Use CData driver technologies to create a virtual data source for Microsoft Teams in the Denodo Virtual DataPort Administrator.
-
Connect to Zoom in RapidMiner
Integrate Zoom with standard components and data source configuration wizards in RapidMiner Studio.
-
Replicate Snapchat Ads in Heroku for Use in Salesforce Connect
Replicate Snapchat Ads to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create Oracle-Connected Business Apps in AppSheet
Connect to Oracle via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Oracle Database.
-
Automated Continuous Microsoft Project Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Microsoft Project replication to Microsoft Access.
-
A PostgreSQL Interface for Teradata using the CData ODBC Driver
Use the SQL Gateway and Teradata ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate with Square in JReport Designer
Create charts and reports based on Square in JReport Designer.
-
Connect to Azure Analysis Services from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Azure Analysis Services using standard SQL.
-
Deploy the ADO.NET Provider for SAP HANA XS Advanced on an SSRS Report Server
Connect to SAP HANA XS Advanced 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.
-
Build MVC Applications with Connectivity to Google Search Results
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Google Search from an ASP.NET MVC application.
-
Create Reports from Oracle Financials Cloud in Looker Studio
Use CData Connect AI to gain access to live Oracle Financials Cloud and create custom reports in Looker Studio.
-
Object-Relational Mapping (ORM) with Freshdesk 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 Freshdesk into a Java-based ORM framework, Hibernate.
-
Analyze Confluence in Infragistics Reveal
Use the CData API Server to create an OData API on top of Atlassian Confluence and visualize live Atlassian Confluence in Infragistics Reveal.
-
Access Live Shopify in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Shopify from your Excel spreadsheets.
-
Build MVC Applications with Connectivity to Azure Synapse
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Azure Synapse from an ASP.NET MVC application.
-
Create Cosmos DB-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Cosmos DB from OutSystems and build custom enterprise apps using live Azure Cosmos DB.
-
Access MYOB AccountRight in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for MYOB AccountRight.
-
Automated Continuous JSON Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable JSON replication to delimited files (CSV/TSV).
-
Integrating Gumloop with Google Search Results via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Google Search within automated workflows.
-
Load Freshdesk to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Freshdesk to a database.
-
Automated Continuous Google Analytics Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Google Analytics replication to PostgreSQL.
-
Connect to ADP from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live ADP from Filemaker Pro on Mac.
-
Connect to Phoenix from PowerBuilder via ADO.NET
This article demonstrates how to access Apache Phoenix from Appeon PowerBuilder using the CData ADO.NET Provider for Phoenix.
-
Work with Amazon Athena in FoxPro
Load Amazon Athena into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create Xero-Connected Dashboards in Grafana
Connect to Xero via CData Connect AI in Grafana and create custom business dashboards with real-time access to Xero Accounting.
-
Build Apps with Live Raisers Edge NXT Using the Low-Code Development Platform of Mendix
-