CData Software - Knowledge Base
Recent Articles
-
Connect to ElevenLabs Data from PowerBuilder via JDBC
This article demonstrates how to access ElevenLabs data from PowerBuilder using the ElevenLabs JDBC Driver.
-
Connect to Discord Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Discord data.
-
Connect to Eventbrite Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Eventbrite data.
-
Integrate LibreChat with Live Acumatica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Acumatica data from within the chat interface.
-
Integrate Excel with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Excel with External Services.
-
Bidirectional Access to Epicor Kinetic Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Epicor Kinetic data in Filemaker Pro for Mac or Windows.
-
Integrate Perigon Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Perigon data from Informatica Cloud.
-
Process & Analyze Teamgate Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Teamgate Data.
-
Integrate Discord Data into Power Automate Desktop using CData Connect
CData Connect for Discord Data enables you to integrate Discord data into workflows built using Microsoft Power Automate Desktop.
-
Integrate Postmark with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Postmark with External Services.
-
Connect to Microsoft Planner from Asprova with CData Software ODBC Driver for Microsoft Planner
This article shows how to connect faster to Microsoft Planner data from Asprova.
-
Build Apps with Live AgileCRM data in Adalo using CData Connect AI
Use CData Connect AI to integrate live AgileCRM data into the Adalo platform and build custom mobile and web applications with real-time AgileCRM data.
-
Access Live Microsoft Exchange Data in TIBCO Data Virtualization
Use the Microsoft Exchange Tibco DV Adapter to create a Microsoft Exchange data data source in TIBCO Data Virtualization Studio and gain access to live Microsoft Exchange data from your TDV Server.
-
Replicate Multiple Instagram Accounts
Replicate multiple Instagram accounts to one or many databases.
-
Build ServiceDesk Plus-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 ServiceDesk Plus data without replication.
-
Integrate Real-Time Access to Redis in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Redis data in real time.
-
Consume Highrise OData Feeds in PowerBuilder
This article demonstrates how to consume Highrise data as OData feeds from PowerBuilder using the API Server.
-
Connect to Humanity Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Humanity and the SQL Gateway to access Humanity data from Google Apps Script.
-
How to connect SharePoint with Oracle HCM Cloud Data through external lists
Provide Oracle HCM Cloud data to SharePoint users as an external list.
-
Server Certificate Verification Failed: Connection Aborted
This entry details the typical causes of the error and proposes solutions to resolve it.
-
Build Data Flows from Dynamics 365 to SQL Server using SSIS
Easily back up Dynamics 365 data to SQL Server using the SSIS components for Dynamics 365.
-
Connect to Missive 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 Missive and work with Missive data in your FileMaker application.
-
Visualize QuickBooks Data in Sisense
Create an ElastiCube in Sisense app with access to QuickBooks data.
-
Automate CapsuleCRM Integration Tasks from PowerShell
Are you in search of a quick and easy way to access CapsuleCRM data from PowerShell? This article demonstrates how to utilize the CapsuleCRM Cmdlets for tasks like connecting to CapsuleCRM data, automating operations, downloading data, and more.
-
Extract, Transform, and Load Kintone Data in Informatica PowerCenter
Create a simple Workflow for Kintone data in Informatica PowerCenter.
-
Integrate Live SAP Concur Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live SAP Concur data to Blue Prism using the CData ODBC Driver for SAP Concur to create automated workflows for repetitive business tasks.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Mixpanel
Provide connectivity to Mixpanel data through an SAP BusinessObjects universe.
-
Create Informatica Mappings From/To a JDBC Data Source for Xero
Create Xero data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to and Visualize Live Humanity Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Humanity data.
-
Search External SendPulse Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of SendPulse data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SendPulse Data objects that you can access from apps and the dashboard.
-
Analyze Zoho Projects Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Zoho Projects from Power Pivot. You will use the Table Import Wizard to load Zoho Projects data. You can visually build the import query or use any SQL supported by the driver.
-
How to Connect to & Open SAP ByDesign Data in Microsoft Excel
This article uses the CData ODBC driver for SAP ByDesign to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Easily Query SAP Fieldglass Data in OpenOffice Base
Connect to SAP Fieldglass data in OpenOffice Base using the CData ODBC Driver for SAP Fieldglass and generate reports with live data insights.
-
Create Datasets from Mailgun in Domo Workbench and Build Visualizations of Mailgun Data in Domo
Use the CData Software ODBC Driver for Mailgun to create datasets from Mailgun data in Domo Workbench and then build visualizations in the Domo service.
-
Replicate Pingdom Data in Heroku for Use in Salesforce Connect
Replicate Pingdom data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create Moosend-Connected Dashboards in Grafana
Connect to Moosend Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Moosend data.
-
Connect to ClickTime Data from PowerBuilder via ADO.NET
This article demonstrates how to access ClickTime data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Publish Reports with Superchat Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Superchat data.
-
How to connect PolyBase to Mailgun
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Mailgun data.
-
DataBind Controls to Zoom Data in Delphi
DataBind to Zoom data in Delphi with standard data access components and controls.
-
Connect to and Query SurveyMonkey Data in QlikView over ODBC
Create data visualizations with SurveyMonkey data in QlikView.
-
Work with Live Salesforce CRM Analytics Data in Power Query
Use CData Connect AI to connect to Salesforce CRM Analytics data and work with live Salesforce CRM Analytics data in Microsoft Power Query.
-
Connect to and Visualize Live Gorgias Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Gorgias data.
-
Connect FreshBooks to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live FreshBooks data using the CData Python MCP Server.
-
Integrate LibreChat with Live Avalara AvaTax Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Avalara AvaTax data from within the chat interface.
-
Import and Visualize Templated Data in Power View
Create data visualizations based on Templated data in Excel.
-
Integrate SAP Netweaver Gateway with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SAP Netweaver Gateway with External Services.
-
Connecting Pipedream with Twitter Ads 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 Twitter Ads data in real time.
-
Import Real-Time Flowlu Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Flowlu data in ColdFusion.
-
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.
-
Prepare, Blend, and Analyze Oracle Eloqua Data in Alteryx Designer (Connect AI)
Build workflows to access live Oracle Eloqua data for self-service data analytics.
-
Integrating LangChain with Excel Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Excel Online data within automated workflows.
-
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.
-
Connect to SFTP Data in ACL Analytics
Connect to SFTP data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to SFTP data.
-
View Reports on Real-Time PingOne Data in Power BI Report Server
Use the CData ODBC Driver for PingOne to visualize PingOne data in Power BI Desktop and then publish them to Power BI Report Server.
-
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 data to a chart.
-
Integrate with live Pinterest Data in Jitterbit
Use CData Connect AI to connect to and integrate live Pinterest data in Jitterbit.
-
Use the CData Software ODBC Driver for Nuclia in MicroStrategy
Connect to Nuclia data in MicroStrategy Developer using the CData Software ODBC Driver for Nuclia.
-
Visualize LeadDesk Data in Sisense
Create an ElastiCube in Sisense app with access to LeadDesk data.
-
Replicate NASA Data to Multiple Databases
Replicate NASA data to disparate databases with a point-and-click configuration.
-
How to create an RPA flow for Salesforce CRM Analytics Data in UiPath Studio
Use the Salesforce CRM Analytics ODBC Driver to create workflows that access real-time Salesforce CRM Analytics data without any coding.
-
How to Connect to Live QuickBooks Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your QuickBooks data for you.
-
How to Access Float Data Using Entity Framework
This article shows how to access Float data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automated Continuous YouTube Analytics Replication to Databricks
Use CData Sync for automated, continuous, customizable YouTube Analytics replication to Databricks.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Redis
Provide connectivity to Redis data through an SAP BusinessObjects universe.
-
Integrate LibreChat with Live FHIR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live FHIR data from within the chat interface.
-
Replicate Multiple Dynamics NAV Accounts via the CData Sync CLI
Replicate multiple Dynamics NAV accounts to one or many databases.
-
Create Informatica Mappings From/To an ODBC Data Source for HCL Domino
Create an ODBC connection to HCL Domino in Informatica and browse and transfer HCL Domino data.
-
Build Automated Okta-Connected Workflows in Zapier
Use CData Connect AI to connect to live Okta data and build automated workflows in Zapier.
-
Access Live Splunk Data in Coginiti Pro
Connect to and query live Splunk data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Choosing the Best Method to Connect SAP HANA to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SAP HANA data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to GraphQL 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 GraphQL data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for PayPal
Provide connectivity to PayPal data through an SAP BusinessObjects universe.
-
Access Live Trello Data in TIBCO Data Virtualization
Use the Trello Tibco DV Adapter to create a Trello data data source in TIBCO Data Virtualization Studio and gain access to live Trello data from your TDV Server.
-
Connect to Egnyte Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Egnyte and the SQL Gateway to access Egnyte data from Google Apps Script.
-
Operational Reporting on Google Tasks Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Google Tasks data.
-
Connect to Excel Data in NetBeans
Connect to Excel data in NetBeans with the data source configuration wizard.
-
Connect to Microsoft Planner Data in ACL Analytics
Connect to Microsoft Planner data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Microsoft Planner data.
-
Build Pipelines with Live SAS xpt Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to SAS xpt from Google Cloud Data Fusion, enabling the integration of live SAS xpt data into the building and management of effective data pipelines.
-
How to Connect to Live Apify Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Apify data without replication.
-
Connect to Bannerbear Data in DBeaver
Use the CData ODBC Driver to connect to Bannerbear data in DBeaver.
-
Connect to ZarMoney in SpagoBI
Create reports featuring live ZarMoney data in SpagoBI Studio. Host ZarMoney reports on SpagoBI Server.
-
Replicate Clockify Data in Heroku for Use in Salesforce Connect
Replicate Clockify data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Replicate Webflow Data to Multiple Databases via the CData Sync CLI
Replicate Webflow data to disparate databases with a single configuration.
-
Build Dashboards with Asana Data in DBxtra
Create dynamic dashboards and perform analytics based on Asana data in DBxtra.
-
How to Access Live Copper Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Copper enables you to integrate Copper data into workflows built using Microsoft Power Automate Desktop.
-
Connect to MarkLogic Data from a Connection Pool in JBoss
Integrate MarkLogic data into Java servlets: Use the Management Console in JBoss to install the MarkLogic JDBC Driver.
-
Query Presto Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Presto data from Node.js.
-
Integrating Antigravity CLI with Mailjet data via CData CLI
Connect Mailjet data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Access Live IBM Cloud Object Storage Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live IBM Cloud Object Storage data from your Google Sheets.
-
Automated Continuous ShipEngine Replication to MySQL
Use CData Sync for automated, continuous, customizable ShipEngine replication to MySQL.
-
Automated Continuous Copper Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Copper replication to IBM DB2.
-
How to Connect the Power BI Service to Postmark: Complete Guide
Connect to the CData Software Power BI Connector for Postmark from PowerBI.com to provide real-time Postmark data across the organization.
-
How to Visualize Retently Data in Python with pandas
Use pandas and other modules to analyze and visualize live Retently data in Python.
-
Connect to Gumroad Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Gumroad and work with Gumroad data in your FileMaker applications.
-
Analyze Live SAP Business Warehouse Data in SAS Viya
Use CData Connect AI to connect to SAP Business Warehouse data from SAS Viya and deploy self-service analytics using live SAP Business Warehouse data.
-
Validate Everhour Data with QuerySurge
Access and validate Everhour data in QuerySurge using the CData JDBC Driver.
-
Use the CData Software ODBC Driver for Superchat in MicroStrategy Web
Connect to Superchat data in MicroStrategy Web using the CData Software ODBC Driver for Superchat.
-
Use the CData Software ODBC Driver for Tanda in MicroStrategy Desktop
Connect to Tanda data in MicroStrategy Desktop using the CData Software ODBC Driver for Tanda.
-
Connect to SAP Netweaver Gateway Data in Ruby
Connect to SAP Netweaver Gateway data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.