CData Software - Knowledge Base

Recent Articles

---

• «
• 1131
• 1132
• 1133
• 1134
• 1135
• 1136
• 1137
• 1138
• 1139
• 1140
• »

• Access MariaDB Data from MySQL in PHP

  Connect to MariaDB through the standard MySQL libraries in PHP.

• How to integrate Nuclia with Apache Airflow

  Access and process Nuclia in Apache Airflow using the CData JDBC Driver.

• Integrating Antigravity CLI with Pivotal GreenPlum via CData CLI

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

• Create Informatica Mappings From/To a JDBC Data Source for Raisers Edge NXT

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

• How to connect and process Salesforce CRM Analytics from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Salesforce CRM Analytics.

• Connect to Epicor Kinetic Data as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Epicor Kinetic.

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

  Use LlamaIndex to query live Microsoft Dynamics CRM data in natural language using Python.

• Access Live xBase Data in Coginiti Pro

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

• Use Dash to Build Web Apps on JSON Services via CData Connect AI

  Build interactive Dash web apps on live JSON using pandas and the CData Connect AI Python SDK.

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

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

• Work with Google Directory Data in FoxPro

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

• Model, Search, and Visualize Live Okta Data in ThoughtSpot

  Use CData Connect AI to connect to live Okta for modeling, searching, and visualizing.

• Access Greenplum Data from MySQL in Amazon QuickSight

  Connect to Greenplum and build visualizations of Pivotal GreenPlum using a MySQL Connection in Amazon QuickSight.

• Creating SQL Server-Connected Applications in Unqork

  You can use CData Connect AI to feed Microsoft SQL Server to Unqork and build custom business apps.

• Add Google Ad Manager Data to Informatica Enterprise Data Catalog

  Use the CData Software JDBC Driver for Google Ad Manager with the Informatica Enterprise Data Catalog to classify and organize data.

• Automated Continuous Sage Intacct Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable Sage Intacct replication to AlloyDB.

• Validate RabbitMQ Data with QuerySurge

  Access and validate RabbitMQ in QuerySurge using the CData JDBC Driver.

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

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

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

  Execute MySQL queries against Freshsales from Node.js.

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

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

• Add Coinbase Data to Informatica Enterprise Data Catalog

  Use the CData Software JDBC Driver for Coinbase with the Informatica Enterprise Data Catalog to classify and organize data.

• Add Spark Data to Informatica Enterprise Data Catalog

  Use the CData Software JDBC Driver for Spark with the Informatica Enterprise Data Catalog to classify and organize data.

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

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

• ZohoPeople Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on ZohoPeople facts in real time.

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

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

• Integrate Paymo with JetBrains RubyMine using CData JDBC Drivers

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

• Operational Reporting on Instagram Data from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Instagram.

• How to use SQLAlchemy ORM to access Oracle Eloqua Reporting Data in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Oracle Eloqua Reporting.

• Integrating GitHub Copilot CLI with Sage 200 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.

• Use JayDeBeApi to access Cloudant Data in Python

  Use standard Python scripting and the development environment of your choice to access live IBM Cloudant.

• Build Visualizations of Instagram Data in Birst

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

• How to Connect the Power BI Service to BigQuery: Complete Guide

  Connect to the CData Software Power BI Connector for BigQuery from PowerBI.com to provide real-time Google BigQuery across the organization.

• Create a Data Access Object for Billsby Data using JDBI

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

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

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

• Work with PhantomBuster Data in FoxPro

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

• Connect to Dynamics 365 Business Central in SpagoBI

  Create reports featuring live Dynamics 365 Business Central in SpagoBI Studio. Host Dynamics 365 Business Central reports on SpagoBI Server.

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

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

• Getting Started with the CData JDBC Driver for Wrike

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

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

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

• Connect to Printful Data from PowerBuilder via ODBC

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

• Query Instantly Data in DataGrip

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

• Connect FHIR to IBM WebSphere Using the CData JDBC Driver

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

• Build Google Campaign Manager 360 Visualizations in Tableau Cloud

  Use CData Connect AI to connect to live Google Campaign Manager 360 and build visualizations in Tableau Cloud.

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

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

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

• Integrate Zoho Projects Data in the Pentaho Report Designer

  Publish reports based on Zoho Projects in the Pentaho BI tool.

• Connect to YouTube Analytics Data in JRuby

  Create a simple JRuby app with access to live YouTube Analytics.

• How to Connect to Live Monday.com Data in n8n Workflows and Agents (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Monday.com for you.

• Integrate PostgreSQL Data into Power Automate Desktop using CData Connect

  CData Connect for PostgreSQL Data enables you to integrate PostgreSQL into workflows built using Microsoft Power Automate Desktop.

• LINQ to Dynamics 365 Business Central Data

  LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Dynamics 365 Business Central Data Provider.

• Connect to Cosmos DB Data in Ruby

  Connect to Azure Cosmos DB in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Query Tanda Data through ODBC in Node.js

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

• Build Automated MailChimp-Connected Workflows in Zapier

  Use CData Connect AI to connect to live MailChimp and build automated workflows in Zapier.

• Getting Started with the CData Excel Add-In for Foursquare

  Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Foursquare.

• Visualize Live Oracle Eloqua Data in the Power BI Service

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

• Use ChatGPT to Talk to Your Zoho Projects Data via CData Connect AI

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

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

  Connect to your Azure DevOps using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

• Edit and Search Basecamp External Objects in Salesforce Connect (API Server)

  Use the API Server to securely provide OData feeds of Basecamp to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Basecamp objects that you can access from apps and the dashboard.

• Create Dashboards and Visualize Live Greenhouse Data in Geckoboard

  Use CData Connect AI to connect to live Greenhouse and create dashboards for real-time monitoring and visualization in Geckoboard.

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

  Connect to Cloudflare 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.

• Integrating Antigravity CLI with Templated via CData CLI

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

• Automated Continuous Google Cloud Storage Replication to Databricks

  Use CData Sync for automated, continuous, customizable Google Cloud Storage replication to Databricks.

• Connect to Highrise Data in RunMyProcess through Connect AI

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

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

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

• Build Active Directory-Powered Applications in GitHub Copilot with CData MCP Server

  Use the CData MCP Server for Active Directory to explore live Active Directory Data in GitHub Copilot to assist with building Active Directory-powered applications.

• Automated Continuous LightSpeedRetail Replication to Apache Kafka

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

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

• Model PostgreSQL Data Using Azure Analysis Services

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

• Creating Google Cloud Storage-Connected Applications in Unqork

  You can use CData Connect AI to feed Google Cloud Storage to Unqork and build custom business apps.

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

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

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

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

• Query Trello Data through ODBC in Node.js

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

• Connect to Clio Data in the Denodo Platform

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

• Use the CData API Server to Access Facebook Data in Microsoft PowerPivot

  Use the CData API Server to connect to live Facebook in the Power Pivot business intelligence tool.

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

• Automated Continuous SAP Netweaver Gateway Replication to MongoDB

  Use CData Sync for automated, continuous, customizable SAP Netweaver Gateway replication to MongoDB.

• How to connect Amazon QuickSight to Lakebase Data

  Create a connection to Lakebase in CData Connect AI and insert Lakebase into Amazon QuickSight SPICE to build interactive dashboards.

• Connect to Procore Data as an External Data Source using PolyBase

  Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Procore.

• Integrate SAP ByDesign Data in Pentaho Data Integration

  Build ETL pipelines based on SAP Business ByDesign in the Pentaho Data Integration tool.

• Automated Continuous LinkedIn Ads Replication to MongoDB

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

• Enable the Xero JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Xero Accounting.

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

  Use CData ODBC drivers to import and use Adobe Target in ColdFusion.

• Bind Live Cloudant Data in Wijmo FlexGrid with CData API Server

  With CData API Server, easily create OData endpoints for live Cloudant data

• How to connect PolyBase to RabbitMQ

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

• Automated Continuous Greenplum Replication to MySQL

  Use CData Sync for automated, continuous, customizable Greenplum replication to MySQL.

• Visualize Ontraport Data in TIBCO Spotfire through ODBC

  The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Ontraport into TIBCO Spotfire.

• Visualize Zoho Creator Data in TIBCO Spotfire through ODBC

  The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Zoho Creator into TIBCO Spotfire.

• Connect to Scrapfly Data in RazorSQL

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

• Connect to Microsoft Entra ID Data in DBArtisan

  Use wizards in DBArtisan to configure Microsoft Entra ID as a data source.

• Getting Started with the CData Python Connector for Kintone

  Learn to install and license the CData Python Connector

• Getting Started with the CData JDBC Driver for Mixpanel

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

• Query Zendesk Data in ColdFusion

  Write standard ColdFusion data access code to connect to Zendesk.

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

  The CData ODBC Driver for Salesforce enables you to integrate Salesforce & Force.com into workflows built using Microsoft Power Automate Desktop.

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

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

• Access Live Productboard Data in SAS JMP via ODBC

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

• Integrate LibreChat with Live Zendesk Data via CData Connect AI

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

• Connect to and Query Outlook Data in QlikView over ODBC

  Create data visualizations with Outlook in QlikView.

• Analyze SAP Concur Data in Infragistics Reveal

  Use the CData API Server to create an OData API on top of SAP Concur and visualize live SAP Concur in Infragistics Reveal.

• Automated Continuous Opsgenie Data Replication to OneLake in Microsoft Fabric

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

• Connect to Amazon Athena Data in Google Apps Script via SQL Gateway

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

• «
• 1131
• 1132
• 1133
• 1134
• 1135
• 1136
• 1137
• 1138
• 1139
• 1140
• »