CData Software - Knowledge Base
Recent Articles
-
Connecting Moonlit Workflow with Splunk 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 Splunk in real time.
-
Process & Analyze Access in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Access .
-
Use the CData SSIS Components to Insert New or Update Existing Teradata Records from SQL Server
Easily push SQL Server data to Teradata using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Teradata or update existing records with data from a SQL Server database.
-
Automated Continuous Airtable Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Airtable replication to Amazon S3.
-
Analyze Twilio in Cognos Analytics
Use CData Connect AI to connect to Twilio from Cognos Analytics and analyze live Twilio.
-
Automated Continuous DB2 Replication to MongoDB
Use CData Sync for automated, continuous, customizable DB2 replication to MongoDB.
-
Use the CData Software JDBC Driver for Bitbucket in MicroStrategy
Connect to Bitbucket in MicroStrategy Developer using the CData Software JDBC Driver for Bitbucket.
-
Seamlessly Bring PostgreSQL into Retool Using CData Connect AI
Integrate PostgreSQL data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Build Data Flows from Epicor Kinetic to SQL Server using SSIS
Easily back up Epicor Kinetic to SQL Server using the SSIS components for Epicor Kinetic.
-
How to Query Live Google Analytics in Perplexity MacOS Desktop
Connect to and query live Google Analytics in Perplexity Desktop using CData Code Assist MCP.
-
Integrate Neo4J in Pentaho Data Integration
Build ETL pipelines based on Neo4J in the Pentaho Data Integration tool.
-
How to Design Access Power Apps with Database-Like Connectivity
This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.
-
Use Azure AI Foundry to Talk to Your Cloudant via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your IBM Cloudant for you.
-
LINQ to Oracle Sales
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 Oracle Sales Data Provider.
-
Connect to Amazon DynamoDB in HULFT Integrate
Connect to Amazon DynamoDB as a JDBC data source in HULFT Integrate
-
Automated Continuous SharePoint Excel Services Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to Azure SQL Database.
-
Bind Live Exact Online Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Exact Online data
-
Create SSAS Tabular Models from Google Analytics
How to build a SQL Server Analysis Service Tabular Model from Google Analytics using CData drivers.
-
Connect to Greenplum as an External Source in Dremio
Use the CData JDBC Driver to connect to Greenplum as an External Source in Dremio.
-
How to Connect to Live Microsoft Project 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 Microsoft Project without replication.
-
Migrating data from Spark to Databricks using CData SSIS Components.
Easily push Apache Spark SQL to Databricks using the CData SSIS Tasks for Spark and Databricks.
-
Connecting Pipedream with Salesforce via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Salesforce data in real time.
-
Analyze Active Directory in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Active Directory and visualize Active Directory in SAP Analytics Cloud.
-
Build a PostgreSQL Interface for Excel using the CData JDBC Driver
Use the Remoting features of the Excel JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automate Slack Replication to Azure Synapse
Use CData Sync to customize and automate Slack replication to Azure Synapse.
-
Automated Continuous Adobe Commerce Replication to SQL Server
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to SQL Server.
-
Connect to Gmail as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Gmail.
-
Connect to MongoDB in DBArtisan
Use wizards in DBArtisan to configure MongoDB as a data source.
-
How to Connect Flowise AI Agents to Live OData Services 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.
-
Create Dynamic Twilio Grids Using the Infragistics XamDataGrid
Learn how you can connect Twilio to Infragistics XamDataGrid to build dynamic grids.
-
How to Visualize AlloyDB Data in Python with pandas
Use pandas and other modules to analyze and visualize live Google AlloyDB in Python.
-
Perform Batch Operations with Sage Intacct in Apache NiFi
Connect to Sage Intacct and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Integrate QuickBooks Time into Power Automate Desktop using CData Connect
CData Connect for QuickBooks Time enables you to integrate QuickBooks Time into workflows built using Microsoft Power Automate Desktop.
-
How to Work with Authorize.Net in AWS Glue Jobs Using JDBC
Connect to Authorize.Net from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Perform Batch Operations with LDAP Objects in Apache NiFi
Connect to LDAP and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Access Greenplum 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 Pivotal GreenPlum.
-
Connect to Google Calendar as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Google Calendar.
-
Create a Data Access Object for Sage 200 using JDBI
A brief overview of creating a SQL Object API for Sage 200 in JDBI.
-
Integrate with Live BigQuery in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to BigQuery from the MuleSoft Anypoint Platform to integrate live Google BigQuery into custom reports and dashboards.
-
ETL Reckon in Oracle Data Integrator
This article shows how to transfer Reckon into a data warehouse using Oracle Data Integrator.
-
Perform Batch Operations with Workday in Apache NiFi
Connect to Workday and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Connect to Odoo in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to Hive from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Apache Hive, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to Build an ETL App for Microsoft Exchange in Python with CData
Create ETL applications and real-time data pipelines for Microsoft Exchange in Python with petl.
-
How to pipe Bullhorn CRM to CSV in PowerShell
Use standard PowerShell cmdlets to access Bullhorn CRM tables.
-
Connect to Oracle in ACL Analytics
Connect to Oracle Database via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Oracle Database.
-
Connect to Box from PowerBuilder via JDBC
This article demonstrates how to access Box from PowerBuilder using the Box JDBC Driver.
-
Connect to Trello in CloverDX (formerly CloverETL)
Transfer Trello using the visual workflow in the CloverDX data integration tool.
-
Stream Zoho Projects into Apache Kafka Topics
Access and stream Zoho Projects in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Replicate Multiple MarkLogic Accounts via the CData Sync CLI
Replicate multiple MarkLogic accounts to one or many databases.
-
Import Real-Time Basecamp via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Basecamp in ColdFusion.
-
Getting Started with the CData ADO.NET Provider for Databricks
-