CData Software - Knowledge Base
Recent Articles
-
Access Live WordPress in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate WordPress into the statistical analysis tools available in SAS JMP. This article shows how to use WordPress in the Graph Builder and Query Builder.
-
Prepare, Blend, and Analyze Asana in Alteryx Designer (ODBC)
Build workflows to access live Asana for self-service data analytics.
-
How to create Zoho Inventory federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Zoho Inventory in MySQL .
-
Bind Live Calendly Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Calendly data
-
Access Live HubDB in AWS Lambda (with IntelliJ IDEA)
Connect to live HubDB in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Create Power BI Reports on Real-Time Twitter Ads
Use the CData ODBC Driver for Twitter Ads to visualize Twitter Ads in Power BI Desktop.
-
Connect to HBase from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Apache HBase using standard SQL.
-
How to update Amazon DynamoDB from Excel
This article explains how to transfer data from Excel to Amazon DynamoDB using the Excel Add-In for Amazon DynamoDB.
-
Access Live Dynamics 365 Business Central in AWS Lambda
Connect to live Dynamics 365 Business Central in AWS Lambda using the CData JDBC Driver.
-
Getting Started with the CData SSIS Components for Asana
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Asana.
-
Bridge PayPal Connectivity with Apache NiFi
Access and process PayPal in Apache NiFi using the CData JDBC Driver.
-
A PostgreSQL Interface for SurveyMonkey using the CData ODBC Driver
Use the SQL Gateway and SurveyMonkey ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to create Wave Financial federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Wave Financial in MySQL .
-
Connect to CouchDB from a Connection Pool in Jetty
The CouchDB JDBC Driver supports connection pooling: This article shows how to connect faster to Apache CouchDB from Web apps in Jetty.
-
Access Live Act CRM in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Act CRM into the statistical analysis tools available in SAS JMP. This article shows how to use Act CRM in the Graph Builder and Query Builder.
-
Connecting Moonlit Workflow with Couchbase 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 Couchbase in real time.
-
Use the CData Software ODBC Driver for Highrise in SAS for Real-Time Reporting and Analytics
Connect to real-time Highrise CRM in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Highrise.
-
Automated Continuous Google Directory Replication to SQL Server
Use CData Sync for automated, continuous, customizable Google Directory replication to SQL Server.
-
How to use SQLAlchemy ORM to access Oracle Financials Cloud in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Oracle Financials Cloud.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Azure Table
Provide connectivity to Azure Table Storage through an SAP BusinessObjects universe.
-
Integrate SharePoint Excel Services with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SharePoint Excel Services with External Services.
-
Edit and Search External Jira Service Management Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Atlassian Jira Service Management to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Jira Service Management objects that you can access from apps and the dashboard.
-
Deploy the ADO.NET Provider for Zoho Books on an SSRS Report Server
Connect to Zoho Books from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Access Live Sugar CRM in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Sugar CRM from your Excel spreadsheets.
-
Access Live Active Directory Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Active Directory data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
How to Connect to Live DocuSign 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 DocuSign without replication.
-
How to pipe Teradata to CSV in PowerShell
Use standard PowerShell cmdlets to access Teradata tables.
-
Connect to Pinterest from Asprova with CData Software ODBC Driver for Pinterest
This article shows how to connect faster to Pinterest data from Asprova.
-
Import and Visualize Tableau CRM Analytics in Power View
Create data visualizations based on Tableau CRM Analytics in Excel.
-
Analyze Oracle Financials Cloud in Looker
Use CData Connect AI to connect to Oracle Financials Cloud from Looker and build custom apps using live Oracle Financials Cloud.
-
Bind Live ClickUp Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live ClickUp data
-
Getting Started with the CData SSIS Components for SAP HANA
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SAP HANA.
-
Perform Batch Operations with Microsoft Project in Apache NiFi
Connect to Microsoft Project and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
How to connect to IBM Informix from IntelliJ
Integrate connectivity to IBM Informix with wizards in IntelliJ.
-
Create Active Directory-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Active Directory from OutSystems and build custom enterprise apps using live Active Directory.
-
Connect to NetSuite in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for NetSuite and connect to NetSuite CRM & ERP in Akorbi Digital RunMyProcess.
-
Manage BigQuery in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for BigQuery.
-
Extract, Transform, and Load Teradata in Informatica PowerCenter
Create a simple Workflow for Teradata in Informatica PowerCenter.
-
How to Query LinkedIn in MySQL Workbench
Execute MySQL queries against live LinkedIn from MySQL Workbench.
-
How to create an RPA flow for Zoho Projects in UiPath Studio
Use the Zoho Projects ODBC Driver to create workflows that access real-time Zoho Projects without any coding.
-
Connect to Live Adobe Analytics in PostGresSQL Interface through CData Connect AI
Create a live connection to Adobe Analytics in CData Connect AI and connect to your Adobe Analytics from PostgreSQL.
-
How to connect to Harvest in DBVisualizer
Integrate Harvest with visual data analysis tools and data connection wizards in DBVisualizer
-
How to Connect to Live OneNote from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Microsoft OneNote for you.
-
Use the CData API Server to Access Sybase IQ in Microsoft PowerPivot
Use the CData API Server to connect to live Sybase IQ in the Power Pivot business intelligence tool.
-
Create Datasets from Phoenix in Domo Workbench and Build Visualizations of Phoenix in Domo
Use the CData Software ODBC Driver for Phoenix to create datasets from Apache Phoenix in Domo Workbench and then build visualizations in the Domo service.
-
Connecting Agentforce with API via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your API for you.
-
Consume Calendly OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Calendly feeds that reflect any changes in SAP Lumira.
-
ETL Salesforce Pardot in Oracle Data Integrator
This article shows how to transfer Salesforce Pardot into a data warehouse using Oracle Data Integrator.
-
How to Connect DBeaver to Cassandra via a JDBC Driver
Manage Apache Cassandra with visual tools in DBeaver like the query browser.
-
Build Apps with Live Amazon Redshift in Adalo using CData Connect AI
Use CData Connect AI to integrate live Amazon Redshift into the Adalo platform and build custom mobile and web applications with real-time Amazon Redshift.
-
DataBind Charts to Excel Online
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Microsoft Excel Online from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Automated Continuous Reckon Accounts Hosted Replication to SQL Server
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to SQL Server.
-
Extract, Transform, and Load SuiteCRM in Informatica PowerCenter
Create a simple Workflow for SuiteCRM in Informatica PowerCenter.
-
How to Connect Flowise AI Agents to Live Databricks 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.
-
Query ADP in ColdFusion
Write standard ColdFusion data access code to connect to ADP.
-
Create Cosmos DB-Connected Applications in Appsmith
Connect to Cosmos DB via CData Connect AI in Appsmith and create custom business applications with real-time access to Azure Cosmos DB.
-
Automated Continuous Power BI XMLA Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Power BI XMLA replication to Google BigQuery.
-
Automate Zendesk Replication to Azure Data Lake
Use CData Sync to customize and automate Zendesk replication to Azure Data Lake.
-
Load ADP to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load ADP to a database.
-
Work with Live GraphQL in Power Query
Use CData Connect AI to connect to GraphQL and work with live GraphQL in Microsoft Power Query.
-
How to Connect to Live SAP Concur from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your SAP Concur for you.
-
Connect to Jira in Ruby
Connect to Atlassian Jira in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automate HubSpot Replication to Azure Data Lake
Use CData Sync to customize and automate HubSpot replication to Azure Data Lake.
-
Migrating data from Paylocity to Snowflake using CData SSIS Components.
Easily push Paylocity to Snowflake using the CData SSIS Tasks for Paylocity and Snowflake.
-
Analyze Exact Online in Looker
Use CData Connect AI to connect to Exact Online from Looker and build custom apps using live Exact Online.
-
Microsoft Dataverse Reporting in OBIEE with the Microsoft Dataverse JDBC Driver
Deploy the Microsoft Dataverse JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Migrating data from Lakebase to Snowflake using CData SSIS Components.
Easily push Lakebase to Snowflake using the CData SSIS Tasks for Lakebase and Snowflake.
-
Integrate Live AlloyDB into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to AlloyDB from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Google AlloyDB.
-
Create SSAS Tabular Models from Box
How to build a SQL Server Analysis Service Tabular Model from Box using CData drivers.
-
Access Live Trello Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Trello data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
How to Connect to Live ServiceNow 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 ServiceNow without replication.
-
Create SSAS Tabular Models from SAP HANA XS Advanced
How to build a SQL Server Analysis Service Tabular Model from SAP HANA XS Advanced using CData drivers.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Klaviyo
Provide connectivity to Klaviyo through an SAP BusinessObjects universe.
-
Viewing Microsoft Teams in RAD Studio Data Explorer
How to view Microsoft Teams in RAD Studio Data Explorer using the CData ODBC Driver for Microsoft Teams.
-
Use Azure AI Foundry to Talk to Your Couchbase 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 Couchbase for you.
-
Visualize Google Drive in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Google Drive into TIBCO Spotfire.
-
Query Workday through ODBC in Node.js
Use node-odbc to execute SQL queries against Workday from Node.js.
-
Connect to ClickUp in HULFT Integrate
Connect to ClickUp as a JDBC data source in HULFT Integrate
-
Build Pipelines with Live MYOB AccountRight in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to MYOB AccountRight from Google Cloud Data Fusion, enabling the integration of live MYOB AccountRight into the building and management of effective data pipelines.
-
Connect to Cloudant in DBArtisan
Use wizards in DBArtisan to configure IBM Cloudant as a data source.
-
Access Live Twitter in TIBCO Data Virtualization
-