CData Software - Knowledge Base
Recent Articles
-
Migrating data from Dynamics 365 to Databricks using CData SSIS Components.
Easily push Microsoft Dynamics 365 to Databricks using the CData SSIS Tasks for Dynamics 365 and Databricks.
-
Edit and Search EnterpriseDB External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of EnterpriseDB to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create EnterpriseDB objects that you can access from apps and the dashboard.
-
Integrate Cursor with Live Zoho Books Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Zoho Books from within the editor.
-
Visualize Live Stripe in the Power BI Service
Use CData Connect AI to connect to live Stripe and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to MailChimp in Jaspersoft Studio
Execute SQL to remote MailChimp in Jaspersoft Studio.
-
Use CData Connect AI to Access Google Contacts in Microsoft Power Pivot
Use CData Connect AI to connect to live Google Contacts in the Power Pivot business intelligence tool.
-
Use the CData Software JDBC Driver for Xero in MicroStrategy Web
Connect to Xero Accounting in MicroStrategy Web using the CData Software JDBC Driver for Xero.
-
Use CData Connect AI to Access Couchbase in Microsoft Power Pivot
Use CData Connect AI to connect to live Couchbase in the Power Pivot business intelligence tool.
-
Integrate Dynamics NAV in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Microsoft Dynamics NAV from Informatica Cloud.
-
Create Datasets from Aha in Domo Workbench and Build Visualizations of Aha in Domo
Use the CData Software ODBC Driver for Aha to create datasets from Aha! in Domo Workbench and then build visualizations in the Domo service.
-
Creating Gmail-Connected Applications in Unqork
You can use CData Connect AI to feed Gmail to Unqork and build custom business apps.
-
LINQ to Oracle Financials Cloud
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 Financials Cloud Data Provider.
-
Connecting Agentforce with Microsoft Exchange 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 Microsoft Exchange for you.
-
Integrate Live Oracle SCM into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Oracle SCM and integrate live Oracle SCM into apps built in Microsoft Power Apps.
-
Access Live Presto in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Presto from your Google Sheets.
-
How to Query Live Freshdesk Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Freshdesk data in natural language using Python.
-
Integrate SAP Business One in the Pentaho Report Designer
Publish reports based on SAP Business One in the Pentaho BI tool.
-
Connect to Amazon Athena from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Amazon Athena from Filemaker Pro on Mac.
-
Getting Started with the CData Python Connector for ADP
Learn to install and license the CData Python Connector
-
Integrate with live SAP ByDesign in Jitterbit
Use CData Connect AI to connect to and integrate live SAP Business ByDesign in Jitterbit.
-
Getting Started with the CData SSIS Components for CouchDB
Complete guide to installing, licensing, and connecting with the CData SSIS Components for CouchDB.
-
Automated Continuous Stripe Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Stripe replication to Azure SQL Database.
-
How to use SQLAlchemy ORM to access Zuora in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Zuora.
-
Use the CData ODBC Driver for Azure Active Directory in Microsoft Power Query
You can use the CData Azure Active Directory ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Azure Active Directory into Microsoft Power Query.
-
Migrating data from Certinia to Google BigQuery using CData SSIS Components.
Easily push Certinia to Google BigQuery using the CData SSIS Tasks for Certinia and Google BigQuery.
-
How to connect PolyBase to MySQL
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live MySQL.
-
Getting Started with the CData Python Connector for Cassandra
Learn to install and license the CData Python Connector
-
Build Semantic Layer Views for SAP Concur in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for SAP Concur.
-
How to Create Power BI Visual Reports with Real-Time Xero
Use CData Power BI Connectors to visualize Xero Accounting in Power BI.
-
Integrating Boomi Agentstudio with Oracle via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Oracle Database, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to Freshdesk from a Connection Pool in Jetty
The Freshdesk JDBC Driver supports connection pooling: This article shows how to connect faster to Freshdesk from Web apps in Jetty.
-
Query Active Directory as a MySQL Database in Node.js
Execute MySQL queries against Active Directory from Node.js.
-
Access Live SAP SuccessFactors in AWS Lambda (with IntelliJ IDEA)
Connect to live SAP SuccessFactors in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Publish Reports with Cassandra in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Apache Cassandra.
-
Prepare, Blend, and Analyze Greenplum in Alteryx Designer (ODBC)
Build workflows to access live Pivotal GreenPlum for self-service data analytics.
-
Build Dashboards with ActiveCampaign in DBxtra
Create dynamic dashboards and perform analytics based on ActiveCampaign in DBxtra.
-
How to Query Cloudant in MySQL Workbench
Execute MySQL queries against live IBM Cloudant from MySQL Workbench.
-
Visualize Sage 200 from Tableau
Use the Tableau Desktop business intelligence tool to connect to Sage 200.
-
Automate Tasks in Power Automate Using the CData API Server
Automate actions like sending emails to a contact list, posting to social media, or syncing CRM and ERP.
-
How to load Redshift data into Elasticsearch via Logstash
Introducing a simple method to load Redshift data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Unbounce as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Unbounce.
-
Connect SAP SuccessFactors to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SAP SuccessFactors with IBM WebSphere for seamless data integration and connectivity.
-
Use Microsoft Copilot Studio to talk to your SurveyMonkey 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 SurveyMonkey for you.
-
Automated Continuous Oracle Eloqua Replication to SQL Server
Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to SQL Server.
-
Automated Continuous OneNote Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable OneNote replication to delimited files (CSV/TSV).
-
Analyze Amazon Marketplace in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Amazon Marketplace and visualize live Amazon Marketplace in Infragistics Reveal.
-
Add Exact Online to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Exact Online with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous Slack Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Slack replication to PostgreSQL.
-
Create Confluence-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Confluence from OutSystems and build custom enterprise apps using live Atlassian Confluence.
-
Connect to BigCommerce as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live BigCommerce.
-
Use the CData Software ODBC Driver for ShipStation in MicroStrategy
Connect to ShipStation in MicroStrategy Developer using the CData Software ODBC Driver for ShipStation.
-
Oracle HCM Cloud Reporting in OBIEE with the Oracle HCM Cloud JDBC Driver
Deploy the Oracle HCM Cloud JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Create Data Visualizations Based On CockroachDB in Mode
Use CData Connect AI to connect to CockroachDB from Mode and build visualizations using live
-
Natively Connect to Zoom in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Zoom. Leverage the native support for ODBC in PHP.
-
How to connect to SurveyMonkey in DBVisualizer
Integrate SurveyMonkey with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Agents in Relevance AI with Access to Live Zoho Projects via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Zoho Projects within intelligent agent workflows.
-
Connect to SingleStore in Aqua Data Studio
Access SingleStore from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrating Claude Code with MailChimp via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on MailChimp within assisted coding and automated development workflows.
-
Automated Continuous Adobe Commerce Replication to SQL Server
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to SQL Server.
-
Automated Continuous GraphQL Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable GraphQL replication to Microsoft Access.
-
Create Data Visualizations in Cognos BI with Amazon DynamoDB
Access Amazon DynamoDB as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrate Live eBay into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to eBay and integrate live eBay into apps built in Microsoft Power Apps.
-
Create Reports from Twitter in Looker Studio
Use CData Connect AI to gain access to live Twitter and create custom reports in Looker Studio.
-
Automated Continuous YouTube Analytics Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable YouTube Analytics replication to Apache Kafka.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Exact Online
Provide connectivity to Exact Online through an SAP BusinessObjects universe.
-
Build SAP HANA-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for SAP HANA and create custom apps in Mendix.
-
Automated Continuous Adobe Analytics Replication to SingleStore
Use CData Sync for automated, continuous, customizable Adobe Analytics replication to SingleStore.
-
Connect to HubSpot in Claris FileMaker Pro
-