CData Software - Knowledge Base
Recent Articles
-
Build Automated Workflows with Live ServiceNow in Workato
Use CData Connect AI to connect to live ServiceNow and build automated workflows in Workato.
-
Salesforce Marketing Reporting in OBIEE with the Salesforce Marketing JDBC Driver
Deploy the Salesforce Marketing JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Back Up Epicor Kinetic to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Epicor Kinetic. In this article, we will employ an SSIS workflow to populate a database with Epicor Kinetic data.
-
Import Real-Time Slack via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Slack in ColdFusion.
-
Edit and Search External Zendesk Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Zendesk to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Zendesk objects that you can access from apps and the dashboard.
-
Connect to SAP SuccessFactors in CloverDX (formerly CloverETL)
Transfer SAP SuccessFactors using the visual workflow in the CloverDX data integration tool.
-
Connect to Facebook in NetBeans
Connect to Facebook in NetBeans with the data source configuration wizard.
-
How to connect PolyBase to PayPal
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live PayPal.
-
Replicate Google Cloud Storage from PowerShell
Write a quick PowerShell script to query Google Cloud Storage. Use connectivity to the live data to replicate Google Cloud Storage to SQL Server.
-
Query Unbounce in ColdFusion
Write standard ColdFusion data access code to connect to Unbounce.
-
Build Data Flows from SQL Server to HubSpot through SSIS
Easily push SQL Server data to HubSpot using the CData SSIS Tasks for HubSpot.
-
How to connect to Amazon Marketplace from IntelliJ
Integrate connectivity to Amazon Marketplace with wizards in IntelliJ.
-
Replicate Power BI XMLA to Multiple Databases via the CData Sync CLI
Replicate Power BI XMLA to disparate databases with a single configuration.
-
Validate HCL Domino with QuerySurge
Access and validate HCL Domino in QuerySurge using the CData JDBC Driver.
-
Integrate with Azure Data Catalog using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Azure Data Catalog to a JSON file on disk.
-
Automated Continuous SAP Concur Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SAP Concur replication to AlloyDB.
-
Integrate QuickBooks Online into Power Automate Desktop using CData Connect
CData Connect for QuickBooks Online enables you to integrate QuickBooks Online into workflows built using Microsoft Power Automate Desktop.
-
Getting Started with the CData Excel Add-In for Oracle Financials Cloud
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Oracle Financials Cloud.
-
Automated Continuous Salesloft Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Salesloft replication to OneLake in Microsoft Fabric.
-
Back Up Apache Avro to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Avro. In this article, we will employ an SSIS workflow to populate a database with Apache Avro data.
-
Connect to Twilio in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Twilio in Airbyte.
-
Connect to ShipStation in Google Apps Script via Connect AI
Use CData Connect AI to access ShipStation in Google Apps Script.
-
Replicate Calendly to Multiple Databases
Replicate Calendly to disparate databases with a point-and-click configuration.
-
A PostgreSQL Interface for Google Ad Manager using the CData ODBC Driver
Use the SQL Gateway and Google Ad Manager ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create SSAS Tabular Models from Google Sheets
How to build a SQL Server Analysis Service Tabular Model from Google Sheets using CData drivers.
-
Integrate Oracle HCM Cloud in Pentaho Data Integration
Build ETL pipelines based on Oracle HCM Cloud in the Pentaho Data Integration tool.
-
Visualize Live Oracle SCM in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Oracle SCM into custom reports in Power BI.
-
Visualize HCL Domino in Tableau
The CData ODBC driver for HCL Domino enables you integrate HCL Domino into Tableau dashboards.
-
How to update Workday from Excel
This article explains how to transfer data from Excel to Workday using the Excel Add-In for Workday.
-
Stream Dynamics 365 Business Central into Apache Kafka Topics
Access and stream Dynamics 365 Business Central in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Visualize Jira in TIBCO Spotfire through OData
Integrate Atlassian Jira into dashboards in TIBCO Spotfire.
-
Bidirectional Access to Google Directory from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Google Directory in Filemaker Pro for Mac or Windows.
-
Connecting Agentforce with Slack 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 Slack for you.
-
Publish Crystal Reports on Google Data Catalog
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Google Data Catalog.
-
Automated Continuous Sage 200 Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Sage 200 replication to IBM DB2.
-
Integrate with Live LinkedIn in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to LinkedIn from the MuleSoft Anypoint Platform to integrate live LinkedIn into custom reports and dashboards.
-
Automated Continuous Trello Replication to Oracle
Use CData Sync for automated, continuous, customizable Trello replication to Oracle.
-
SingleStore Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SingleStore facts in real time.
-
Build Dashboards with Excel Online in Dundas BI
Create dynamic dashboards and perform analytics based on Microsoft Excel Online in Dundas BI.
-
Integrate Cursor with Live Kintone Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Kintone from within the editor.
-
How to connect to ClickUp with Squirrel SQL client
Connect to ClickUp and execute queries in the Squirrel SQL Client.
-
How to Connect to Live Salesforce Pardot from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Salesforce Pardot through natural language.
-
How to update Oracle Service Cloud from Excel
This article explains how to transfer data from Excel to Oracle Service Cloud using the Excel Add-In for Oracle Service Cloud.
-
Getting Started with the CData Excel Add-In for SQLite
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SQLite.
-
Connect to ShipStation in CloverDX (formerly CloverETL)
Transfer ShipStation using the visual workflow in the CloverDX data integration tool.
-
Analyze Oracle SCM with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Oracle SCM from Power Pivot. You will use the Table Import Wizard to load Oracle SCM. You can visually build the import query or use any SQL supported by the driver.
-
How to Connect to Live Smartsheet 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 Smartsheet for you.
-
How to Create Power BI Visual Reports with Real-Time Azure Table
Use CData Power BI Connectors to visualize Azure Table Storage in Power BI.
-
Operational Reporting on OneNote from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Microsoft OneNote.
-
Query Neo4J in ColdFusion
Write standard ColdFusion data access code to connect to Neo4J.
-
Build Presto-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Presto from Zoho Analytics and import live Presto.
-
ETL Okta in Oracle Data Integrator
This article shows how to transfer Okta into a data warehouse using Oracle Data Integrator.
-
How to integrate Salesforce with Apache Airflow
Access and process Salesforce & Force.com in Apache Airflow using the CData JDBC Driver.
-
Establish a Live Connection with Zoho CRM using Tableau Bridge
The CData ODBC Driver for Zoho CRM enables you to integrate live Zoho CRM into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to GraphQL from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for GraphQL to connect to GraphQL and execute queries in PowerBuilder.
-
Extract, Transform, and Load Vault CRM in Informatica PowerCenter
Create a simple Workflow for Veeva Vault & Vault CRM in Informatica PowerCenter.
-
Build Apps with Live Asana in Adalo using CData Connect AI
Use CData Connect AI to integrate live Asana into the Adalo platform and build custom mobile and web applications with real-time Asana.
-
Query Pinterest from Node.js
Use the OData endpoint of the CData API Server to connect to your Pinterest and perform CRUD operations on Pinterest from Node.js.
-
Import Real-Time LinkedIn via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use LinkedIn in ColdFusion.
-
Automated Continuous SAP SuccessFactors Replication to SingleStore
Use CData Sync for automated, continuous, customizable SAP SuccessFactors replication to SingleStore.
-
Provide OData Services of MailChimp from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for MailChimp by developing a WCF Service Application.
-
Feed SAS Data Sets into FineReport
How to set SAS Data Sets as a JDBC data source in FineReport.
-
Use the CData Software JDBC Driver for Twitter in MicroStrategy Web
Connect to Twitter in MicroStrategy Web using the CData Software JDBC Driver for Twitter.
-
Create SSAS Tabular Models from Paylocity
How to build a SQL Server Analysis Service Tabular Model from Paylocity using CData drivers.
-
Connect to TigerGraph in HULFT Integrate
Connect to TigerGraph as a JDBC data source in HULFT Integrate
-
Visualize Zoho Creator from Tableau
Use the Tableau Desktop business intelligence tool to connect to Zoho Creator.
-
Getting Started with the CData Power BI Connector for Shippo
-