CData Software - Knowledge Base

Recent Articles

---

• «
• 667
• 668
• 669
• 670
• 671
• 672
• 673
• 674
• 675
• 676
• »

• Use the CData ODBC Driver for Microsoft Entra ID from SharePoint Excel Services

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

• How to Build an ETL App for Couchbase Data in Python with CData Connect AI

  Build ETL pipelines that read and write live Couchbase data in Python with petl and the CData Connect AI Python SDK.

• Consume Shopify OData Feeds in PowerBuilder

  This article demonstrates how to consume Shopify data as OData feeds from PowerBuilder using the API Server.

• Consume ServiceNow OData Feeds in SAP Lumira

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

• Build Google Ads-Connected Dashboards Using Zoho Analytics

  Use CData Connect AI to connect to Google Ads Data from Zoho Analytics and import live Google Ads data.

• Analyze Asana Data in Slingshot with CData API Server

  Use the CData API Server to build an OData API on top of Asana data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.

• Excel Spreadsheet Automation on Spark Data with the QUERY Formula

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

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for Klaviyo

  Provide connectivity to Klaviyo data through an SAP BusinessObjects universe.

• Use JayDeBeApi to access Sugar CRM Data in Python

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

• Integrate Live Google Ad Manager Data into Amazon SageMaker Canvas with RDS

  Use CData Connect AI to connect to Google Ad Manager from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Google Ad Manager data.

• Build a Singer.io Tap for Instagram With the CData Python Connector

  Learn how to easily build a Singer.io Tap for live Instagram data using the CData Python Connector.

• How to connect to Shopify Data in DBVisualizer

  Integrate Shopify data with visual data analysis tools and data connection wizards in DBVisualizer

• Create Data Visualizations in Cognos BI with Google Directory Data

  Access Google Directory data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

• Connecting Mastra with SendGrid 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 SendGrid data, no replication required.

• Integrate Live OneNote Data into Amazon SageMaker Canvas with RDS

  Use CData Connect AI to connect to OneNote from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live OneNote data.

• Getting Started with the CData Tableau Connector for CloudConvert

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

• Visualize Live Twitter Ads Data of Power BI Report Builder in Power BI Service

  Use CData Power BI Connectors to connect to live Twitter Ads data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

• Build Semantic Layer Views for Adobe Experience Manager Data in APOS Live Data Gateway

  Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Adobe Experience Manager data.

• A PostgreSQL Interface for ClickTime Data using the CData ODBC Driver

  Use the SQL Gateway and ClickTime ODBC Driver to create a PostgreSQL entry-point for data access.

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

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

• Automate Sage 300 Data Replication to Azure Data Lake

  Use CData Sync to customize and automate Sage 300 data replication to Azure Data Lake.

• Connect to Highrise Data from PowerBuilder via ADO.NET

  This article demonstrates how to access Highrise data from Appeon PowerBuilder using the CData ADO.NET Provider for Highrise.

• Use Databricks Agent Bricks to Talk to Your SendGrid Data via CData Connect AI

  Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your SendGrid data for you.

• Build Pipelines with Live Email Data in Google Cloud Data Fusion (via CData Connect AI)

  Use CData Connect AI to connect to Email from Google Cloud Data Fusion, enabling the integration of live Email data into the building and management of effective data pipelines.

• Replicate Multiple Avalara AvaTax Accounts via the CData Sync CLI

  Replicate multiple Avalara AvaTax accounts to one or many databases.

• Google Drive Reporting in OBIEE with the Google Drive JDBC Driver

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

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

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

• Getting Started with the CData ADO.NET Provider for Klaviyo

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

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

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

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

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

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

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

• Automate Azure Table Integration Tasks from PowerShell

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

• Access Live Google Directory Data in Coginiti Pro

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

• Connect to Amazon DynamoDB Data in JRuby

  Create a simple JRuby app with access to live Amazon DynamoDB data.

• How to Work with Clio Data in ETL Validator JDBC

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

• Use the CData Software JDBC Driver for Reckon Accounts Hosted in MicroStrategy

  Connect to Reckon Accounts Hosted data in MicroStrategy Developer using the CData Software JDBC Driver for Reckon Accounts Hosted.

• How to Connect to Live Exact Online 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 Exact Online data for you.

• Connect to JSON Services as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for JSON services.

• Automated Continuous Dynamics NAV Replication to MongoDB

  Use CData Sync for automated, continuous, customizable Dynamics NAV replication to MongoDB.

• Access Live Typeform Data in Excel (Desktop) through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Typeform data from your Excel spreadsheets.

• Access Live Authorize.Net Data in AWS Lambda (with IntelliJ IDEA)

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

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

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

• Create Drip Dataflows on PowerBI.com

  Connect to the CData Power BI Connector for Drip from PowerBI.com to create Power BI Dataflows with real-time data.

• Integrate Cline with Live Mode Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Mode data from within your IDE.

• Connect to Todoist Data in CloverDX (formerly CloverETL)

  Transfer Todoist data using the visual workflow in the CloverDX data integration tool.

• Integrating Codex with BambooHR 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.

• Automate ZohoInvoice Data Replication to Couchbase

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

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

  Provide connectivity to ZohoInvoice data through an SAP BusinessObjects universe.

• Automated Continuous Microsoft Exchange Replication to Amazon Redshift

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

• Integrating GitHub Copilot with Pinecone 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 MessageBird Data in NetBeans

  Connect to MessageBird data in NetBeans with the data source configuration wizard.

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

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

• Access Live Sybase IQ Data in SAS JMP via ODBC

  You can use the CData ODBC Driver to integrate Sybase IQ data into the statistical analysis tools available in SAS JMP. This article shows how to use Sybase IQ data in the Graph Builder and Query Builder.

• Integrate Live CouchDB Data into Amazon SageMaker Canvas with RDS

  Use CData Connect AI to connect to CouchDB from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live CouchDB data.

• How to connect to Paymo Data in DBVisualizer

  Integrate Paymo data with visual data analysis tools and data connection wizards in DBVisualizer

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

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

• Analyze Monday.com Data in R via ODBC

  Create data visualizations and use high-performance statistical functions to analyze Monday.com data in Microsoft R Open.

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

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

• Use Dash to Build to Web Apps on ZohoSubscriptions Data

  Create Python applications that use pandas and Dash to build ZohoSubscriptions-connected web apps.

• Integrate Google's Vertex AI Agent with Live Excel Online Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Excel Online data within intelligent workflows.

• Connect Drip to AI Assistants With the CData Python MCP Server

  Learn how to give AI assistants like Claude direct access to live Drip data using the CData Python MCP Server.

• Build Semantic Layer Views for RSS Feeds in APOS Live Data Gateway

  Use the CData Connector for RSS in APOS Live Data Gateway to build Semantic Layer Views for RSS feeds.

• Migrating data from Splunk to Databricks using CData SSIS Components.

  Easily push Splunk data to Databricks using the CData SSIS Tasks for Splunk and Databricks.

• Use Claude to Talk to Your eCommerce Data

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

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

• Automated Continuous Optimizely Replication to Databricks

  Use CData Sync for automated, continuous, customizable Optimizely replication to Databricks.

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

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

• Getting Started with the CData Tableau Connector for Onfleet

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

• Connect to Real-Time Greenhouse Data in Power Apps Using Dataflows to Build Custom Applications

  Use CData Power BI Connector for Greenhouse and Dataflow to import and use Greenhouse data in Power Apps.

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

• Connect to Live Okta Data in PostGresSQL Interface through CData Connect AI

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

• Connecting Mastra with Pinterest 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 Pinterest data, no replication required.

• Connect to Webex Data in RazorSQL

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

• Connect Hacker News Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

  Connect to your Hacker News data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

• Connect to Recurly Data in DBeaver

  Use the CData ODBC Driver to connect to Recurly data in DBeaver.

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

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

• Automated Continuous Zoho Creator Replication to SingleStore

  Use CData Sync for automated, continuous, customizable Zoho Creator replication to SingleStore.

• DataBind Charts to Google Translate Data

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Google Translate 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.

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

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

• How to connect SharePoint with CockroachDB Data through external lists

  Provide CockroachDB data to SharePoint users as an external list.

• Query Live Google Ad Manager Data in Zed Editor via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Google Ad Manager data directly from the development environment.

• Integrating LangGraph with Sugar CRM Data via CData Connect AI

  Leverage CData Connect AI to enable LangGraph agents to securely access and act on Sugar CRM data within automated workflows.

• Integrate LibreChat with Live Apollo Data via CData Connect AI

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

• Integrating OpenCode with Microsoft OneDrive 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 Oracle Sales Data from PowerBuilder via ADO.NET

  This article demonstrates how to access Oracle Sales data from Appeon PowerBuilder using the CData ADO.NET Provider for Oracle Sales.

• Integrate Goose with Live XML Data via CData Connect AI

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

• Create Data Visualizations in Cognos BI with Tanda Data

  Access Tanda data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

• Access SAP Netweaver Gateway Data from MySQL in Amazon QuickSight

  Connect to SAP Netweaver Gateway and build visualizations of SAP Netweaver Gateway data using a MySQL Connection in Amazon QuickSight.

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

• How to connect PolyBase to Mouseflow

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Mouseflow data.

• Connect to Box Data in CloverDX (formerly CloverETL)

  Transfer Box data using the visual workflow in the CloverDX data integration tool.

• Connect Printify to AI Assistants With the CData Python MCP Server

  Learn how to give AI assistants like Claude direct access to live Printify data using the CData Python MCP Server.

• Integrate Dify with Live Coda 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 Coda data.

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

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

• Use the CData Software JDBC Driver for Excel in MicroStrategy

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

• Query SpaceX Data in ColdFusion

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

• How to connect to JobNimbus Data with Squirrel SQL client

  Connect to JobNimbus data and execute queries in the Squirrel SQL Client.

• Analyze Workday Data in SAP Analytics Cloud

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

• Easily Integrate SAP Ariba Source Data in Lazarus Pascal IDE

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

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

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

• «
• 667
• 668
• 669
• 670
• 671
• 672
• 673
• 674
• 675
• 676
• »