CData Software - Knowledge Base
Recent Articles
-
Model, Search, and Visualize Live Raisers Edge NXT in ThoughtSpot
Use CData Connect AI to connect to live Raisers Edge NXT for modeling, searching, and visualizing.
-
How to Access Klaviyo Using Entity Framework
This article shows how to access Klaviyo using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Parquet in CloverDX (formerly CloverETL)
Transfer Apache Parquet using the visual workflow in the CloverDX data integration tool.
-
Connect to Sugar CRM from PowerBuilder via ADO.NET
This article demonstrates how to access Sugar CRM from Appeon PowerBuilder using the CData ADO.NET Provider for Sugar CRM.
-
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.
-
Connect to SendGrid in NetBeans
Connect to SendGrid in NetBeans with the data source configuration wizard.
-
Create Active Directory-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Active Directory from Klipfolio and build custom visualizations using live Active Directory.
-
Connecting Moonlit Workflow with Salesforce Pardot 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 Salesforce Pardot in real time.
-
How to Query SAP ByDesign in MySQL Workbench
Execute MySQL queries against live SAP Business ByDesign from MySQL Workbench.
-
Create Reports with Google Ad Manager in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Ad Manager.
-
Visualize Live ShipStation in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live ShipStation into custom reports in Power BI.
-
Getting Started with the CData Excel Add-In for MariaDB
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for MariaDB.
-
How to Query PayPal in MySQL Workbench
Execute MySQL queries against live PayPal from MySQL Workbench.
-
Integrate with Couchbase in SnapLogic
Use CData Connect AI to connect to and integrate with live Couchbase in SnapLogic.
-
Migrating data from SAP Ariba Procurement to Snowflake using CData SSIS Components.
Easily push SAP Ariba Procurement to Snowflake using the CData SSIS Tasks for SAP Ariba Procurement and Snowflake.
-
Build an OLAP Cube in SSAS from Avro
Establish a connection to Apache Avro data from SQL Server Analysis Services, and use the Avro Data Provider to build OLAP cubes for use in analytics and reporting.
-
Import SharePoint into the Power BI Service for Visualizations
Use CData Connect AI to connect to SharePoint and provide access to live Microsoft SharePoint for custom reports in the Power BI Service.
-
Deploy the ADO.NET Provider for HCL Domino on an SSRS Report Server
Connect to HCL Domino 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.
-
Use the CData Software JDBC Driver for Zoho Projects in MicroStrategy Web
Connect to Zoho Projects in MicroStrategy Web using the CData Software JDBC Driver for Zoho Projects.
-
Connect to Amazon Athena as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Amazon Athena.
-
Analyze Live Azure Synapse in SAS Viya
Use CData Connect AI to connect to Azure Synapse from SAS Viya and deploy self-service analytics using live Azure Synapse.
-
Integrate Live Facebook Ads into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Facebook Ads and integrate live Facebook Ads into apps built in Microsoft Power Apps.
-
Connect Salesforce Data Cloud to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Salesforce Data Cloud using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Use ChatGPT to Talk to Your SAP Concur via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your SAP Concur for you.
-
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.
-
Build Microsoft Planner-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Microsoft Planner from Zoho Analytics and import live Microsoft Planner.
-
Connect to Act CRM in Ruby
Connect to Act CRM in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Twitter as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Twitter.
-
How to Visualize SAP Business One Data in Python with pandas
Use pandas and other modules to analyze and visualize live SAP Business One in Python.
-
Build Avalara AvaTax Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Avalara AvaTax and build visualizations in Tableau Cloud.
-
Use the CData Software ODBC Driver for Klipfolio in MicroStrategy
Connect to Klipfolio in MicroStrategy Developer using the CData Software ODBC Driver for Klipfolio.
-
Build a Singer.io Tap for Epicor Kinetic With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Epicor Kinetic data using
-
Automated Continuous Oracle SCM Replication to MySQL
Use CData Sync for automated, continuous, customizable Oracle SCM replication to MySQL.
-
Build AI Agents with Act CRM Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can
-
Connect to Bullhorn CRM from PowerBuilder via ADO.NET
This article demonstrates how to access Bullhorn CRM from Appeon PowerBuilder using the CData ADO.NET Provider for Bullhorn CRM.
-
Query Outreach.io in ColdFusion
Write standard ColdFusion data access code to connect to Outreach.io.
-
How to Connect to Live Azure DevOps 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 Azure DevOps for you.
-
Replicate Printful from PowerShell
Write a quick PowerShell script to query Printful. Use connectivity to the live data to replicate Printful to SQL Server.
-
Automated Continuous Oracle Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Oracle replication to PostgreSQL.
-
How to use SQLAlchemy ORM to access SurveyMonkey in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SurveyMonkey.
-
Create SAP Ariba Procurement-Connected Business Apps in AppSheet
Connect to SAP Ariba Procurement via CData Connect AI in Google AppSheet and create custom business applications with real-time access to SAP Ariba Procurement.
-
LINQ to Salesforce Marketing
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 Salesforce Marketing Data Provider.
-
Create Datasets from BambooHR in Domo Workbench and Build Visualizations of BambooHR in Domo
Use the CData Software ODBC Driver for BambooHR to create datasets from BambooHR in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous LinkedIn Replication to MySQL
Use CData Sync for automated, continuous, customizable LinkedIn replication to MySQL.
-
Build Dashboards with QuickBooks in Dundas BI
Create dynamic dashboards and perform analytics based on QuickBooks Desktop in Dundas BI.
-
Automated Continuous Confluence Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Confluence replication to PostgreSQL.
-
Create ADP-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to ADP from OutSystems and build custom enterprise apps using live ADP.
-
A PostgreSQL Interface for Typeform using the CData ODBC Driver
Use the SQL Gateway and Typeform ODBC Driver to create a PostgreSQL entry-point for data access.
-
ETL Teradata in Oracle Data Integrator
This article shows how to transfer Teradata into a data warehouse using Oracle Data Integrator.
-
Access Adobe Commerce as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Adobe Commerce from your Oracle system.
-
Integrate with Dynamics 365 in SnapLogic
Use CData Connect AI to connect to and integrate with live Microsoft Dynamics 365 in SnapLogic.
-
Consume API OData Feeds in SAP Lumira
Use the API Server to create data visualizations on API feeds that reflect any changes in SAP Lumira.
-
Seamlessly Bring PayPal into Retool Using CData Connect AI
Integrate PayPal data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect to Bing Ads from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Bing Ads to connect to Bing Ads and execute queries in PowerBuilder.
-
OneNote Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Microsoft OneNote through CData Connect AI using different applications and tools.
-
Use JayDeBeApi to access CockroachDB in Python
Use standard Python scripting and the development environment of your choice to access live CockroachDB.
-
How to Query Live Access in Perplexity MacOS Desktop
Connect to and query live Access in Perplexity Desktop using CData Code Assist MCP.
-
Replicate Unbounce to Multiple Databases
Replicate Unbounce to disparate databases with a point-and-click configuration.
-
Use the CData Software ODBC Driver for Stripe in SAS for Real-Time Reporting and Analytics
Connect to real-time Stripe in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Stripe.
-
How to import Azure Data Catalog into Apache Solr
Use the CData Software JDBC Driver for Azure Data Catalog in Data Import Handler and create an automated import of Azure Data Catalog to Apache Solr Enterprise Search platform.
-
Validate GitHub with QuerySurge
Access and validate GitHub in QuerySurge using the CData JDBC Driver.
-
How to Import Data from Workday into Google Sheets
Import Workday into a Google spreadsheet that is automatically refreshed.
-
Access Live MariaDB in TIBCO Data Virtualization
-