CData Software - Knowledge Base
Recent Articles
-
Build Data Flows from Smartsheet to SQL Server using SSIS
Easily back up Smartsheet to SQL Server using the SSIS components for Smartsheet.
-
How to Query Live Okta in Perplexity MacOS Desktop
Connect to and query live Okta in Perplexity Desktop using CData Code Assist MCP.
-
How to Query Live Azure Data Lake Storage in Perplexity MacOS Desktop
Connect to and query live Azure Data Lake Storage in Perplexity Desktop using CData Code Assist MCP.
-
Visualize BigCommerce in Sisense
Create an ElastiCube in Sisense app with access to BigCommerce.
-
Connect to Jira Service Management from Crystal Reports
Use CData Connect AI to connect to and report on live Atlassian Jira Service Management from Crystal Reports.
-
Migrating data from Smartsheet to Databricks using CData SSIS Components.
Easily push Smartsheet to Databricks using the CData SSIS Tasks for Smartsheet and Databricks.
-
How to update Microsoft Teams from Excel
This article explains how to transfer data from Excel to Microsoft Teams using the Excel Add-In for Microsoft Teams.
-
How to integrate Metabase with Google Campaign Manager 360
Use CData Connect AI to connect to live Google Campaign Manager 360 and create an interactive dashboard in Metabase from Google Campaign Manager 360.
-
Create Microsoft Exchange Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create SSAS Tabular Models from Snowflake
How to build a SQL Server Analysis Service Tabular Model from Snowflake using CData drivers.
-
Edit and Search Stripe External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Stripe to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Stripe objects that you can access from apps and the dashboard.
-
Use Claude to Talk to Your ServiceNow via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your ServiceNow for you.
-
Prepare, Blend, and Analyze Teradata in Alteryx Designer (ODBC)
Build workflows to access live Teradata for self-service data analytics.
-
Access Live Azure Analysis Services in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Azure Analysis Services through MCP integration.
-
How to load HubDB data into Elasticsearch via Logstash
Introducing a simple method to load HubDB data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Validate SAP Hybris C4C with QuerySurge
Access and validate SAP Hybris C4C in QuerySurge using the CData JDBC Driver.
-
How to Work with Zoho Books in AWS Glue Jobs Using JDBC
Connect to Zoho Books from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build a Simple VCL Application for Act CRM
How to build a simple VCL Application to view Act CRM in RAD Studio using the CData ODBC Driver for Act CRM.
-
Integrate with xBase in JReport Designer
Create charts and reports based on xBase in JReport Designer.
-
Use Azure AI Foundry to Talk to Your Quickbase 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 Quickbase for you.
-
Edit and Search External Cosmos DB Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Azure Cosmos DB to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Cosmos DB objects that you can access from apps and the dashboard.
-
Connect to Bing Ads from a Connection Pool in WebLogic
Use the CData JDBC Driver for Bing Ads to connect to Bing Ads from Web applications running on WebLogic.
-
Connect to Adobe Commerce through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Adobe Commerce using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Use the CData Software ODBC Driver for eBay in MicroStrategy Web
Connect to eBay in MicroStrategy Web using the CData Software ODBC Driver for eBay.
-
Create PayPal Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous QuickBooks Time Replication to SQLite
Use CData Sync for automated, continuous, customizable QuickBooks Time replication to SQLite.
-
Analyze Avalara AvaTax in Infragistics Reveal
Use the CData API Server to create an OData API on top of Avalara AvaTax and visualize live Avalara AvaTax in Infragistics Reveal.
-
DataBind Charts to OData Services
Use the standard ADO.NET procedures for databinding to provide bidirectional access to OData 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.
-
Build AI Agents with Monday.com Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can
-
Connect to OneNote from AWS Glue
Use CData Connect AI to gain access to live Microsoft OneNote from your AWS Glue jobs.
-
Choosing the Best Method to Connect eBay to SQL Server: 5 Options Explained
Discover multiple ways to connect and use eBay from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use the CData Software ODBC Driver for Harvest in MicroStrategy Desktop
Connect to Harvest in MicroStrategy Desktop using the CData Software ODBC Driver for Harvest.
-
Connect Zoho Inventory to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Zoho Inventory using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Work with Live SAP Ariba Procurement in Power Query
Use CData Connect AI to connect to SAP Ariba Procurement and work with live SAP Ariba Procurement in Microsoft Power Query.
-
Create Power BI Reports on Real-Time SAP Ariba Procurement
Use the CData ODBC Driver for SAP Ariba Procurement to visualize SAP Ariba Procurement in Power BI Desktop.
-
Replicate Multiple Blackbaud FE NXT Accounts
Replicate multiple Blackbaud FE NXT accounts to one or many databases.
-
Import and Visualize Procore in Power View
Create data visualizations based on Procore in Excel.
-
Connect to Dynamics 365 in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Microsoft Dynamics 365 in Airbyte.
-
Analyze Okta with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Okta from Power Pivot. You will use the Table Import Wizard to load Okta. You can visually build the import query or use any SQL supported by the driver.
-
Connect to and Visualize Live ClickUp in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live ClickUp.
-
Create SAP Ariba Source-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to SAP Ariba Source from Klipfolio and build custom visualizations using live SAP Ariba Source.
-
Automate Epicor Kinetic Replication to Azure Data Lake
Use CData Sync to customize and automate Epicor Kinetic replication to Azure Data Lake.
-
Integrate Okta with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Okta with External Services.
-
Connect to TigerGraph from a Connection Pool in WebLogic
Use the CData JDBC Driver for TigerGraph to connect to TigerGraph from Web applications running on WebLogic.
-
Connect and Query Live Raisers Edge NXT Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Raisers Edge NXT into Databricks
-
Use ChatGPT to Talk to Your Databricks via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Databricks for you.
-
Add SAS xpt to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SAS xpt with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Connect to Live OData Services from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your OData for you.
-
Configure the CData JDBC Driver for TaxJar in a Connection Pool in Tomcat
Connect to TaxJar from a connection pool in Tomcat.
-
How to connect to Zoho Projects with Squirrel SQL client
Connect to Zoho Projects and execute queries in the Squirrel SQL Client.
-
Automated Continuous eBay Analytics Replication to Databricks
Use CData Sync for automated, continuous, customizable eBay Analytics replication to Databricks.
-
Publish Greenhouse-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Greenhouse.
-
Use the CData Software ODBC Driver for ADP in SAS for Real-Time Reporting and Analytics
Connect to real-time ADP in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ADP.
-
A PostgreSQL Interface for Blackbaud FE NXT using the CData ODBC Driver
Use the SQL Gateway and Blackbaud FE NXT ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Live Workday 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 Workday through natural language.
-
Integrate Live Impala into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Apache Impala and integrate live Apache Impala into apps built in Microsoft Power Apps.
-
How to Connect to Live Azure Analysis Services 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 Azure Analysis Services for you.
-
Automated Continuous XML Replication to SQLite
Use CData Sync for automated, continuous, customizable XML replication to SQLite.
-
Build Pipelines with Live Facebook Ads in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Facebook Ads from Google Cloud Data Fusion, enabling the integration of live Facebook Ads into the building and management of effective data pipelines.
-
Getting Started with the CData Python Connector for Printify
Learn to install and license the CData Python Connector
-
Automated Continuous EnterpriseDB Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to PostgreSQL.
-
Automated Continuous Blackbaud FE NXT Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to PostgreSQL.
-
How to Connect Flowise AI Agents to Live Zoho Creator 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.
-
Connect Dynamics CRM to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Microsoft Dynamics CRM using the CData Python MCP Server.
-
How to Connect to Live Google Calendar 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 Google Calendar through natural language.
-
How to connect SharePoint with Microsoft Dataverse through external lists
Provide Microsoft Dataverse (CDS) to SharePoint users as an external list.
-
Automated Continuous Harvest Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Harvest replication to delimited files (CSV/TSV).
-
Build MVC Applications with Connectivity to Unbounce
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Unbounce from an ASP.NET MVC application.
-
How to Access Live Google Campaign Manager 360 in Visual Studio Code via Cline
-