CData Software - Knowledge Base
Recent Articles
-
Connect to Kintone Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Kintone data.
-
Integrate Webex Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Webex data from Informatica Cloud.
-
A PostgreSQL Interface for Timely Data using the CData ODBC Driver
Use the SQL Gateway and Timely ODBC Driver to create a PostgreSQL entry-point for data access.
-
View Reports on Real-Time Mixpanel Data in Power BI Report Server
Use the CData ODBC Driver for Mixpanel to visualize Mixpanel data in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrating Cursor with Printful 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.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Postmark
Provide connectivity to Postmark data through an SAP BusinessObjects universe.
-
Create Power BI Reports on Real-Time Azure Analysis Services Data
Use the CData ODBC Driver for Azure Analysis Services to visualize Azure Analysis Services data in Power BI Desktop.
-
Configure the CData JDBC Driver for Active Directory in a Connection Pool in Tomcat
Connect to Active Directory data from a connection pool in Tomcat.
-
Build Semantic Layer Views for Snapchat Ads Data in APOS Live Data Gateway
Use the CData Connector for Snapchat Ads in APOS Live Data Gateway to build Semantic Layer Views for Snapchat Ads data.
-
How to Work with Shortcut Data in AWS Glue Jobs Using JDBC
Connect to Shortcut from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous QuickBooks Replication to IBM DB2
Use CData Sync for automated, continuous, customizable QuickBooks replication to IBM DB2.
-
How to Access ShipStation Data Using Entity Framework
This article shows how to access ShipStation data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Access Facebook Ads 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 Facebook Ads data.
-
Access Live Stack Exchange Data in Coginiti Pro
Connect to and query live Stack Exchange data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Model Amazon Marketplace Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Amazon Marketplace, enabling the direct import of real-time Amazon Marketplace data.
-
Connect to BigQuery Data in ACL Analytics
Connect to BigQuery data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to BigQuery data.
-
Visualize Live Google Campaign Manager 360 Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Google Campaign Manager 360 data into custom reports in Power BI.
-
Import Toggl Data Using Azure Data Factory
Use CData Connect AI to connect to Toggl Data from Azure Data Factory and import live Toggl data.
-
Automate Planio Data Replication to Azure Data Lake
Use CData Sync to customize and automate Planio data replication to Azure Data Lake.
-
Connect to FormSite in SpagoBI
Create reports featuring live FormSite data in SpagoBI Studio. Host FormSite reports on SpagoBI Server.
-
Integrate LibreChat with Live Elasticsearch Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Elasticsearch data from within the chat interface.
-
Automate Samanage Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Samanage data from PowerShell? This article demonstrates how to utilize the Samanage Cmdlets for tasks like connecting to Samanage data, automating operations, downloading data, and more.
-
Use the CData Software ODBC Driver for Microsoft Ads in MicroStrategy
Connect to Microsoft Ads data in MicroStrategy Developer using the CData Software ODBC Driver for Microsoft Ads.
-
Create Dynamic Copper Grids Using the Infragistics XamDataGrid
Learn how you can connect Copper to Infragistics XamDataGrid to build dynamic grids.
-
Build MVC Applications with Connectivity to Reckon Accounts Hosted Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Reckon Accounts Hosted from an ASP.NET MVC application.
-
Automated Continuous Simplesat Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Simplesat replication to Amazon Redshift.
-
Twitter Ads Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Twitter Ads facts in real time.
-
Visualize CockroachDB Data in TIBCO Spotfire through ADO.NET
Integrate CockroachDB data into dashboards in TIBCO Spotfire.
-
Link SpaceX with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SpaceX data in Filemaker Pro for Mac or Windows.
-
Bidirectional Access to Teradata Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Teradata data in Filemaker Pro for Mac or Windows.
-
Create SSAS Tabular Models from ADP Data
How to build a SQL Server Analysis Service Tabular Model from ADP data using CData drivers.
-
Establish a Live Connection with Redis Data using Tableau Bridge
The CData ODBC Driver for Redis enables you to integrate live Redis data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Amazon S3 Data from Crystal Reports
Use CData Connect AI to connect to and report on live Amazon S3 data from Crystal Reports.
-
How to Connect SingleStore Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live SingleStore data in real time using natural language.
-
Build Visualizations of SAP Business Warehouse Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SAP Business Warehouse data in Birst.
-
Automated Continuous Factorial Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Factorial replication to Azure SQL Database.
-
How to Query Live Elorus Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Elorus data data in natural language using Python.
-
How to connect to Microsoft OneDrive Data from Spring Boot
Connect to Microsoft OneDrive in a Spring Boot Application using the CData JDBC Driver for Microsoft OneDrive
-
Connect to Oracle Eloqua Reporting Data from PowerBuilder via ADO.NET
This article demonstrates how to access Oracle Eloqua Reporting data from Appeon PowerBuilder using the CData ADO.NET Provider for Oracle Eloqua Reporting.
-
Connect to Google Cloud Storage Data in RazorSQL
Connect to Google Cloud Storage from wizards and query Google Cloud Storage data from the GUI in the RazorSQL database management tool.
-
Automated Continuous GitLab Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable GitLab replication to Google Cloud SQL.
-
Integrating OpenCode with HelloSign 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.
-
Easily Integrate Webflow Data in Lazarus Pascal IDE
Learn how to easily integrate live Webflow data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build Apps with Live Slack data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Slack data into the Adalo platform and build custom mobile and web applications with real-time Slack data.
-
Create SSAS Tabular Models from LDAP Objects
How to build a SQL Server Analysis Service Tabular Model from LDAP objects using CData drivers.
-
Use the CData Software ODBC Driver for SAP Netweaver Gateway in MicroStrategy Web
Connect to SAP Netweaver Gateway data in MicroStrategy Web using the CData Software ODBC Driver for SAP Netweaver Gateway.
-
Integrate Trae with Live Oracle Sales Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Oracle Sales data from within the AI-powered IDE.
-
Build Apify Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Apify data and build visualizations in Tableau.
-
Access Live Microsoft Exchange Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Microsoft Exchange data from your Excel spreadsheets.
-
Import Facebook Ads Data Using Azure Data Factory
Use CData Connect AI to connect to Facebook Ads Data from Azure Data Factory and import live Facebook Ads data.
-
Automate Splunk Data Replication to SAP HANA
Use CData Sync to customize and automate Splunk data replication to SAP HANA.
-
How to connect to Monday.com Data from Spring Boot
Connect to Monday.com in a Spring Boot Application using the CData JDBC Driver for Monday.com
-
Build ZohoMarketingHub-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live ZohoMarketingHub data.
-
Visualize Live Sugar CRM Data in the Power BI Service
Use CData Connect AI to connect to live Sugar CRM data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Connect to & Open Xero Data in Microsoft Excel
This article uses the CData ODBC driver for Xero to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build a Singer.io Tap for Humanity With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Humanity data using the CData Python Connector.
-
Use the CData Software ODBC Driver for Vimeo in SAS for Real-Time Reporting and Analytics
Connect to real-time Vimeo data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Vimeo.
-
Create Auth0 Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Auth0 data access from reports, embedded analytics, and more.
-
Integrate Devin with Live Spark Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Spark data.
-
Create Oracle Financials Cloud-Connected Nintex Workflows
Use CData Connect AI to connect to Oracle Financials Cloud Data from Nintex Workflow Cloud and build custom workflows using live Oracle Financials Cloud data.
-
Prepare, Blend, and Analyze Square Data in Alteryx Designer (Connect AI)
Build workflows to access live Square data for self-service data analytics.
-
Extract, Transform, and Load Zoho Books Data in Informatica PowerCenter
Create a simple Workflow for Zoho Books data in Informatica PowerCenter.
-
Connect to LeadDesk 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 LeadDesk and work with LeadDesk data in your FileMaker application.
-
Prepare, Blend, and Analyze Office 365 Data in Alteryx Designer (Connect AI)
Build workflows to access live Office 365 data for self-service data analytics.
-
Getting Started with the CData Excel Add-In for Oracle Eloqua
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Oracle Eloqua.
-
Integrate Goose with Live Procore Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Procore data from within the local AI agent.
-
Automated Continuous HubDB Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable HubDB data replication to OneLake in Microsoft Fabric.
-
Use CData Connect AI to Access NetSuite SuiteAnalytics Data in Microsoft Power Pivot
Use CData Connect AI to connect to live NetSuite SuiteAnalytics data in the Power Pivot business intelligence tool.
-
Create Datasets from HubSpot in Domo Workbench and Build Visualizations of HubSpot Data in Domo
Use the CData Software ODBC Driver for HubSpot to create datasets from HubSpot data in Domo Workbench and then build visualizations in the Domo service.
-
Integrating Boomi Agentstudio with Elasticsearch Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Elasticsearch data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Automated Continuous Sage Cloud Accounting Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to Google Cloud SQL.
-
Prepare, Blend, and Analyze SAP HANA Data in Alteryx Designer (ODBC)
Build workflows to access live SAP HANA data for self-service data analytics.
-
How to Query Live Azure Synapse Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Azure Synapse data data in natural language using Python.
-
How to Connect to Live Zoho Projects 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 Zoho Projects data through natural language.
-
Integrate Theia IDE with Live MailerLite Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live MailerLite data from within the development environment.
-
Connect to Smartsheet Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Smartsheet data in Airbyte.
-
Build Apps with Live Clockify Data Using the Low-Code Development Platform of Mendix
Connect Clockify data with Mendix to build apps using the CData API Driver for JDBC.
-
Integrate SendPulse Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to SendPulse data and integrate live SendPulse data into your Power Automate tasks.
-
Connect to Spark Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Spark Data and connect to Spark data in Akorbi Digital RunMyProcess.
-
How to Connect DBeaver to Dynamics 365 via a JDBC Driver
Manage Dynamics 365 data with visual tools in DBeaver like the query browser.
-
Query Sendwithus Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Sendwithus data from Node.js.
-
How to Build an ETL App for ElevenLabs Data in Python with CData
Create ETL applications and real-time data pipelines for ElevenLabs data in Python with petl.
-
Connect to Yelp from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Yelp data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Import Real-Time Foursquare Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Foursquare data in ColdFusion.
-
How to connect to Stack Exchange Data from IntelliJ
Integrate connectivity to Stack Exchange data with wizards in IntelliJ.
-
Build ServiceNow-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to ServiceNow Data from Zoho Analytics and import live ServiceNow data.
-
How to Connect to Live Klipfolio 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 Klipfolio data for you.
-
Back Up Sage 300 data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Sage 300. In this article, we will employ an SSIS workflow to populate a database with Sage 300 data data.
-
Connect to Raisers Edge NXT Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Raisers Edge NXT data using standard SQL.
-
Automated Continuous Spotify Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Spotify replication to PostgreSQL.
-
Connect to EnterpriseDB Data in Claris FileMaker Pro
Use the CData ODBC Driver for EnterpriseDB in FileMaker Pro to connect to EnterpriseDB and work with EnterpriseDB data in your FileMaker applications.
-
Use the CData Software JDBC Driver for CSV in MicroStrategy
Connect to CSV data in MicroStrategy Developer using the CData Software JDBC Driver for CSV.
-
Build AI/ML Models with Live Avro Data using Dataiku
Connect Avro Data with Dataiku using the CData JDBC Driver for Avro.
-
Integrating Gumloop with Twitter Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Twitter Ads data within automated workflows.
-
Connect to EnterpriseDB Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time EnterpriseDB data using standard SQL.
-
Create Informatica Mappings From/To an ODBC Data Source for Sugar CRM
Create an ODBC connection to Sugar CRM in Informatica and browse and transfer Sugar CRM data.
-
Replicate Multiple Perigon Accounts
Replicate multiple Perigon accounts to one or many databases.
-
Moving Data from Figshare to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Figshare data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automated Continuous Sage 200 Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Sage 200 replication to delimited files (CSV/TSV).
-
How to create an RPA flow for Blackbaud FE NXT Data in UiPath Studio
Use the Blackbaud FE NXT ODBC Driver to create workflows that access real-time Blackbaud FE NXT data without any coding.