CData Software - Knowledge Base
Recent Articles
-
Access SQL Server from MySQL in PHP
Connect to SQL Server through the standard MySQL libraries in PHP.
-
Create Zoho Creator-Connected Nintex Workflows
Use CData Connect AI to connect to Zoho Creator from Nintex Workflow Cloud and build custom workflows using live Zoho Creator.
-
Use the CData Software ODBC Driver for FTP in SAS for Real-Time Reporting and Analytics
Connect to real-time FTP Servers in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for FTP.
-
Analyze Redis in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Redis in Microsoft R Open.
-
Access Live Spark Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Spark data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Getting Started with the CData Python Connector for Email
Learn to install and license the CData Python Connector
-
Natively Connect to Google Analytics in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Google Analytics. Leverage the native support for ODBC in PHP.
-
Seamlessly Bring Azure Data Lake Storage into Retool Using CData Connect AI
Integrate Azure Data Lake Storage data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to Connect DBeaver to LinkedIn via a JDBC Driver
Manage LinkedIn with visual tools in DBeaver like the query browser.
-
Visualize ClickUp in Sisense
Create an ElastiCube in Sisense app with access to ClickUp.
-
How to Design Sugar CRM Power Apps with Database-Like Connectivity
This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.
-
Access Zuora as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Zuora from your Oracle system.
-
Automated Continuous SAP ByDesign Replication to SQL Server
Use CData Sync for automated, continuous, customizable SAP ByDesign replication to SQL Server.
-
Automated Continuous Asana Replication to Snowflake
Use CData Sync for automated, continuous, customizable Asana replication to Snowflake.
-
Getting Started with the CData ODBC Driver for Twilio
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Twilio.
-
Use Microsoft Copilot Studio to talk to your SQL Server 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 Microsoft SQL Server for you.
-
How to Connect the Power BI Service to CSV: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Easily Integrate Adobe Target in Lazarus Pascal IDE
Learn how to easily integrate live Adobe Target in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect Microsoft Planner to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Microsoft Planner using the CData Python MCP Server.
-
Automated Continuous Azure Synapse Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Azure Synapse replication to Azure SQL Database.
-
How to Connect to Live SendGrid 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 SendGrid for you.
-
Replicate Multiple Amazon Marketplace Accounts via the CData Sync CLI
Replicate multiple Amazon Marketplace accounts to one or many databases.
-
Choosing the Best Method to Connect MailChimp to SQL Server: 5 Options Explained
Discover multiple ways to connect and use MailChimp from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Create Reports from FHIR in Looker Studio
Use CData Connect AI to gain access to live FHIR and create custom reports in Looker Studio.
-
How to work with Azure Data Catalog in Apache Spark using SQL
Access and process Azure Data Catalog in Apache Spark using the CData Software JDBC Driver.
-
Connect to Power BI XMLA from AWS Glue
Use CData Connect AI to gain access to live Power BI XMLA from your AWS Glue jobs.
-
How to connect to Airtable from Spring Boot
Connect to Airtable in a Spring Boot Application using CData JDBC Airtable Driver
-
Query MariaDB through ODBC in Node.js
Use node-odbc to execute SQL queries against MariaDB from Node.js.
-
Back Up Oracle Eloqua Reporting to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Oracle Eloqua Reporting. In this article, we will employ an SSIS workflow to populate a database with Oracle Eloqua Reporting data.
-
LINQ to Drift
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 Drift Data Provider.
-
Integrate Freshdesk in Pentaho Data Integration
Build ETL pipelines based on Freshdesk in the Pentaho Data Integration tool.
-
Integrating Gumloop with Stripe via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Stripe within automated workflows.
-
Connect to DB2 in DBArtisan
Use wizards in DBArtisan to configure IBM DB2 as a data source.
-
How to connect SharePoint with ClickUp through external lists
Provide ClickUp to SharePoint users as an external list.
-
LINQ to SAP HANA
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 SAP HANA Data Provider.
-
Build Data Flows from Salesloft to SQL Server using SSIS
Easily back up Salesloft to SQL Server using the SSIS components for Salesloft.
-
Integrate with HDFS in JReport Designer
Create charts and reports based on Apache HDFS in JReport Designer.
-
Migrating data from Certinia to Snowflake using CData SSIS Components.
Easily push Certinia to Snowflake using the CData SSIS Tasks for Certinia and Snowflake.
-
Replicate Twilio to Multiple Databases via the CData Sync CLI
Replicate Twilio to disparate databases with a single configuration.
-
How to Connect to Live Oracle 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 Oracle Database through natural language.
-
Use the CData Software JDBC Driver for Google Contacts in MicroStrategy
Connect to Google Contacts in MicroStrategy Developer using the CData Software JDBC Driver for Google Contacts.
-
How to create an RPA flow for SharePoint in UiPath Studio
Use the SharePoint ODBC Driver to create workflows that access real-time Microsoft SharePoint without any coding.
-
Automate Phoenix Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Apache Phoenix from PowerShell? This article demonstrates how to utilize the Phoenix Cmdlets for tasks like connecting to Apache Phoenix, automating operations, downloading data, and more.
-
Integrate WordPress with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate WordPress with External Services.
-
Model, Search, and Visualize Live Zoho CRM in ThoughtSpot
Use CData Connect AI to connect to live Zoho CRM for modeling, searching, and visualizing.
-
Integrate Real-Time Access to XML in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to XML Files in real time.
-
Query, Visualize, and Share live Salesforce in Redash
Use CData Connect AI to connect to live Salesforce & Force.com in Redash for querying, visualizing, and sharing.
-
How to use SQLAlchemy ORM to access Square in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Square.
-
Excel Spreadsheet Automation on Phoenix with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Connect Zoho Projects to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Zoho Projects using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrate with Live Shopify in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Shopify from the MuleSoft Anypoint Platform to integrate live Shopify into custom reports and dashboards.
-
Analyze Cassandra in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Apache Cassandra and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to Outreach.io in RazorSQL
Connect to Outreach.io from wizards and query Outreach.io from the GUI in the RazorSQL database management tool.
-
Publish Facebook Ads-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Facebook Ads.
-
How to integrate AlloyDB with Apache Airflow
Access and process Google AlloyDB in Apache Airflow using the CData JDBC Driver.
-
Integrating Outreach.io in Talend Cloud Data Management Platform
-