CData Software - Knowledge Base
Recent Articles
-
Enable the ServiceNow JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with ServiceNow.
-
DataBind Controls to Google Directory in C++Builder
DataBind to Google Directory in C++Builder with standard components and controls.
-
Extract, Transform, and Load Microsoft Teams in Informatica PowerCenter
Create a simple Workflow for Microsoft Teams in Informatica PowerCenter.
-
Work with REST in FoxPro
Load REST into a FoxPro database. This article includes full code and a walk-through of the process.
-
Getting Started with the CData ODBC Driver for Vault CRM
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Vault CRM.
-
Use Claude to Talk to Your Oracle SCM via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Oracle SCM for you.
-
How to create an RPA flow for Oracle Eloqua Reporting in UiPath Studio
Use the Oracle Eloqua Reporting ODBC Driver to create workflows that access real-time Oracle Eloqua Reporting without any coding.
-
Connect to IBM Informix in DBArtisan
Use wizards in DBArtisan to configure IBM Informix as a data source.
-
Integrate Zuora in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Zuora from Informatica Cloud.
-
How to Access Live Jira Assets in Power Automate Desktop via ODBC
The CData ODBC Driver for Jira Assets enables you to integrate Jira Assets into workflows built using Microsoft Power Automate Desktop.
-
How to Visualize SharePoint Excel Services Data in Python with pandas
Use pandas and other modules to analyze and visualize live SharePoint Excel Services in Python.
-
Rapidly Develop Square-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Build a Singer.io Tap for Okta With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Okta data using
-
Changelog: Driver Update 2024.3
Review the driver-specific changes from the 2024.3 CData Driver release.
-
Use JayDeBeApi to access Microsoft Project in Python
Use standard Python scripting and the development environment of your choice to access live Microsoft Project.
-
Excel Spreadsheet Automation on xBase with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Build Voice Agents in ElevenLabs with access to Live Lakebase
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Lakebase.
-
How to Connect the Power BI Service to Oracle Eloqua Reporting: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
How to Query Live SendGrid in Claude Desktop
Connect to and query live SendGrid in Claude Desktop using CData Code Assist MCP.
-
Access Live Salesforce Pardot in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Salesforce Pardot from your Google Sheets.
-
Access Todoist from MySQL in PHP
Connect to Todoist through the standard MySQL libraries in PHP.
-
Automate Tasks in Power Automate Using the CData API Server
Automate actions like sending emails to a contact list, posting to social media, or syncing CRM and ERP.
-
Build Dashboards with Cassandra in DBxtra
Create dynamic dashboards and perform analytics based on Apache Cassandra in DBxtra.
-
Build Zoho Inventory-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Zoho Inventory and build Zoho Inventory-connected web apps with Axios.
-
Validate Zoho Books with QuerySurge
Access and validate Zoho Books in QuerySurge using the CData JDBC Driver.
-
DataBind Controls to Marketo in Delphi
DataBind to Marketo in Delphi with standard data access components and controls.
-
How to Connect to Bing Ads in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Bing Ads. Leverage the pyodbc module for ODBC in Python.
-
Use the CData ODBC Driver for Cosmos DB from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Cosmos DB to connect to Azure Cosmos DB from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Azure Cosmos DB in Excel.
-
Connect to PingOne from a Connection Pool in WebLogic
Use the CData JDBC Driver for PingOne to connect to PingOne from Web applications running on WebLogic.
-
Automate xBase Replication to Azure Data Lake
Use CData Sync to customize and automate xBase replication to Azure Data Lake.
-
Integrating LangGraph with IBM Informix via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on IBM Informix within automated workflows.
-
Use the CData Software JDBC Driver for FTP in MicroStrategy
Connect to FTP Servers in MicroStrategy Developer using the CData Software JDBC Driver for FTP.
-
Build Avalara AvaTax-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Avalara AvaTax.
-
Connecting Agentforce with ADP 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 ADP for you.
-
Connect to Paylocity in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Paylocity in Airbyte.
-
Object-Relational Mapping (ORM) with Slack 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 Slack into a Java-based ORM framework, Hibernate.
-
How to Connect to & Open Facebook in Microsoft Excel
This article uses the CData ODBC driver for Facebook to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Publish Reports with Dynamics NAV in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft Dynamics NAV.
-
How to connect to Twitter Ads from IntelliJ
Integrate connectivity to Twitter Ads with wizards in IntelliJ.
-
Create SAP ByDesign-Connected Nintex Workflows
Use CData Connect AI to connect to SAP ByDesign from Nintex Workflow Cloud and build custom workflows using live SAP Business ByDesign.
-
Choosing the Best Method to Connect Azure DevOps to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Azure DevOps from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Access Live Excel in AWS Lambda
Connect to live Microsoft Excel in AWS Lambda using the CData JDBC Driver.
-
Import Real-Time Invoiced via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Invoiced in ColdFusion.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Wave Financial
Provide connectivity to Wave Financial through an SAP BusinessObjects universe.
-
How to Connect Flowise AI Agents to Live Freshdesk via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live data without replication.
-
How to Query Live Sugar CRM in Perplexity MacOS Desktop
Connect to and query live Sugar CRM in Perplexity Desktop using CData Code Assist MCP.
-
Use the CData Software ODBC Driver for Adobe Experience Manager in MicroStrategy Web
Connect to Adobe Experience Manager in MicroStrategy Web using the CData Software ODBC Driver for Adobe Experience Manager.
-
How to publish and share Amazon Marketplace dashboards with Tableau Server
The CData ODBC driver for Amazon Marketplace enables you integrate Amazon Marketplace into Tableau dashboards.
-
Use the CData API Server to Access SurveyMonkey in Microsoft PowerPivot
Use the CData API Server to connect to live SurveyMonkey in the Power Pivot business intelligence tool.
-
Integrating Claude Code with Adobe Analytics via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Adobe Analytics within assisted coding and automated development workflows.
-
Process & Analyze QuickBooks Online in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live QuickBooks Online .
-
Automate Reckon Accounts Hosted Replication to Azure Synapse
Use CData Sync to customize and automate Reckon Accounts Hosted replication to Azure Synapse.
-
Connect to Splunk from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Splunk using standard SQL.
-
Building Dynamic Web Pages with Microsoft Exchange Using AngularJS
Create single-page applications with live connectivity to Microsoft Exchange using the CData API Server.
-
Use the CData API Server to Access Cloudant in Microsoft PowerPivot
Use the CData API Server to connect to live IBM Cloudant in the Power Pivot business intelligence tool.
-
Automated Continuous Microsoft Planner Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Microsoft Planner replication to Microsoft Access.
-
Integrate Sage 200 in Pentaho Data Integration
Build ETL pipelines based on Sage 200 in the Pentaho Data Integration tool.
-
Use the CData Software ODBC Driver for SAP Netweaver Gateway in MicroStrategy Web
Connect to SAP Netweaver Gateway in MicroStrategy Web using the CData Software ODBC Driver for SAP Netweaver Gateway.
-
Integrate Google Spanner in the Pentaho Report Designer
Publish reports based on Google Spanner in the Pentaho BI tool.
-
How to Access Live Google Sheets in Power Automate Desktop via ODBC
The CData ODBC Driver for Google Sheets enables you to integrate Google Sheets into workflows built using Microsoft Power Automate Desktop.
-
Integrate Splunk into Automated Tasks with Power Automate
Use CData Connect AI to connect to Splunk and integrate live Splunk into your Power Automate tasks.
-
Create Smartsheet-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Smartsheet from Klipfolio and build custom visualizations using live Smartsheet.
-
How to pipe Salesforce Data Cloud to CSV in PowerShell
Use standard PowerShell cmdlets to access Salesforce Data Cloud tables.
-
How to create an RPA flow for Acumatica in UiPath Studio
Use the Acumatica ODBC Driver to create workflows that access real-time Acumatica ERP without any coding.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Basecamp
Provide connectivity to Basecamp through an SAP BusinessObjects universe.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Zendesk
Provide connectivity to Zendesk through an SAP BusinessObjects universe.
-
Integrate Live SAP Ariba Procurement into Blue Prism for Intelligent Robotic Process Automation (RPA)
-