CData Software - Knowledge Base
Recent Articles
-
Use Microsoft Copilot Studio to talk to your Basecamp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Basecamp for you.
-
Integrate Keap with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Keap with External Services.
-
Replicate Multiple Instagram Accounts
Replicate multiple Instagram accounts to one or many databases.
-
Access Live Outlook Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Outlook in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Connect to Live Google Ad Manager Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Google Ad Manager securely in real time.
-
Automated Continuous SparkPost Replication to SingleStore
Use CData Sync for automated, continuous, customizable SparkPost replication to SingleStore.
-
How to connect to Box Data from Spring Boot
Connect to Box in a Spring Boot Application using the CData JDBC Driver for Box
-
Build Asana-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Asana and build Asana-connected web apps with Axios.
-
Natively Connect to SAP Data in PHP
The CData ODBC driver for SAP enables you to create PHP applications with connectivity to SAP ERP/NetWeaver. Leverage the native support for ODBC in PHP.
-
How to Connect DBeaver to Zendesk via a JDBC Driver
Manage Zendesk with visual tools in DBeaver like the query browser.
-
How to connect Amazon QuickSight to Sybase Data
Create a connection to Sybase in CData Connect AI and insert Sybase into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to YouTube Analytics Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for YouTube Analytics and the Script function in FileMaker Pro to connect to YouTube Analytics and work with YouTube Analytics in your FileMaker application.
-
How to Connect to Live Presto Data 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 Presto for you.
-
Automated Continuous Zoom Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Zoom replication to AlloyDB.
-
Use Microsoft Copilot Studio to talk to your Google Campaign Manager 360 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Google Campaign Manager 360 for you.
-
Design BIRT Reports on Tanda Data
Provide current Tanda to your embedded analytics.
-
Create Apollo-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Apollo Data from OutSystems and build custom enterprise apps using live Apollo.
-
ETL Clockify in Oracle Data Integrator
This article shows how to transfer Clockify into a data warehouse using Oracle Data Integrator.
-
Bridge Sage 200 Connectivity with Apache NiFi
Access and process Sage 200 in Apache NiFi using the CData JDBC Driver.
-
How to Work with GetResponse Data in AWS Glue Jobs Using JDBC
Connect to GetResponse from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to connect PolyBase to Exa
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Exa.
-
Connect to Dotmailer 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 Dotmailer and work with Dotmailer in your FileMaker application.
-
Automated Continuous Freshservice Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Freshservice replication to Apache Cassandra.
-
Connect to Certinia Data in Ruby
Connect to Certinia in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Tally ERP using the Model Context Protocol.
-
Visualize Gorgias Data in TIBCO Spotfire through ADO.NET
Integrate Gorgias into dashboards in TIBCO Spotfire.
-
Access Live Procore Data in AWS Lambda
Connect to live Procore in AWS Lambda using the CData JDBC Driver.
-
How to Connect to Live SAP Ariba Source Data 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 SAP Ariba Source for you.
-
Automated Continuous Pipeliner CRM Replication to SingleStore
Use CData Sync for automated, continuous, customizable Pipeliner CRM replication to SingleStore.
-
Work with Live Salesforce CRM Analytics Data in Power Query
Use CData Connect AI to connect to Salesforce CRM Analytics and work with live Salesforce CRM Analytics in Microsoft Power Query.
-
Use the CData Software ODBC Driver for Oracle Sales in MicroStrategy Web
Connect to Oracle Sales in MicroStrategy Web using the CData Software ODBC Driver for Oracle Sales.
-
Connect to DocuSign Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live DocuSign.
-
Automated Attio Data Replication to Teradata
Use CData Sync to Customize and automate Attio replication to Teradata.
-
Building Dynamic Web Pages with Redis Data Using AngularJS
Create single-page applications with live connectivity to Redis using the CData API Server.
-
Build Quickbase-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Quickbase to explore live Quickbase Data in GitHub Copilot to assist with building Quickbase-powered applications.
-
Connect to IBM Cloud Object Storage from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from IBM Cloud Object Storage, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Analyze Sage Intacct Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Sage Intacct with the CData JDBC Driver for Sage Intacct.
-
Connect to Float Data in CloverDX (formerly CloverETL)
Transfer Float using the visual workflow in the CloverDX data integration tool.
-
How to integrate Metabase with MYOB AccountRight Data
Use CData Connect AI to connect to live MYOB AccountRight and create an interactive dashboard in Metabase from MYOB AccountRight.
-
Connect to ActiveCampaign Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with ActiveCampaign Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Build JobNimbus-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live JobNimbus.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Oracle Sales within intelligent workflows.
-
Choosing the Best Method to Connect Nuclia to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Nuclia from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Prepare, Blend, and Analyze Oracle Eloqua Data in Alteryx Designer (Connect AI)
Build workflows to access live Oracle Eloqua for self-service data analytics.
-
LINQ to Sugar CRM Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Sugar CRM Data Provider.
-
Connect to Missive Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Missive as an External Source in Dremio.
-
DataBind Coinbase Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Coinbase to a chart.
-
Build AI/ML Models with Live HCL Domino Data using Dataiku
Connect HCL Domino Data with Dataiku using the CData JDBC Driver for HCL Domino.
-
Build Neo4J-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Neo4J to explore live Neo4J Data in Claude Code to assist with building Neo4J-powered applications.
-
Automated Continuous NetSuite Replication to MongoDB
Use CData Sync for automated, continuous, customizable NetSuite replication to MongoDB.
-
Create Data Visualizations in Cognos BI with ConvertKit Data
Access ConvertKit as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Use the CData Software JDBC Driver for JobNimbus in MicroStrategy Desktop
Connect to JobNimbus in MicroStrategy Desktop using the CData Software JDBC Driver for JobNimbus.
-
Query PagerDuty Data through ODBC in Node.js
Use node-odbc to execute SQL queries against PagerDuty from Node.js.
-
Import Stripe Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Stripe. In this article, you will use the OData format to import Stripe into Microsoft Power Query.
-
Access Live PhantomBuster Data in AWS Lambda (with IntelliJ IDEA)
Connect to live PhantomBuster in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Natively Connect to Superchat Data in PHP
The CData ODBC driver for Superchat enables you to create PHP applications with connectivity to Superchat. Leverage the native support for ODBC in PHP.
-
Connect to Anaplan in SpagoBI
Create reports featuring live Anaplan in SpagoBI Studio. Host Anaplan reports on SpagoBI Server.
-
Highrise Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Highrise CRM through CData Connect AI using different applications and tools.
-
Rapidly Develop Typeform-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Typeform.
-
Replicate Multiple Dynamics NAV Accounts via the CData Sync CLI
Replicate multiple Dynamics NAV accounts to one or many databases.
-
How to connect to Sage Cloud Accounting Data with Squirrel SQL client
Connect to Sage Business Cloud Accounting and execute queries in the Squirrel SQL Client.
-
Create SSAS Tabular Models from ZohoPeople Data
How to build a SQL Server Analysis Service Tabular Model from ZohoPeople using CData drivers.
-
Using the CData Software ODBC Driver for AgileCRM in PyCharm
Connect to AgileCRM as an ODBC data source in PyCharm using the CData Software ODBC Driver for AgileCRM.
-
Automate Drift Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Drift from PowerShell? This article demonstrates how to utilize the Drift Cmdlets for tasks like connecting to Drift, automating operations, downloading data, and more.
-
Operational Reporting on BenchmarkEmail Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote BenchmarkEmail.
-
Using the CData Software ODBC Driver for Hive in PyCharm
Connect to Hive as an ODBC data source in PyCharm using the CData Software ODBC Driver for Hive.
-
Use Microsoft Copilot Studio to talk to your EnterpriseDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your EnterpriseDB for you.
-
Automated Continuous HubDB Replication to AlloyDB
Use CData Sync for automated, continuous, customizable HubDB replication to AlloyDB.
-
Explore Geographical Relationships in Spotify Data with Power Map
Create data visualizations with Spotify in Power Map.
-
Connect to Email Data in DBArtisan
Use wizards in DBArtisan to configure Email as a data source.
-
How to use SQLAlchemy ORM to access Calendly Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Calendly.
-
Automate Ontraport Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Ontraport from PowerShell? This article demonstrates how to utilize the Ontraport Cmdlets for tasks like connecting to Ontraport, automating operations, downloading data, and more.
-
Connect to Bannerbear Data in DBeaver
Use the CData ODBC Driver to connect to Bannerbear in DBeaver.
-
Connect to ZarMoney in SpagoBI
Create reports featuring live ZarMoney in SpagoBI Studio. Host ZarMoney reports on SpagoBI Server.
-
Connect to IBM Informix Data from AWS Glue
Use CData Connect AI to gain access to live IBM Informix from your AWS Glue jobs.
-
Access Live CouchDB Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Apache CouchDB into the statistical analysis tools available in SAS JMP. This article shows how to use Apache CouchDB in the Graph Builder and Query Builder.
-
Connect to MarkLogic Data from a Connection Pool in JBoss
Integrate MarkLogic into Java servlets: Use the Management Console in JBoss to install the MarkLogic JDBC Driver.
-
Analyze Browserless Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Browserless with the CData JDBC Driver for Browserless.
-
Connect to Phoenix Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Apache Phoenix in Airbyte.
-
How to Connect to Live Pipedrive Data 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 Pipedrive for you.
-
Connect to AdRoll Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for AdRoll to connect to AdRoll and execute queries in PowerBuilder.
-
Access Webex Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Webex from HeidiSQL.
-
Automated Continuous ShipEngine Replication to MySQL
Use CData Sync for automated, continuous, customizable ShipEngine replication to MySQL.
-
Build an OLAP Cube in SSAS from ElevenLabs Data
Establish a connection to ElevenLabs data from SQL Server Analysis Services, and use the ElevenLabs Data Provider to build OLAP cubes for use in analytics and reporting.
-
Visualize Live SurveyMonkey Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SurveyMonkey using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
DataBind Pinterest Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Pinterest with the DevExpress Windows Forms and Web controls to provide Pinterest to a chart.
-
How to Easily Query Sendwithus Data in OpenOffice Base
Connect to Sendwithus data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Migrating data from Timely to Snowflake using CData SSIS Components.
Easily push Timely to Snowflake using the CData SSIS Tasks for Timely and Snowflake.
-
Process & Analyze Beeminder Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Beeminder Data.
-
Use Agno to Talk to Your Google Search Results via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Google Search for you.
-
Connect Vercel to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Vercel with IBM WebSphere for seamless data integration and connectivity.
-
Use the CData Software ODBC Driver for Superchat in MicroStrategy Web
Connect to Superchat in MicroStrategy Web using the CData Software ODBC Driver for Superchat.
-
Create Data Visualizations Based On SendGrid Data in Mode
Use CData Connect AI to connect to SendGrid Data from Mode and build visualizations using live
-
Automated Continuous Mailgun Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Mailgun replication to OneLake in Microsoft Fabric.
-
Access Live Azure Synapse Data in TIBCO Data Virtualization
Use the Azure Synapse Tibco DV Adapter to create a Azure Synapse data source in TIBCO Data Virtualization Studio and gain access to live Azure Synapse from your TDV Server.
-
Use the CData ODBC Driver for Workable from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Workable to connect to Workable from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Workable in Excel.
-
Getting Started with the CData Excel Add-In for Wave Financial
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Wave Financial.
-
Access Live Greenhouse Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Greenhouse data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Perform Batch Operations with SAP Hybris C4C Data in Apache NiFi
Connect to SAP Hybris C4C and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Build Zoho Books-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Zoho Books Data and create custom apps in Mendix.