CData Software - Knowledge Base

Recent Articles

---

• «
• 1144
• 1145
• 1146
• 1147
• 1148
• 1149
• 1150
• 1151
• 1152
• 1153
• »

• Query Gorgias Data through ODBC in Node.js

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

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

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

• Build MVC Applications with Connectivity to Smartsheet Data

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

• Connect to BenchmarkEmail Data in the Denodo Platform

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

• Analyze Live HubSpot Data in SAS Viya

  Use CData Connect AI to connect to HubSpot from SAS Viya and deploy self-service analytics using live HubSpot.

• How to create ZohoExpense federated tables in MySQL

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

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

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

• DataBind Charts to ZarMoney Data

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

• Build Outreach.io-Connected Apps in Bubble

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

• Integrate REST with JetBrains RubyMine using CData JDBC Drivers

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

• How to Access Live Google Analytics Data in Visual Studio Code via Cline

  Run CData MCP Server for Google Analytics on Windows Subsytem for Linux (WSL) and connect to live Google Analytics from the Cline extension in Visual Studio Code.

• Publish Reports with Paylocity Data in SAP Crystal Reports

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

• Access Airtable Data as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Airtable from your Oracle system.

• Analyze Recurly Data in R via ODBC

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

• Automated Continuous Omnisend Replication to MongoDB

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

• Model Oracle Service Cloud Data Using Azure Analysis Services

  Leverage CData Connect AI to establish a connection between Azure Analysis Services and Oracle Service Cloud, enabling the direct import of real-time Oracle Service Cloud.

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

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

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

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

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

• Query Sybase Data in DataGrip

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

• How to Query Klipfolio Data in MySQL Workbench

  Execute MySQL queries against live Klipfolio from MySQL Workbench.

• How to import Adobe Commerce Data into Apache Solr

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

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

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

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

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

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

  Provide connectivity to SAP Fieldglass through an SAP BusinessObjects universe.

• Connect SAP to IBM WebSphere Using the CData JDBC Driver

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

• DataBind Controls to Okta Data in C++Builder

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

• View Reports on Real-Time XML Data in Power BI Report Server

  Use the CData ODBC Driver for XML to visualize XML Files in Power BI Desktop and then publish them to Power BI Report Server.

• How to import Bitly Data into Apache Solr

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

• Connect to Tickspot Data from a Connection Pool in JBoss

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

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

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

• Automated Continuous Adobe Target Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable Adobe Target replication to PostgreSQL.

• How to connect and process ConvertKit from Azure Databricks

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

• Model PayPal Data Using Azure Analysis Services

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

• Connect to Amazon Athena Data in DBArtisan

  Use wizards in DBArtisan to configure Amazon Athena as a data source.

• Integrate Goose with Live Office 365 Data via CData Connect AI

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

• Connect to JotForm Data in RazorSQL

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

• Use the CData Software JDBC Driver for Perplexity in MicroStrategy

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

• Bridge Google Campaign Manager 360 Connectivity with Apache NiFi

  Access and process Google Campaign Manager 360 in Apache NiFi using the CData JDBC Driver.

• How to connect SharePoint with EnterpriseDB Data through external lists

  Provide EnterpriseDB to SharePoint users as an external list.

• Build Charts with Microsoft Ads Data in Clear Analytics

  Create dynamic charts and perform analytics based on Microsoft Ads in Clear Analytics.

• Build SAP Hybris C4C-Powered Applications in Claude Code with CData MCP Server

  Use the CData MCP Server for SAP Hybris C4C to explore live SAP Hybris C4C Data in Claude Code to assist with building SAP Hybris C4C-powered applications.

• Integrate Square with External Services using SnapLogic

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

• Query Pinterest Data in DataGrip

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

• Automated Continuous Rebilly Replication to SQL Server

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

• Natively Connect to ZohoExpense Data in PHP

  The CData ODBC driver for ZohoExpense enables you to create PHP applications with connectivity to ZohoExpense. Leverage the native support for ODBC in PHP.

• Connect to ElevenLabs Data in NetBeans

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

• Excel Spreadsheet Automation on Salesloft Data with the QUERY Formula

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

• Back Up Templated 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 Templated data.

• Query Excel Online Data through ODBC in Node.js

  Use node-odbc to execute SQL queries against Microsoft Excel Online from Node.js.

• Query Greenhouse Data using the OData SDK for PHP

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

• How to Work with Freshservice Data in ETL Validator JDBC

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

• Access Live Missive Data in SAS JMP via ODBC

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

• How to Import Data from Adobe Commerce into Google Sheets

  Import Adobe Commerce into a Google spreadsheet that is automatically refreshed.

• Use the CData Software ODBC Driver for Microsoft OneDrive in MicroStrategy Desktop

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

• Integrate with Freshsales Data in JReport Designer

  Create charts and reports based on Freshsales in JReport Designer.

• Visualize Contentful Data in Sisense

  Create an ElastiCube in Sisense app with access to Contentful.

• Connect to Pinterest in SpagoBI

  Create reports featuring live Pinterest in SpagoBI Studio. Host Pinterest reports on SpagoBI Server.

• Analyze Unbounce Data with Power Pivot

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

• Connecting Agentforce with Redshift Data via CData Connect AI MCP Server

  Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Amazon Redshift for you.

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

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

• Replicate MarkLogic Data in Heroku for Use in Salesforce Connect

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

• Excel Online Reporting in OBIEE with the Excel Online JDBC Driver

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

• Connect to Eventbrite Data in RazorSQL

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

• Connect to RabbitMQ Data in Jaspersoft Studio

  Execute SQL to remote RabbitMQ in Jaspersoft Studio.

• Build Automated Workflows with Live Oracle Service Cloud Data in Workato

  Use CData Connect AI to connect to live Oracle Service Cloud and build automated workflows in Workato.

• Explore Geographical Relationships in GitHub Data with Power Map

  Create data visualizations with GitHub in Power Map.

• Create VWO Dataflows on PowerBI.com

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

• DataBind Charts to Toggl Data

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Toggl 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 Dynamics 365 Business Central Data as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Dynamics 365 Business Central.

• Automated Continuous BambooHR Replication to Apache Kafka

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

• Automated Continuous Salesforce Pardot Replication to SingleStore

  Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to SingleStore.

• How to Connect to Live Cosmos DB Data from Gemini CLI (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Azure Cosmos DB for you.

• How to connect PolyBase to Reckon Accounts Hosted

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

• Build Apps with Live Outreach.io in Adalo using CData Connect AI

  Use CData Connect AI to integrate live Outreach.io into the Adalo platform and build custom mobile and web applications with real-time Outreach.io.

• Create Teamgate Dataflows on PowerBI.com

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

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

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

• Analyze Dynamics 365 Business Central Data with Power Pivot

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

• Use Grok to Talk to Your SAP Netweaver Gateway Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your SAP Netweaver Gateway for you.

• Automated Continuous Autopilot Replication to Vertica

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

• Access Phoenix Data from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Apache Phoenix from HeidiSQL.

• Replicate Multiple Accelo Accounts via the CData Sync CLI

  Replicate multiple Accelo accounts to one or many databases.

• Use Dash to Build to Web Apps on SFTP Data

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

• Access Microsoft Planner 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 Microsoft Planner.

• Automated Continuous Microsoft Dataverse Replication to Vertica

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

• Connect to Egnyte Data in RapidMiner

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

• Connect ChartMogul to IBM WebSphere Using the CData JDBC Driver

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

• Integrate with CircleCI Data in JReport Designer

  Create charts and reports based on CircleCI in JReport Designer.

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

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

• Getting Started with the CData Power BI Connector for Smartsheet

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

• Connect to Salesforce Pardot from a Connection Pool in WebLogic

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

• Create a Data Access Object for LionDesk Data using JDBI

  A brief overview of creating a SQL Object API for LionDesk in JDBI.

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

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

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

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

• Build Data Flows from SendPulse to SQL Server using SSIS

  Easily back up SendPulse to SQL Server using the SSIS components for SendPulse.

• Getting Started with the CData Power BI Connector for DB2

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

• Create Reports with Microsoft Dataverse Data in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Microsoft Dataverse (CDS).

• View Reports on Real-Time Azure Synapse Data in Power BI Report Server

  Use the CData ODBC Driver for Azure Synapse to visualize Azure Synapse in Power BI Desktop and then publish them to Power BI Report Server.

• Visualize Live Oracle Data in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Oracle Database.

• Automated Continuous Front Replication to Oracle

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

• «
• 1144
• 1145
• 1146
• 1147
• 1148
• 1149
• 1150
• 1151
• 1152
• 1153
• »