CData Software - Knowledge Base
Recent Articles
-
Connect to Excel Online Data in ACL Analytics
Connect to Microsoft Excel Online via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Microsoft Excel Online.
-
Integrating Claude Code CLI with OData Services 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.
-
Integrate Live SharePoint Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SharePoint from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Microsoft SharePoint.
-
Object-Relational Mapping (ORM) with MessageBird 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 MessageBird into a Java-based ORM framework, Hibernate.
-
Create MariaDB-Connected Business Apps in AppSheet
Connect to MariaDB Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to MariaDB.
-
Build Okta-Connected Apps in Choreo
Use CData Connect AI to connect to Okta Data from Choreo and build custom apps using live Okta.
-
Build NetSuite SuiteAnalytics Visualizations in Tableau Desktop
Use CData Connect AI to connect to live NetSuite SuiteAnalytics and build visualizations in Tableau.
-
Use the CData Software ODBC Driver for Mocean in SAS for Real-Time Reporting and Analytics
Connect to real-time Mocean in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Mocean.
-
How to Connect to Live JSON Services 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 JSON through natural language.
-
Query Dynamics NAV Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Microsoft Dynamics NAV and perform CRUD operations on Dynamics NAV from Node.js.
-
Automated Continuous Adobe Analytics Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Adobe Analytics replication to PostgreSQL.
-
Create Zoho Projects-Connected Business Apps in AppSheet
Connect to Zoho Projects Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Zoho Projects.
-
Automated Continuous Clio Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Clio replication to Amazon S3.
-
Automated Continuous Avro Replication to Snowflake
Use CData Sync for automated, continuous, customizable Avro replication to Snowflake.
-
Build Apps with Live JSON Services Using the Low-Code Development Platform of Mendix
Connect JSON with Mendix to build apps using the CData JDBC Driver for JSON.
-
How to Build an ETL App for FreshBooks Data in Python with CData
Create ETL applications and real-time data pipelines for FreshBooks in Python with petl.
-
How to Access Procore Data Using Entity Framework
This article shows how to access Procore using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrate with Microsoft Ads Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Microsoft Ads to a JSON file on disk.
-
Process & Analyze ScrapingBee Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live ScrapingBee Data.
-
Write a Simple Go Application to work with Email Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Email.
-
Build AI Agents with Paylocity Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Paylocity through CData Connect AI.
-
How to Connect the Power BI Service to Acumatica: Complete Guide
Connect to the CData Software Power BI Connector for Acumatica from PowerBI.com to provide real-time Acumatica ERP across the organization.
-
Integrate with Opsgenie Data in JReport Designer
Create charts and reports based on Opsgenie in JReport Designer.
-
Build SingleStore-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SingleStore.
-
Getting Started with the CData Excel Add-In for Avaza
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Avaza.
-
Extract, Transform, and Load Apify Data in Informatica PowerCenter
Create a simple Workflow for Apify in Informatica PowerCenter.
-
Analyze Square Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Square and visualize Square in SAP Analytics Cloud.
-
Create Informatica Mappings From/To an ODBC Data Source for Azure Data Catalog
Create an ODBC connection to Azure Data Catalog in Informatica and browse and transfer Azure Data Catalog.
-
Connect to Opsgenie Data in Jaspersoft Studio
Execute SQL to remote Opsgenie in Jaspersoft Studio.
-
Build MVC Applications with Connectivity to Oracle SCM Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Oracle SCM from an ASP.NET MVC application.
-
Analyze SurveyMonkey Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SurveyMonkey and visualize live SurveyMonkey in Infragistics Reveal.
-
Visualize Live Teradata Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Teradata.
-
Connecting Pipedream with Google Search Results via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Google Search data in real time.
-
Access Live AlloyDB Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Google AlloyDB through MCP integration.
-
Visualize Live MongoDB Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live MongoDB using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create Informatica Mappings From/To an ODBC Data Source for ZohoDesk
Create an ODBC connection to ZohoDesk in Informatica and browse and transfer ZohoDesk.
-
Integrating Boomi Agentstudio with Zuora Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Zuora, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to Miro Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Miro to connect to Miro and execute queries in PowerBuilder.
-
Build MVC Applications with Connectivity to Nethunt Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Nethunt from an ASP.NET MVC application.
-
Connect to Clio Data from PowerBuilder via JDBC
This article demonstrates how to access Clio from PowerBuilder using the Clio JDBC Driver.
-
Analyze Vault CRM Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Veeva Vault & Vault CRM and visualize live Veeva Vault & Vault CRM in Infragistics Reveal.
-
Connect to Greenplum from Asprova with CData Software ODBC Driver for Greenplum
This article shows how to connect faster to Greenplum data from Asprova.
-
Extend Google Sheets with Wave Financial Data
Make calls to Wave Financial from Google Apps Script via the API Server.
-
Natively Connect to YouTube Analytics Data in PHP
The CData ODBC driver for YouTube Analytics enables you to create PHP applications with connectivity to YouTube Analytics. Leverage the native support for ODBC in PHP.
-
How to connect to Codat Data with Squirrel SQL client
Connect to Codat and execute queries in the Squirrel SQL Client.
-
How to Connect to Live MailChimp Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live MailChimp securely in real time.
-
Getting Started with the CData Python Connector for Excel
Learn to install and license the CData Python Connector
-
Build an OLAP Cube in SSAS from Redis Data
Establish a connection to Redis data from SQL Server Analysis Services, and use the Redis Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate LibreChat with Live Google Spanner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Google Spanner from within the chat interface.
-
Replicate NetSuite SuiteAnalytics Data in Heroku for Use in Salesforce Connect
Replicate NetSuite SuiteAnalytics to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create Reports with SuiteCRM Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SuiteCRM.
-
Automated Continuous Google Forms Replication to Vertica
Use CData Sync for automated, continuous, customizable Google Forms replication to Vertica.
-
How to Connect DBeaver to Acumatica via a JDBC Driver
Manage Acumatica ERP with visual tools in DBeaver like the query browser.
-
Connect to GitLab Data in RazorSQL
Connect to GitLab from wizards and query GitLab from the GUI in the RazorSQL database management tool.
-
Replicate iContact Data to Multiple Databases
Replicate iContact to disparate databases with a point-and-click configuration.
-
A PostgreSQL Interface for Beeminder Data using the CData ODBC Driver
Use the SQL Gateway and Beeminder ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous ShipEngine Replication to Snowflake
Use CData Sync for automated, continuous, customizable ShipEngine replication to Snowflake.
-
Query GitHub Data in ColdFusion
Write standard ColdFusion data access code to connect to GitHub.
-
Replicate RSS Feeds to Multiple Databases via the CData Sync CLI
Replicate RSS Feeds to disparate databases with a single configuration.
-
Easily Integrate Google Spanner Data in Lazarus Pascal IDE
Learn how to easily integrate live Google Spanner in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build Apps with Live Acumatica Data Using the Low-Code Development Platform of Mendix
Connect Acumatica ERP with Mendix to build apps using the CData JDBC Driver for Acumatica.
-
Easily Integrate Foursquare Data in Lazarus Pascal IDE
Learn how to easily integrate live Foursquare in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Build an ETL App for SendGrid Data in Python with CData Connect AI
Build ETL pipelines that read and write live SendGrid in Python with petl and the CData Connect AI Python SDK.
-
Integrating Kiro CLI with Factorial 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.
-
Integrating OpenCode Terminal with FreshBooks 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.
-
Migrating data from Dynamics 365 Business Central to Google BigQuery using CData SSIS Components.
Easily push Dynamics 365 Business Central to Google BigQuery using the CData SSIS Tasks for Dynamics 365 Business Central and Google BigQuery.
-
Connect to BambooHR Data in DBArtisan
Use wizards in DBArtisan to configure BambooHR as a data source.
-
A PostgreSQL Interface for Confluence Data (MySQL Remoting via JDBC)
Use the Remoting features of the Confluence JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Live Amazon DynamoDB Data in MicroStrategy through CData Connect AI
Create a live connection to Amazon DynamoDB Data in CData Connect AI and connect to your Amazon DynamoDB from MicroStrategy.
-
Connect Gong to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Gong with IBM WebSphere for seamless data integration and connectivity.
-
Build AI/ML Models with Live SAP BusinessObjects BI Data using Dataiku
Connect SAP BusinessObjects BI Data with Dataiku using the CData JDBC Driver for SAP BusinessObjects BI.
-
How to Work with ADP Data in AWS Glue Jobs Using JDBC
Connect to ADP from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build Automated SAP HANA-Connected Workflows in Zapier
Use CData Connect AI to connect to live SAP HANA and build automated workflows in Zapier.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Splunk actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Extract, Transform, and Load Webex Data in Informatica PowerCenter
Create a simple Workflow for Webex in Informatica PowerCenter.
-
Access Live Microsoft Exchange Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Microsoft Exchange from your Google Sheets.
-
Import Tally Data Using Azure Data Factory
Use CData Connect AI to connect to Tally Data from Azure Data Factory and import live Tally ERP.
-
How to import TigerGraph Data into Apache Solr
Use the CData Software JDBC Driver for TigerGraph in Data Import Handler and create an automated import of TigerGraph to Apache Solr Enterprise Search platform.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Authorize.Net
Provide connectivity to Authorize.Net through an SAP BusinessObjects universe.
-
Edit and Search Google Calendar External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Google Calendar to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Google Calendar objects that you can access from apps and the dashboard.
-
Use Grok to Talk to Your ServiceNow 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 ServiceNow for you.
-
Create Power BI Reports on Real-Time Adobe Target Data
Use the CData ODBC Driver for Adobe Target to visualize Adobe Target in Power BI Desktop.
-
Automated Continuous Procore Replication to Oracle
Use CData Sync for automated, continuous, customizable Procore replication to Oracle.
-
Build AI/ML Models with Live SFTP Data using Dataiku
Connect SFTP Data with Dataiku using the CData JDBC Driver for SFTP.
-
Connect to Jira Assets from a Connection Pool in WebLogic
Use the CData JDBC Driver for Jira Assets to connect to Jira Assets from Web applications running on WebLogic.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Todoist
Provide connectivity to Todoist through an SAP BusinessObjects universe.
-
Prepare, Blend, and Analyze CapsuleCRM Data in Alteryx Designer (ODBC)
Build workflows to access live CapsuleCRM for self-service data analytics.
-
Bidirectional Access to Oracle Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Oracle Database in Filemaker Pro for Mac or Windows.
-
Establish a Live Connection with Raisers Edge NXT Data using Tableau Bridge
The CData ODBC Driver for Raisers Edge NXT enables you to integrate live Raisers Edge NXT into Tableau Cloud dashboards using the Tableau Bridge.
-
How to connect PolyBase to Authorize.Net
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Authorize.Net.
-
Access Attio Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Attio from HeidiSQL.
-
Connect to PagerDuty Data from PowerBuilder via ADO.NET
This article demonstrates how to access PagerDuty from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to load ClickTime data into Elasticsearch via Logstash
Introducing a simple method to load ClickTime data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Excel Online Data from PowerBuilder via ADO.NET
This article demonstrates how to access Microsoft Excel Online from Appeon PowerBuilder using the CData ADO.NET Provider for Excel Online.
-
View Reports on Real-Time Azure Data Catalog Data in Power BI Report Server
Use the CData ODBC Driver for Azure Data Catalog to visualize Azure Data Catalog in Power BI Desktop and then publish them to Power BI Report Server.
-
How to connect to Excel Data with Squirrel SQL client
Connect to Microsoft Excel and execute queries in the Squirrel SQL Client.
-
Connect to Microsoft Dataverse Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Microsoft Dataverse Data and connect to Microsoft Dataverse (CDS) in Akorbi Digital RunMyProcess.
-
Back Up Amazon DynamoDB to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Amazon DynamoDB. In this article, we will employ an SSIS workflow to populate a database with Amazon DynamoDB data.
-
Connect to ZohoDesk from Asprova with CData Software ODBC Driver for ZohoDesk
This article shows how to connect faster to ZohoDesk data from Asprova.
-
Integrating Splunk Data in Talend Cloud Data Management Platform
Connect Splunk Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Splunk.