CData Software - Knowledge Base
Recent Articles
-
Build Data Flows from SQL Server to Outreach.io through SSIS
Easily push SQL Server data to Outreach.io using the CData SSIS Tasks for Outreach.io.
-
Replicate Greenhouse from PowerShell
Write a quick PowerShell script to query Greenhouse. Use connectivity to the live data to replicate Greenhouse to SQL Server.
-
Replicate Slack in Heroku for Use in Salesforce Connect
Replicate Slack to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate with live Greenplum in Jitterbit
Use CData Connect AI to connect to and integrate live Pivotal GreenPlum in Jitterbit.
-
How to Build an ETL App for Google Campaign Manager 360 in Python with CData
Create ETL applications and real-time data pipelines for Google Campaign Manager 360 in Python with petl.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed QuickBooks Time to Power BI dashboards. Simply drag and drop QuickBooks Time into data visuals on the Power BI canvas.
-
How to Connect Flowise AI Agents to Live SQL Server 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.
-
Use ChatGPT to Talk to Your Trello via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Trello for you.
-
Access SAP SuccessFactors LMS as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SAP SuccessFactors LMS from your Oracle system.
-
How to Query Live Zoho Books Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Zoho Books data in natural language using Python.
-
Getting Started with the CData Excel Add-In for Pinterest
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Pinterest.
-
Extend Google Sheets with SAP HANA
Make calls to the API Server from Google Apps Script.
-
Access Live Google Ad Manager Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Google Ad Manager data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
How to load Google Ad Manager data into Elasticsearch via Logstash
Introducing a simple method to load Google Ad Manager data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Access Live Microsoft Dataverse in Power Automate Desktop via ODBC
The CData ODBC Driver for Microsoft Dataverse enables you to integrate Microsoft Dataverse (CDS) into workflows built using Microsoft Power Automate Desktop.
-
Use the CData Software ODBC Driver for Cvent in MicroStrategy Web
Connect to Cvent in MicroStrategy Web using the CData Software ODBC Driver for Cvent.
-
Migrating data from FHIR to Databricks using CData SSIS Components.
Easily push FHIR to Databricks using the CData SSIS Tasks for FHIR and Databricks.
-
Use Dash to Build to Web Apps on Clio
Create Python applications that use pandas and Dash to build Clio-connected web apps.
-
Query SingleStore in ColdFusion
Write standard ColdFusion data access code to connect to SingleStore.
-
Back Up Cvent to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Cvent. In this article, we will employ an SSIS workflow to populate a database with Cvent data.
-
Connecting Mastra with SAP ByDesign via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time data across 300+ enterprise sources no replication required.
-
Object-Relational Mapping (ORM) with Marketo 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 Marketo into a Java-based ORM framework, Hibernate.
-
Build Twilio-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Twilio and create custom apps in Mendix.
-
Creating SAP BusinessObjects BI-Connected Applications in Unqork
You can use CData Connect AI to feed SAP BusinessObjects BI to Unqork and build custom business apps.
-
Build Charts with Dynamics NAV in Clear Analytics
Create dynamic charts and perform analytics based on Microsoft Dynamics NAV in Clear Analytics.
-
Publish Reports with Trello in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Trello.
-
Replicate Oracle Service Cloud to Multiple Databases
Replicate Oracle Service Cloud to disparate databases with a point-and-click configuration.
-
Import and Visualize MailChimp in Power View
Create data visualizations based on MailChimp in Excel.
-
A PostgreSQL Interface for Microsoft OneDrive using the CData ODBC Driver
Use the SQL Gateway and Microsoft OneDrive ODBC Driver to create a PostgreSQL entry-point for data access.
-
Configure the CData JDBC Driver for Tally in a Connection Pool in Tomcat
Connect to Tally ERP from a connection pool in Tomcat.
-
Natively Connect to Microsoft Project in PHP
The CData ODBC driver for Microsoft Project enables you to create PHP applications with connectivity to Microsoft Project. Leverage the native support for ODBC in PHP.
-
Import Real-Time SQL Server via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Microsoft SQL Server in ColdFusion.
-
Query Okta in ColdFusion
Write standard ColdFusion data access code to connect to Okta.
-
Create SAP HANA-Connected Applications in Appsmith
Connect to SAP HANA via CData Connect AI in Appsmith and create custom business applications with real-time access to SAP HANA.
-
Using the CData Software ODBC Driver for Tableau CRM Analytics in PyCharm
Connect to Tableau CRM Analytics as an ODBC data source in PyCharm using the CData Software ODBC Driver for Tableau CRM Analytics.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed SAP Fieldglass to Power BI dashboards. Simply drag and drop SAP Fieldglass into data visuals on the Power BI canvas.
-
Build Semantic Layer Views for Power BI XMLA in APOS Live Data Gateway
Use the CData Connector for Power BI XMLA in APOS Live Data Gateway to build Semantic Layer Views for Power BI XMLA.
-
Automated Continuous Azure Active Directory Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Azure Active Directory replication to Google BigQuery.
-
Getting Started with the CData Tableau Connector for SuiteCRM
-