CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Parallel Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Parallel replication to AlloyDB.
-
Integrating Claude Code with PayPal Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on PayPal data within assisted coding and automated development workflows.
-
Create Sage Cloud Accounting-Connected Applications in Appsmith
Connect to Sage Cloud Accounting Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Sage Cloud Accounting data.
-
Create Informatica Mappings From/To an ODBC Data Source for ChartMogul
Create an ODBC connection to ChartMogul in Informatica and browse and transfer ChartMogul data.
-
Integrate Okta Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Okta data and integrate live Okta data into your Power Automate tasks.
-
Getting Started with the CData JDBC Driver for Lakebase
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Lakebase.
-
Publish Freshservice-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Freshservice data.
-
Connect to OneNote Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with OneNote Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Automate Excel Online Data Replication to Azure Synapse
Use CData Sync to customize and automate Excel Online data replication to Azure Synapse.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Landbot
Provide connectivity to Landbot data through an SAP BusinessObjects universe.
-
ETL Salesforce in Oracle Data Integrator
This article shows how to transfer Salesforce data into a data warehouse using Oracle Data Integrator.
-
Automated Continuous Guru Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Guru replication to PostgreSQL.
-
How to create an RPA flow for Ontraport Data in UiPath Studio
Use the Ontraport ODBC Driver to create workflows that access real-time Ontraport data without any coding.
-
Create Data Visualizations Based On CockroachDB Data in Mode
Use CData Connect AI to connect to CockroachDB Data from Mode and build visualizations using live CockroachDB data.
-
Integrating LlamaIndex with Shortcut Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Shortcut data in real time.
-
Access Live Bullhorn CRM Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Bullhorn CRM data from your Excel spreadsheets.
-
Getting Started with the CData SSIS Components for PabblySubscriptions
Complete guide to installing, licensing, and connecting with the CData SSIS Components for PabblySubscriptions.
-
Object-Relational Mapping (ORM) with Authorize.Net 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 Authorize.Net data into a Java-based ORM framework, Hibernate.
-
Excel Spreadsheet Automation on SAP Fieldglass Data with the QUERY Formula
Pull data from SAP Fieldglass, automate spreadsheets, and more with the QUERY formula.
-
Getting Started with the CData Power BI Connector for Hubstaff
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connect PDFMonkey Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your PDFMonkey data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Airtable Data in ACL Analytics
Connect to Airtable data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Airtable data.
-
Automated Continuous Google Directory Replication to Snowflake
Use CData Sync for automated, continuous, customizable Google Directory replication to Snowflake.
-
Connect to ZohoPeople Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to ZohoPeople.
-
DataBind Controls to SFTP Data in C++Builder
DataBind to SFTP data in C++Builder with standard components and controls.
-
Migrating data from PingOne to Snowflake using CData SSIS Components.
Easily push PingOne data to Snowflake using the CData SSIS Tasks for PingOne and Snowflake.
-
Connecting Agentforce with Zoho Inventory 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 Zoho Inventory data for you.
-
Connect to Couchbase Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Couchbase data.
-
Stream ShipStation Data into Apache Kafka Topics
Access and stream ShipStation data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Visualize Salesforce Marketing 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 Salesforce Marketing data in Python.
-
Connect Salesforce Marketing Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Salesforce Marketing data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Work with Parallel Data in ETL Validator JDBC
Connect to Parallel from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Outreach.io Data in HULFT Integrate
Connect to Outreach.io as a JDBC data source in HULFT Integrate
-
Provide OData Services of WooCommerce Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for WooCommerce data by developing a WCF Service Application.
-
Use CData Connect AI to Access Mailgun Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Mailgun data in the Power Pivot business intelligence tool.
-
Work with WooCommerce Data in FoxPro
Load WooCommerce data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build an OLAP Cube in SSAS from SAP HANA Data
Establish a connection to SAP HANA data data from SQL Server Analysis Services, and use the SAP HANA Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create Dashboards and Visualize Live Google Directory Data in Geckoboard
Use CData Connect AI to connect to live Google Directory data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to connect to Lakebase Data from Spring Boot
Connect to Lakebase in a Spring Boot Application using the CData JDBC Driver for Lakebase
-
How to create an RPA flow for Miro Data in UiPath Studio
Use the Miro ODBC Driver to create workflows that access real-time Miro data without any coding.
-
How to load Wistia data into Elasticsearch via Logstash
Introducing a simple method to load Wistia data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect CloudConvert to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live CloudConvert data using the CData Python MCP Server.
-
Connect to Excel Data from PowerBuilder via JDBC
This article demonstrates how to access Excel data from PowerBuilder using the Excel JDBC Driver.
-
Connect RSS to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect RSS with IBM WebSphere for seamless data integration and connectivity.
-
Access Live Greenplum Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Greenplum data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Visualize ConvertKit Data in Tableau
The CData ODBC driver for ConvertKit enables you integrate ConvertKit data into Tableau dashboards.
-
Use Databricks Agent Bricks to Talk to Your AgileCRM Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your AgileCRM data for you.
-
A PostgreSQL Interface for PDFMonkey Data (MySQL Remoting via JDBC)
Use the Remoting features of the PDFMonkey JDBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Microsoft OneDrive Data in Sisense
Create an ElastiCube in Sisense app with access to Microsoft OneDrive data.
-
Create Dynamic Mistral AI Grids Using the Infragistics XamDataGrid
Learn how you can connect Mistral AI to Infragistics XamDataGrid to build dynamic grids.
-
Manage Spark Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Spark.
-
Configure the CData JDBC Driver for Jumpseller in a Connection Pool in Tomcat
Connect to Jumpseller data from a connection pool in Tomcat.
-
Integrate Google's Vertex AI Agent with Live Shopify Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Shopify data within intelligent workflows.
-
Analyze SurveyMonkey Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of SurveyMonkey data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Work with Live TaxJar Data in Power Query
Use CData Connect AI to connect to TaxJar data and work with live TaxJar data in Microsoft Power Query.
-
Getting Started with the CData Python Connector for Calendly
Learn to install and license the CData Python Connector and configure a connection to live Calendly data.
-
Visualize Discourse Data in Sisense
Create an ElastiCube in Sisense app with access to Discourse data.
-
Query Spark Data as a SQL Server Database in Node.js
Execute SQL Server queries against Spark data from Node.js.
-
Integrating Boomi Agentstudio with ShipEngine Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to ShipEngine data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to Easily Query Exact Online Data in OpenOffice Base
Connect to Exact Online data in OpenOffice Base using the CData ODBC Driver for Exact Online and generate reports with live data insights.
-
How to import FHIR Data into Apache Solr
Use the CData Software JDBC Driver for FHIR in Data Import Handler and create an automated import of FHIR data to Apache Solr Enterprise Search platform.
-
Build Data Flows from FHIR to SQL Server using SSIS
Easily back up FHIR data to SQL Server using the SSIS components for FHIR.
-
Operational Reporting on BigQuery Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote BigQuery data.
-
Create a Data Access Object for Simplesat Data using JDBI
A brief overview of creating a SQL Object API for Simplesat data in JDBI.
-
How to Use a Microsoft Access Database to Update Salesloft Data in Real Time
Update Salesloft data by creating a linked table in Microsoft Access with the CData Salesloft ODBC Driver.
-
Automated Continuous NASA Replication to Vertica
Use CData Sync for automated, continuous, customizable NASA replication to Vertica.
-
Integrate Theia IDE with Live IBM Informix Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live IBM Informix data from within the development environment.
-
Integrate Autopilot Data in the Pentaho Report Designer
Publish reports based on Autopilot data in the Pentaho BI tool.
-
Query Customer.io Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Customer.io data from Node.js.
-
Integrate with Live Twitter Ads Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Twitter Ads from the MuleSoft Anypoint Platform to integrate live Twitter Ads data into custom reports and dashboards.
-
Use JayDeBeApi to access Aircall Data in Python
Use standard Python scripting and the development environment of your choice to access live Aircall data.
-
Integrating LangChain with Basecamp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Basecamp data within automated workflows.
-
Connect to FTP Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time FTP data using standard SQL.
-
Connect to Cloudflare Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Cloudflare.
-
How to Seamlessly Import Stack Exchange Data into IBM SPSS Modeler
Integrate Stack Exchange data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Facebook Ads Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Facebook Ads.
-
Analyze Sybase Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Sybase from Power Pivot. You will use the Table Import Wizard to load Sybase data. You can visually build the import query or use any SQL supported by the driver.
-
Integrating Dataiku with SAP HANA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live SAP HANA data.
-
Build Amazon Marketplace-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Amazon Marketplace data without replication.
-
Build Samanage-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Samanage data without replication.
-
Automated Continuous Omnisend Replication to Oracle
Use CData Sync for automated, continuous, customizable Omnisend replication to Oracle.
-
Create Informatica Mappings From/To an ODBC Data Source for Azure DevOps
Create an ODBC connection to Azure DevOps in Informatica and browse and transfer Azure DevOps data.
-
Connect to Bannerbear Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Bannerbear and work with Bannerbear data in your FileMaker application.
-
Automated FreshBooks Data Replication to Teradata
Use CData Sync to Customize and automate FreshBooks data replication to Teradata.
-
Build Data Flows from Invoiced to SQL Server using SSIS
Easily back up Invoiced data to SQL Server using the SSIS components for Invoiced.
-
Choosing the Best Method to Connect Ontraport to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Ontraport data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Using the CData Software ODBC Driver for Oracle SCM in PyCharm
Connect to Oracle SCM as an ODBC data source in PyCharm using the CData Software ODBC Driver for Oracle SCM.
-
How to Connect to SFTP Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SFTP data. Leverage the pyodbc module for ODBC in Python.
-
Connect to Xero Data in Jaspersoft Studio
Execute SQL to remote Xero data in Jaspersoft Studio.
-
Configure the CData JDBC Driver for Sage Cloud Accounting in a Connection Pool in Tomcat
Connect to Sage Cloud Accounting data from a connection pool in Tomcat.
-
Replicate HubDB Data to Multiple Databases
Replicate HubDB data to disparate databases with a point-and-click configuration.
-
Easily Integrate MongoDB Data in Lazarus Pascal IDE
Learn how to easily integrate live MongoDB data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Analyze Egnyte Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Egnyte data in Microsoft R Open.
-
Connect to Basecamp Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Basecamp Data and connect to Basecamp data in Akorbi Digital RunMyProcess.
-
Getting Started with the CData ADO.NET Provider for Rootly
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Integrate Live Act CRM Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Act CRM from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Act CRM data.
-
Build SageHR-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live SageHR data and build SageHR-connected web apps with Axios.
-
Connect to Harvest Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Harvest data using standard SQL.
-
Connect and Query Live Odoo Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Odoo data into Databricks and enable direct, live querying and analysis without replication.
-
Connect to GitLab in SpagoBI
Create reports featuring live GitLab data in SpagoBI Studio. Host GitLab reports on SpagoBI Server.