CData Software - Knowledge Base

Recent Articles

---

• «
• 1318
• 1319
• 1320
• 1321
• 1322
• 1323
• 1324
• 1325
• 1326
• 1327
• »

• Prepare, Blend, and Analyze Shopify Data in Alteryx Designer (ODBC)

  Build workflows to access live Shopify data for self-service data analytics.

• Natively Connect to Mailjet Data in PHP via ODBC (Linux)

  Create PHP applications on Linux/UNIX machines with connectivity to Mailjet data. Leverage the native support for ODBC in PHP.

• How to Connect to & Open Autopilot Data in Microsoft Excel

  This article uses the CData ODBC driver for Autopilot to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

• Use JayDeBeApi to access Hacker News Data in Python

  Use standard Python scripting and the development environment of your choice to access live Hacker News data.

• Use the CData Software JDBC Driver for Microsoft Exchange in MicroStrategy Web

  Connect to Microsoft Exchange data in MicroStrategy Web using the CData Software JDBC Driver for Microsoft Exchange.

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for OnePageCrm

  Provide connectivity to OnePageCrm data through an SAP BusinessObjects universe.

• Integrate Open WebUI with Live PayPal Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live PayPal data from within the chat interface.

• Create a Data Access Object for Google Calendar Data using JDBI

  A brief overview of creating a SQL Object API for Google Calendar data in JDBI.

• Automated Continuous Demio Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable Demio replication to IBM DB2.

• Connect to Instagram Data as an External Source in Dremio

  Use the CData JDBC Driver to connect to Instagram as an External Source in Dremio.

• GitLab Reporting in OBIEE with the GitLab JDBC Driver

  Deploy the GitLab JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• Enable the Sage Intacct JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Sage Intacct data.

• Connect to CampaignMonitor Data in RazorSQL

  Connect to CampaignMonitor from wizards and query CampaignMonitor data from the GUI in the RazorSQL database management tool.

• Use Microsoft Copilot Studio to talk to your Paymo 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 Paymo data for you.

• Odoo Reporting in OBIEE with the Odoo JDBC Driver

  Deploy the Odoo JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• Moving Data from Zuora to SQL Server Using Toad Data Point and CData ODBC Driver

  Query, export, and automate live Zuora data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.

• Connect to ClickUp Data in RapidMiner

  Integrate ClickUp data with standard components and data source configuration wizards in RapidMiner Studio.

• Use JayDeBeApi to access SFTP Data in Python

  Use standard Python scripting and the development environment of your choice to access live SFTP data.

• Connect to Oracle Eloqua Data in RazorSQL

  Connect to Oracle Eloqua from wizards and query Oracle Eloqua data from the GUI in the RazorSQL database management tool.

• How to Connect to Live Oracle 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 Oracle data through natural language.

• Connect to SAP Business Warehouse in SpagoBI

  Create reports featuring live SAP Business Warehouse data in SpagoBI Studio. Host SAP Business Warehouse reports on SpagoBI Server.

• Replicate Amplitude Data in Heroku for Use in Salesforce Connect

  Replicate Amplitude data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Automated Continuous ZendeskSell Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable ZendeskSell replication to IBM DB2.

• Connect to Supabase Data as a SQL Server Linked Server

  Use CData Connect AI to create a linked server for live Supabase data.

• Automated Continuous Sugar CRM Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable Sugar CRM replication to AlloyDB.

• Use the CData Software JDBC Driver for OneNote in MicroStrategy Desktop

  Connect to OneNote data in MicroStrategy Desktop using the CData Software JDBC Driver for OneNote.

• How to Connect to Live Toggl 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 Toggl data through natural language.

• Build Visualizations of Quickbase Data in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Quickbase data in Birst.

• Model, Search, and Visualize Live xBase Data in ThoughtSpot

  Use CData Connect AI to connect to live xBase data for modeling, searching, and visualizing.

• DataBind Controls to Amazon DynamoDB Data in C++Builder

  DataBind to Amazon DynamoDB data in C++Builder with standard components and controls.

• Connect to EmailOctopus Data in HULFT Integrate

  Connect to EmailOctopus as a JDBC data source in HULFT Integrate

• Access Live Sentry Data in Coginiti Pro

  Connect to and query live Sentry data from the GUI in the Coginiti Pro: SQL Analytics Tool.

• Access Live Sugar CRM Data in Coginiti Pro

  Connect to and query live Sugar CRM data from the GUI in the Coginiti Pro: SQL Analytics Tool.

• Integrating GitHub Copilot with Avro 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.

• Build an OLAP Cube in SSAS from FreeAgent Data

  Establish a connection to FreeAgent data data from SQL Server Analysis Services, and use the FreeAgent Data Provider to build OLAP cubes for use in analytics and reporting.

• DataBind Charts to Act-On Data

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Act-On data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.

• Connect to Perplexity from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Perplexity to connect to Perplexity data from Web applications running on WebLogic.

• Integrate Dify with Live SageHR Data via CData Connect AI

  Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live SageHR data.

• How to create Visio diagrams from Cassandra Data

  Automatically update Cassandra data with the changes you make to Visio master shapes.

• Automated Continuous JobNimbus Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable JobNimbus replication to Apache Kafka.

• Connect to Paddle Data from PowerBuilder via JDBC

  This article demonstrates how to access Paddle data from PowerBuilder using the Paddle JDBC Driver.

• Integrate Shippo Data into Automated Tasks with Power Automate

  Use CData Connect AI to connect to Shippo data and integrate live Shippo data into your Power Automate tasks.

• Getting Started with the CData ADO.NET Provider for Cosmos DB

  Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Cosmos DB.

• How to Access Live SAP Fieldglass Data in Power Automate Desktop via ODBC

  The CData ODBC Driver for SAP Fieldglass enables you to integrate SAP Fieldglass data into workflows built using Microsoft Power Automate Desktop.

• Rapidly Develop Todoist-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 Todoist.

• Import NetSuite SuiteAnalytics Data into the Power BI Service for Visualizations

  Use CData Connect AI to connect to NetSuite SuiteAnalytics Data and provide access to live NetSuite SuiteAnalytics data for custom reports in the Power BI Service.

• Access Live Google Forms Data in Coginiti Pro

  Connect to and query live Google Forms data from the GUI in the Coginiti Pro: SQL Analytics Tool.

• Integrating Phoenix Data in Talend Cloud Data Management Platform

  Connect Phoenix Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Phoenix.

• Write a Simple Go Application to work with Postmark Data on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Postmark data.

• Using the CData Software ODBC Driver for Discourse in PyCharm

  Connect to Discourse as an ODBC data source in PyCharm using the CData Software ODBC Driver for Discourse.

• How to Create Power BI Visual Reports with Real-Time Marketo Data

  Use CData Power BI Connectors to visualize Marketo data in Power BI.

• Provide OData Services of AdRoll Data from a WCF Application

  In this article, we will demonstrate the process of generating an OData feed for AdRoll data by developing a WCF Service Application.

• Query Live Salesforce Data in Perplexity Desktop via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Salesforce data through a conversational interface.

• Automated Continuous Notion Replication to SQLite

  Use CData Sync for automated, continuous, customizable Notion replication to SQLite.

• Integrating Claude Code CLI with Spotify 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 BenchmarkEmail Data from MySQL in Amazon QuickSight

  Connect to BenchmarkEmail and build visualizations of BenchmarkEmail data using a MySQL Connection in Amazon QuickSight.

• How to Easily Query LDAP Objects in OpenOffice Base

  Connect to LDAP data in OpenOffice Base using the CData ODBC Driver for LDAP and generate reports with live data insights.

• Query SAP Ariba Procurement Data in DataGrip

  Create a Data Source for SAP Ariba Procurement in DataGrip and use SQL to query live SAP Ariba Procurement data.

• Automated Continuous Pinecone Replication to Google BigQuery

  Use CData Sync for automated, continuous, customizable Pinecone replication to Google BigQuery.

• Create Power BI Reports on Real-Time Workday Data

  Use the CData ODBC Driver for Workday to visualize Workday data in Power BI Desktop.

• Query, Visualize, and Share live Bannerbear Data in Redash

  Use CData Connect AI to connect to live Bannerbear data in Redash for querying, visualizing, and sharing.

• Analyze Zoho Inventory Data with Power Pivot

  This article walks you through the process of using the CData ODBC Driver for Zoho Inventory from Power Pivot. You will use the Table Import Wizard to load Zoho Inventory data. You can visually build the import query or use any SQL supported by the driver.

• Import Real-Time ZohoMarketingHub Data via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use ZohoMarketingHub data in ColdFusion.

• Build a Simple VCL Application for Cloudflare Data

  How to build a simple VCL Application to view Cloudflare data in RAD Studio using the CData ODBC Driver for Cloudflare.

• DataBind Controls to Excel Data in C++Builder

  DataBind to Excel data in C++Builder with standard components and controls.

• Automated Continuous Pipeliner CRM Replication to Oracle

  Use CData Sync for automated, continuous, customizable Pipeliner CRM replication to Oracle.

• Connect to Power BI XMLA Data in RapidMiner

  Integrate Power BI XMLA data with standard components and data source configuration wizards in RapidMiner Studio.

• Access Live Amazon S3 Data in Google Sheets through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Amazon S3 data from your Google Sheets.

• Prepare, Blend, and Analyze Datadog Data in Alteryx Designer (ODBC)

  Build workflows to access live Datadog data for self-service data analytics.

• Load Autopilot Data to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Autopilot data to a database.

• Connect to Sybase Data in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Sybase.

• Build OneNote-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live OneNote data.

• Integrate with Live Aweber Data in MuleSoft (via CData Connect AI)

  Use CData Connect AI to connect to Aweber from the MuleSoft Anypoint Platform to integrate live Aweber data into custom reports and dashboards.

• Connect to Confluence Data from PowerBuilder via JDBC

  This article demonstrates how to access Confluence data from PowerBuilder using the Confluence JDBC Driver.

• Use Manus AI to Talk to Your Adobe Commerce Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Adobe Commerce data.

• Build Automated GraphQL-Connected Workflows in Zapier

  Use CData Connect AI to connect to live GraphQL data and build automated workflows in Zapier.

• Access SharePoint Data from MySQL in Amazon QuickSight

  Connect to SharePoint and build visualizations of SharePoint data using a MySQL Connection in Amazon QuickSight.

• Integrate Trae with Live Notion Data via CData Connect AI

  Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Notion data from within the AI-powered IDE.

• Connect to SAP Business One from a Connection Pool in WebLogic

  Use the CData JDBC Driver for SAP Business One to connect to SAP Business One data from Web applications running on WebLogic.

• Work with Airtable Data in FoxPro

  Load Airtable data into a FoxPro database. This article includes full code and a walk-through of the process.

• Connect to RSS from Asprova with CData Software ODBC Driver for RSS

  This article shows how to connect faster to RSS data from Asprova.

• Build Agents in Relevance AI with Access to Live Exact Online Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Exact Online data within intelligent agent workflows.

• Connect to Perplexity Data from HeidiSQL

  Use CData Connect AI to connect to and query live Perplexity data from HeidiSQL.

• Use the CData Software ODBC Driver for Google Translate in MicroStrategy

  Connect to Google Translate data in MicroStrategy Developer using the CData Software ODBC Driver for Google Translate.

• Salesforce Marketing Reporting in OBIEE with the Salesforce Marketing JDBC Driver

  Deploy the Salesforce Marketing JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• LINQ to Facebook Ads 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 Facebook Ads Data Provider.

• Query HDFS Data through ODBC in Node.js

  Use node-odbc to execute SQL queries against HDFS data from Node.js.

• How to update Google Directory from Excel

  This article explains how to transfer data from Excel to Google Directory using the Excel Add-In for Google Directory.

• Analyze GitLab Data in SAP Analytics Cloud

  Use CData Connect AI to create an OData API on top of GitLab data and visualize GitLab data in SAP Analytics Cloud.

• Getting Started with the CData Python Connector for Presto

  Learn to install and license the CData Python Connector and configure a connection to live Presto data.

• ZohoPeople Data Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to ZohoPeople data through CData Connect AI using different applications and tools.

• How to Work with Drip Data in ETL Validator JDBC

  Connect to Drip from ETL Validator jobs using the CData Software JDBC Driver.

• Query Todoist Data through ODBC in Node.js

  Use node-odbc to execute SQL queries against Todoist data from Node.js.

• Integrate Testmonitor with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Testmonitor with External Services.

• Connect to SAP BusinessObjects BI Data in the Denodo Platform

  Use CData driver technologies to create a virtual data source for SAP BusinessObjects BI data in the Denodo Virtual DataPort Administrator.

• Model SAS Data Sets Data Using Azure Analysis Services

  Leverage CData Connect AI to establish a connection between Azure Analysis Services and SAS Data Sets, enabling the direct import of real-time SAS Data Sets data.

• Visualize Pipedrive 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 Pipedrive data into TIBCO Spotfire.

• Connect to CSV Data Using the Script Function in Claris FileMaker Pro

  Use the CData ODBC Driver for CSV and the Script function in FileMaker Pro to connect to CSV and work with CSV data in your FileMaker application.

• How to publish and share CloudConvert Data dashboards with Tableau Server

  The CData ODBC driver for CloudConvert enables you integrate CloudConvert data into Tableau dashboards.

• Automated Continuous Templated Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable Templated replication to Amazon S3.

• «
• 1318
• 1319
• 1320
• 1321
• 1322
• 1323
• 1324
• 1325
• 1326
• 1327
• »