CData Software - Knowledge Base
Recent Articles
-
Use Microsoft Copilot Studio to talk to your Instagram 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 Instagram for you.
-
Query Drift as a MySQL Database in Node.js
Execute MySQL queries against Drift from Node.js.
-
Integrate with Google Directory in SnapLogic
Use CData Connect AI to connect to and integrate with live Google Directory in SnapLogic.
-
Build an OLAP Cube in SSAS from OneNote
Establish a connection to Microsoft OneNote data from SQL Server Analysis Services, and use the OneNote Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous DocuSign Replication to Databricks
Use CData Sync for automated, continuous, customizable DocuSign replication to Databricks.
-
Build Data Flows from SQL Server to Klaviyo through SSIS
Easily push SQL Server data to Klaviyo using the CData SSIS Tasks for Klaviyo.
-
Connect to Redshift from Asprova with CData Software ODBC Driver for Redshift
This article shows how to connect faster to Redshift data from Asprova.
-
Publish Reports with SAP Hybris C4C in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP Hybris C4C.
-
Connect to Sybase IQ from Asprova with CData Software ODBC Driver for Sybase IQ
This article shows how to connect faster to Sybase IQ data from Asprova.
-
Back Up Authorize.Net to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Authorize.Net. In this article, we will employ an SSIS workflow to populate a database with Authorize.Net data.
-
Connecting Mastra with Avalara AvaTax via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time data across 300+ enterprise sources no replication required.
-
Connect to Snowflake from PowerBuilder via JDBC
This article demonstrates how to access Snowflake from PowerBuilder using the Snowflake JDBC Driver.
-
Connect to Databricks in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Databricks and connect to Databricks in Akorbi Digital RunMyProcess.
-
Access Live Excel Online in AWS Lambda
Connect to live Microsoft Excel Online in AWS Lambda using the CData JDBC Driver.
-
Build Visualizations of Oracle SCM in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Oracle SCM in Birst.
-
Build an OLAP Cube in SSAS from Marketo
Establish a connection to Marketo data from SQL Server Analysis Services, and use the Marketo Data Provider to build OLAP cubes for use in analytics and reporting.
-
Getting Started with the CData Excel Add-In for Dynamics NAV
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Dynamics NAV.
-
Working with CSV in LINQPad
Execute LINQ queries to CSV/TSV Files in LINQPad.
-
Easily Integrate xBase in Lazarus Pascal IDE
Learn how to easily integrate live xBase in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
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.
-
Automated Continuous ClickUp Replication to Amazon S3
Use CData Sync for automated, continuous, customizable ClickUp replication to Amazon S3.
-
Trigger OneNote IFTTT Flows in Azure App Service
This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.
-
Twitter Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Twitter through CData Connect AI using different applications and tools.
-
A PostgreSQL Interface for Typeform (MySQL Remoting via JDBC)
Use the Remoting features of the Typeform JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to CockroachDB from Crystal Reports
Use CData Connect AI to connect to and report on live CockroachDB from Crystal Reports.
-
Build Google Contacts Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Google Contacts and build visualizations in Tableau Cloud.
-
Consume Microsoft Project OData Feeds in PowerBuilder
This article demonstrates how to consume Microsoft Project as OData feeds from PowerBuilder using the API Server.
-
Edit and Search External Jira Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Atlassian Jira to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Jira objects that you can access from apps and the dashboard.
-
Import MongoDB Using Azure Data Factory
Use CData Connect AI to connect to MongoDB from Azure Data Factory and import live MongoDB.
-
How to connect to Access with Squirrel SQL client
Connect to Microsoft Access and execute queries in the Squirrel SQL Client.
-
How to Use a Microsoft Access Database to Update Oracle Sales in Real Time
Update Oracle Sales data by creating a linked table in Microsoft Access with the CData Oracle Sales ODBC Driver.
-
How to work with Asana in Apache Spark using SQL
Access and process Asana in Apache Spark using the CData Software JDBC Driver.
-
Using the CData Software ODBC Driver for ServiceNow in PyCharm
Connect to ServiceNow as an ODBC data source in PyCharm using the CData Software ODBC Driver for ServiceNow.
-
Validate Google Analytics with QuerySurge
Access and validate Google Analytics in QuerySurge using the CData JDBC Driver.
-
How to Work with Cloudant in AWS Glue Jobs Using JDBC
Connect to Cloudant from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate XML in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live XML Files from Informatica Cloud.
-
Automated Continuous Acumatica Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Acumatica replication to Google Cloud SQL.
-
Build Apps with Live Apache Impala in Adalo using CData Connect AI
Use CData Connect AI to integrate live Apache Impala into the Adalo platform and build custom mobile and web applications with real-time Apache Impala.
-
Feed Marketo into FineReport
How to set Marketo as a JDBC data source in FineReport.
-
Automated Continuous Twitter Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Twitter replication to PostgreSQL.
-
Visualize OData Services in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load OData into TIBCO Spotfire.
-
Integrate Live OData Services into Blue Prism for Intelligent Robotic Process Automation (RPA)
-