CData Software - Knowledge Base

Recent Articles

• «
• 64
• 65
• 66
• 67
• 68
• 69
• 70
• 71
• 72
• 73
• »

• How to create Bing Ads federated tables in MySQL

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

• Build a PostgreSQL Interface for Printify using the CData JDBC Driver

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

• Manage Calendly in DBArtisan as a JDBC Source

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

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

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

• How to connect SharePoint with Sugar CRM through external lists

  Provide Sugar CRM to SharePoint users as an external list.

• Analyze GraphQL in Infragistics Reveal

  Use CData Connect AI to create on OData API on top of GraphQL and visualize live GraphQL in Infragistics Reveal.

• How to Query Live Greenplum in Perplexity MacOS Desktop

  Connect to and query live Greenplum in Perplexity Desktop using the CData MCP Server.

• Connect to SharePoint Excel Services in RazorSQL

  Connect to SharePoint Excel Services from wizards and query SharePoint Excel Services from the GUI in the RazorSQL database management tool.

• Access TigerGraph 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 TigerGraph.

• Use the CData Software ODBC Driver for Square in MicroStrategy

  Connect to Square in MicroStrategy Developer using the CData Software ODBC Driver for Square.

• Replicate SAP Hybris C4C from PowerShell

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

• Connect Neo4J to IBM WebSphere Using the CData JDBC Driver

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

• Automated Continuous Google Ads Replication to Oracle

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

• How to use SQLAlchemy ORM to access JotForm in Python

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

• Integrating Dataiku with Amazon Athena via CData Connect AI

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

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

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

• Access Live PostgreSQL in AWS Lambda (with IntelliJ IDEA)

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

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

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

• Connect and Query Live MongoDB Data in Databricks with CData Connect AI

  Use CData Connect AI to integrate live MongoDB into Databricks

• Visualize GraphQL in Tableau

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

• Enable the Xero JDBC Driver in KNIME

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

• Use the CData API Server to Access Azure Table in Microsoft PowerPivot

  Use the CData API Server to connect to live Azure Table Storage in the Power Pivot business intelligence tool.

• Automated Continuous DocuSign Replication to MongoDB

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

• Connect to Blackbaud FE NXT in Jaspersoft Studio

  Execute SQL to remote Blackbaud FE NXT in Jaspersoft Studio.

• Configure the CData JDBC Driver for Jira Service Management in a Connection Pool in Tomcat

  Connect to Atlassian Jira Service Management from a connection pool in Tomcat.

• Extract, Transform, and Load Amazon Athena in Informatica PowerCenter

  Create a simple Workflow for Amazon Athena in Informatica PowerCenter.

• Bidirectional Access to Zoho Inventory from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate Zoho Inventory in Filemaker Pro for Mac or Windows.

• Connect to Okta in RapidMiner

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

• Use the CData Software ODBC Driver for Active Directory in MicroStrategy Web

  Connect to Active Directory in MicroStrategy Web using the CData Software ODBC Driver for Active Directory.

• How to connect PolyBase to SAP

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SAP ERP/NetWeaver.

• Use the CData Software JDBC Driver for MySQL in MicroStrategy

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

• Connect to Presto through External Services in Salesforce

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

• Validate ADP with QuerySurge

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

• Integrate Google Campaign Manager 360 in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Google Campaign Manager 360 from Informatica Cloud.

• Connect to Adobe Commerce in the Denodo Platform

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

• Establish a Live Connection with Google Ad Manager using Tableau Bridge

  The CData ODBC Driver for Google Ad Manager enables you to integrate live Google Ad Manager into Tableau Cloud dashboards using the Tableau Bridge.

• Build MVC Applications with Connectivity to Amazon Marketplace

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

• How to Connect Flowise AI Agents to Live NetSuite via CData Connect AI

  Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live data without replication.

• A PostgreSQL Interface for Workday (MySQL Remoting via JDBC)

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

• Access Live Kafka Data in Tableau with CData API Server

  With CData API Server, easily create OData endpoints for live Kafka data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.

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

• 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.

• Import Real-Time ClickUp via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use ClickUp in ColdFusion.

• How to use SQLAlchemy ORM to access Wave Financial in Python

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

• Use Claude to Talk to Your Azure DevOps via CData Connect AI

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

• How to Query Live Neo4J in Claude Desktop

  Connect to and query live Neo4J in Claude Desktop using the CData MCP Server.

• How to Access Live Presto in Power Automate Desktop via ODBC

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

• How to Connect DBeaver to Highrise via a JDBC Driver

  Manage Highrise CRM with visual tools in DBeaver like the query browser.

• Create PostgreSQL-Connected Nintex Workflows

  Use CData Connect AI to connect to PostgreSQL from Nintex Workflow Cloud and build custom workflows using live PostgreSQL.

• Query Zoho Books through ODBC in Node.js

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

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

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

• How to Connect Flowise AI Agents to Live Act CRM via CData Connect AI

  Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live data without replication.

• How to Work with Azure Active Directory in AWS Glue Jobs Using JDBC

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

• Connect to Oracle HCM Cloud through External Services in Salesforce

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

• Integrate Splunk in the Pentaho Report Designer

  Publish reports based on Splunk in the Pentaho BI tool.

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

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

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

  Easily push IBM Cloudant to Databricks using the CData SSIS Tasks for Cloudant and Databricks.

• Access Live Printful Data in Tableau with CData API Server

  With CData API Server, easily create OData endpoints for live Printful data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.

• How to Connect DBeaver to SAP via a JDBC Driver

  Manage SAP ERP/NetWeaver with visual tools in DBeaver like the query browser.

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

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

• Access Couchbase from MySQL in PHP

  Connect to Couchbase through the standard MySQL libraries in PHP.

• Use the CData SSIS Components to Insert New or Update Existing Adobe Commerce Records from SQL Server

  Easily push SQL Server data to Adobe Commerce using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Adobe Commerce or update existing records with data from a SQL Server database.

• How to pipe SAP to CSV in PowerShell

  Use standard PowerShell cmdlets to access SAP tables.

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

  Provide connectivity to Tally ERP through an SAP BusinessObjects universe.

• Enable the Active Directory JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Active Directory.

• Viewing Typeform in RAD Studio Data Explorer

  How to view Typeform in RAD Studio Data Explorer using the CData ODBC Driver for Typeform.

• How to connect PolyBase to Google Search

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

• Query Outreach.io using the OData SDK for PHP

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

• Connecting Mastra with PostgreSQL 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 data across 300+ enterprise sources no replication required.

• Building Dynamic Web Pages with ServiceNow Using AngularJS

  Create single-page applications with live connectivity to ServiceNow using the CData API Server.

• Build Dashboards with Microsoft Dataverse in Dundas BI

  Create dynamic dashboards and perform analytics based on Microsoft Dataverse (CDS) in Dundas BI.

• Publish Tableau CRM Analytics-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Tableau CRM Analytics.

• Analyze NetSuite in Cognos Analytics

  Use CData Connect AI to connect to NetSuite from Cognos Analytics and analyze live NetSuite CRM & ERP.

• How to pipe Cloudant to CSV in PowerShell

  Use standard PowerShell cmdlets to access Cloudant tables.

• Connect to MongoDB in the Denodo Platform

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

• Connect to Twitter in Aqua Data Studio

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

• Connect and Visualize Live Kintone Data in Databricks Lakehouse Federation with CData Connect AI

  Use CData Connect AI to integrate live Kintone into the Databricks platform and create visualization dashboards with real-time Kintone.

• Write a Simple Go Application to work with MailChimp on Linux

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

• How to connect to WooCommerce in DBVisualizer

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

• LINQ to WooCommerce

  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 WooCommerce Data Provider.

• Access Instagram as a Remote Oracle Database

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

• Automated Continuous Pinterest Replication to SingleStore

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

• Connect to Smartsheet in ACL Analytics

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

• Integrate Parquet with JetBrains RubyMine using CData JDBC Drivers

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

• How to Connect to & Open Oracle Service Cloud in Microsoft Excel

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

• Excel Spreadsheet Automation on Box with the QUERY Formula

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

• Getting Started with the CData Power BI Connector for Trello

• «
• 64
• 65
• 66
• 67
• 68
• 69
• 70
• 71
• 72
• 73
• »