CData Software - Knowledge Base
Recent Articles
-
Model, Search, and Visualize Live BigCommerce in ThoughtSpot
Use CData Connect AI to connect to live BigCommerce for modeling, searching, and visualizing.
-
Connect to WordPress from a Connection Pool in JBoss
Integrate WordPress into Java servlets: Use the Management Console in JBoss to install the WordPress JDBC Driver.
-
Migrating data from Stripe to Snowflake using CData SSIS Components.
Easily push Stripe to Snowflake using the CData SSIS Tasks for Stripe and Snowflake.
-
Rapidly Develop Sugar CRM-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Create Act-On-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Act-On from Klipfolio and build custom visualizations using live Act-On.
-
Integrate Elasticsearch in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Elasticsearch from Informatica Cloud.
-
Automate Cosmos DB Replication to Couchbase
Use CData Sync to Customize and automate Azure Cosmos DB replication to Couchbase.
-
Access LDAP Objects from MySQL in Amazon QuickSight
Connect to LDAP and build visualizations of LDAP using a MySQL Connection in Amazon QuickSight.
-
Consume Google Ad Manager OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Google Ad Manager feeds that reflect any changes in SAP Lumira.
-
Integrating Boomi Agentstudio with Confluence via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Atlassian Confluence, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect Epicor Kinetic to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Epicor Kinetic with IBM WebSphere for seamless data integration and connectivity.
-
Access ADP from MySQL in Amazon QuickSight
Connect to ADP and build visualizations of ADP using a MySQL Connection in Amazon QuickSight.
-
Configure the CData JDBC Driver for Okta in a Connection Pool in Tomcat
Connect to Okta from a connection pool in Tomcat.
-
Build Charts with Exact Online in Clear Analytics
Create dynamic charts and perform analytics based on Exact Online in Clear Analytics.
-
Replicate HubSpot from PowerShell
Write a quick PowerShell script to query HubSpot. Use connectivity to the live data to replicate HubSpot to SQL Server.
-
Edit and Search FTP External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of FTP Servers to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create FTP objects that you can access from apps and the dashboard.
-
Choosing the Best Method to Connect Amazon DynamoDB to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Amazon DynamoDB from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Getting Started with the CData JDBC Driver for TigerGraph
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for TigerGraph.
-
Automate Google Calendar Replication to SAP HANA
Use CData Sync to customize and automate Google Calendar replication to SAP HANA.
-
How to Connect to Live Exact Online 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 Exact Online without replication.
-
Build Kintone-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Kintone.
-
Getting Started with the CData ODBC Driver for SingleStore
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SingleStore.
-
Integrating Gumloop with Microsoft Dataverse via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Microsoft Dataverse (CDS) within automated workflows.
-
Replicate Odoo to Multiple Databases
Replicate Odoo ERP to disparate databases with a point-and-click configuration.
-
Create Datasets from Bing Ads in Domo Workbench and Build Visualizations of Bing Ads in Domo
Use the CData Software ODBC Driver for Bing Ads to create datasets from Bing Ads in Domo Workbench and then build visualizations in the Domo service.
-
How to Work with MariaDB in AWS Glue Jobs Using JDBC
Connect to MariaDB from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to SAP Hybris C4C as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SAP Hybris C4C.
-
How to publish and share Email dashboards with Tableau Server
The CData ODBC driver for Email enables you integrate Email into Tableau dashboards.
-
DataBind Reckon to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Reckon with the DevExpress Windows Forms and Web controls to provide Reckon to a chart.
-
Use the CData Software ODBC Driver for Presto in SAS for Real-Time Reporting and Analytics
Connect to real-time Presto in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Presto.
-
Automated Continuous Microsoft Planner Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Microsoft Planner replication to OneLake in Microsoft Fabric.
-
Build Snowflake-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Snowflake.
-
Connect to Salesforce Pardot in SpagoBI
Create reports featuring live Salesforce Pardot in SpagoBI Studio. Host Salesforce Pardot reports on SpagoBI Server.
-
Process & Analyze Excel Online in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Excel Online .
-
Object-Relational Mapping (ORM) with SAP Ariba Procurement 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 Ariba Procurement into a Java-based ORM framework, Hibernate.
-
Build an OLAP Cube in SSAS from Xero
Establish a connection to Xero Accounting data from SQL Server Analysis Services, and use the Xero Data Provider to build OLAP cubes for use in analytics and reporting.
-
Building Dynamic Web Pages with Aha Using AngularJS
Create single-page applications with live connectivity to Aha using the CData API Server.
-
Integrate Procore with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Procore with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Procore.
-
Build Data Flows from Teradata to SQL Server using SSIS
Easily back up Teradata to SQL Server using the SSIS components for Teradata.
-
How to Connect to Live Workday 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 Workday for you.
-
Connect to ConstantContact in SpagoBI
Create reports featuring live ConstantContact in SpagoBI Studio. Host ConstantContact reports on SpagoBI Server.
-
Build a Singer.io Tap for Redis With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Redis data using
-
Work with Live Google Spanner in Power Query
Use CData Connect AI to connect to Google Spanner and work with live Google Spanner in Microsoft Power Query.
-
Analyze Aha with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Aha from Power Pivot. You will use the Table Import Wizard to load Aha!. You can visually build the import query or use any SQL supported by the driver.
-
Use CData Connect AI to Access Cassandra in Microsoft Power Pivot
Use CData Connect AI to connect to live Apache Cassandra in the Power Pivot business intelligence tool.
-
Build Pipelines with Live Zoho Inventory in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Zoho Inventory from Google Cloud Data Fusion, enabling the integration of live Zoho Inventory into the building and management of effective data pipelines.
-
Connect to Act-On from Crystal Reports
Use CData Connect AI to connect to and report on live Act-On from Crystal Reports.
-
Connect to and Visualize Live Oracle Eloqua Reporting in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Oracle Eloqua Reporting.
-
How to connect to Salesforce in DBVisualizer
Integrate Salesforce & Force.com with visual data analysis tools and data connection wizards in DBVisualizer
-
Create a Data Access Object for Azure Active Directory using JDBI
A brief overview of creating a SQL Object API for Azure Active Directory in JDBI.
-
Connect to Workday in Google Apps Script via Connect AI
Use CData Connect AI to access Workday in Google Apps Script.
-
Visualize Live Raisers Edge NXT in the Power BI Service
Use CData Connect AI to connect to live Raisers Edge NXT and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate CouchDB in the Pentaho Report Designer
Publish reports based on Apache CouchDB in the Pentaho BI tool.
-
Import Real-Time Sage Cloud Accounting via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Sage Business Cloud Accounting in ColdFusion.
-
Access Sugar CRM 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 Sugar CRM.
-
Getting Started with the CData SSIS Components for SharePoint
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SharePoint.
-
Build Oracle SCM-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Oracle SCM and create custom apps in Bubble.
-
Analyze QuickBooks Online in Looker
Use CData Connect AI to connect to QuickBooks Online from Looker and build custom apps using live QuickBooks Online.
-
Create Dynamic REST Grids Using the Infragistics XamDataGrid
Learn how you can connect REST to Infragistics XamDataGrid to build dynamic grids.
-
Integrating LangGraph with Cassandra via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Apache Cassandra within automated workflows.
-
Visualize Live eBay in the Power BI Service
Use CData Connect AI to connect to live eBay and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connecting GenSpark with HCL Domino via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to enterprise data across 300+ systems without any replication or custom integration required.
-
Create Reports with MarkLogic in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date MarkLogic.
-
Build Semantic Layer Views for GitHub in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for GitHub.
-
Choosing the Best Method to Connect Bitbucket to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Bitbucket from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use the CData Software ODBC Driver for Zoho CRM in SAS for Real-Time Reporting and Analytics
Connect to real-time Zoho CRM in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Zoho CRM.
-
Build AI Agents with Slack Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can
-
Connect to HubDB Using the Script Function in Claris FileMaker Pro
-