CData Software - Knowledge Base
Recent Articles
-
Connect to ClickUp from a Connection Pool in Jetty
The ClickUp JDBC Driver supports connection pooling: This article shows how to connect faster to ClickUp from Web apps in Jetty.
-
How to Connect to Live Instagram from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Instagram for you.
-
Use the CData SSIS Components to Insert New or Update Existing EnterpriseDB Records from SQL Server
Easily push SQL Server data to EnterpriseDB using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into EnterpriseDB or update existing records with data from a SQL Server database.
-
Explore Geographical Relationships in ADP with Power Map
Create data visualizations with ADP in Power Map.
-
How to Connect the Power BI Service to Microsoft Planner: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Import LinkedIn Ads into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access LinkedIn Ads. In this article, you will use the OData format to import LinkedIn Ads into Microsoft Power Query.
-
Connect to Blackbaud FE NXT from Crystal Reports
Use CData Connect AI to connect to and report on live Blackbaud FE NXT from Crystal Reports.
-
Connect to Impala in RapidMiner
Integrate Apache Impala with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Connect to ShipStation in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to ShipStation. Leverage the pyodbc module for ODBC in Python.
-
Getting Started with the CData SSIS Components for Azure Table
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Azure Table.
-
Connect to Epicor Kinetic in RapidMiner
Integrate Epicor Kinetic with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous Zoom Replication to SQL Server
Use CData Sync for automated, continuous, customizable Zoom replication to SQL Server.
-
Build Voice Agents in ElevenLabs with access to Live LinkedIn
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live LinkedIn.
-
LINQ to Amazon DynamoDB
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 Amazon DynamoDB Data Provider.
-
Integrating Gumloop with FHIR via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on FHIR within automated workflows.
-
How to Connect to Live eBay 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 eBay through natural language.
-
Zoho Projects Reporting in OBIEE with the Zoho Projects JDBC Driver
Deploy the Zoho Projects JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Access Live Microsoft Dataverse in AWS Lambda
Connect to live Microsoft Dataverse (CDS) in AWS Lambda using the CData JDBC Driver.
-
Automated Continuous LinkedIn Ads Replication to SQLite
Use CData Sync for automated, continuous, customizable LinkedIn Ads replication to SQLite.
-
How to Connect to Oracle in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Oracle Database. Leverage the pyodbc module for ODBC in Python.
-
Connect to Vault CRM in DBArtisan
Use wizards in DBArtisan to configure Veeva Vault & Vault CRM as a data source.
-
Visualize Dynamics 365 from Tableau
Use the Tableau Desktop business intelligence tool to connect to Microsoft Dynamics 365.
-
Connect to Email in Jaspersoft Studio
Execute SQL to remote Email in Jaspersoft Studio.
-
Build Voice Agents in ElevenLabs with access to Live Salesforce Marketing
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Salesforce Marketing Cloud.
-
Connect to REST from PowerBuilder via ADO.NET
This article demonstrates how to access REST from Appeon PowerBuilder using the CData ADO.NET Provider for REST.
-
Access Live Exact Online in AWS Lambda (with IntelliJ IDEA)
Connect to live Exact Online in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Query Zoho Projects in ColdFusion
Write standard ColdFusion data access code to connect to Zoho Projects.
-
Trigger SingleStore IFTTT Flows in Azure App Service
This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.
-
Bridge Oracle Financials Cloud Connectivity with Apache NiFi
Access and process Oracle Financials Cloud in Apache NiFi using the CData JDBC Driver.
-
Connect to OData Services in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for OData in Airbyte.
-
Connect to Office 365 as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Microsoft Office 365.
-
Build MVC Applications with Connectivity to Outreach.io
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Outreach.io from an ASP.NET MVC application.
-
Access Live SharePoint in AWS Lambda (with IntelliJ IDEA)
Connect to live Microsoft SharePoint in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Visualize Instagram in TIBCO Spotfire through ADO.NET
Integrate Instagram into dashboards in TIBCO Spotfire.
-
Integrate with Zoho Creator in JReport Designer
Create charts and reports based on Zoho Creator in JReport Designer.
-
How to Access Live IBM Cloud Object Storage in Power Automate Desktop via ODBC
The CData ODBC Driver for IBM Cloud Object Storage enables you to integrate IBM Cloud Object Storage into workflows built using Microsoft Power Automate Desktop.
-
Integrating Claude Code with Oracle Service Cloud via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Oracle Service Cloud within assisted coding and automated development workflows.
-
Publish OneNote-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Microsoft OneNote.
-
Integrate Airtable in the Pentaho Report Designer
Publish reports based on Airtable in the Pentaho BI tool.
-
Connect and Query Live Snapchat Ads Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Snapchat Ads into Databricks
-
How to Query Live Act CRM in Perplexity MacOS Desktop
Connect to and query live Act CRM in Perplexity Desktop using CData Code Assist MCP.
-
Automate Calendly Replication to SAP HANA
Use CData Sync to customize and automate Calendly replication to SAP HANA.
-
How to connect PolyBase to Pipedrive
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Pipedrive.
-
Getting Started with the CData ODBC Driver for Jira Service Management
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Jira Service Management.
-
Write a Simple Go Application to work with ShipStation on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to ShipStation.
-
Deploy the ADO.NET Provider for IBM Cloud Object Storage on an SSRS Report Server
Connect to IBM Cloud Object Storage 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.
-
How to Connect to Live Trello Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Trello securely in real time.
-
Create BigQuery-Connected Applications in Appsmith
Connect to BigQuery via CData Connect AI in Appsmith and create custom business applications with real-time access to Google BigQuery.
-
A PostgreSQL Interface for Salesloft using the CData ODBC Driver
Use the SQL Gateway and Salesloft ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build a Singer.io Tap for Dynamics CRM With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Dynamics CRM data using
-
A PostgreSQL Interface for Asana using the CData ODBC Driver
Use the SQL Gateway and Asana ODBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live Shippo in AWS Lambda
Connect to live Shippo in AWS Lambda using the CData JDBC Driver.
-
Create Avalara AvaTax-Connected Applications in Appsmith
Connect to Avalara AvaTax via CData Connect AI in Appsmith and create custom business applications with real-time access to Avalara AvaTax.
-
How to Query Adobe Commerce in MySQL Workbench
Execute MySQL queries against live Adobe Commerce from MySQL Workbench.
-
Create Dynamic Google Sheets Grids Using the Infragistics XamDataGrid
Learn how you can connect Google Sheets to Infragistics XamDataGrid to build dynamic grids.
-
Use the CData Software ODBC Driver for Twitter in MicroStrategy Web
Connect to Twitter in MicroStrategy Web using the CData Software ODBC Driver for Twitter.
-
Query Marketo in ColdFusion
Write standard ColdFusion data access code to connect to Marketo.
-
Replicate Multiple Outreach.io Accounts via the CData Sync CLI
Replicate multiple Outreach.io accounts to one or many databases.
-
Connect to Snapchat Ads from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Snapchat Ads, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Use JayDeBeApi to access Amazon S3 in Python
Use standard Python scripting and the development environment of your choice to access live Amazon S3.
-
Use Claude to Talk to Your Epicor Kinetic via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Epicor Kinetic for you.
-
Load eBay to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load eBay to a database.
-
Use the CData Software JDBC Driver for Coinbase in MicroStrategy Web
Connect to Coinbase in MicroStrategy Web using the CData Software JDBC Driver for Coinbase.
-
Query Salesforce from Node.js
Use the OData endpoint of the CData API Server to connect to your Salesforce & Force.com and perform CRUD operations on Salesforce from Node.js.
-
Enable the SAP Netweaver Gateway JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SAP Netweaver Gateway.
-
Query, Visualize, and Share live ActiveCampaign in Redash
Use CData Connect AI to connect to live ActiveCampaign in Redash for querying, visualizing, and sharing.
-
Access Sage Cloud Accounting from MySQL in PHP
Connect to Sage Cloud Accounting through the standard MySQL libraries in PHP.
-
Connect to Salesforce Pardot as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Salesforce Pardot.
-
Replicate Workday to Multiple Databases
Replicate Workday to disparate databases with a point-and-click configuration.
-
Stream Jira into Apache Kafka Topics
Access and stream Atlassian Jira in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous Jira Replication to SQLite
Use CData Sync for automated, continuous, customizable Jira replication to SQLite.
-
Build AI Agents with Tableau CRM Analytics Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can
-
Access Live Email in AWS Lambda (with IntelliJ IDEA)
Connect to live Email in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Okta in DBeaver
Use the CData ODBC Driver to connect to Okta in DBeaver.
-
Import SharePoint Excel Services into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access SharePoint Excel Services. In this article, you will use the OData format to import SharePoint Excel Services into Microsoft Power Query.
-
Import and Visualize Todoist in Power View
Create data visualizations based on Todoist in Excel.
-
Replicate Multiple NetSuite SuiteAnalytics Accounts via the CData Sync CLI
Replicate multiple NetSuite SuiteAnalytics accounts to one or many databases.
-
Access Live Google Sheets in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Sheets from your Google Sheets.
-
Query Xero as a SQL Server Database in Node.js
Execute SQL Server queries against Xero Accounting from Node.js.
-
Use the CData Software JDBC Driver for REST in MicroStrategy Desktop
Connect to REST in MicroStrategy Desktop using the CData Software JDBC Driver for REST.
-
Automated Continuous Azure Blob Storage Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to Amazon S3.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed ConstantContact to Power BI dashboards. Simply drag and drop ConstantContact into data visuals on the Power BI canvas.
-
How to import CockroachDB into Apache Solr
Use the CData Software JDBC Driver for CockroachDB in Data Import Handler and create an automated import of CockroachDB to Apache Solr Enterprise Search platform.
-
Easily Integrate TigerGraph in Lazarus Pascal IDE
Learn how to easily integrate live TigerGraph in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create Power BI Reports on Real-Time SAS Data Sets
Use the CData ODBC Driver for SAS Data Sets to visualize SAS Data Sets in Power BI Desktop.
-
View Reports on Real-Time Outreach.io in Power BI Report Server
Use the CData ODBC Driver for Outreach.io to visualize Outreach.io in Power BI Desktop and then publish them to Power BI Report Server.
-
Visualize Live Sage Intacct in the Power BI Service
Use CData Connect AI to connect to live Sage Intacct and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Import and Visualize Redis in Power View
Create data visualizations based on Redis in Excel.
-
Analyze Confluence in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Atlassian Confluence in Microsoft R Open.
-
Automated Continuous XML Replication to MySQL
Use CData Sync for automated, continuous, customizable XML replication to MySQL.
-
Access Excel from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Microsoft Excel from HeidiSQL.
-
Use Claude to Talk to Your Microsoft Project via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Microsoft Project for you.
-
Integrate Exact Online in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Exact Online from Informatica Cloud.
-
Using the CData Software ODBC Driver for Microsoft OneDrive in PyCharm
Connect to Microsoft OneDrive as an ODBC data source in PyCharm using the CData Software ODBC Driver for Microsoft OneDrive.
-
Connect to Clio in Jaspersoft Studio
Execute SQL to remote Clio in Jaspersoft Studio.
-
Viewing Dynamics NAV in RAD Studio Data Explorer
How to view Microsoft Dynamics NAV in RAD Studio Data Explorer using the CData ODBC Driver for Dynamics NAV.
-
Visualize Live Dynamics NAV of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Microsoft Dynamics NAV using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect Adobe Experience Manager to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Adobe Experience Manager using the CData Python MCP Server.
-
Connect to SurveyMonkey in Jaspersoft Studio
Execute SQL to remote SurveyMonkey in Jaspersoft Studio.
-
Visualize Live ADP in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live ADP.