CData Software - Knowledge Base
Recent Articles
-
How to create an RPA flow for CockroachDB in UiPath Studio
Use the CockroachDB ODBC Driver to create workflows that access real-time CockroachDB without any coding.
-
Connect to Google Sheets in NetBeans
Connect to Google Sheets in NetBeans with the data source configuration wizard.
-
Connect Sage 200 to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Sage 200 using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Prepare, Blend, and Analyze GitHub in Alteryx Designer (Connect AI)
Build workflows to access live GitHub for self-service data analytics.
-
How to integrate Microsoft Dataverse with Apache Airflow
Access and process Microsoft Dataverse (CDS) in Apache Airflow using the CData JDBC Driver.
-
How to load Oracle Service Cloud data into Elasticsearch via Logstash
Introducing a simple method to load Oracle Service Cloud data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create Lakebase Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Lakebase data access from reports, embedded analytics, and more.
-
Automated Continuous Tableau CRM Analytics Replication to Snowflake
Use CData Sync for automated, continuous, customizable Tableau CRM Analytics replication to Snowflake.
-
Integrating Dataiku with Kintone via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Kintone.
-
How to Query Live PostgreSQL in Perplexity MacOS Desktop
Connect to and query live PostgreSQL in Perplexity Desktop using the CData MCP Server.
-
How to connect to ServiceNow with Squirrel SQL client
Connect to ServiceNow and execute queries in the Squirrel SQL Client.
-
How to Seamlessly Import AlloyDB Data into IBM SPSS Modeler
Integrate AlloyDB data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Publish Kafka-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Apache Kafka.
-
Integrating Boomi Agentstudio with SAP BusinessObjects BI via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to SAP BusinessObjects BI, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Bidirectional Access to Klaviyo from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Klaviyo in Filemaker Pro for Mac or Windows.
-
Excel Spreadsheet Automation on Salesforce Data Cloud with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Consume Twitter OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Twitter feeds that reflect any changes in SAP Lumira.
-
Edit and Search Zoho Projects External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Zoho Projects to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Zoho Projects objects that you can access from apps and the dashboard.
-
How to connect SharePoint with Azure Data Catalog through external lists
Provide Azure Data Catalog to SharePoint users as an external list.
-
Automated Continuous Workday Replication to SQL Server
Use CData Sync for automated, continuous, customizable Workday replication to SQL Server.
-
PayPal Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to PayPal through CData Connect AI using different applications and tools.
-
Analyze SAP HANA in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of SAP HANA and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
-
Migrating data from Pipedrive to Google BigQuery using CData SSIS Components.
Easily push Pipedrive to Google BigQuery using the CData SSIS Tasks for Pipedrive and Google BigQuery.
-
How to integrate Klaviyo with Apache Airflow
Access and process Klaviyo in Apache Airflow using the CData JDBC Driver.
-
Query SAP Ariba Source in DataGrip
Create a Data Source for SAP Ariba Source in DataGrip and use SQL to query live SAP Ariba Source.
-
Connect to and Query Salesforce Marketing in QlikView over ODBC
Create data visualizations with Salesforce Marketing Cloud in QlikView.
-
Connecting GenSpark with Adobe Commerce 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.
-
Use the CData ODBC Driver for SAS xpt from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SAS xpt to connect to SAS XPORT from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SAS XPORT in Excel.
-
Natively Connect to Snowflake in PHP
The CData ODBC driver for Snowflake enables you to create PHP applications with connectivity to Snowflake. Leverage the native support for ODBC in PHP.
-
Model Airtable Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Airtable, enabling the direct import of real-time Airtable.
-
Create SingleStore Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous Tally Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Tally replication to Amazon Redshift.
-
Build Charts with Elasticsearch in Clear Analytics
Create dynamic charts and perform analytics based on Elasticsearch in Clear Analytics.
-
Connecting Moonlit Workflow with HCL Domino via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your HCL Domino in real time.
-
Analyze SAP BusinessObjects BI in Cognos Analytics
Use CData Connect AI to connect to SAP BusinessObjects BI from Cognos Analytics and analyze live SAP BusinessObjects BI.
-
Use ChatGPT to Talk to Your Smartsheet via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Smartsheet for you.
-
Integrating Gumloop with Google Ads via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Google Ads within automated workflows.
-
Connecting Moonlit Workflow with Snapchat Ads via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Snapchat Ads in real time.
-
How to connect SharePoint with Email through external lists
Provide Email to SharePoint users as an external list.
-
Integrating Adobe Analytics in Talend Cloud Data Management Platform
-