CData Software - Knowledge Base
Recent Articles
-
How to Connect to Live Cloudant 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 IBM Cloudant for you.
-
Connect to Zuora in ACL Analytics
Connect to Zuora via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Zuora.
-
How to connect PolyBase to Bitbucket
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Bitbucket.
-
How to Access Marketo Using Entity Framework
This article shows how to access Marketo using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build Data Flows from Google Cloud Storage to SQL Server using SSIS
Easily back up Google Cloud Storage to SQL Server using the SSIS components for Google Cloud Storage.
-
How to work with Azure Synapse in Apache Spark using SQL
Access and process Azure Synapse in Apache Spark using the CData Software JDBC Driver.
-
Build GitHub-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live GitHub.
-
ETL Snowflake in Oracle Data Integrator
This article shows how to transfer Snowflake into a data warehouse using Oracle Data Integrator.
-
Build Apps with Live Sage Business Cloud Accounting in Adalo using CData Connect AI
Use CData Connect AI to integrate live Sage Business Cloud Accounting into the Adalo platform and build custom mobile and web applications with real-time Sage Business Cloud Accounting.
-
Connect to Workday as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Workday.
-
How to Query Live Sybase Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Sybase data in natural language using Python.
-
How to connect SharePoint with Zoho Projects through external lists
Provide Zoho Projects to SharePoint users as an external list.
-
Connect to and Visualize Live Phoenix in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Apache Phoenix.
-
Visualize Zoom from Tableau
Use the Tableau Desktop business intelligence tool to connect to Zoom.
-
Automated Continuous Office 365 Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Office 365 replication to Amazon Redshift.
-
Connect to MarkLogic in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to SingleStore in RazorSQL
Connect to SingleStore from wizards and query SingleStore from the GUI in the RazorSQL database management tool.
-
How to import SharePoint Excel Services into Apache Solr
Use the CData Software JDBC Driver for SharePoint Excel Services in Data Import Handler and create an automated import of SharePoint Excel Services to Apache Solr Enterprise Search platform.
-
Build Data Flows from QuickBooks Online to SQL Server using SSIS
Easily back up QuickBooks Online to SQL Server using the SSIS components for QuickBooks Online.
-
How to connect to Snowflake with Squirrel SQL client
Connect to Snowflake and execute queries in the Squirrel SQL Client.
-
Visualize Live IBM Informix in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live IBM Informix.
-
Automated Continuous HDFS Replication to AlloyDB
Use CData Sync for automated, continuous, customizable HDFS replication to AlloyDB.
-
Working with Box in LINQPad
Execute LINQ queries to Box in LINQPad.
-
Viewing Salesforce in RAD Studio Data Explorer
How to view Salesforce & Force.com in RAD Studio Data Explorer using the CData ODBC Driver for Salesforce.
-
How to Connect to Live Twitter 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 Twitter through natural language.
-
Use the CData Software JDBC Driver for SAP ByDesign in MicroStrategy Web
Connect to SAP Business ByDesign in MicroStrategy Web using the CData Software JDBC Driver for SAP ByDesign.
-
Creating SendGrid-Connected Applications in Unqork
You can use CData Connect AI to feed SendGrid to Unqork and build custom business apps.
-
Access Live Google Calendar in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Google Calendar from your Excel spreadsheets.
-
Connecting Moonlit Workflow with Smartsheet 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 Smartsheet in real time.
-
Manage Salesforce in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Salesforce.
-
How to Create Power BI Visual Reports with Real-Time SAP Fieldglass
Use CData Power BI Connectors to visualize SAP Fieldglass in Power BI.
-
Work with YouTube Analytics in FoxPro
Load YouTube Analytics into a FoxPro database. This article includes full code and a walk-through of the process.
-
Analyze Azure Data Lake Storage with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Azure Data Lake Storage from Power Pivot. You will use the Table Import Wizard to load Azure Data Lake Storage. You can visually build the import query or use any SQL supported by the driver.
-
How to connect to OneNote with Squirrel SQL client
Connect to Microsoft OneNote and execute queries in the Squirrel SQL Client.
-
Building Dynamic Web Pages with MySQL Using AngularJS
Create single-page applications with live connectivity to MySQL using the CData API Server.
-
Connect to Snapchat Ads in the Denodo Platform
Use CData driver technologies to create a virtual data source for Snapchat Ads in the Denodo Virtual DataPort Administrator.
-
Replicate Multiple eBay Accounts
Replicate multiple eBay accounts to one or many databases.
-
View Reports on Real-Time Confluence in Power BI Report Server
Use the CData ODBC Driver for Confluence to visualize Atlassian Confluence in Power BI Desktop and then publish them to Power BI Report Server.
-
Build Dashboards with JSON Services in Dundas BI
Create dynamic dashboards and perform analytics based on JSON in Dundas BI.
-
Access Live SharePoint in AWS Lambda (with IntelliJ IDEA)
Connect to live Microsoft SharePoint in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Paylocity in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Access Live Access in AWS Lambda (with IntelliJ IDEA)
Connect to live Microsoft Access in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated Continuous Office 365 Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Office 365 replication to Azure SQL Database.
-
Automate Clio Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Clio and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Bridge Avro Connectivity with Apache NiFi
Access and process Apache Avro in Apache NiFi using the CData JDBC Driver.
-
Create Microsoft Planner-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Microsoft Planner from Klipfolio and build custom visualizations using live Microsoft Planner.
-
Build Microsoft Dataverse-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Microsoft Dataverse (CDS) and build Microsoft Dataverse-connected web apps with Axios.
-
Visualize Okta in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Okta into TIBCO Spotfire.
-
Connect to Zoho Inventory in RazorSQL
Connect to Zoho Inventory from wizards and query Zoho Inventory from the GUI in the RazorSQL database management tool.
-
Connect to ADP from Asprova with CData Software ODBC Driver for ADP
This article shows how to connect faster to ADP data from Asprova.
-
Connect to ServiceNow in RapidMiner
Integrate ServiceNow with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate Xero into Power Automate Desktop using CData Connect
CData Connect for Xero enables you to integrate Xero Accounting into workflows built using Microsoft Power Automate Desktop.
-
Connect to ServiceNow as an External Source in Dremio
Use the CData JDBC Driver to connect to ServiceNow as an External Source in Dremio.
-
Create Cloudant-Connected Business Apps in AppSheet
Connect to Cloudant via CData Connect AI in Google AppSheet and create custom business applications with real-time access to IBM Cloudant.
-
Connect to Greenhouse from Asprova with CData Software ODBC Driver for Greenhouse
This article shows how to connect faster to Greenhouse data from Asprova.
-
Object-Relational Mapping (ORM) with SAP Fieldglass Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to SAP Fieldglass into a Java-based ORM framework, Hibernate.
-
Automated Continuous Cosmos DB Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Cosmos DB replication to Amazon S3.
-
How to Connect to Live Zoho Books Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Zoho Books securely in real time.
-
Connect to Tally in NetBeans
Connect to Tally ERP in NetBeans with the data source configuration wizard.
-
Build Visualizations of Trello in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Trello in Birst.
-
Build Semantic Layer Views for Azure Analysis Services in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Azure Analysis Services.
-
Analyze Dropbox in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Dropbox in Microsoft R Open.
-
Connect to Live Facebook Ads in PostGresSQL Interface through CData Connect AI
Create a live connection to Facebook Ads in CData Connect AI and connect to your Facebook Ads from PostgreSQL.
-
How to Connect DBeaver to Typeform via a JDBC Driver
Manage Typeform with visual tools in DBeaver like the query browser.
-
How to import MongoDB into Apache Solr
Use the CData Software JDBC Driver for MongoDB in Data Import Handler and create an automated import of MongoDB to Apache Solr Enterprise Search platform.
-
How to Design Couchbase Power Apps with Database-Like Connectivity
This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.
-
Operational Reporting on ShipStation from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote ShipStation.
-
How to Query Live Adobe Target in Claude Desktop
Connect to and query live Adobe Target in Claude Desktop using the CData MCP Server.
-
Access Live Sage 50 UK in AWS Lambda
Connect to live Sage 50 UK in AWS Lambda using the CData JDBC Driver.
-
Connect to Harvest from a Connection Pool in JBoss
Integrate Harvest into Java servlets: Use the Management Console in JBoss to install the Harvest JDBC Driver.
-
Connect to Salesforce in Claris FileMaker Pro
-