CData Software - Knowledge Base
Recent Articles
-
Use JayDeBeApi to access HDFS Data in Python
Use standard Python scripting and the development environment of your choice to access live Apache HDFS.
-
Automated Continuous Amazon Marketplace Replication to Databricks
Use CData Sync for automated, continuous, customizable Amazon Marketplace replication to Databricks.
-
Create Informatica Mappings From/To a JDBC Data Source for Zoho Creator
Create Zoho Creator data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect ElevenLabs to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect ElevenLabs with IBM WebSphere for seamless data integration and connectivity.
-
Connect to FHIR from Asprova with CData Software ODBC Driver for FHIR
This article shows how to connect faster to FHIR data from Asprova.
-
Getting Started with the CData Tableau Connector for Sendwithus
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Connect to Beeminder Data in DBeaver
Use the CData ODBC Driver to connect to Beeminder in DBeaver.
-
Analyze Live OneNote Data in SAS Viya
Use CData Connect AI to connect to Microsoft OneNote from SAS Viya and deploy self-service analytics using live Microsoft OneNote.
-
Connect to Outlook Data in Aqua Data Studio
Access Outlook from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Getting Started with the CData SSIS Components for ShipEngine
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ShipEngine.
-
Connect to SAP SuccessFactors Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live SAP SuccessFactors.
-
Connecting Moonlit Workflow with Oracle Financials Cloud 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 Oracle Financials Cloud in real time.
-
Analyze Splunk Data in Looker
Use CData Connect AI to connect to Splunk Data from Looker and build custom apps using live Splunk.
-
Analyze SurveyMonkey Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SurveyMonkey from Power Pivot. You will use the Table Import Wizard to load SurveyMonkey. You can visually build the import query or use any SQL supported by the driver.
-
How to connect to Jira Assets Data in DBVisualizer
Integrate Jira Assets with visual data analysis tools and data connection wizards in DBVisualizer
-
Query Reckon Data in DataGrip
Create a Data Source for Reckon in DataGrip and use SQL to query live Reckon.
-
Import PayPal Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access PayPal. In this article, you will use the OData format to import PayPal into Microsoft Power Query.
-
Use the CData Software JDBC Driver for SAP Ariba Procurement in MicroStrategy
Connect to SAP Ariba Procurement in MicroStrategy Developer using the CData Software JDBC Driver for SAP Ariba Procurement.
-
Integrate Live Datadog Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Datadog to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Build FTP-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for FTP to explore live FTP Data in Cursor to assist with building FTP-powered applications.
-
Connect Email to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Email using the CData Python MCP Server.
-
Build a PostgreSQL Interface for Sentry Data using the CData JDBC Driver
Use the Remoting features of the Sentry JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Zendesk from a Connection Pool in WebLogic
Use the CData JDBC Driver for Zendesk to connect to Zendesk from Web applications running on WebLogic.
-
Configure the CData JDBC Driver for SAP Netweaver Gateway in a Connection Pool in Tomcat
Connect to SAP Netweaver Gateway from a connection pool in Tomcat.
-
Getting Started with the CData Python Connector for Foursquare
Learn to install and license the CData Python Connector
-
Visualize SharePoint Excel Services Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SharePoint Excel Services.
-
How to connect Amazon QuickSight to SAP HANA Data
Create a connection to SAP HANA in CData Connect AI and insert SAP HANA into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to CouchDB Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for CouchDB and the Script function in FileMaker Pro to connect to CouchDB and work with Apache CouchDB in your FileMaker application.
-
Getting Started with the CData SSIS Components for Presto
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Presto.
-
Automate Notion Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Notion from PowerShell? This article demonstrates how to utilize the Notion Cmdlets for tasks like connecting to Notion, automating operations, downloading data, and more.
-
Connect to Stack Exchange Data in DBArtisan
Use wizards in DBArtisan to configure Stack Exchange as a data source.
-
How to Seamlessly Import LightSpeedRetail Data into IBM SPSS Modeler
Integrate LightSpeedRetail data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automated Continuous Twilio Replication to SQLite
Use CData Sync for automated, continuous, customizable Twilio replication to SQLite.
-
Build Sybase IQ-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Sybase IQ to explore live Sybase IQ Data in Cursor to assist with building Sybase IQ-powered applications.
-
Create Data Visualizations Based On ShipStation Data in Mode
Use CData Connect AI to connect to ShipStation Data from Mode and build visualizations using live
-
Query SendPulse Data in DataGrip
Create a Data Source for SendPulse in DataGrip and use SQL to query live SendPulse.
-
Connect to Paymo Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Paymo to connect to Paymo and execute queries in PowerBuilder.
-
Connect SAP SuccessFactors to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SAP SuccessFactors using the CData Python MCP Server.
-
Publish Crystal Reports on Adobe Commerce Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Adobe Commerce.
-
Connect to and Query Recurly Data in QlikView over ODBC
Create data visualizations with Recurly in QlikView.
-
Visualize Azure DevOps Data in TIBCO Spotfire through ADO.NET
Integrate Azure DevOps into dashboards in TIBCO Spotfire.
-
LINQ to Xero 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 Xero Data Provider.
-
Use the CData ODBC Driver for Adobe Analytics from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Adobe Analytics to connect to Adobe Analytics from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Adobe Analytics in Excel.
-
Access Live SAP Ariba Procurement Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live SAP Ariba Procurement data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed SAS XPORT to Power BI dashboards. Simply drag and drop SAS XPORT into data visuals on the Power BI canvas.
-
Automate SingleStore Data Replication to Couchbase
Use CData Sync to Customize and automate SingleStore replication to Couchbase.
-
Import and Visualize Vault CRM Data in Power View
Create data visualizations based on Veeva Vault & Vault CRM in Excel.
-
Access Live MongoDB Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live MongoDB data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Prepare, Blend, and Analyze Sage 200 Data in Alteryx Designer (ODBC)
Build workflows to access live Sage 200 for self-service data analytics.
-
Connect to CampaignMonitor Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for CampaignMonitor and the SQL Gateway to access CampaignMonitor from Google Apps Script.
-
Create Power BI Reports on Real-Time Miro Data
Use the CData ODBC Driver for Miro to visualize Miro in Power BI Desktop.
-
How to connect and process SpaceX from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live SpaceX.
-
Build Data Flows from PolarTeamPro to SQL Server using SSIS
Easily back up PolarTeamPro to SQL Server using the SSIS components for PolarTeamPro.
-
How to Connect to Live FHIR 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 FHIR through natural language.
-
Integrate with live Blackbaud FE NXT Data in Jitterbit
Use CData Connect AI to connect to and integrate live Blackbaud FE NXT in Jitterbit.
-
How to Create Power BI Visual Reports with Real-Time Printify Data
Use CData Power BI Connectors to visualize Printify in Power BI.
-
Use Agno to Talk to Your Google Ads Data 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 Ads for you.
-
Connect to Clari Data from a Connection Pool in JBoss
Integrate Clari into Java servlets: Use the Management Console in JBoss to install the Clari JDBC Driver.
-
How to import Power BI XMLA Data into Apache Solr
Use the CData Software JDBC Driver for Power BI XMLA in Data Import Handler and create an automated import of Power BI XMLA to Apache Solr Enterprise Search platform.
-
Create Dynamic Salesforce Marketing Grids Using the Infragistics XamDataGrid
Learn how you can connect Salesforce Marketing to Infragistics XamDataGrid to build dynamic grids.
-
How to integrate Toggl with Apache Airflow
Access and process Toggl in Apache Airflow using the CData JDBC Driver.
-
Integrate Live Sybase Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Sybase from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Sybase.
-
How to Query Live Google Calendar Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Google Calendar data in natural language using Python.
-
How to Visualize ActiveCampaign Data in Python with pandas
Use pandas and other modules to analyze and visualize live ActiveCampaign in Python.
-
Using the CData Software ODBC Driver for SAP BusinessObjects BI in PyCharm
Connect to SAP BusinessObjects BI as an ODBC data source in PyCharm using the CData Software ODBC Driver for SAP BusinessObjects BI.
-
Excel Spreadsheet Automation on Keap Data with the QUERY Formula
Pull data from Keap, automate spreadsheets, and more with the QUERY formula.
-
Bridge Act CRM Connectivity with Apache NiFi
Access and process Act CRM in Apache NiFi using the CData JDBC Driver.
-
How to Query Datadog Data in MySQL Workbench
Execute MySQL queries against live Datadog from MySQL Workbench.
-
Use the CData Software ODBC Driver for Grafana in MicroStrategy
Connect to Grafana in MicroStrategy Developer using the CData Software ODBC Driver for Grafana.
-
Publish Reports with Nethunt Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Nethunt.
-
How to connect and process Mailjet from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Mailjet.
-
Access XML Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for XML Files.
-
Trigger Reckon Accounts Hosted IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Reckon Accounts Hosted with standard wizards in Logic Apps.
-
Build Dashboards with Onfleet Data in DBxtra
Create dynamic dashboards and perform analytics based on Onfleet in DBxtra.
-
Build Automated Workflows with Live Asana Data in Workato
Use CData Connect AI to connect to live Asana and build automated workflows in Workato.
-
View Reports on Real-Time Short.io Data in Power BI Report Server
Use the CData ODBC Driver for Short.io to visualize Short.io in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Access Outlook Data Using Entity Framework
This article shows how to access Outlook using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to and Query Sentry Data in QlikView over ODBC
Create data visualizations with Sentry in QlikView.
-
Extract, Transform, and Load IBM Cloud Object Storage Data in Informatica PowerCenter
Create a simple Workflow for IBM Cloud Object Storage in Informatica PowerCenter.
-
Integrate Sage Intacct Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Sage Intacct and integrate live Sage Intacct into your Power Automate tasks.
-
Stream FormSite Data into Apache Kafka Topics
Access and stream FormSite in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to PabblySubscriptions from Asprova with CData Software ODBC Driver for PabblySubscriptions
This article shows how to connect faster to PabblySubscriptions data from Asprova.
-
How to Access Live Okta Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Okta enables you to integrate Okta into workflows built using Microsoft Power Automate Desktop.
-
Build AI/ML Models with Live Splunk Data using Dataiku
Connect Splunk Data with Dataiku using the CData JDBC Driver for Splunk.
-
Connect to Perplexity Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Perplexity and the SQL Gateway to access Perplexity from Google Apps Script.
-
Visualize DB2 Data in Sisense
Create an ElastiCube in Sisense app with access to IBM DB2.
-
How to Use a Microsoft Access Database to Update REST Data in Real Time
Update REST data by creating a linked table in Microsoft Access with the CData REST ODBC Driver.
-
How to connect to ZendeskSell Data with Squirrel SQL client
Connect to ZendeskSell and execute queries in the Squirrel SQL Client.
-
Design BIRT Reports on PivotalTracker Data
Provide current PivotalTracker to your embedded analytics.
-
Feed Omnisend Data into FineReport
How to set Omnisend as a JDBC data source in FineReport.
-
Migrating data from Exa to Google BigQuery using CData SSIS Components.
Easily push Exa to Google BigQuery using the CData SSIS Tasks for Exa and Google BigQuery.
-
Automated Continuous Slack Replication to Databricks
Use CData Sync for automated, continuous, customizable Slack replication to Databricks.
-
Viewing Samanage Data in RAD Studio Data Explorer
How to view Samanage in RAD Studio Data Explorer using the CData ODBC Driver for Samanage.
-
Access Mocean Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Mocean.
-
Access Live LinkedIn Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate LinkedIn into the statistical analysis tools available in SAS JMP. This article shows how to use LinkedIn in the Graph Builder and Query Builder.
-
Easily Integrate Gmail Data in Lazarus Pascal IDE
Learn how to easily integrate live Gmail in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Rapidly Develop Adobe Commerce-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 Adobe Commerce.
-
Connect to Zoho Creator Data from Crystal Reports
Use CData Connect AI to connect to and report on live Zoho Creator from Crystal Reports.
-
Connect to ZohoDesk Data in Aqua Data Studio
Access ZohoDesk from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Query QuickBooks Time Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume QuickBooks Time entities in PHP by modeling them as objects.