CData Software - Knowledge Base

Recent Articles

---

• «
• 860
• 861
• 862
• 863
• 864
• 865
• 866
• 867
• 868
• 869
• »

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

  Execute MySQL queries against Salesforce data from Node.js.

• How to connect and process Vault CRM data from Azure Databricks

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

• Connect to SAP Business One Data in Jaspersoft Studio

  Execute SQL to remote SAP Business One data in Jaspersoft Studio.

• Integrating Dataiku with Mode Data via CData Connect AI

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

• Visualize MailerSend Data in Sisense

  Create an ElastiCube in Sisense app with access to MailerSend data.

• Integrate Hive Data in the Pentaho Report Designer

  Publish reports based on Hive data in the Pentaho BI tool.

• Integrating LlamaIndex with CapsuleCRM Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on CapsuleCRM data in real time.

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

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

• How to Connect to Live Google Ad Manager 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 Google Ad Manager data through natural language.

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

• Access Live Oracle HCM Cloud Data in AWS Lambda

  Connect to live Oracle HCM Cloud data in AWS Lambda using the CData JDBC Driver.

• Build Dashboards with Dynamics 365 Business Central Data in Dundas BI

  Create dynamic dashboards and perform analytics based on Dynamics 365 Business Central data in Dundas BI.

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

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

• Manage Optimizely Data in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for Optimizely.

• Integrating GitHub Copilot with TaxJar 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 ZeroBounce Data as an External Source in Dremio

  Use the CData JDBC Driver to connect to ZeroBounce as an External Source in Dremio.

• How to Visualize AlloyDB Data in Python with pandas via CData Connect AI

  Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live AlloyDB data in Python.

• Automated Continuous Excel Replication to Azure SQL Database

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

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

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

• Integrate OpenCode with Live Oracle SCM Data via CData Connect AI

  Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Oracle SCM data from within your AI coding agent.

• Access Exa Data from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Exa data from HeidiSQL.

• How to import TaxJar Data into Apache Solr

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

• Automated Continuous Bugsnag Replication to SQL Server

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

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

  Provide connectivity to Notion data through an SAP BusinessObjects universe.

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

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

• Excel Spreadsheet Automation on Instantly Data with the QUERY Formula

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

• Connect to Calendly Data from a Connection Pool in Jetty

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

• Replicate Klaviyo Data from PowerShell

  Write a quick PowerShell script to query Klaviyo data. Use connectivity to the live data to replicate Klaviyo data to SQL Server.

• Natively Connect to OData Services in PHP via ODBC (Linux)

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

• Analyze Instantly Data in R via JDBC

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

• Build Dashboards with Mistral AI Data in DBxtra

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

• Build Semantic Layer Views for CSV Data in APOS Live Data Gateway

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

• Access Live Dynamics 365 Business Central 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 Dynamics 365 Business Central data through MCP integration.

• Automated Continuous AlloyDB Replication to SQLite

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

• Automated Insightly Data Replication to Teradata

  Use CData Sync to Customize and automate Insightly data replication to Teradata.

• Extract, Transform, and Load Redshift Data in Informatica PowerCenter

  Create a simple Workflow for Redshift data in Informatica PowerCenter.

• Access LaunchDarkly Data from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live LaunchDarkly data from HeidiSQL.

• Connect to Browserless Data as an External Source in Dremio

  Use the CData JDBC Driver to connect to Browserless as an External Source in Dremio.

• Access Sage 300 Data as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Sage 300 data from your Oracle system.

• Access Live Azure Table Data in AWS Lambda

  Connect to live Azure Table data in AWS Lambda using the CData JDBC Driver.

• Integrate Theia IDE with Live NetSuite SuiteAnalytics 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 NetSuite SuiteAnalytics data from within the development environment.

• Search External Aweber Objects in Salesforce Connect

  Use CData Connect AI to securely provide OData feeds of Aweber data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Aweber Data objects that you can access from apps and the dashboard.

• How to Query SFTP Data in MySQL Workbench

  Execute MySQL queries against live SFTP data from MySQL Workbench.

• Connect to Microsoft Exchange Data in DBArtisan

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

• Replicate SAP Data in Heroku for Use in Salesforce Connect

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

• Connect to Bright Data Data in ACL Analytics

  Connect to Bright Data data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Bright Data data.

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

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

• How to Connect DBeaver to JSON via a JDBC Driver

  Manage JSON services with visual tools in DBeaver like the query browser.

• Connect to Clio Data in DigitalSuite Studio through RunMyProcess DSEC

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

• Connect to Figshare 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 Figshare and work with Figshare data in your FileMaker application.

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

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

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

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

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

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

• Connect to iContact Data through External Services in Salesforce

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

• Redshift Data Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to Redshift data through CData Connect AI using different applications and tools.

• Visualize Live Azure Analysis Services Data of Power BI Report Builder in Power BI Service

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

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

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

• How to Work with Close Data in AWS Glue Jobs Using JDBC

  Connect to Close from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

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

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

• Choosing the Best Method to Connect SAP HANA XS Advanced to SQL Server: 5 Options Explained

  Discover multiple ways to connect and use SAP HANA XS Advanced data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.

• Establish a Live Connection with Avro Data using Tableau Bridge

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

• Integrate Real-Time Access to Azure Data Catalog in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Azure Data Catalog data in real time.

• Replicate Unbounce Data to Multiple Databases via the CData Sync CLI

  Replicate Unbounce data to disparate databases with a single configuration.

• Build a Simple VCL Application for ChartMogul Data

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

• Create ZohoMarketingHub-Connected Visualizations in Klipfolio

  Use CData Connect AI to connect to ZohoMarketingHub Data from Klipfolio and build custom visualizations using live ZohoMarketingHub data.

• How to use SQLAlchemy ORM to access Snapchat Ads Data in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Snapchat Ads data.

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

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

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

• Migrating data from SAP HANA XS Advanced to Snowflake using CData SSIS Components.

  Easily push SAP HANA XS Advanced data to Snowflake using the CData SSIS Tasks for SAP HANA XS Advanced and Snowflake.

• Visualize Salesforce Pardot Data in TIBCO Spotfire through OData

  Integrate Salesforce Pardot data into dashboards in TIBCO Spotfire.

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

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

• Create HubSpot-Connected Business Apps in AppSheet

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

• Build GraphQL-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to GraphQL data and build web apps with connectivity to live GraphQL data.

• DataBind Charts to Testmonitor Data

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

• Use the CData Software JDBC Driver for ZendeskSell in MicroStrategy Desktop

  Connect to ZendeskSell data in MicroStrategy Desktop using the CData Software JDBC Driver for ZendeskSell.

• Connect to Rootly Data in HULFT Integrate

  Connect to Rootly as a JDBC data source in HULFT Integrate

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

  Connect to Microsoft Teams data 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.

• Query Live SharePoint 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 SharePoint data directly from the development environment.

• Access Accelo Data as a Remote Oracle Database

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

• Connect to Optimizely Data in RunMyProcess through Connect AI

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

• How to Work with Zoho Books Data in AWS Glue Jobs Using JDBC

  Connect to Zoho Books from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• Manage Sendwithus Data in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for Sendwithus.

• Access Paylocity Data from MySQL in Amazon QuickSight

  Connect to Paylocity and build visualizations of Paylocity data using a MySQL Connection in Amazon QuickSight.

• Integrate Live ActiveCampaign Data into Amazon SageMaker Canvas with RDS

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

• Provide OData Services of MailerSend Data from a WCF Application

  In this article, we will demonstrate the process of generating an OData feed for MailerSend data by developing a WCF Service Application.

• How to Create Power BI Visual Reports with Real-Time Oracle Eloqua Reporting Data

  Use CData Power BI Connectors to visualize Oracle Eloqua Reporting data in Power BI.

• Connect to Bright Data Data in DBArtisan

  Use wizards in DBArtisan to configure Bright Data data as a data source.

• Connect to Redshift Data in Aqua Data Studio

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

• Using the CData Software ODBC Driver for MessageBird in PyCharm

  Connect to MessageBird as an ODBC data source in PyCharm using the CData Software ODBC Driver for MessageBird.

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

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

• Automated Continuous SendPulse Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable SendPulse replication to Google Cloud SQL.

• Connect to Recurly Data in RapidMiner

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

• Connect to Raisers Edge NXT Data in Aqua Data Studio

  Access Raisers Edge NXT data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Integrate Clockify with External Services using SnapLogic

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

• Access Live Harvest Data in SAS JMP via ODBC

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

• Use the CData Software ODBC Driver for Trello in MicroStrategy Desktop

  Connect to Trello data in MicroStrategy Desktop using the CData Software ODBC Driver for Trello.

• How to Build an ETL App for Certinia Data in Python with CData

  Create ETL applications and real-time data pipelines for Certinia data in Python with petl.

• Create Reports with Oracle Eloqua Data in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Oracle Eloqua data.

• Use Microsoft Copilot Studio to talk to your RSS Feeds via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your RSS feeds for you.

• Integrate Open WebUI with Live Cosmos DB Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Cosmos DB data from within the chat interface.

• «
• 860
• 861
• 862
• 863
• 864
• 865
• 866
• 867
• 868
• 869
• »