CData Software - Knowledge Base
Recent Articles
-
Integrate with live Dynamics 365 Business Central in Jitterbit
Use CData Connect AI to connect to and integrate live Dynamics 365 Business Central in Jitterbit.
-
Rapidly Develop Adobe Experience Manager-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.
-
Use ChatGPT to Talk to Your Snapchat Ads via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Snapchat Ads for you.
-
Access Live Zoho Creator in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Zoho Creator into the statistical analysis tools available in SAS JMP. This article shows how to use Zoho Creator in the Graph Builder and Query Builder.
-
Build Dashboards with Dropbox in DBxtra
Create dynamic dashboards and perform analytics based on Dropbox in DBxtra.
-
How to publish and share Redshift dashboards with Tableau Server
The CData ODBC driver for Redshift enables you integrate Amazon Redshift into Tableau dashboards.
-
Add WordPress to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for WordPress with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Query HBase in MySQL Workbench
Execute MySQL queries against live Apache HBase from MySQL Workbench.
-
How to Seamlessly Import ADP Data into IBM SPSS Modeler
Integrate ADP data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Object-Relational Mapping (ORM) with Snowflake 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 Snowflake into a Java-based ORM framework, Hibernate.
-
How to Connect the Power BI Service to Instagram: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Automated Continuous MYOB AccountRight Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to OneLake in Microsoft Fabric.
-
Integrate with SAS Data Sets in JReport Designer
Create charts and reports based on SAS Data Sets in JReport Designer.
-
Connect to Dropbox in Ruby
Connect to Dropbox in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Use Agno to Talk to Your Smartsheet via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Smartsheet for you.
-
Connect to Office 365 in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Microsoft Office 365 in Airbyte.
-
Build Dashboards with SQL Server in DBxtra
Create dynamic dashboards and perform analytics based on Microsoft SQL Server in DBxtra.
-
How to Access PostgreSQL Using Entity Framework
This article shows how to access PostgreSQL using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect and Visualize Live Dynamics 365 Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Microsoft Dynamics 365 into the Databricks platform and create visualization dashboards with real-time Microsoft Dynamics 365.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Microsoft Exchange
Provide connectivity to Microsoft Exchange through an SAP BusinessObjects universe.
-
Automated Continuous WooCommerce Replication to MySQL
Use CData Sync for automated, continuous, customizable WooCommerce replication to MySQL.
-
Create Informatica Mappings From/To a JDBC Data Source for Google Calendar
Create Google Calendar data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Connect to Live SAP Ariba Procurement in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your SAP Ariba Procurement for you.
-
Automated Continuous OneNote Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable OneNote replication to Apache Kafka.
-
Create Data Visualizations Based On ADP in Mode
Use CData Connect AI to connect to ADP from Mode and build visualizations using live
-
How to create an RPA flow for Dynamics NAV in UiPath Studio
Use the Dynamics NAV ODBC Driver to create workflows that access real-time Microsoft Dynamics NAV without any coding.
-
Create Data Visualizations in Cognos BI with Authorize.Net
Access Authorize.Net as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Use Dash to Build to Web Apps on Klipfolio
Create Python applications that use pandas and Dash to build Klipfolio-connected web apps.
-
Integrate with Live Dynamics CRM in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Dynamics CRM from the MuleSoft Anypoint Platform to integrate live Microsoft Dynamics CRM into custom reports and dashboards.
-
Integrate SingleStore in the Pentaho Report Designer
Publish reports based on SingleStore in the Pentaho BI tool.
-
Automated Continuous Salesforce Replication to SQL Server
Use CData Sync for automated, continuous, customizable Salesforce replication to SQL Server.
-
Prepare, Blend, and Analyze Salesforce Data in Alteryx Designer
Build workflows to access live Salesforce data for self-service data analytics.
-
Connect Google Campaign Manager 360 to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Google Campaign Manager 360 using the CData Python MCP Server.
-
Access Cassandra 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 Apache Cassandra.
-
Model Google Drive Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Google Drive, enabling the direct import of real-time Google Drive.
-
Automate NetSuite Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live NetSuite CRM & ERP and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
How to Import Data from PostgreSQL into Google Sheets
Import PostgreSQL into a Google spreadsheet that is automatically refreshed.
-
PowerShell Scripting to Replicate SAP Netweaver Gateway to MySQL
Write a simple PowerShell script to replicate SAP Netweaver Gateway to a MySQL database.
-
Access Live MongoDB in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live MongoDB from your Excel spreadsheets.
-
Use the CData Software ODBC Driver for Cassandra in SAS for Real-Time Reporting and Analytics
Connect to real-time Apache Cassandra in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Cassandra.
-
Replicate Databricks to Multiple Databases via the CData Sync CLI
Replicate Databricks to disparate databases with a single configuration.
-
Create Reports from Sugar CRM in Looker Studio
Use CData Connect AI to gain access to live Sugar CRM and create custom reports in Looker Studio.
-
View Reports on Real-Time Facebook in Power BI Report Server
Use the CData ODBC Driver for Facebook to visualize Facebook in Power BI Desktop and then publish them to Power BI Report Server.
-
Edit and Search SAS Data Sets External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of SAS Data Sets to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create SAS Data Sets objects that you can access from apps and the dashboard.
-
Visualize IBM Cloud Object Storage in TIBCO Spotfire through OData
Integrate IBM Cloud Object Storage into dashboards in TIBCO Spotfire.
-
Connect to WooCommerce from HeidiSQL
Use CData Connect AI to connect to and query live WooCommerce from HeidiSQL.
-
Automated Continuous Jira Service Management Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Jira Service Management replication to AlloyDB.
-
Analyze QuickBooks Online in R via JDBC
Use standard R functions and the development environment of your choice to analyze QuickBooks Online with the CData JDBC Driver for QuickBooks Online.
-
Replicate Azure DevOps in Heroku for Use in Salesforce Connect
Replicate Azure DevOps to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build Microsoft Teams-Powered Applications in Gemini Code Assist with CData Code Assist MCP
-