CData Software - Knowledge Base
Recent Articles
-
Analyze PDFMonkey Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for PDFMonkey from Power Pivot. You will use the Table Import Wizard to load PDFMonkey. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Google Calendar Data in RazorSQL
Connect to Google Calendar from wizards and query Google Calendar from the GUI in the RazorSQL database management tool.
-
Extract, Transform, and Load Twitter Ads Data in Informatica PowerCenter
Create a simple Workflow for Twitter Ads in Informatica PowerCenter.
-
How to Connect to Wrike Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Wrike. Leverage the pyodbc module for ODBC in Python.
-
Connect to YouTube Analytics Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live YouTube Analytics.
-
How to Create Power BI Visual Reports with Real-Time OpenWeatherMap Data
Use CData Power BI Connectors to visualize OpenWeatherMap in Power BI.
-
Visualize Live Stripe Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Stripe using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate Live Acumatica Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Acumatica ERP and integrate live Acumatica ERP into apps built in Microsoft Power Apps.
-
Build an OLAP Cube in SSAS from Guru Data
Establish a connection to Guru data from SQL Server Analysis Services, and use the Guru Data Provider to build OLAP cubes for use in analytics and reporting.
-
Snapchat Ads Reporting in OBIEE with the Snapchat Ads JDBC Driver
Deploy the Snapchat Ads JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Easily Integrate Zendesk Data in Lazarus Pascal IDE
Learn how to easily integrate live Zendesk in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to ChargeOver from Asprova with CData Software ODBC Driver for ChargeOver
This article shows how to connect faster to ChargeOver data from Asprova.
-
SAP ERP: Enhanced sys_procedureparameters Metadata for BAPI Procedures
Learn about the enhanced sys_procedureparameters metadata for BAPI procedures in SAP ERP.
-
How to Work with Bright Data Data in AWS Glue Jobs Using JDBC
Connect to Bright Data from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Visualize Trello Data in TIBCO Spotfire through ADO.NET
Integrate Trello into dashboards in TIBCO Spotfire.
-
Automated Continuous PagerDuty Replication to SQL Server
Use CData Sync for automated, continuous, customizable PagerDuty replication to SQL Server.
-
How to Visualize Gmail Data in Python with pandas
Use pandas and other modules to analyze and visualize live Gmail in Python.
-
Connect to Oracle Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Oracle and the SQL Gateway to access Oracle Database from Google Apps Script.
-
Build an OLAP Cube in SSAS from SAP HANA XS Advanced Data
Establish a connection to SAP HANA XS Advanced data from SQL Server Analysis Services, and use the SAP HANA XS Advanced Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use the CData API Server to Access ConvertKit Data in Microsoft PowerPivot
Use the CData API Server to connect to live ConvertKit in the Power Pivot business intelligence tool.
-
How to Easily Query Eventbrite Data in OpenOffice Base
Connect to Eventbrite data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Integrate Cline with Live Confluence Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Atlassian Confluence from within your IDE.
-
Getting Started with the CData Tableau Connector for WordPress
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Wordpress.
-
Create Power BI Reports on Real-Time Reply.io Data
Use the CData ODBC Driver for Reply.io to visualize Reply.io in Power BI Desktop.
-
How to integrate Spotify with Apache Airflow
Access and process Spotify in Apache Airflow using the CData JDBC Driver.
-
Connect to ADP Data from Crystal Reports
Use CData Connect AI to connect to and report on live ADP from Crystal Reports.
-
How to Connect Flowise AI Agents to Live WordPress 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 WordPress without replication.
-
How to use SQLAlchemy ORM to access Kintone Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Kintone.
-
Create Datasets from SendInBlue in Domo Workbench and Build Visualizations of SendInBlue Data in Domo
Use the CData Software ODBC Driver for SendInBlue to create datasets from SendInBlue in Domo Workbench and then build visualizations in the Domo service.
-
Prepare, Blend, and Analyze Opsgenie Data in Alteryx Designer (ODBC)
Build workflows to access live Opsgenie for self-service data analytics.
-
Visualize Live IBM Informix Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live IBM Informix using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build SendPulse-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData API Driver for MCP Server to explore live SendPulse Data in Gemini Code Assist to assist with building SendPulse-powered applications.
-
Use Microsoft Copilot Studio to talk to your PayPal Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your PayPal for you.
-
Integrating GitHub Copilot CLI with Twitter Ads via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Connect to Salesforce Pardot Data from Crystal Reports
Use CData Connect AI to connect to and report on live Salesforce Pardot from Crystal Reports.
-
Build Mistral AI-Powered Applications in Claude Code with CData MCP Server
Use the CData API Driver for MCP Server to explore live Mistral AI Data in Claude Code to assist with building Mistral AI-powered applications.
-
Automated Continuous Aweber Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Aweber replication to Azure SQL Database.
-
Operational Reporting on Tanda Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Tanda.
-
How to Connect to Live SAP Concur Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live SAP Concur without replication.
-
Connect to Live BigQuery Data in PostGresSQL Interface through CData Connect AI
Create a live connection to BigQuery in CData Connect AI and connect to your Google BigQuery from PostgreSQL.
-
Getting Started with the CData Python Connector for Pipeliner CRM
Learn to install and license the CData Python Connector
-
Build Visualizations of ClickUp Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ClickUp in Birst.
-
Integrate Xero Data in Pentaho Data Integration
Build ETL pipelines based on Xero Accounting in the Pentaho Data Integration tool.
-
Excel Spreadsheet Automation on Zoho Inventory Data with the QUERY Formula
Pull data from Zoho Inventory, automate spreadsheets, and more with the QUERY formula.
-
Connect to Gong Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Gong from Filemaker Pro on Mac.
-
How to Connect to Live HBase Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Apache HBase for you.
-
Create a Data Access Object for ShipEngine Data using JDBI
A brief overview of creating a SQL Object API for ShipEngine in JDBI.
-
Integrating ADP Data in Talend Cloud Data Management Platform
Connect ADP Data with Talend Cloud Data Management Platform using the CData JDBC Driver for ADP.
-
Natively Connect to Sendwithus Data in PHP
The CData ODBC driver for Sendwithus enables you to create PHP applications with connectivity to Sendwithus. Leverage the native support for ODBC in PHP.
-
Connect to Oracle HCM Cloud Data in Jaspersoft Studio
Execute SQL to remote Oracle HCM Cloud in Jaspersoft Studio.
-
Create Adobe Commerce-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Adobe Commerce Data from OutSystems and build custom enterprise apps using live Adobe Commerce.
-
Analyze Zoho Books Data in Cognos Analytics
Use CData Connect AI to connect to Zoho Books Data from Cognos Analytics and analyze live Zoho Books.
-
Connect to Invoiced Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Invoiced in the Denodo Virtual DataPort Administrator.
-
How to connect SharePoint with Zendesk Data through external lists
Provide Zendesk to SharePoint users as an external list.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for AdRoll
Provide connectivity to AdRoll through an SAP BusinessObjects universe.
-
How to Easily Query Instagram Data in OpenOffice Base
Connect to Instagram data in OpenOffice Base using the CData ODBC Driver for Instagram and generate reports with live data insights.
-
Rapidly Develop Accelo-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 Accelo.
-
How to integrate MarkLogic with Apache Airflow
Access and process MarkLogic in Apache Airflow using the CData JDBC Driver.
-
Create a Data Access Object for Printify Data using JDBI
A brief overview of creating a SQL Object API for Printify in JDBI.
-
Build Dashboards with Gong Data in Dundas BI
Create dynamic dashboards and perform analytics based on Gong in Dundas BI.
-
Write a Simple Go Application to work with ClickTime Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to ClickTime.
-
Build Apps with Live ShipEngine Data Using the Low-Code Development Platform of Mendix
Connect ShipEngine with Mendix to build apps using the CData API Driver for JDBC.
-
Integrate with Live Marketo Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Marketo from the MuleSoft Anypoint Platform to integrate live Marketo into custom reports and dashboards.
-
Integrate Spotify with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Spotify with External Services.
-
LINQ to Klaviyo 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 Klaviyo Data Provider.
-
Access Placid Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Placid from HeidiSQL.
-
Seamlessly Bring Facebook Ads Data into Retool Using CData Connect AI
Integrate Facebook Ads data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
SAP Business Warehouse Reporting in OBIEE with the SAP Business Warehouse JDBC Driver
Deploy the SAP Business Warehouse JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Analyze SendGrid Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SendGrid from Power Pivot. You will use the Table Import Wizard to load SendGrid. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Hugging Face Data in DBeaver
Use the CData ODBC Driver to connect to Hugging Face in DBeaver.
-
Visualize ZohoDesk Data in Tableau
The CData ODBC driver for ZohoDesk enables you integrate ZohoDesk into Tableau dashboards.
-
Connecting Agentforce with Marketo Data 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 Marketo for you.
-
Create a Data Access Object for Tally Data using JDBI
A brief overview of creating a SQL Object API for Tally ERP in JDBI.
-
Use the CData Software JDBC Driver for Oracle Sales in MicroStrategy
Connect to Oracle Sales in MicroStrategy Developer using the CData Software JDBC Driver for Oracle Sales.
-
Query Reckon Accounts Hosted Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Reckon Accounts Hosted and perform CRUD operations on Reckon Accounts Hosted from Node.js.
-
How to Easily Query LeadDesk Data in OpenOffice Base
Connect to LeadDesk data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Use the CData Software ODBC Driver for HBase in MicroStrategy Web
Connect to Apache HBase in MicroStrategy Web using the CData Software ODBC Driver for HBase.
-
Integrate with live Google Calendar Data in Jitterbit
Use CData Connect AI to connect to and integrate live Google Calendar in Jitterbit.
-
Access Live Exa Data in AWS Lambda
Connect to live Exa in AWS Lambda using the CData JDBC Driver.
-
Bridge Exact Online Connectivity with Apache NiFi
Access and process Exact Online in Apache NiFi using the CData JDBC Driver.
-
Query Zoho Creator Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Zoho Creator from Node.js.
-
Create Data Visualizations in Cognos BI with Splunk Data
Access Splunk as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build a Simple VCL Application for WooCommerce Data
How to build a simple VCL Application to view WooCommerce in RAD Studio using the CData ODBC Driver for WooCommerce.
-
Import Real-Time CloudConvert Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use CloudConvert in ColdFusion.
-
Model CSV Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and CSV, enabling the direct import of real-time CSV/TSV Files.
-
Visualize Short.io Data in Tableau
The CData ODBC driver for Short.io enables you integrate Short.io into Tableau dashboards.
-
How to Seamlessly Import Intercom Data into IBM SPSS Modeler
Integrate Intercom data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Extract, Transform, and Load Quaderno Data in Informatica PowerCenter
Create a simple Workflow for Quaderno in Informatica PowerCenter.
-
Automated Continuous SendInBlue Replication to SQL Server
Use CData Sync for automated, continuous, customizable SendInBlue replication to SQL Server.
-
Automated Continuous XML Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable XML replication to Apache Kafka.
-
How to Query Live Mode Data in Perplexity MacOS Desktop
Connect to and query live Mode Data in Perplexity Desktop using CData MCP Server.
-
Integrating Avro Data in Talend Cloud Data Management Platform
Connect Avro Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Avro.
-
Use Biml to Build SSIS Tasks to Replicate Attio Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Attio to SQL Server.
-
Connect to WooCommerce Data in Claris FileMaker Pro
Use the CData ODBC Driver for WooCommerce in FileMaker Pro to connect to WooCommerce and work with WooCommerce in your FileMaker applications.
-
Connect to Flowlu Data from PowerBuilder via JDBC
This article demonstrates how to access Flowlu from PowerBuilder using the Flowlu JDBC Driver.
-
Analyze Egnyte Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Egnyte and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Configure the CData JDBC Driver for Freshservice in a Connection Pool in Tomcat
Connect to Freshservice from a connection pool in Tomcat.
-
Validate Email Data with QuerySurge
Access and validate Email in QuerySurge using the CData JDBC Driver.
-
Analyze Salesforce Pardot Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Salesforce Pardot and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
How to Work with ZohoDesk Data in AWS Glue Jobs Using JDBC
Connect to ZohoDesk from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.