CData Software - Knowledge Base
Recent Articles
-
Connect to Jira from Asprova with CData Software ODBC Driver for Jira
This article shows how to connect faster to Jira data from Asprova.
-
Connect to Figshare in SpagoBI
Create reports featuring live Figshare in SpagoBI Studio. Host Figshare reports on SpagoBI Server.
-
Publish Reports with ServiceDesk Plus Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ServiceDesk Plus.
-
Build Automated Workflows with Live Office 365 Data in Workato
Use CData Connect AI to connect to live Microsoft Office 365 and build automated workflows in Workato.
-
Natively Connect to Sage 300 Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Sage 300. Leverage the native support for ODBC in PHP.
-
Analyze GitHub Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze GitHub with the CData JDBC Driver for GitHub.
-
Query Quaderno Data in DataGrip
Create a Data Source for Quaderno in DataGrip and use SQL to query live Quaderno.
-
View Reports on Real-Time Facebook Data in Power BI Report Server
Use the CData ODBC Driver for Facebook to visualize Facebook in Power BI Desktop and then publish them to Power BI Report Server.
-
Building Dynamic Web Pages with Salesforce Data 360 Data Using AngularJS
Create single-page applications with live connectivity to Salesforce Data 360 using the CData API Server.
-
Bidirectional Access to WordPress Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate WordPress in Filemaker Pro for Mac or Windows.
-
How to Access Live SAP Concur Data in Visual Studio Code via Cline
Run CData MCP Server for SAP Concur on Windows Subsytem for Linux (WSL) and connect to live SAP Concur from the Cline extension in Visual Studio Code.
-
Access Live Pushbullet Data in Coginiti Pro
Connect to and query live Pushbullet from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Build an ETL App for Workable Data in Python with CData
Create ETL applications and real-time data pipelines for Workable in Python with petl.
-
Feed Oracle HCM Cloud Data into FineReport
How to set Oracle HCM Cloud as a JDBC data source in FineReport.
-
How to Access Live Sage Cloud Accounting Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Sage Cloud Accounting enables you to integrate Sage Business Cloud Accounting into workflows built using Microsoft Power Automate Desktop.
-
Connect to Mouseflow Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to Connect to Live Azure Data Lake Storage Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Azure Data Lake Storage for you.
-
Connect to Paddle 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 Paddle and work with Paddle in your FileMaker application.
-
Automate Azure Blob Storage Data Replication to Azure Synapse
Use CData Sync to customize and automate Azure Blob Storage replication to Azure Synapse.
-
Connect to and Query RabbitMQ Data in QlikView over ODBC
Create data visualizations with RabbitMQ in QlikView.
-
CData Sync’s Enhanced CDC vs Traditional CDC: A Performance Comparison
Testing how much faster Sync is able to replicate changes using Enhanced CDC vs Traditional CDC.
-
Automated Continuous Drift Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Drift replication to Azure SQL Database.
-
Replicate Salesloft Data from PowerShell
Write a quick PowerShell script to query Salesloft. Use connectivity to the live data to replicate Salesloft to SQL Server.
-
Create Microsoft Entra ID-Connected Applications in Appsmith
Connect to Microsoft Entra ID Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Microsoft Entra ID.
-
Connect to Real-Time Clio Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Clio in Power Apps.
-
Build Dashboards with Intercom Data in DBxtra
Create dynamic dashboards and perform analytics based on Intercom in DBxtra.
-
Visualize Live Accelo Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Accelo using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Trigger Klaviyo IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Klaviyo with standard wizards in Logic Apps.
-
Connect to Avaza Data in DBeaver
Use the CData ODBC Driver to connect to Avaza in DBeaver.
-
How to Connect the Power BI Service to Vercel: Complete Guide
Connect to the CData Software Power BI Connector for Vercel from PowerBI.com to provide real-time Vercel across the organization.
-
Getting Started with the CData ADO.NET Provider for Adobe Experience Manager
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Adobe Experience Manager.
-
Connect to Microsoft Teams 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 Microsoft Teams.
-
Import Real-Time Gmail Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Gmail in ColdFusion.
-
How to Visualize Instagram Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Instagram in Python.
-
Integrating Slack Data in Talend Cloud Data Management Platform
Connect Slack Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Slack.
-
Prepare, Blend, and Analyze Marketo Data in Alteryx Designer (Connect AI)
Build workflows to access live Marketo for self-service data analytics.
-
How to Visualize Power BI XMLA Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Power BI XMLA in Python.
-
Automate JotForm Integration Tasks from PowerShell
Are you in search of a quick and easy way to access JotForm from PowerShell? This article demonstrates how to utilize the JotForm Cmdlets for tasks like connecting to JotForm, automating operations, downloading data, and more.
-
Visualize Coinbase Data in Tableau
The CData ODBC driver for Coinbase enables you integrate Coinbase into Tableau dashboards.
-
Visualize Live Google Ad Manager Data in the Power BI Service
Use CData Connect AI to connect to live Google Ad Manager and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Keap
Provide connectivity to Keap through an SAP BusinessObjects universe.
-
How to Query Live Coinbase Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Coinbase data in natural language using Python.
-
How to Access Drift Data Using Entity Framework
This article shows how to access Drift using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build Agents in Relevance AI with Access to Live Salesforce CRM Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Salesforce CRM Analytics within intelligent agent workflows.
-
Build Dashboards with Confluence Data in DBxtra
Create dynamic dashboards and perform analytics based on Atlassian Confluence in DBxtra.
-
Automated Continuous Adobe Commerce Replication to SQL Server
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to SQL Server.
-
Build AI Agents with Act-On Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Act-On through CData Connect AI.
-
Build Greenhouse-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Greenhouse to explore live Greenhouse Data in Gemini Code Assist to assist with building Greenhouse-powered applications.
-
Integrating Codex CLI with Reckon 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.
-
Migrating data from FormSite to Google BigQuery using CData SSIS Components.
Easily push FormSite to Google BigQuery using the CData SSIS Tasks for FormSite and Google BigQuery.
-
Access Live Facebook Data in Coginiti Pro
Connect to and query live Facebook from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build Smartsheet-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Smartsheet Data from Zoho Analytics and import live Smartsheet.
-
Add Clari Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Clari with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to integrate Metabase with Google Spanner Data
Use CData Connect AI to connect to live Google Spanner and create an interactive dashboard in Metabase from Google Spanner.
-
Model Google Contacts Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Google Contacts, enabling the direct import of real-time Google Contacts.
-
Access Live ZohoExpense Data in Coginiti Pro
Connect to and query live ZohoExpense from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build Smartsheet Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Smartsheet and build visualizations in Tableau.
-
Integrate Live Cloudant Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Cloudant from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live IBM Cloudant.
-
Create Paylocity-Connected Business Apps in AppSheet
Connect to Paylocity Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Paylocity.
-
Connect to Google Ad Manager Data from Crystal Reports
Use CData Connect AI to connect to and report on live Google Ad Manager from Crystal Reports.
-
Automated Continuous SingleStore Replication to Oracle
Use CData Sync for automated, continuous, customizable SingleStore replication to Oracle.
-
Connect to PingOne Data in CloverDX (formerly CloverETL)
Transfer PingOne using the visual workflow in the CloverDX data integration tool.
-
How to Work with Act-On Data in ETL Validator JDBC
Connect to Act-On from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate with Slack Data in JReport Designer
Create charts and reports based on Slack in JReport Designer.
-
Adobe Commerce Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Adobe Commerce through CData Connect AI using different applications and tools.
-
Connect to Mocean Data in RazorSQL
Connect to Mocean from wizards and query Mocean from the GUI in the RazorSQL database management tool.
-
Use the CData ODBC Driver for Jodoo from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Jodoo to connect to Jodoo from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Jodoo in Excel.
-
Create Reports with YouTube Analytics Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date YouTube Analytics.
-
Connect to Twitter Ads Data in ACL Analytics
Connect to Twitter Ads via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Twitter Ads.
-
How to Connect DBeaver to Exa via a JDBC Driver
Manage Exa with visual tools in DBeaver like the query browser.
-
Create a Data Access Object for Unbounce Data using JDBI
A brief overview of creating a SQL Object API for Unbounce in JDBI.
-
Automated Continuous MarkLogic Replication to Amazon S3
Use CData Sync for automated, continuous, customizable MarkLogic replication to Amazon S3.
-
Create Reports with GetResponse Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date GetResponse.
-
Easily Integrate Copper Data in Lazarus Pascal IDE
Learn how to easily integrate live Copper in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Getting Started with the CData Power BI Connector for Trello
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Trello.
-
Consume Oracle Financials Cloud OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Oracle Financials Cloud feeds that reflect any changes in SAP Lumira.
-
Visualize Live Google Search Results in the Power BI Service
Use CData Connect AI to connect to live Google Search and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating GitHub Copilot CLI with Microsoft Access 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.
-
Build a PostgreSQL Interface for Missive Data using the CData JDBC Driver
Use the Remoting features of the Missive JDBC Driver to create a PostgreSQL entry-point for data access.
-
Consume Microsoft Entra ID OData Feeds in PowerBuilder
This article demonstrates how to consume Microsoft Entra ID as OData feeds from PowerBuilder using the API Server.
-
Build Excel-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Excel to explore live Excel Data in Cursor to assist with building Excel-powered applications.
-
Analyze Excel Online Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Microsoft Excel Online and visualize Microsoft Excel Online in SAP Analytics Cloud.
-
Build Voice Agents in ElevenLabs with access to Live CockroachDB Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live CockroachDB.
-
Connect to IBM Cloud Object Storage in SpagoBI
Create reports featuring live IBM Cloud Object Storage in SpagoBI Studio. Host IBM Cloud Object Storage reports on SpagoBI Server.
-
Connect to Marketo Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Marketo in the Denodo Virtual DataPort Administrator.
-
Build Charts with Moosend Data in Clear Analytics
Create dynamic charts and perform analytics based on Moosend in Clear Analytics.
-
Import Snapchat Ads Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Snapchat Ads Data and provide access to live Snapchat Ads for custom reports in the Power BI Service.
-
Use the CData ODBC Driver for Salesforce Data 360 from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Salesforce Data 360 to connect to Salesforce Data 360 from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Salesforce Data 360 in Excel.
-
Query WordPress Data as a SQL Server Database in Node.js
Execute SQL Server queries against WordPress from Node.js.
-
Automate Aha! Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Aha! from PowerShell? This article demonstrates how to utilize the Aha! Cmdlets for tasks like connecting to Aha!, automating operations, downloading data, and more.
-
How to Work with LeadDesk Data in AWS Glue Jobs Using JDBC
Connect to LeadDesk from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrating OpenCode Terminal with Impala 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 Live Moosend Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Moosend to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Access Live Basecamp Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Basecamp from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connecting Moonlit Workflow with Adobe Commerce 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 Adobe Commerce in real time.
-
Automated Continuous DB2 Replication to AlloyDB
Use CData Sync for automated, continuous, customizable DB2 replication to AlloyDB.
-
Automate Adobe Commerce Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Adobe Commerce from PowerShell? This article demonstrates how to utilize the Adobe Commerce Cmdlets for tasks like connecting to Adobe Commerce, automating operations, downloading data, and more.
-
Build Automated Workflows with Live Google Ad Manager Data in Workato
Use CData Connect AI to connect to live Google Ad Manager and build automated workflows in Workato.
-
Getting Started with the CData Power BI Connector for Postmark
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Build a PostgreSQL Interface for Sybase Data using the CData JDBC Driver
Use the Remoting features of the Sybase JDBC Driver to create a PostgreSQL entry-point for data access.