CData Software - Knowledge Base
Recent Articles
-
Connecting Agentforce with Mailjet 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 Mailjet data for you.
-
Publish Contentful-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Contentful data.
-
Connect and Query Live Sybase IQ Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Sybase IQ data into Databricks and enable direct, live querying and analysis without replication.
-
Automate Contentful Data Replication to Azure Data Lake
Use CData Sync to customize and automate Contentful data replication to Azure Data Lake.
-
Automated Adobe Analytics Data Replication to Teradata
Use CData Sync to Customize and automate Adobe Analytics data replication to Teradata.
-
Seamlessly Bring Figshare Data into Retool Using CData Connect AI
Integrate Figshare data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to Connect to Marketo Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Marketo data. Leverage the pyodbc module for ODBC in Python.
-
Connect to SAP SuccessFactors from Asprova with CData Software ODBC Driver for SAP SuccessFactors
This article shows how to connect faster to SAP SuccessFactors data from Asprova.
-
Integrating GitHub Copilot with SuiteCRM 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.
-
Integrate Live Close Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Close data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrate JobNimbus Data in Pentaho Data Integration
Build ETL pipelines based on JobNimbus data in the Pentaho Data Integration tool.
-
Connect to HelloSign Data in DBeaver
Use the CData ODBC Driver to connect to HelloSign data in DBeaver.
-
Create Informatica Mappings From/To a JDBC Data Source for SpaceX
Create SpaceX data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Load Zoho Projects Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Zoho Projects data to a database.
-
Connect to Simplesat from Asprova with CData Software ODBC Driver for Simplesat
This article shows how to connect faster to Simplesat data from Asprova.
-
Visualize Apify Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Apify data into TIBCO Spotfire.
-
Connect to Twilio Data in JRuby
Create a simple JRuby app with access to live Twilio data.
-
Validate MongoDB Data with QuerySurge
Access and validate MongoDB data in QuerySurge using the CData JDBC Driver.
-
Connect to OneNote Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for OneNote and the SQL Gateway to access OneNote data from Google Apps Script.
-
Connect Recurly Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Recurly data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Replicate Multiple AdRoll Accounts
Replicate multiple AdRoll accounts to one or many databases.
-
Connect to FormSite Data in DBArtisan
Use wizards in DBArtisan to configure FormSite data as a data source.
-
Integrating Boomi Agentstudio with Sage 300 Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Sage 300 data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to NASA Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for NASA data.
-
Connect to Google Cloud Storage Data from PowerBuilder via ADO.NET
This article demonstrates how to access Google Cloud Storage data from Appeon PowerBuilder using the CData ADO.NET Provider for Google Cloud Storage.
-
Moving Data from LeadDesk to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live LeadDesk data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrating Gumloop with SAP SuccessFactors LMS Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on SAP SuccessFactors LMS data within automated workflows.
-
Connect to Harvest Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Harvest data.
-
Integrating Gumloop with Impala Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Impala data within automated workflows.
-
Build Apps with Live Office 365 data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Office 365 data into the Adalo platform and build custom mobile and web applications with real-time Office 365 data.
-
Connect to SQL Analysis Services Data from AWS Glue
Use CData Connect AI to gain access to live SQL Analysis Services data from your AWS Glue jobs.
-
How to Connect Suadeo Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Suadeo data in real time using natural language.
-
Connect to and Query eBay Data in QlikView over ODBC
Create data visualizations with eBay data in QlikView.
-
Load Raisers Edge NXT Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Raisers Edge NXT data to a database.
-
Connect to Discord Data in Google Apps Script via Connect AI
Use CData Connect AI to access Discord data in Google Apps Script.
-
Automated Continuous Intercom Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Intercom replication to AlloyDB.
-
How to Connect to Live ZohoSubscriptions 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 ZohoSubscriptions data for you.
-
Connecting Pipedream with Dynamics 365 Business Central Data 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 Dynamics 365 Business Central data in real time.
-
How to connect SharePoint with SharePoint Excel Services Data through external lists
Provide SharePoint Excel Services data to SharePoint users as an external list.
-
How to Connect to MarkLogic Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to MarkLogic data. Leverage the pyodbc module for ODBC in Python.
-
Connect to Sage 300 Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Sage 300 Data and connect to Sage 300 data in Akorbi Digital RunMyProcess.
-
Build SurveyMonkey-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live SurveyMonkey data and build SurveyMonkey-connected web apps with Axios.
-
Configure the CData JDBC Driver for Microsoft Teams in a Connection Pool in Tomcat
Connect to Microsoft Teams data from a connection pool in Tomcat.
-
Connect to Okta Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Okta Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to update Couchbase from Excel
This article explains how to transfer data from Excel to Couchbase using the Excel Add-In for Couchbase.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Nethunt
Provide connectivity to Nethunt data through an SAP BusinessObjects universe.
-
Access Live Oracle Eloqua Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Oracle Eloqua data from your Excel spreadsheets.
-
How to Connect to Live Sage Intacct Data 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 Sage Intacct data through natural language.
-
Create Data Visualizations Based On Azure Data Lake Storage Data in Mode
Use CData Connect AI to connect to Azure Data Lake Storage Data from Mode and build visualizations using live Azure Data Lake Storage data.
-
How to Easily Query Act-On Data in OpenOffice Base
Connect to Act-On data in OpenOffice Base using the CData ODBC Driver for Act-On and generate reports with live data insights.
-
Create Informatica Mappings From/To a JDBC Data Source for OneNote
Create OneNote data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to connect to Excel Data from IntelliJ
Integrate connectivity to Excel data with wizards in IntelliJ.
-
Integrate Live WooCommerce Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to WooCommerce data and integrate live WooCommerce data into apps built in Microsoft Power Apps.
-
Create Salesforce Pardot-Connected Applications in Appsmith
Connect to Salesforce Pardot Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Salesforce Pardot data.
-
Natively Connect to SAP HANA XS Advanced Data in PHP
The CData ODBC driver for SAP HANA XS Advanced enables you to create PHP applications with connectivity to SAP HANA XS Advanced data. Leverage the native support for ODBC in PHP.
-
Connect and Query Live ConstantContact Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live ConstantContact data into Databricks and enable direct, live querying and analysis without replication.
-
How to Connect to & Open Asana Data in Microsoft Excel
This article uses the CData ODBC driver for Asana to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Access Live Todoist Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Todoist data into the statistical analysis tools available in SAS JMP. This article shows how to use Todoist data in the Graph Builder and Query Builder.
-
Connect SendPulse to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SendPulse with IBM WebSphere for seamless data integration and connectivity.
-
Use ChatGPT to Talk to Your Oracle SCM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Oracle SCM data for you.
-
Model, Search, and Visualize Live Google Drive Data in ThoughtSpot
Use CData Connect AI to connect to live Google Drive data for modeling, searching, and visualizing.
-
Automated Continuous Oracle Sales Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Oracle Sales replication to Amazon S3.
-
Use the CData Software JDBC Driver for Zoho CRM in MicroStrategy
Connect to Zoho CRM data in MicroStrategy Developer using the CData Software JDBC Driver for Zoho CRM.
-
Getting Started with the CData JDBC Driver for Supabase
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Supabase.
-
Deploy the ADO.NET Provider for SurveyMonkey on an SSRS Report Server
Connect to SurveyMonkey data 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.
-
Migrating data from eBay to Snowflake using CData SSIS Components.
Easily push eBay data to Snowflake using the CData SSIS Tasks for eBay and Snowflake.
-
Create Data Visualizations in Cognos BI with Google Contacts Data
Access Google Contacts data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrate AdRoll with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate AdRoll with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to AdRoll data.
-
Connect to Onfleet Data in Aqua Data Studio
Access Onfleet data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Building Dynamic Web Pages with Act-On Data Using AngularJS
Create single-page applications with live connectivity to Act-On using the CData API Server.
-
How to Create Power BI Visual Reports with Real-Time Discourse Data
Use CData Power BI Connectors to visualize Discourse data in Power BI.
-
Integrate Google's Antigravity Agent with Live Excel Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Excel Online data using the Model Context Protocol.
-
Connect to IBM Informix Data from PowerBuilder via ADO.NET
This article demonstrates how to access IBM Informix data from Appeon PowerBuilder using the CData ADO.NET Provider for IBM Informix.
-
How to Connect Flowise AI Agents to Live LinkedIn Ads Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live LinkedIn Ads data without replication.
-
Provide OData Services of PayPal Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for PayPal data by developing a WCF Service Application.
-
How to Visualize Azure Analysis Services 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 Azure Analysis Services data in Python.
-
Build Charts with Monday.com Data in Clear Analytics
Create dynamic charts and perform analytics based on Monday.com data in Clear Analytics.
-
Automate Slack Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Slack data from PowerShell? This article demonstrates how to utilize the Slack Cmdlets for tasks like connecting to Slack data, automating operations, downloading data, and more.
-
How to use SQLAlchemy ORM to access Paylocity Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Paylocity data.
-
How to Visualize ShipEngine 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 ShipEngine data in Python.
-
How to connect to SparkPost Data from IntelliJ
Integrate connectivity to SparkPost data with wizards in IntelliJ.
-
Connect to Datadog Data from a Connection Pool in JBoss
Integrate Datadog data into Java servlets: Use the Management Console in JBoss to install the Datadog JDBC Driver.
-
Connecting Moonlit Workflow with SendPulse Data 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 SendPulse data in real time.
-
Connect to Bitbucket Data in Claris FileMaker Pro
Use the CData ODBC Driver for Bitbucket in FileMaker Pro to connect to Bitbucket and work with Bitbucket data in your FileMaker applications.
-
Automated Continuous ZohoSubscriptions Replication to SQL Server
Use CData Sync for automated, continuous, customizable ZohoSubscriptions replication to SQL Server.
-
Connect to Live IBM Cloud Object Storage Data in PostGresSQL Interface through CData Connect AI
Create a live connection to IBM Cloud Object Storage in CData Connect AI and connect to your IBM Cloud Object Storage data from PostgreSQL.
-
How to connect to Power BI XMLA Data with Squirrel SQL client
Connect to Power BI XMLA data and execute queries in the Squirrel SQL Client.
-
Access Live Zuora Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Zuora data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Access Live Supabase 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 Supabase data through MCP integration.
-
Build eBay-Connected Apps in Choreo
Use CData Connect AI to connect to eBay Data from Choreo and build custom apps using live eBay data.
-
Connect to Factorial Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Factorial.
-
Connect to Redshift Data in HULFT Integrate
Connect to Redshift as a JDBC data source in HULFT Integrate
-
Write a Simple Go Application to work with Salesforce CRM Analytics Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Salesforce CRM Analytics data.
-
Integrate with live ServiceNow Data in Jitterbit
Use CData Connect AI to connect to and integrate live ServiceNow data in Jitterbit.
-
Build a PostgreSQL Interface for SAS xpt Data using the CData JDBC Driver
Use the Remoting features of the SAS xpt JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Power BI XMLA Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Power BI XMLA data.
-
Getting Started with the CData ODBC Driver for Zuora
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Zuora.
-
Build eBay Analytics-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for eBay Analytics Data and create custom apps in Bubble.
-
Build Pipelines with Live Shopify Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Shopify from Google Cloud Data Fusion, enabling the integration of live Shopify data into the building and management of effective data pipelines.
-
Query Live Google Drive Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Google Drive data through a conversational interface.