CData Software - Knowledge Base

Recent Articles

---

• «
• 417
• 418
• 419
• 420
• 421
• 422
• 423
• 424
• 425
• 426
• »

• Excel Spreadsheet Automation on Access Data with the QUERY Formula

  Pull data from Access, automate spreadsheets, and more with the QUERY formula.

• Integrate Harvest Data in the Pentaho Report Designer

  Publish reports based on Harvest in the Pentaho BI tool.

• Query Amplitude Data in DataGrip

  Create a Data Source for Amplitude in DataGrip and use SQL to query live Amplitude.

• Create Apps from CSV Data in Qlik Sense Cloud

  Use CData Connect AI to connect to CSV Data and build apps from live CSV/TSV Files in Qlik Sense Cloud.

• Build Voice Agents in ElevenLabs with access to Live Google Campaign Manager 360 Data

  Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Google Campaign Manager 360.

• Access Live Oracle Service Cloud Data in Excel 365 Online (Excel for the web)

  Connect to Oracle Service Cloud from Excel 365 Online (Excel for the web) with CData Connect AI.

• Create Datasets from Nuclia in Domo Workbench and Build Visualizations of Nuclia Data in Domo

  Use the CData Software ODBC Driver for Nuclia to create datasets from Nuclia in Domo Workbench and then build visualizations in the Domo service.

• Access Live Twitter Ads Data in Tableau with CData API Server

  With CData API Server, easily create OData endpoints for live Twitter Ads data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.

• Choosing the Best Method to Connect Google Tasks to SQL Server: 5 Options Explained

  Discover multiple ways to connect and use Google Tasks from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.

• Use Claude to Talk to Your Gmail Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Gmail for you.

• Automated Continuous Mode Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Mode replication to SQL Server.

• How to Query Live Xero Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live Xero Accounting data in natural language using Python.

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

  Use CData Power BI Connectors to visualize Quickbase in Power BI.

• Access Live PostgreSQL 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 PostgreSQL through MCP integration.

• Getting Started with the CData JDBC Driver for Stripe

  Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Stripe.

• How to create Foursquare federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for Foursquare in MySQL .

• Bridge Mailjet Connectivity with Apache NiFi

  Access and process Mailjet in Apache NiFi using the CData JDBC Driver.

• Visualize Mixpanel Data in TIBCO Spotfire through ADO.NET

  Integrate Mixpanel into dashboards in TIBCO Spotfire.

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

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

• Connect to SAP SuccessFactors Data from AWS Glue

  Use CData Connect AI to gain access to live SAP SuccessFactors from your AWS Glue jobs.

• Working with SparkPost Data in LINQPad

  Execute LINQ queries to SparkPost in LINQPad.

• Create Datasets from Reckon in Domo Workbench and Build Visualizations of Reckon Data in Domo

  Use the CData Software ODBC Driver for Reckon to create datasets from Reckon in Domo Workbench and then build visualizations in the Domo service.

• Connect to Salesforce Pardot Data in NetBeans

  Connect to Salesforce Pardot in NetBeans with the data source configuration wizard.

• Consume HCL Domino OData Feeds in SAP Lumira

  Use the API Server to create data visualizations on HCL Domino feeds that reflect any changes in SAP Lumira.

• ETL MailerSend in Oracle Data Integrator

  This article shows how to transfer MailerSend into a data warehouse using Oracle Data Integrator.

• Visualize Oracle Sales Data in TIBCO Spotfire through OData

  Integrate Oracle Sales into dashboards in TIBCO Spotfire.

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

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

• Connect to Vimeo Data in Claris FileMaker Pro

  Use the CData API Driver for ODBC in FileMaker Pro to connect to Vimeo and work with Vimeo in your FileMaker applications.

• Integrate Simplesat Data in Pentaho Data Integration

  Build ETL pipelines based on Simplesat in the Pentaho Data Integration tool.

• Query Paylocity Data using the OData SDK for PHP

  Use the API Server and the OData PHP SDK to easily consume Paylocity entities in PHP by modeling them as objects.

• Prepare, Blend, and Analyze Sybase Data in Alteryx Designer (Connect AI)

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

• Connect to Gorgias Data in RapidMiner

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

• How to create an RPA flow for JobNimbus Data in UiPath Studio

  Use the JobNimbus ODBC Driver to create workflows that access real-time JobNimbus without any coding.

• How to Easily Query Sage 300 Data in OpenOffice Base

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

• Build SAS Data Sets-Connected Visualizations in datapine

  Use CData Connect AI and datapine to build visualizations and dashboards with access to live SAS Data Sets.

• How to create SpaceX federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for SpaceX in MySQL .

• Use the CData Software ODBC Driver for ConvertKit in MicroStrategy Desktop

  Connect to ConvertKit in MicroStrategy Desktop using the CData Software ODBC Driver for ConvertKit.

• Getting Started with the CData SSIS Components for Humanity

  Complete guide to installing, licensing, and connecting with the CData SSIS Components for Humanity.

• Use the CData Software ODBC Driver for Sugar CRM in SAS for Real-Time Reporting and Analytics

  Connect to real-time Sugar CRM in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Sugar CRM.

• Integrating Claude Code with Databricks Data via CData Connect AI

  Leverage CData Connect AI to enable Claude Code to securely access and act on Databricks within assisted coding and automated development workflows.

• Integrating Antigravity CLI with IBM DB2 via CData CLI

  Connect IBM DB2 to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.

• Integrate MongoDB with JetBrains RubyMine using CData JDBC Drivers

  Learn how to integrate MongoDB with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to MongoDB.

• Connect to Zoho Books Data in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Connect to Acumatica Data in ACL Analytics

  Connect to Acumatica ERP via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Acumatica ERP.

• Connect to SingleStore Data in Google Apps Script via SQL Gateway

  Use the ODBC Driver for SingleStore and the SQL Gateway to access SingleStore from Google Apps Script.

• Import Real-Time Samanage Data via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Samanage in ColdFusion.

• Visualize Live QuickBooks Time Data in the Power BI Service

  Use CData Connect AI to connect to live QuickBooks Time and create custom reports in the Power BI Service through the On-Premises Gateway.

• How to Work with Bullhorn CRM Data in ETL Validator JDBC

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

• Use the CData Software ODBC Driver for Billsby in MicroStrategy Desktop

  Connect to Billsby in MicroStrategy Desktop using the CData Software ODBC Driver for Billsby.

• How to create GetResponse federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for GetResponse in MySQL .

• Automate Tasks in Power Automate Using the CData API Server

  Automate Salesforce actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.

• Extract, Transform, and Load PabblySubscriptions Data in Informatica PowerCenter

  Create a simple Workflow for PabblySubscriptions in Informatica PowerCenter.

• Use Agno to Talk to Your Epicor Kinetic Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Epicor Kinetic for you.

• Bridge Google Calendar Connectivity with Apache NiFi

  Access and process Google Calendar in Apache NiFi using the CData JDBC Driver.

• How to Work with Postmark Data in ETL Validator JDBC

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

• How to connect SharePoint with Amazon S3 Data through external lists

  Provide Amazon S3 to SharePoint users as an external list.

• Connect to PayPal Data in JRuby

  Create a simple JRuby app with access to live PayPal.

• Integrate Google

  Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Pivotal GreenPlum using the Model Context Protocol.

• Integrate Live Google Analytics Data into Blue Prism for Intelligent Robotic Process Automation (RPA)

  Connect live Google Analytics to Blue Prism using the CData ODBC Driver for Google Analytics to create automated workflows for repetitive business tasks.

• How to Connect DBeaver to Templated via a JDBC Driver

  Manage Templated with visual tools in DBeaver like the query browser.

• Query Bitly Data as a MySQL Database in Node.js

  Execute MySQL queries against Bitly from Node.js.

• Integrate Real-Time Access to Google Drive in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Google Drive in real time.

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

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

• How to Connect Flowise AI Agents to Live Zoho CRM 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 Zoho CRM without replication.

• Visualize Google Campaign Manager 360 Data in Sisense

  Create an ElastiCube in Sisense app with access to Google Campaign Manager 360.

• Connect to MySQL Data as a SQL Server Linked Server

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

• Integrate Real-Time Access to Elasticsearch in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Elasticsearch in real time.

• Import Okta Data Using Azure Data Factory

  Use CData Connect AI to connect to Okta Data from Azure Data Factory and import live Okta.

• Use the CData Software ODBC Driver for LinkedIn Ads in MicroStrategy Web

  Connect to LinkedIn Ads in MicroStrategy Web using the CData Software ODBC Driver for LinkedIn Ads.

• Automated Continuous HBase Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable HBase replication to Amazon Redshift.

• Operational Reporting on SAP Business One Data from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote SAP Business One.

• Back Up Salesforce & Force.com to SQL Server through SSIS

  Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Salesforce. In this article, we will employ an SSIS workflow to populate a database with Salesforce & Force.com data.

• Analyze Clari Data in R via JDBC

  Use standard R functions and the development environment of your choice to analyze Clari with the CData JDBC Driver for Clari.

• Use the CData Software JDBC Driver for Salesforce Pardot in MicroStrategy Web

  Connect to Salesforce Pardot in MicroStrategy Web using the CData Software JDBC Driver for Salesforce Pardot.

• Connect to DocuSign from Excel & GoogleSheets!

  Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from DocuSign, and over 250 other data sources, right inside your Excel and Google spreadsheets!

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

  Use CData JDBC drivers to import and use Instagram in ColdFusion.

• Build an OLAP Cube in SSAS from Acumatica Data

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

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

  Use CData Power BI Connectors to visualize Jumpseller in Power BI.

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

  Use CData Power BI Connectors to visualize Webex in Power BI.

• Integrate Cursor with Live HCL Domino Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live HCL Domino from within the editor.

• Integrate with Clari Data using Apache Camel2

  Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Clari to a JSON file on disk.

• Build AI/ML Models with Live Azure Table Data using Dataiku

  Connect Azure Table Data with Dataiku using the CData JDBC Driver for Azure Table.

• Integrating Cursor CLI with Attio 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.

• Replicate Avaza Data to Multiple Databases via the CData Sync CLI

  Replicate Avaza to disparate databases with a single configuration.

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

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

• Access Live Microsoft Ads Data in Excel 365 Online (Excel for the web)

  Connect to Microsoft Ads from Excel 365 Online (Excel for the web) with CData Connect AI.

• How to Access HBase Data Using Entity Framework

  This article shows how to access Apache HBase 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 Google Sheets Data via CData Connect AI

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

• Automate SAP Netweaver Gateway Integration Tasks from PowerShell

  Are you in search of a quick and easy way to access SAP Netweaver Gateway from PowerShell? This article demonstrates how to utilize the SAP Netweaver Gateway Cmdlets for tasks like connecting to SAP Netweaver Gateway, automating operations, downloading data, and more.

• Connect to Snowflake Data in RapidMiner

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

• Create Informatica Mappings From/To a JDBC Data Source for WooCommerce

  Create WooCommerce data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• Build Apps with Live Asana Data Using the Low-Code Development Platform of Mendix

  Connect Asana with Mendix to build apps using the CData JDBC Driver for Asana.

• How to Build an ETL App for CampaignMonitor Data in Python with CData

  Create ETL applications and real-time data pipelines for CampaignMonitor in Python with petl.

• Extend Google Sheets with Slack Data

  Make calls to Slack from Google Apps Script via the API Server.

• Build MVC Applications with Connectivity to Contentful Data

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Contentful from an ASP.NET MVC application.

• Build Automated Workflows with Live Greenhouse Data in Workato

  Use CData Connect AI to connect to live Greenhouse and build automated workflows in Workato.

• Automated Continuous Odoo Replication to Vertica

  Use CData Sync for automated, continuous, customizable Odoo replication to Vertica.

• Connect to Couchbase Data from Crystal Reports

  Use CData Connect AI to connect to and report on live Couchbase from Crystal Reports.

• Integrate ADP with JetBrains RubyMine using CData JDBC Drivers

  Learn how to integrate ADP with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to ADP.

• Build Visualizations of Dynamics 365 Data in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Microsoft Dynamics 365 in Birst.

• «
• 417
• 418
• 419
• 420
• 421
• 422
• 423
• 424
• 425
• 426
• »