CData Software - Knowledge Base

Recent Articles

---

• «
• 823
• 824
• 825
• 826
• 827
• 828
• 829
• 830
• 831
• 832
• »

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

• Query Spark using the OData SDK for PHP

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

• Connecting GenSpark with Impala via CData Connect AI MCP Server

  Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to enterprise data across 300+ systems without any replication or custom integration required.

• Create Gmail Dataflows on PowerBI.com

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

• How to load Sage Cloud Accounting data into Elasticsearch via Logstash

  Introducing a simple method to load Sage Cloud Accounting data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.

• Integrate Google

  Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Google Directory within intelligent workflows.

• How to connect to QuickBooks with Squirrel SQL client

  Connect to QuickBooks Desktop and execute queries in the Squirrel SQL Client.

• DataBind Controls to Workday in C++Builder

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

• How to Query Live Office 365 in Perplexity MacOS Desktop

  Connect to and query live Office 365 in Perplexity Desktop using CData Code Assist MCP.

• How to Connect to Live Instagram in Mistral AI Workflows

  Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Instagram without replication.

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

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

• Integrate with Sybase IQ using Apache Camel2

  Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Sybase IQ to a JSON file on disk.

• Use CData Connect AI to Access ADP in Microsoft Power Pivot

  Use CData Connect AI to connect to live ADP in the Power Pivot business intelligence tool.

• Create Act-On-Connected Nintex Workflows

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

• Replicate Salesforce Data to SAP Datasphere with CData Sync

  Use CData Sync to replicate Salesforce data into SAP Datasphere via SAP HANA.

• Connect to Reckon Accounts Hosted from a Connection Pool in JBoss

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

• How to Create Power BI Visual Reports with Real-Time Acumatica

  Use CData Power BI Connectors to visualize Acumatica ERP in Power BI.

• Build Apps with Live MariaDB in Adalo using CData Connect AI

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

• Validate Azure Data Catalog with QuerySurge

  Access and validate Azure Data Catalog in QuerySurge using the CData JDBC Driver.

• How to import Cloudant into Apache Solr

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

• Use JayDeBeApi to access SuiteCRM in Python

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

• Create Snowflake Reports on JasperReports Server

  Deploy the CData JDBC Driver on JasperReports Server to provide real-time Snowflake data access from reports, embedded analytics, and more.

• Automated Continuous MongoDB Replication to Databricks

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

• Integrate Sage 200 in Pentaho Data Integration

  Build ETL pipelines based on Sage 200 in the Pentaho Data Integration tool.

• Visualize Couchbase in Sisense

  Create an ElastiCube in Sisense app with access to Couchbase.

• How to Access Salesforce Using Entity Framework

  This article shows how to access Salesforce & Force.com using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

• How to create Sage 300 federated tables in MySQL

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

• Analyze Live MongoDB in SAS Viya

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

• How to Query Microsoft Project in MySQL Workbench

  Execute MySQL queries against live Microsoft Project from MySQL Workbench.

• Integrate Cursor with Live BigCommerce Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live BigCommerce from within the editor.

• Analyze GitHub in SAP Analytics Cloud

  Use CData Connect AI to create an OData API on top of GitHub and visualize GitHub in SAP Analytics Cloud.

• Integrate Bing Ads in the Pentaho Report Designer

  Publish reports based on Bing Ads in the Pentaho BI tool.

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

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

• Connect to Exact Online in Google Apps Script via SQL Gateway

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

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

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

• Access Databricks as a Remote Oracle Database

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

• Create Microsoft Exchange-Connected Enterprise Applications in OutSystems

  Use CData Connect AI to connect to Microsoft Exchange from OutSystems and build custom enterprise apps using live Microsoft Exchange.

• Integrate Azure Data Lake Storage with JetBrains RubyMine using CData JDBC Drivers

  Learn how to integrate Azure Data Lake Storage with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Azure Data Lake Storage.

• Connect to LinkedIn Ads in HULFT Integrate

  Connect to LinkedIn Ads as a JDBC data source in HULFT Integrate

• Connect to Google Data Catalog in SpagoBI

  Create reports featuring live Google Data Catalog in SpagoBI Studio. Host Google Data Catalog reports on SpagoBI Server.

• How to Work with PostgreSQL in AWS Glue Jobs Using JDBC

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

• Analyze Avalara AvaTax in Infragistics Reveal

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

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

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

• Automated Continuous Printify Replication to Apache Kafka

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

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

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

• Connect to Marketo in Aqua Data Studio

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

• Integrate Google Spanner into Power Automate Desktop using CData Connect

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

• Create Google Ads-Connected Business Apps in AppSheet

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

• Automate Teradata Replication to SAP HANA

  Use CData Sync to customize and automate Teradata replication to SAP HANA.

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

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

• Create Avalara AvaTax-Connected Enterprise Applications in OutSystems

  Use CData Connect AI to connect to Avalara AvaTax from OutSystems and build custom enterprise apps using live Avalara AvaTax.

• Integrating Boomi Agentstudio with Google Campaign Manager 360 via CData Connect AI

  Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Google Campaign Manager 360, enabling AI agents to act on live enterprise data within your integration and automation workflows.

• Load MariaDB to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load MariaDB to a database.

• Access AlloyDB as a Remote Oracle Database

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

• Build Greenhouse-Connected Web Apps in Servoy

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

• Visualize Freshdesk in TIBCO Spotfire through ADO.NET

  Integrate Freshdesk into dashboards in TIBCO Spotfire.

• Consume Klipfolio OData Feeds in SAP Lumira

  Use the API Server to create data visualizations on Klipfolio feeds that reflect any changes in SAP Lumira.

• How to connect and process Apache Parquet from Azure Databricks

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

• Create Reckon-Connected Nintex Workflows

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

• Replicate Google Ad Manager from PowerShell

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

• Visualize Presto in Tableau

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

• Use the CData ODBC Driver for Wave Financial in Microsoft Power Query

  You can use the CData Wave Financial ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Wave Financial into Microsoft Power Query.

• Use CData Connect AI to Access Sage Intacct in Microsoft Power Pivot

  Use CData Connect AI to connect to live Sage Intacct in the Power Pivot business intelligence tool.

• Build Data Flows from Oracle Financials Cloud to SQL Server using SSIS

  Easily back up Oracle Financials Cloud to SQL Server using the SSIS components for Oracle Financials Cloud.

• Working with HDFS in LINQPad

  Execute LINQ queries to Apache HDFS in LINQPad.

• Add Odoo to Informatica Enterprise Data Catalog

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

• DataBind Charts to Zoho Projects

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

• Excel Spreadsheet Automation on Phoenix with the QUERY Formula

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

• How to Connect Flowise AI Agents to Live Dynamics 365 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.

• Prepare, Blend, and Analyze Google Campaign Manager 360 in Alteryx Designer (ODBC)

  Build workflows to access live Google Campaign Manager 360 for self-service data analytics.

• How to integrate Redshift with Apache Airflow

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

• Automated Continuous PostgreSQL Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable PostgreSQL replication to Microsoft Access.

• Build MVC Applications with Connectivity to eBay

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

• Analyze Cosmos DB with Power Pivot

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

• Automate Microsoft Project Replication to Azure Data Lake

  Use CData Sync to customize and automate Microsoft Project replication to Azure Data Lake.

• Connect to Kafka in the Denodo Platform

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

• How to create WooCommerce federated tables in MySQL

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

• Import and Visualize QuickBooks Time in Power View

  Create data visualizations based on QuickBooks Time in Excel.

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

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

• Create Salesforce Pardot-Connected Enterprise Applications in OutSystems

  Use CData Connect AI to connect to Salesforce Pardot from OutSystems and build custom enterprise apps using live Salesforce Pardot.

• Create Dashboards and Visualize Live PayPal in Geckoboard

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

• Integrate Live Sage 200 into Blue Prism for Intelligent Robotic Process Automation (RPA)

• «
• 823
• 824
• 825
• 826
• 827
• 828
• 829
• 830
• 831
• 832
• »