CData Software - Knowledge Base
Recent Articles
-
Create Raisers Edge NXT-Connected Applications in Appsmith
Connect to Raisers Edge NXT via CData Connect AI in Appsmith and create custom business applications with real-time access to Raisers Edge NXT.
-
Visualize Live BambooHR of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live BambooHR using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Parquet in DBArtisan
Use wizards in DBArtisan to configure Apache Parquet as a data source.
-
Automated Continuous Wave Financial Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Wave Financial replication to Apache Cassandra.
-
Build Pipelines with Live Zuora in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Zuora from Google Cloud Data Fusion, enabling the integration of live Zuora into the building and management of effective data pipelines.
-
Create Power BI Reports on Real-Time Impala
Use the CData ODBC Driver for Impala to visualize Apache Impala in Power BI Desktop.
-
Extract, Transform, and Load Drip in Informatica PowerCenter
Create a simple Workflow for Drip in Informatica PowerCenter.
-
How to Connect to Live Google Drive from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Google Drive for you.
-
Create WordPress Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time WordPress data access from reports, embedded analytics, and more.
-
How to load Confluence data into Elasticsearch via Logstash
Introducing a simple method to load Confluence data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Replicate Azure Data Lake Storage in Heroku for Use in Salesforce Connect
Replicate Azure Data Lake Storage to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build AI Agents with AlloyDB Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can
-
Consume SQL Server OData Feeds in PowerBuilder
This article demonstrates how to consume Microsoft SQL Server as OData feeds from PowerBuilder using the API Server.
-
How to use SQLAlchemy ORM to access NetSuite in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of NetSuite CRM & ERP.
-
Migrating data from Google Cloud Storage to Snowflake using CData SSIS Components.
Easily push Google Cloud Storage to Snowflake using the CData SSIS Tasks for Google Cloud Storage and Snowflake.
-
How to connect to SAS Data Sets in DBVisualizer
Integrate SAS Data Sets with visual data analysis tools and data connection wizards in DBVisualizer
-
Replicate Multiple Zendesk Accounts
Replicate multiple Zendesk accounts to one or many databases.
-
Automated Continuous GitHub Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable GitHub replication to Google BigQuery.
-
Work with Live Outreach.io in Power Query
Use CData Connect AI to connect to Outreach.io and work with live Outreach.io in Microsoft Power Query.
-
How to integrate Sage Intacct with Apache Airflow
Access and process Sage Intacct in Apache Airflow using the CData JDBC Driver.
-
Use Azure AI Foundry to Talk to Your Microsoft Teams via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Microsoft Teams for you.
-
Use the CData Software ODBC Driver for LDAP in MicroStrategy Desktop
Connect to LDAP in MicroStrategy Desktop using the CData Software ODBC Driver for LDAP.
-
Access Amazon S3 from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Amazon S3 from HeidiSQL.
-
Build QuickBooks Online-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to QuickBooks Online from Zoho Analytics and import live QuickBooks Online.
-
Object-Relational Mapping (ORM) with Zoho Creator 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 Zoho Creator into a Java-based ORM framework, Hibernate.
-
Stream Quickbase into Apache Kafka Topics
Access and stream Quickbase in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to connect to Google Spanner with Squirrel SQL client
Connect to Google Spanner and execute queries in the Squirrel SQL Client.
-
Publish Crystal Reports on Monday.com
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Monday.com.
-
Automated Continuous Shippo Replication to Oracle
Use CData Sync for automated, continuous, customizable Shippo replication to Oracle.
-
Build Apps with Live SurveyMonkey in Adalo using CData Connect AI
Use CData Connect AI to integrate live SurveyMonkey into the Adalo platform and build custom mobile and web applications with real-time SurveyMonkey.
-
Integrate Monday.com into Automated Tasks with Power Automate
Use CData Connect AI to connect to Monday.com and integrate live Monday.com into your Power Automate tasks.
-
Prepare, Blend, and Analyze Google Directory in Alteryx Designer (Connect AI)
Build workflows to access live Google Directory for self-service data analytics.
-
Validate Kafka with QuerySurge
Access and validate Apache Kafka in QuerySurge using the CData JDBC Driver.
-
Automated Continuous ClickUp Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable ClickUp replication to PostgreSQL.
-
Import XML into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access XML Files. In this article, you will use the OData format to import XML Files into Microsoft Power Query.
-
Connect to Azure Synapse from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Azure Synapse to connect to Azure Synapse and execute queries in PowerBuilder.
-
How to Connect to Live Outreach.io from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Outreach.io for you.
-
Connect to Zuora in HULFT Integrate
Connect to Zuora as a JDBC data source in HULFT Integrate
-
View Reports on Real-Time EnterpriseDB in Power BI Report Server
Use the CData ODBC Driver for EnterpriseDB to visualize EnterpriseDB in Power BI Desktop and then publish them to Power BI Report Server.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SingleStore
Provide connectivity to SingleStore through an SAP BusinessObjects universe.
-
Automated Continuous Highrise Replication to Snowflake
Use CData Sync for automated, continuous, customizable Highrise replication to Snowflake.
-
Automate Epicor Kinetic Replication to Azure Synapse
Use CData Sync to customize and automate Epicor Kinetic replication to Azure Synapse.
-
Query, Visualize, and Share live Google Directory in Redash
Use CData Connect AI to connect to live Google Directory in Redash for querying, visualizing, and sharing.
-
Use JayDeBeApi to access Redshift in Python
Use standard Python scripting and the development environment of your choice to access live Amazon Redshift.
-
Load Odoo to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Odoo ERP to a database.
-
Connect to SAP Concur in RapidMiner
Integrate SAP Concur with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Query Live Basecamp Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Basecamp data in natural language using Python.
-
Import Real-Time SAP Netweaver Gateway via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SAP Netweaver Gateway in ColdFusion.
-
Explore Geographical Relationships in Invoiced with Power Map
Create data visualizations with Invoiced in Power Map.
-
Analyze Microsoft OneDrive with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Microsoft OneDrive from Power Pivot. You will use the Table Import Wizard to load Microsoft OneDrive. You can visually build the import query or use any SQL supported by the driver.
-
Connect to SingleStore from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SingleStore to connect to SingleStore and execute queries in PowerBuilder.
-
Query Xero from Node.js
Use the OData endpoint of the CData API Server to connect to your Xero Accounting and perform CRUD operations on Xero from Node.js.
-
How to Build an ETL App for Jira Service Management in Python with CData
Create ETL applications and real-time data pipelines for Atlassian Jira Service Management in Python with petl.
-
Connect to Highrise from a Connection Pool in JBoss
Integrate Highrise CRM into Java servlets: Use the Management Console in JBoss to install the Highrise JDBC Driver.
-
Import Redshift into the Power BI Service for Visualizations
Use CData Connect AI to connect to Redshift and provide access to live Amazon Redshift for custom reports in the Power BI Service.
-
Create Dynamic Google Ad Manager Grids Using the Infragistics XamDataGrid
Learn how you can connect Google Ad Manager to Infragistics XamDataGrid to build dynamic grids.
-
Use Azure AI Foundry to Talk to Your YouTube Analytics via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your YouTube Analytics for you.
-
Extend Google Sheets with Basecamp
Make calls to the API Server from Google Apps Script.
-
Query SAP HANA in ColdFusion
Write standard ColdFusion data access code to connect to SAP HANA.
-
Work with SQL Analysis Services in FoxPro
Load SQL Analysis Services into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous Airtable Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Airtable replication to Amazon Redshift.
-
Use the CData ODBC Driver for Zuora in Microsoft Power Query
You can use the CData Zuora ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Zuora into Microsoft Power Query.
-
Visualize Live Airtable of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Airtable using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Connect to & Open MarkLogic in Microsoft Excel
This article uses the CData ODBC driver for MarkLogic to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automate Access Replication to Couchbase
Use CData Sync to Customize and automate Microsoft Access replication to Couchbase.
-
Query Office 365 in ColdFusion
Write standard ColdFusion data access code to connect to Microsoft Office 365.
-
Create Data Visualizations in Cognos BI with Google Sheets
Access Google Sheets as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to connect PolyBase to Amazon S3
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Amazon S3.
-
Automated Continuous Aha Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Aha replication to IBM DB2.
-
Connect to Amazon S3 as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Amazon S3.
-
Use Biml to Build SSIS Tasks to Replicate Office 365 to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Microsoft Office 365 to SQL Server.
-
Connect to and Visualize Live Sage Cloud Accounting in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Sage Business Cloud Accounting.
-
Analyze Power BI XMLA in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Power BI XMLA in Microsoft R Open.
-
BambooHR Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on BambooHR facts in real time.
-
Validate SAS xpt with QuerySurge
Access and validate SAS XPORT in QuerySurge using the CData JDBC Driver.
-
DataBind Controls to Instagram in C++Builder
DataBind to Instagram in C++Builder with standard components and controls.
-
Rapidly Develop Avalara AvaTax-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Build Agents in Relevance AI with Access to Live Gmail via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Gmail within intelligent agent workflows.
-
Connecting Agentforce with Redshift 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 Amazon Redshift for you.
-
Getting Started with the CData Python Connector for Stripe
Learn to install and license the CData Python Connector
-
How to Connect DBeaver to MailChimp via a JDBC Driver
Manage MailChimp with visual tools in DBeaver like the query browser.
-
Visualize Basecamp in Tableau
The CData ODBC driver for Basecamp enables you integrate Basecamp into Tableau dashboards.
-
How to Connect to & Open Unbounce in Microsoft Excel
This article uses the CData ODBC driver for Unbounce to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Access Live Azure Table in Power Automate Desktop via ODBC
The CData ODBC Driver for Azure Table enables you to integrate Azure Table Storage into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Printify Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Printify replication to Amazon S3.
-
Connect to Confluence in SpagoBI
Create reports featuring live Atlassian Confluence in SpagoBI Studio. Host Confluence reports on SpagoBI Server.
-
Seamlessly Bring Twitter into Retool Using CData Connect AI
Integrate Twitter data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Build Oracle Service Cloud-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Oracle Service Cloud and build Oracle Service Cloud-connected web apps with Axios.
-
Access Live Reckon Accounts Hosted in AWS Lambda
Connect to live Reckon Accounts Hosted in AWS Lambda using the CData JDBC Driver.
-
Use ChatGPT to Talk to Your Epicor Kinetic via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Epicor Kinetic for you.
-
Connect to QuickBooks Online as an External Source in Dremio
Use the CData JDBC Driver to connect to QuickBooks Online as an External Source in Dremio.
-
Connect to OneNote in RazorSQL
Connect to OneNote from wizards and query Microsoft OneNote from the GUI in the RazorSQL database management tool.
-
Automated Continuous Salesloft Replication to SingleStore
Use CData Sync for automated, continuous, customizable Salesloft replication to SingleStore.
-
Build Data Flows from Zendesk to SQL Server using SSIS
Easily back up Zendesk to SQL Server using the SSIS components for Zendesk.
-
Connecting Moonlit Workflow with Oracle HCM Cloud 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 Oracle HCM Cloud in real time.
-
Connect to Reckon Using the Script Function in Claris FileMaker Pro
-