CData Software - Knowledge Base
Recent Articles
-
Query Twitter Ads Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Twitter Ads from Node.js.
-
Visualize Coinbase Data in Sisense
Create an ElastiCube in Sisense app with access to Coinbase.
-
Getting Started with the CData Excel Add-In for CapsuleCRM
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for CapsuleCRM.
-
How to Connect to Facebook Ads Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Facebook Ads. Leverage the pyodbc module for ODBC in Python.
-
Build Cosmos DB-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Azure Cosmos DB and build Cosmos DB-connected web apps with Axios.
-
How to Create Power BI Visual Reports with Real-Time Auth0 Data
Use CData Power BI Connectors to visualize Auth0 in Power BI.
-
Choosing the Best Method to Connect Mistral AI to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Mistral AI from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Add PhantomBuster Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for PhantomBuster with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build PingOne-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for PingOne to explore live PingOne Data in GitHub Copilot to assist with building PingOne-powered applications.
-
Create Reports with PayPal Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date PayPal.
-
How to create an RPA flow for Email Data in UiPath Studio
Use the Email ODBC Driver to create workflows that access real-time Email without any coding.
-
Connect to and Query Google Tasks Data in QlikView over ODBC
Create data visualizations with Google Tasks in QlikView.
-
Connect to SageHR Data in RapidMiner
Integrate SageHR with standard components and data source configuration wizards in RapidMiner Studio.
-
Replicate Vimeo Data from PowerShell
Write a quick PowerShell script to query Vimeo. Use connectivity to the live data to replicate Vimeo to SQL Server.
-
Connect to SAP Ariba Source Data from AWS Glue
Use CData Connect AI to gain access to live SAP Ariba Source from your AWS Glue jobs.
-
A PostgreSQL Interface for BenchmarkEmail Data (MySQL Remoting via JDBC)
Use the Remoting features of the BenchmarkEmail JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to publish and share Quaderno Data dashboards with Tableau Server
The CData ODBC driver for Quaderno enables you integrate Quaderno into Tableau dashboards.
-
Automated Continuous Oracle Eloqua Reporting Replication to Vertica
Use CData Sync for automated, continuous, customizable Oracle Eloqua Reporting replication to Vertica.
-
Connect to Moosend Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Moosend and work with Moosend in your FileMaker applications.
-
Integrate with Mode Data in JReport Designer
Create charts and reports based on Mode in JReport Designer.
-
Access Live Outreach.io Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Outreach.io through MCP integration.
-
Automate LightSpeedRetail Integration Tasks from PowerShell
Are you in search of a quick and easy way to access LightSpeedRetail from PowerShell? This article demonstrates how to utilize the LightSpeedRetail Cmdlets for tasks like connecting to LightSpeedRetail, automating operations, downloading data, and more.
-
Use the CData Software ODBC Driver for Customer.io in MicroStrategy Web
Connect to Customer.io in MicroStrategy Web using the CData Software ODBC Driver for Customer.io.
-
Model Azure Data Lake Storage Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Azure Data Lake Storage, enabling the direct import of real-time Azure Data Lake Storage.
-
Connect to Xero Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Xero Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Choosing the Best Method to Connect Tickspot to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Tickspot from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build MYOB AccountRight-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for MYOB AccountRight Data and create custom apps in Mendix.
-
Integrating Cursor CLI with Intercom Data 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.
-
Working with iContact Data in LINQPad
Execute LINQ queries to iContact in LINQPad.
-
How to connect to SendGrid Data in DBVisualizer
Integrate SendGrid with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Freshdesk Data from PowerBuilder via ADO.NET
This article demonstrates how to access Freshdesk from Appeon PowerBuilder using the CData ADO.NET Provider for Freshdesk.
-
How to Connect to Live Freshdesk 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 Freshdesk through natural language.
-
Create Splunk-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Splunk Data from OutSystems and build custom enterprise apps using live Splunk.
-
How to Visualize Salesloft Data in Python with pandas
Use pandas and other modules to analyze and visualize live Salesloft in Python.
-
Import SAP SuccessFactors LMS Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access SAP SuccessFactors LMS. In this article, you will use the OData format to import SAP SuccessFactors LMS into Microsoft Power Query.
-
Integrate PagerDuty Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live PagerDuty from Informatica Cloud.
-
How to Create Power BI Visual Reports with Real-Time TaxJar Data
Use CData Power BI Connectors to visualize TaxJar in Power BI.
-
Build Browserless-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Browserless and build web apps with connectivity to live Browserless.
-
Work with Live QuickBooks Online Data in Power Query
Use CData Connect AI to connect to QuickBooks Online and work with live QuickBooks Online in Microsoft Power Query.
-
Write a Simple Go Application to work with Redshift Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Amazon Redshift.
-
Publish Reports with Unbounce Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Unbounce.
-
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 ERP from within the chat interface.
-
Access Testmonitor 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 Testmonitor.
-
Analyze Workable Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Workable with the CData JDBC Driver for Workable.
-
Create Zoho CRM-Connected Business Apps in AppSheet
Connect to Zoho CRM Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Zoho CRM.
-
Connect to Klipfolio from Asprova with CData Software ODBC Driver for Klipfolio
This article shows how to connect faster to Klipfolio data from Asprova.
-
Use the CData Software JDBC Driver for Klipfolio in MicroStrategy Web
Connect to Klipfolio in MicroStrategy Web using the CData Software JDBC Driver for Klipfolio.
-
Integrate CampaignMonitor Data in Pentaho Data Integration
Build ETL pipelines based on CampaignMonitor in the Pentaho Data Integration tool.
-
Build a PostgreSQL Interface for OneNote Data using the CData JDBC Driver
Use the Remoting features of the OneNote JDBC Driver to create a PostgreSQL entry-point for data access.
-
Trigger Microsoft Ads IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Microsoft Ads with standard wizards in Logic Apps.
-
Connect to Oracle Sales Data from PowerBuilder via JDBC
This article demonstrates how to access Oracle Sales from PowerBuilder using the Oracle Sales JDBC Driver.
-
Process & Analyze SAP Business Warehouse Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SAP Business Warehouse Data.
-
Automated Continuous Clockify Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Clockify replication to Amazon S3.
-
Getting Started with the CData ADO.NET Provider for Access
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Access.
-
Integrating Claude Code CLI with Intercom Data 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.
-
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 in real time.
-
Access Live Brex Data in Coginiti Pro
Connect to and query live Brex from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Consume Salesforce Marketing OData Feeds in PowerBuilder
This article demonstrates how to consume Salesforce Marketing Cloud as OData feeds from PowerBuilder using the API Server.
-
Use the CData SSIS Components to Insert New or Update Existing Basecamp Records from SQL Server
Easily push SQL Server data to Basecamp using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Basecamp or update existing records with data from a SQL Server database.
-
Connect to Real-Time Oracle Financials Cloud Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Oracle Financials Cloud and Dataflow to import and use Oracle Financials Cloud in Power Apps.
-
How to Access Live Bitbucket Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Bitbucket enables you to integrate Bitbucket into workflows built using Microsoft Power Automate Desktop.
-
Build a Singer.io Tap for Bitly With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Bitly data using
-
Integrating Claude Code CLI with ServiceNow Data 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.
-
Use ChatGPT to Talk to Your Google Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Google Analytics for you.
-
Automated CockroachDB Data Replication to Teradata
Use CData Sync to Customize and automate CockroachDB replication to Teradata.
-
View Reports on Real-Time SAP Concur Data in Power BI Report Server
Use the CData ODBC Driver for SAP Concur to visualize SAP Concur in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrating Kiro CLI with Act-On Data 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 SharePoint Excel Services Data in RazorSQL
Connect to SharePoint Excel Services from wizards and query SharePoint Excel Services from the GUI in the RazorSQL database management tool.
-
Changelog: Driver Update 2024.14
Review the driver-specific changes from the 2024.1 CData Driver release.
-
How to Connect to Live Snowflake 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 Snowflake without replication.
-
How to Connect to Live Google Ad Manager 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 Google Ad Manager for you.
-
Connect to Nethunt Data in HULFT Integrate
Connect to Nethunt as a JDBC data source in HULFT Integrate
-
DataBind Controls to Box Data in C++Builder
DataBind to Box in C++Builder with standard components and controls.
-
Connect to MySQL Data from PowerBuilder via ADO.NET
This article demonstrates how to access MySQL from Appeon PowerBuilder using the CData ADO.NET Provider for MySQL.
-
Analyze ZeroBounce Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze ZeroBounce in Microsoft R Open.
-
Automated Continuous EnterpriseDB Replication to Amazon S3
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to Amazon S3.
-
How to integrate Salesforce Data 360 with Apache Airflow
Access and process Salesforce Data 360 in Apache Airflow using the CData JDBC Driver.
-
A PostgreSQL Interface for Active Directory Data (MySQL Remoting via JDBC)
Use the Remoting features of the Active Directory JDBC Driver to create a PostgreSQL entry-point for data access.
-
Design BIRT Reports on Recurly Data
Provide current Recurly to your embedded analytics.
-
Access Live Unbounce Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Unbounce into the statistical analysis tools available in SAS JMP. This article shows how to use Unbounce in the Graph Builder and Query Builder.
-
Automate Mailjet Data Replication to SAP HANA
Use CData Sync to customize and automate Mailjet replication to SAP HANA.
-
Import SAP Netweaver Gateway Data Using Azure Data Factory
Use CData Connect AI to connect to SAP Netweaver Gateway Data from Azure Data Factory and import live SAP Netweaver Gateway.
-
Integrating Cursor CLI with Couchbase Data 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.
-
Access Live Tally Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Tally ERP from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Automated Continuous LinkedIn Replication to Snowflake
Use CData Sync for automated, continuous, customizable LinkedIn replication to Snowflake.
-
Create Data Visualizations in Cognos BI with ZeroBounce Data
Access ZeroBounce as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to SQL Server Data from PowerBuilder via JDBC
This article demonstrates how to access Microsoft SQL Server from PowerBuilder using the SQL Server JDBC Driver.
-
Create Data Visualizations in Cognos BI with Active Directory Data
Access Active Directory as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Edit and Search Pipedrive External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Pipedrive to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Pipedrive objects that you can access from apps and the dashboard.
-
Replicate Odoo Data in Heroku for Use in Salesforce Connect
Replicate Odoo ERP to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to and Query Sage 300 Data in QlikView over ODBC
Create data visualizations with Sage 300 in QlikView.
-
Connect to Raisers Edge NXT in SpagoBI
Create reports featuring live Raisers Edge NXT in SpagoBI Studio. Host Raisers Edge NXT reports on SpagoBI Server.
-
Connect to Snapchat Ads Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Snapchat Ads and the SQL Gateway to access Snapchat Ads from Google Apps Script.
-
Access Aha! Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Aha! from HeidiSQL.
-
Connect to Simplesat from a Connection Pool in WebLogic
Use the CData JDBC Driver for Simplesat to connect to Simplesat from Web applications running on WebLogic.
-
Access Live Nuclia Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Nuclia in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate SAP Netweaver Gateway with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SAP Netweaver Gateway with External Services.
-
Integrating Zendesk Data in Talend Cloud Data Management Platform
Connect Zendesk Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Zendesk.
-
Use the CData Software ODBC Driver for Nuclia in MicroStrategy
Connect to Nuclia in MicroStrategy Developer using the CData Software ODBC Driver for Nuclia.
-
Working with AgileCRM Data in LINQPad
Execute LINQ queries to AgileCRM in LINQPad.