CData Software - Knowledge Base

Recent Articles

---

• «
• 564
• 565
• 566
• 567
• 568
• 569
• 570
• 571
• 572
• 573
• »

• Migrating data from Toggl to Snowflake using CData SSIS Components.

  Easily push Toggl data to Snowflake using the CData SSIS Tasks for Toggl and Snowflake.

• DataBind Elorus Data to the DevExpress Data Grid

  Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Elorus data to a chart.

• Connect to Zoho Creator Data in RazorSQL

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

• Use the CData Software JDBC Driver for ScrapingBee in MicroStrategy

  Connect to ScrapingBee data in MicroStrategy Developer using the CData Software JDBC Driver for ScrapingBee.

• Integrating Dataiku with ServiceNow Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live ServiceNow data.

• Access Kafka 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 Kafka data.

• Query Elasticsearch Data in DataGrip

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

• Integrate Goose with Live Gmail Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Gmail data from within the local AI agent.

• Getting Started with the CData Power BI Connector for Freshteam

  Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.

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

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

• How to integrate Snapchat Ads with Apache Airflow

  Access and process Snapchat Ads data in Apache Airflow using the CData JDBC Driver.

• ETL Wistia in Oracle Data Integrator

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

• Access Live Cosmos DB Data in AWS Lambda (with IntelliJ IDEA)

  Connect to live Cosmos DB data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• Getting Started with the CData Connect AI Python SDK for SendGrid

  Install the CData Connect AI Python SDK to read and write live SendGrid data with standard DB-API 2.0 Python code.

• Integrate Live Oracle Financials Cloud Data into Blue Prism for Intelligent Robotic Process Automation (RPA)

  Connect live Oracle Financials Cloud data to Blue Prism using the CData ODBC Driver for Oracle Financials Cloud to create automated workflows for repetitive business tasks.

• Use the CData Software ODBC Driver for Dynamics 365 Business Central in MicroStrategy Desktop

  Connect to Dynamics 365 Business Central data in MicroStrategy Desktop using the CData Software ODBC Driver for Dynamics 365 Business Central.

• Link PhantomBuster with FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate PhantomBuster data in Filemaker Pro for Mac or Windows.

• Establish a Live Connection with Superchat Data using Tableau Bridge

  The CData ODBC Driver for Superchat enables you to integrate live Superchat data into Tableau Cloud dashboards using the Tableau Bridge.

• Build an OLAP Cube in SSAS from Twitter Ads Data

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

• Import and Visualize Bullhorn CRM Data in Power View

  Create data visualizations based on Bullhorn CRM data in Excel.

• Getting Started with the CData Power BI Connector for SAP Netweaver Gateway

  Complete guide to installing, licensing, and connecting with the CData Power BI Connector for SAP Netweaver Gateway.

• Easily Integrate ZohoDesk Data in Lazarus Pascal IDE

  Learn how to easily integrate live ZohoDesk data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

• Automated Continuous Klaviyo Replication to Google BigQuery

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

• Use the CData ODBC Driver for Workday from SharePoint Excel Services

  This article demonstrates how to use the CData ODBC Driver for Workday to connect to Workday data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Workday data in Excel.

• Access SAP HANA XS Advanced Data from MySQL in PHP

  Connect to SAP HANA XS Advanced through the standard MySQL libraries in PHP.

• Connect to Aha! Data in Google Apps Script via SQL Gateway

  Use the ODBC Driver for Aha! and the SQL Gateway to access Aha! data from Google Apps Script.

• Use the CData Software JDBC Driver for Redis in MicroStrategy

  Connect to Redis data in MicroStrategy Developer using the CData Software JDBC Driver for Redis.

• Use JayDeBeApi to access ConvertKit Data in Python

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

• Integrating OpenCode with ZohoDesk 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 Live Jira Data in PostGresSQL Interface through CData Connect AI

  Create a live connection to Jira in CData Connect AI and connect to your Jira data from PostgreSQL.

• Access Live Zendesk Data in Excel (Desktop) via Connect AI

  Use CData Connect AI to gain access to live Zendesk data from your Excel spreadsheets.

• Connect to FreshBooks in SpagoBI

  Create reports featuring live FreshBooks data in SpagoBI Studio. Host FreshBooks reports on SpagoBI Server.

• Explore Geographical Relationships in MessageBird Data with Power Map

  Create data visualizations with MessageBird data in Power Map.

• Connect to Timely from Excel & GoogleSheets!

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

• Connect to Google Drive Data in the Denodo Platform

  Use CData driver technologies to create a virtual data source for Google Drive data in the Denodo Virtual DataPort Administrator.

• Visualize Presto Data in Tableau

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

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

• Trigger Blackbaud FE NXT IFTTT Flows in Azure App Service

  Automate IFTTT (if-this-then-that) workflows for Blackbaud FE NXT with standard wizards in Logic Apps.

• How to connect and process Missive data from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Missive data.

• Use the CData Software JDBC Driver for SpaceX in MicroStrategy Web

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

• DataBind Controls to Egnyte Data in Delphi

  DataBind to Egnyte data in Delphi with standard data access components and controls.

• Access Live Campaigner Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

  Connect to Campaigner data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

• Replicate Access Data in Heroku for Use in Salesforce Connect

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

• Build Dashboards with ActiveCampaign Data in DBxtra

  Create dynamic dashboards and perform analytics based on ActiveCampaign data in DBxtra.

• Connect to Facebook Ads Data in JRuby

  Create a simple JRuby app with access to live Facebook Ads data.

• How to Connect to Live Zuora Data from Claude Agent SDK (via CData Connect AI)

  Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Zuora data for you.

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

• Connecting Moonlit Workflow with iContact 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 iContact data in real time.

• Analyze SAP Hybris C4C Data in R via JDBC

  Use standard R functions and the development environment of your choice to analyze SAP Hybris C4C data with the CData JDBC Driver for SAP Hybris C4C.

• Automate ChartMogul Data Replication to Couchbase

  Use CData Sync to Customize and automate ChartMogul data replication to Couchbase.

• Getting Started with the CData JDBC Driver for Jumpseller

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

• Connect to Hugging Face Data in NetBeans

  Connect to Hugging Face data in NetBeans with the data source configuration wizard.

• Oracle Service Cloud Reporting in OBIEE with the Oracle Service Cloud JDBC Driver

  Deploy the Oracle Service Cloud JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• How to Connect to Live Samanage Data from crewAI Agents (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Samanage data for you.

• Visualize Calendly Data in Tableau

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

• Migrating data from Hive to Google BigQuery using CData SSIS Components.

  Easily push Hive data to Google BigQuery using the CData SSIS Tasks for Hive and Google BigQuery.

• Connect to Close Data in DigitalSuite Studio through RunMyProcess DSEC

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

• Connecting Mastra with MySQL Data via CData Connect AI MCP Server

  Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time MySQL data, no replication required.

• Build a PostgreSQL Interface for MailChimp Data using the CData JDBC Driver

  Use the Remoting features of the MailChimp JDBC Driver to create a PostgreSQL entry-point for data access.

• Excel Spreadsheet Automation on Oracle Eloqua Data with the QUERY Formula

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

• Analyze Dropbox Data with Power Pivot

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

• Creating Dynamics NAV-Connected Applications in Unqork

  You can use CData Connect AI to feed Dynamics NAV data to Unqork and build custom business apps.

• Feed Okta Data into FineReport

  How to set Okta data as a JDBC data source in FineReport.

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

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

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

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

• Automate Microsoft Entra ID Integration Tasks from PowerShell

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

• Create ZohoMarketingHub-Connected Dashboards in Grafana

  Connect to ZohoMarketingHub Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to ZohoMarketingHub data.

• Connect to Zoho Inventory Data in RapidMiner

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

• Analyze IBM Informix Data in Cognos Analytics

  Use CData Connect AI to connect to IBM Informix Data from Cognos Analytics and analyze live IBM Informix data.

• Create Informatica Mappings From/To an ODBC Data Source for SAP Ariba Procurement

  Create an ODBC connection to SAP Ariba Procurement in Informatica and browse and transfer SAP Ariba Procurement data.

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

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

• Connect to SAP BusinessObjects BI Data in DBeaver

  Use the CData ODBC Driver to connect to SAP BusinessObjects BI data in DBeaver.

• How to Connect to Live Office 365 Data from Sourcegraph Amp (via CData Connect AI)

  Integrate Sourcegraph Amp with CData Connect AI to query and manage live Office 365 data securely in real time.

• Query AfterShip Data in ColdFusion

  Write standard ColdFusion data access code to connect to AfterShip data.

• DataBind Controls to IBM Cloud Object Storage Data in C++Builder

  DataBind to IBM Cloud Object Storage data in C++Builder with standard components and controls.

• Query ZeroBounce Data through ODBC in Node.js

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

• Connect to Telegram Data as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Telegram data.

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

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

• Connect to Apollo Data through External Services in Salesforce

  Use CData Connect AI to securely connect Salesforce External Services with Apollo Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.

• Use Biml to Build SSIS Tasks to Replicate Zoho Inventory Data to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Zoho Inventory data to SQL Server.

• Consume Google Drive OData Feeds in SAP Lumira

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

• Create Reports from Google Contacts Data in Looker Studio

  Use CData Connect AI to gain access to live Google Contacts data and create custom reports in Looker Studio.

• Authenticating Connections from the Client Side (Power BI & More)

  Authenticate to a service or application directly from a client tool without relying on the ODBC DSN settings

• Integrate Cursor with Live OData Data via CData Connect AI

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

• Import Real-Time SAP SuccessFactors LMS Data via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use SAP SuccessFactors LMS data in ColdFusion.

• Use the CData ODBC Driver for REST from SharePoint Excel Services

  This article demonstrates how to use the CData ODBC Driver for REST to connect to REST data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring REST data in Excel.

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

  Use CData ODBC drivers to import and use Printify data in ColdFusion.

• Access Live Testmonitor Data in Coginiti Pro

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

• Getting Started with the CData Connect AI Python SDK for WordPress

  Install the CData Connect AI Python SDK to read and write live WordPress data with standard DB-API 2.0 Python code.

• Integrating Dataiku with QuickBooks Online Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live QuickBooks Online data.

• Configure the CData JDBC Driver for Customer.io in a Connection Pool in Tomcat

  Connect to Customer.io data from a connection pool in Tomcat.

• How to create FHIR federated tables in MySQL

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

• Build Notion-Connected Web Apps with Axios and CData Connect AI

  Use CData Connect AI to connect to live Notion data and build Notion-connected web apps with Axios.

• Integrate Cursor with Live Azure Synapse Data via CData Connect AI

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

• Connect VWO to IBM WebSphere Using the CData JDBC Driver

  Use the CData JDBC Driver to connect VWO with IBM WebSphere for seamless data integration and connectivity.

• A PostgreSQL Interface for Grafana Data (MySQL Remoting via JDBC)

  Use the Remoting features of the Grafana JDBC Driver to create a PostgreSQL entry-point for data access.

• Establish a Live Connection with Outreach.io Data using Tableau Bridge

  The CData ODBC Driver for Outreach.io enables you to integrate live Outreach.io data into Tableau Cloud dashboards using the Tableau Bridge.

• Integrate Theia IDE with Live Google Search 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 Google Search results from within the development environment.

• How to connect to Microsoft Planner Data from IntelliJ

  Integrate connectivity to Microsoft Planner data with wizards in IntelliJ.

• Connect to FreeAgent Data in DigitalSuite Studio through RunMyProcess DSEC

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

• «
• 564
• 565
• 566
• 567
• 568
• 569
• 570
• 571
• 572
• 573
• »