CData Software - Knowledge Base

Recent Articles

---

• «
• 858
• 859
• 860
• 861
• 862
• 863
• 864
• 865
• 866
• 867
• »

• How to connect PolyBase to Microsoft Entra ID

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

• Deploy the ADO.NET Provider for Klaviyo on an SSRS Report Server

  Connect to Klaviyo from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

• Create Reports with Snapchat Ads Data in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Snapchat Ads.

• Connect to MongoDB Data in RazorSQL

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

• Replicate Sybase IQ Data in Heroku for Use in Salesforce Connect

  Replicate Sybase IQ to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Create Telegram Dataflows on PowerBI.com

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

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

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

• Analyze Outlook Data with Power Pivot

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

• Automated Continuous Coinbase Replication to Azure SQL Database

  Use CData Sync for automated, continuous, customizable Coinbase replication to Azure SQL Database.

• Create Data Visualizations in Cognos BI with Lakebase Data

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

• Integrating Codex CLI with Oracle SCM 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.

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

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

• How to use SQLAlchemy ORM to access MarkLogic Data in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of MarkLogic.

• Work with Optimizely Data in FoxPro

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

• Use Databricks Agent Bricks to Talk to Your Oracle HCM Cloud Data via CData Connect AI

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

• Use Biml to Build SSIS Tasks to Replicate Miro Data to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Miro to SQL Server.

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

  Use CData Connect AI to gain access to live Oracle SCM from your Excel spreadsheets.

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

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

• How to Visualize Microsoft Dataverse Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Microsoft Dataverse (CDS) in Python.

• How to Import Data from SAS Data Sets into Google Sheets

  Import SAS Data Sets into a Google spreadsheet that is automatically refreshed.

• Connect to Microsoft Dataverse Data from AWS Glue

  Use CData Connect AI to gain access to live Microsoft Dataverse (CDS) from your AWS Glue jobs.

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

• Integrating Kiro CLI with Google Translate 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 Dynamic Bitly Grids Using the Infragistics XamDataGrid

  Learn how you can connect Bitly to Infragistics XamDataGrid to build dynamic grids.

• How to connect to GetResponse Data with Squirrel SQL client

  Connect to GetResponse and execute queries in the Squirrel SQL Client.

• Connect to Email Data from a Connection Pool in JBoss

  Integrate Email into Java servlets: Use the Management Console in JBoss to install the Email JDBC Driver.

• Integrate SharePoint with External Services using SnapLogic

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

• How to create Outlook federated tables in MySQL

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

• Connect to Dynamics CRM Data from PowerBuilder via ODBC

  This article demonstrates how to use the CData ODBC Driver for Dynamics CRM to connect to Microsoft Dynamics CRM and execute queries in PowerBuilder.

• Connecting Pipedream with Splunk Data via CData Connect AI MCP Server

  Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Splunk data in real time.

• Query Salesforce CRM Analytics Data from Node.js

  Use the OData endpoint of the CData API Server to connect to your Salesforce CRM Analytics and perform CRUD operations on Salesforce CRM Analytics from Node.js.

• Use Manus AI to Talk to Your Snowflake 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 Snowflake.

• How to import Authorize.Net Data into Apache Solr

  Use the CData Software JDBC Driver for Authorize.Net in Data Import Handler and create an automated import of Authorize.Net to Apache Solr Enterprise Search platform.

• Replicate Multiple Perplexity Accounts via the CData Sync CLI

  Replicate multiple Perplexity accounts to one or many databases.

• Connect to Bannerbear Data from PowerBuilder via ADO.NET

  This article demonstrates how to access Bannerbear from Appeon PowerBuilder using the CData API Driver for ADO.NET.

• Integrate Active Directory with JetBrains RubyMine using CData JDBC Drivers

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

• Connect to Phoenix Data in RunMyProcess through Connect AI

  Use CData Connect AI to create on OData API for Phoenix Data and connect to Apache Phoenix in Akorbi Digital RunMyProcess.

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

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

• Build MailChimp-Connected Dashboards Using Zoho Analytics

  Use CData Connect AI to connect to MailChimp Data from Zoho Analytics and import live MailChimp.

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

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

• Integrate Live Mistral AI Data into Blue Prism for Intelligent Robotic Process Automation (RPA)

  Connect live Mistral AI to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.

• How to Easily Query Authorize.Net Data in OpenOffice Base

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

• Query Cvent Data through ODBC in Node.js

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

• Replicate Multiple Impala Accounts

  Replicate multiple Impala accounts to one or many databases.

• Automated Continuous Azure Blob Storage Replication to Azure SQL Database

  Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to Azure SQL Database.

• How to Connect to & Open SAP HANA Data in Microsoft Excel

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

• Extract, Transform, and Load YouTube Analytics Data in Informatica PowerCenter

  Create a simple Workflow for YouTube Analytics in Informatica PowerCenter.

• How to work with Printful Data in Apache Spark using SQL

  Access and process Printful Data in Apache Spark using the CData Software JDBC Driver.

• How to Interact with Live Data from Anywhere in Open WebUI

  Power Open WebUI with CData MCP Servers to run local LLMs on live enterprise data from SaaS apps, APIs, and databases for secure AI insights.

• Visualize Zoho CRM Data from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Zoho CRM.

• Create Power BI Reports on Real-Time OneNote Data

  Use the CData ODBC Driver for OneNote to visualize Microsoft OneNote in Power BI Desktop.

• Visualize Live Shopify Data in Power BI (via CData Connect AI)

  Use the CData Power BI Connector and CData Connect AI to integrate live Shopify into custom reports in Power BI.

• Build a Simple VCL Application for Sage Intacct Data

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

• Automate Exact Online Data Replication to SAP HANA

  Use CData Sync to customize and automate Exact Online replication to SAP HANA.

• Automate SAP HANA XS Advanced Integration Tasks from PowerShell

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

• Connect to Salesforce Pardot Data from a Connection Pool in Jetty

  The Salesforce Pardot JDBC Driver supports connection pooling: This article shows how to connect faster to Salesforce Pardot from Web apps in Jetty.

• Build a Simple VCL Application for Hacker News Data

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

• Connect to Couchbase Data from AWS Glue

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

• Visualize LeadDesk Data in Tableau

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

• Analyze Live Salesforce Data in Infragistics Reveal by Connecting through CData Connect AI or CData API Server

  Use CData Connect AI or CData API Server to create an OData API on top of Salesforce data and visualize live Salesforce data in Infragistics Reveal.

• Integrate Live Salesforce Pardot Data in the Windsurf IDE via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Windsurf

• Import and Visualize Adobe Experience Manager Data in Power View

  Create data visualizations based on Adobe Experience Manager in Excel.

• How to connect SharePoint with Zoho Inventory Data through external lists

  Provide Zoho Inventory to SharePoint users as an external list.

• Build Visualizations of Freshdesk Data in Birst

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

• Connect to Acumatica Data from a Connection Pool in Jetty

  The Acumatica JDBC Driver supports connection pooling: This article shows how to connect faster to Acumatica ERP from Web apps in Jetty.

• Integrate Sugar CRM Data in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Sugar CRM from Informatica Cloud.

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

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

• Automate SendPulse Integration Tasks from PowerShell

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

• Object-Relational Mapping (ORM) with Quaderno Data Entities in Java

  Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Quaderno into a Java-based ORM framework, Hibernate.

• Connect to ZohoPeople Data from PowerBuilder via JDBC

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

• Choosing the Best Method to Connect Cosmos DB to SQL Server: 5 Options Explained

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

• How to Access Zoho CRM Data Using Entity Framework

  This article shows how to access Zoho CRM using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

• How to Connect to & Open Google Cloud Storage Data in Microsoft Excel

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

• How to publish and share Dynamics NAV Data dashboards with Tableau Server

  The CData ODBC driver for Dynamics NAV enables you integrate Microsoft Dynamics NAV into Tableau dashboards.

• Build Dashboards with Lakebase Data in Dundas BI

  Create dynamic dashboards and perform analytics based on Lakebase in Dundas BI.

• Build Twitter Ads-Connected Apps in Choreo

  Use CData Connect AI to connect to Twitter Ads Data from Choreo and build custom apps using live Twitter Ads.

• Connect to PingOne Data in Aqua Data Studio

  Access PingOne from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Connect to Discourse Data from Blazor Apps

  Build ASP.NET Core Blazor C# apps that integrate with real-time Discourse using standard SQL.

• Integrate Live Redis Data into Custom Business Apps Built in Power Apps

  Use CData Connect AI to connect to Redis and integrate live Redis into apps built in Microsoft Power Apps.

• Build PingOne-Powered Applications in Gemini Code Assist with CData MCP Server

  Use the CData MCP Server for PingOne to explore live PingOne Data in Gemini Code Assist to assist with building PingOne-powered applications.

• Create Instagram-Connected Business Apps in AppSheet

  Connect to Instagram Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Instagram.

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

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

• Create Data Visualizations in Cognos BI with Mailgun Data

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

• Build QuickBooks Online-Connected Apps in Bubble

  Use CData Connect AI to create an OData feed for QuickBooks Online Data and create custom apps in Bubble.

• How to create Klaviyo federated tables in MySQL

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

• Automated Continuous Microsoft Ads Data Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable Microsoft Ads replication to OneLake in Microsoft Fabric.

• Integrate with AgileCRM Data in JReport Designer

  Create charts and reports based on AgileCRM in JReport Designer.

• Connect to Salesforce CRM Analytics from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Salesforce CRM Analytics to connect to Salesforce CRM Analytics from Web applications running on WebLogic.

• Connect SAP HANA to AI Assistants With the CData Python MCP Server

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

• Connect to Planio Data in CloverDX (formerly CloverETL)

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

• Back Up Simplesat to SQL Server through SSIS

  Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Simplesat data.

• Connect and Query Live Microsoft Entra ID Data in Databricks with CData Connect AI

  Use CData Connect AI to integrate live Microsoft Entra ID into Databricks

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

  Use Connect Spreadsheets by CData to gain access to live Active Directory from your Excel spreadsheets.

• How to use SQLAlchemy ORM to access ScrapingBee Data in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of ScrapingBee.

• Viewing Salesforce Data in RAD Studio Data Explorer

  How to view Salesforce & Force.com in RAD Studio Data Explorer using the CData ODBC Driver for Salesforce.

• Automate Tasks in Power Automate Using the CData API Server

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

• Visualize Harvest Data in TIBCO Spotfire through ADO.NET

  Integrate Harvest into dashboards in TIBCO Spotfire.

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

  Execute MySQL queries against Atlassian Confluence from Node.js.

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

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

• Use the CData Software JDBC Driver for Office 365 in MicroStrategy

  Connect to Microsoft Office 365 in MicroStrategy Developer using the CData Software JDBC Driver for Office 365.

• «
• 858
• 859
• 860
• 861
• 862
• 863
• 864
• 865
• 866
• 867
• »