CData Software - Knowledge Base
Recent Articles
-
How to Build an ETL App for Codat Data in Python with CData
Create ETL applications and real-time data pipelines for Codat in Python with petl.
-
How to Connect to Live SAP HANA 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 SAP HANA through natural language.
-
Trigger BigQuery IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for BigQuery with standard wizards in Logic Apps.
-
Create Reports with Cloudflare Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Cloudflare.
-
Automated Continuous RSS Replication to Snowflake
Use CData Sync for automated, continuous, customizable RSS replication to Snowflake.
-
Create GitHub-Connected Applications in Appsmith
Connect to GitHub Data via CData Connect AI in Appsmith and create custom business applications with real-time access to GitHub.
-
Build Dashboards with ConvertKit Data in DBxtra
Create dynamic dashboards and perform analytics based on ConvertKit in DBxtra.
-
Connecting Pipedream with Microsoft Dataverse 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 Microsoft Dataverse data in real time.
-
How to Build an ETL App for Aweber Data in Python with CData
Create ETL applications and real-time data pipelines for Aweber in Python with petl.
-
Build YouTube Analytics-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live YouTube Analytics and build YouTube Analytics-connected web apps with Axios.
-
Use JayDeBeApi to access Samanage Data in Python
Use standard Python scripting and the development environment of your choice to access live Samanage.
-
Using the CData Software ODBC Driver for MySQL in PyCharm
Connect to MySQL as an ODBC data source in PyCharm using the CData Software ODBC Driver for MySQL.
-
Automated Continuous Yelp Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Yelp replication to Google Cloud SQL.
-
How to Query Close Data in MySQL Workbench
Execute MySQL queries against live Close from MySQL Workbench.
-
Building Dynamic Web Pages with Email Data Using AngularJS
Create single-page applications with live connectivity to Email using the CData API Server.
-
Create Google Sheets Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Google Sheets data access from reports, embedded analytics, and more.
-
Build Instagram-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Instagram to explore live Instagram Data in Claude Code to assist with building Instagram-powered applications.
-
Enable the WooCommerce JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with WooCommerce.
-
Connect to CSV Data in HULFT Integrate
Connect to CSV as a JDBC data source in HULFT Integrate
-
Use the CData ODBC Driver for Azure Synapse from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Azure Synapse to connect to Azure Synapse from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Azure Synapse in Excel.
-
Create Reports from SAP BusinessObjects BI Data in Looker Studio
Use CData Connect AI to gain access to live SAP BusinessObjects BI and create custom reports in Looker Studio.
-
Integrate with Coda Data in JReport Designer
Create charts and reports based on Coda in JReport Designer.
-
Use the CData Software JDBC Driver for Box in MicroStrategy Desktop
Connect to Box in MicroStrategy Desktop using the CData Software JDBC Driver for Box.
-
Connect to Quickbase Data in DBeaver
Use the CData ODBC Driver to connect to Quickbase in DBeaver.
-
Manage Pipeliner CRM Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Pipeliner CRM.
-
Getting Started with the CData SSIS Components for Epicor Kinetic
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Epicor Kinetic.
-
How to Connect DBeaver to FormSite via a JDBC Driver
Manage FormSite with visual tools in DBeaver like the query browser.
-
Edit and Search External SAP Ariba Procurement Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of SAP Ariba Procurement to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SAP Ariba Procurement Data objects that you can access from apps and the dashboard.
-
Use Grok to Talk to Your Google Calendar Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Google Calendar for you.
-
Connect to Real-Time Twitter Ads Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Twitter Ads and Dataflow to import and use Twitter Ads in Power Apps.
-
Automate Kafka Data Replication to Azure Synapse
Use CData Sync to customize and automate Apache Kafka replication to Azure Synapse.
-
Connect Beeminder to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Beeminder using the CData Python MCP Server.
-
Connect to Real-Time Freshteam Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Freshteam in Power Apps.
-
LINQ to ServiceDesk Plus 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 ServiceDesk Plus Data Provider.
-
Access Live Oracle Eloqua Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Oracle Eloqua from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect AgileCRM to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live AgileCRM using the CData Python MCP Server.
-
Getting Started with the CData JDBC Driver for Brex
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Brex.
-
Import SendGrid Data Using Azure Data Factory
Use CData Connect AI to connect to SendGrid Data from Azure Data Factory and import live SendGrid.
-
Automated Continuous Flowlu Replication to Databricks
Use CData Sync for automated, continuous, customizable Flowlu replication to Databricks.
-
DataBind Dynamics 365 Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Dynamics 365 with the DevExpress Windows Forms and Web controls to provide Microsoft Dynamics 365 to a chart.
-
DataBind Controls to Mailgun Data in C++Builder
DataBind to Mailgun in C++Builder with standard components and controls.
-
How to Design OneNote Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to OneNote from mobile and tablet Power Apps.
-
Query Parquet Data as a MySQL Database in Node.js
Execute MySQL queries against Apache Parquet from Node.js.
-
Create Wrike Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Wrike from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Access Data from a SharePoint List Based on a Custom View
We use Server Explorer in Visual Studio to show how the CData provider data model exposes custom views of SharePoint lists.
-
Integrate with GraphQL Data in JReport Designer
Create charts and reports based on GraphQL in JReport Designer.
-
Connect to Live Basecamp Data in MicroStrategy through CData Connect AI
Create a live connection to Basecamp Data in CData Connect AI and connect to your Basecamp from MicroStrategy.
-
Process & Analyze Google Contacts Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Google Contacts Data.
-
Integrate Hacker News with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Hacker News with External Services.
-
Automate Excel Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Microsoft Excel from PowerShell? This article demonstrates how to utilize the Excel Cmdlets for tasks like connecting to Microsoft Excel, automating operations, downloading data, and more.
-
Connect to Lakebase Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Lakebase to connect to Lakebase and execute queries in PowerBuilder.
-
How to work with Browserless Data in Apache Spark using SQL
Access and process Browserless Data in Apache Spark using the CData Software JDBC Driver.
-
Integrate Aha! with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Aha! with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Aha!.
-
Connect to ZeroBounce Data in RapidMiner
Integrate ZeroBounce with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Connect Flowise AI Agents to Live Basecamp 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 Basecamp without replication.
-
Use Grok to Talk to Your Monday.com Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Monday.com for you.
-
Build Adobe Commerce Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Adobe Commerce and build visualizations in Tableau.
-
Automated Continuous Microsoft Exchange Replication to MySQL
Use CData Sync for automated, continuous, customizable Microsoft Exchange replication to MySQL.
-
How to use SQLAlchemy ORM to access Zoom Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Zoom.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Aha!
Provide connectivity to Aha! through an SAP BusinessObjects universe.
-
Automated Printify Data Replication to Teradata
Use CData Sync to Customize and automate Printify replication to Teradata.
-
Integrate CircleCI with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate CircleCI with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to CircleCI.
-
Extract, Transform, and Load Mocean Data in Informatica PowerCenter
Create a simple Workflow for Mocean in Informatica PowerCenter.
-
Integrate Live Dynamics NAV Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Microsoft Dynamics NAV to Blue Prism using the CData ODBC Driver for Dynamics NAV to create automated workflows for repetitive business tasks.
-
Integrate Shopify Data into Power Automate Desktop using CData Connect
CData Connect for Shopify Data enables you to integrate Shopify into workflows built using Microsoft Power Automate Desktop.
-
Aircall Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Aircall facts in real time.
-
How to Seamlessly Import Raisers Edge NXT Data into IBM SPSS Modeler
Integrate Raisers Edge NXT data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Workable Data in HULFT Integrate
Connect to Workable as a JDBC data source in HULFT Integrate
-
Use the CData ODBC Driver for SAP in Microsoft Power Query
You can use the CData SAP ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SAP ERP/NetWeaver into Microsoft Power Query.
-
How to Connect to Live EnterpriseDB Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live EnterpriseDB securely in real time.
-
Integrate with live BigCommerce Data in Jitterbit
Use CData Connect AI to connect to and integrate live BigCommerce in Jitterbit.
-
Build Google Sheets-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Google Sheets to explore live Google Sheets Data in Claude Code to assist with building Google Sheets-powered applications.
-
How to connect Amazon QuickSight to SAP SuccessFactors LMS Data
Create a connection to SAP SuccessFactors LMS in CData Connect AI and insert SAP SuccessFactors LMS into Amazon QuickSight SPICE to build interactive dashboards.
-
DB2 Reporting in OBIEE with the DB2 JDBC Driver
Deploy the DB2 JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Import Outreach.io Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Outreach.io. In this article, you will use the OData format to import Outreach.io into Microsoft Power Query.
-
Connect to Gumroad 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 Gumroad and work with Gumroad in your FileMaker application.
-
Automate SAP Concur Data Replication to Couchbase
Use CData Sync to Customize and automate SAP Concur replication to Couchbase.
-
View Reports on Real-Time Sybase Data in Power BI Report Server
Use the CData ODBC Driver for Sybase to visualize Sybase in Power BI Desktop and then publish them to Power BI Report Server.
-
Build Dashboards with Oracle HCM Cloud Data in DBxtra
Create dynamic dashboards and perform analytics based on Oracle HCM Cloud in DBxtra.
-
Use the CData API Server to Access SAP HANA XS Advanced Data in Microsoft PowerPivot
Use the CData API Server to connect to live SAP HANA XS Advanced in the Power Pivot business intelligence tool.
-
Integrate Live Greenplum Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Pivotal GreenPlum to Blue Prism using the CData ODBC Driver for Greenplum to create automated workflows for repetitive business tasks.
-
Use the CData Software ODBC Driver for Mouseflow in SAS for Real-Time Reporting and Analytics
Connect to real-time Mouseflow in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Mouseflow.
-
Connect to BigCommerce Data from AWS Glue
Use CData Connect AI to gain access to live BigCommerce from your AWS Glue jobs.
-
Connect to REST Data from a Connection Pool in JBoss
Integrate REST into Java servlets: Use the Management Console in JBoss to install the REST JDBC Driver.
-
Visualize Cosmos DB Data in Sisense
Create an ElastiCube in Sisense app with access to Azure Cosmos DB.
-
Analyze BambooHR Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of BambooHR and visualize BambooHR in SAP Analytics Cloud.
-
Build Dashboards with Azure Data Catalog Data in DBxtra
Create dynamic dashboards and perform analytics based on Azure Data Catalog in DBxtra.
-
Connect to LaunchDarkly Data in RazorSQL
Connect to LaunchDarkly from wizards and query LaunchDarkly from the GUI in the RazorSQL database management tool.
-
Integrate DocuSign with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate DocuSign with External Services.
-
Visualize Google Ads 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 Google Ads into TIBCO Spotfire.
-
Build Data Flows from Salesforce CRM Analytics to SQL Server using SSIS
Easily back up Salesforce CRM Analytics to SQL Server using the SSIS components for Salesforce CRM Analytics.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Brex
Provide connectivity to Brex through an SAP BusinessObjects universe.
-
Automate Instagram Data Replication to Azure Data Lake
Use CData Sync to customize and automate Instagram replication to Azure Data Lake.
-
Connect to Google Drive Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Google Drive Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
A PostgreSQL Interface for Printify Data (MySQL Remoting via JDBC)
Use the Remoting features of the Printify JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software JDBC Driver for Microsoft Exchange in MicroStrategy Desktop
Connect to Microsoft Exchange in MicroStrategy Desktop using the CData Software JDBC Driver for Microsoft Exchange.
-
Access Greenplum 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 Pivotal GreenPlum.
-
How to Easily Query Salesloft Data in OpenOffice Base
Connect to Salesloft data in OpenOffice Base using the CData ODBC Driver for Salesloft and generate reports with live data insights.
-
How to create an RPA flow for Stack Exchange Data in UiPath Studio
Use the Stack Exchange ODBC Driver to create workflows that access real-time Stack Exchange without any coding.
-
Import Real-Time Workable Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Workable in ColdFusion.