CData Software - Knowledge Base
Recent Articles
-
Create Data Visualizations in Cognos BI with Oracle Financials Cloud
Access Oracle Financials Cloud as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Replicate Office 365 in Heroku for Use in Salesforce Connect
Replicate Microsoft Office 365 to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to connect SharePoint with CSV through external lists
Provide CSV/TSV Files to SharePoint users as an external list.
-
Connecting Mastra with Spark 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 hundreds of enterprise sources no replication required.
-
Use the CData SSIS Components to Insert New or Update Existing SAS Data Sets Records from SQL Server
Easily push SQL Server data to SAS Data Sets using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into SAS Data Sets or update existing records with data from a SQL Server database.
-
Integrate Google Contacts in Pentaho Data Integration
Build ETL pipelines based on Google Contacts in the Pentaho Data Integration tool.
-
Connect to Dropbox in Aqua Data Studio
Access Dropbox from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to MarkLogic from a Connection Pool in JBoss
Integrate MarkLogic into Java servlets: Use the Management Console in JBoss to install the MarkLogic JDBC Driver.
-
Integrate SAS Data Sets with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SAS Data Sets with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SAS Data Sets.
-
Access Live SAP SuccessFactors in AWS Lambda
Connect to live SAP SuccessFactors in AWS Lambda using the CData JDBC Driver.
-
Build Dashboards with Zoho Projects in DBxtra
Create dynamic dashboards and perform analytics based on Zoho Projects in DBxtra.
-
Connect to Microsoft Exchange in CloverDX (formerly CloverETL)
Transfer Microsoft Exchange using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous Blackbaud FE NXT Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to Apache Cassandra.
-
Automated Continuous SAP SuccessFactors Replication to IBM DB2
Use CData Sync for automated, continuous, customizable SAP SuccessFactors replication to IBM DB2.
-
How to load Harvest data into Elasticsearch via Logstash
Introducing a simple method to load Harvest data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Using the CData Software ODBC Driver for Oracle HCM Cloud in PyCharm
Connect to Oracle HCM Cloud as an ODBC data source in PyCharm using the CData Software ODBC Driver for Oracle HCM Cloud.
-
Analyze Kintone in R via JDBC
Use standard R functions and the development environment of your choice to analyze Kintone with the CData JDBC Driver for Kintone.
-
Create a Data Access Object for Kafka using JDBI
A brief overview of creating a SQL Object API for Apache Kafka in JDBI.
-
How to Access Live Google Search Results in Power Automate Desktop via ODBC
The CData ODBC Driver for Google Search enables you to integrate Google Search into workflows built using Microsoft Power Automate Desktop.
-
Edit and Search ClickUp External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of ClickUp to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create ClickUp objects that you can access from apps and the dashboard.
-
Import Avalara AvaTax Using Azure Data Factory
Use CData Connect AI to connect to Avalara AvaTax from Azure Data Factory and import live Avalara AvaTax.
-
Import Real-Time Act CRM via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Act CRM in ColdFusion.
-
A PostgreSQL Interface for Bitbucket using the CData ODBC Driver
Use the SQL Gateway and Bitbucket ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Import Data from Salesforce Marketing into Google Sheets
Import Salesforce Marketing Cloud into a Google spreadsheet that is automatically refreshed.
-
How to connect PolyBase to Azure Analysis Services
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Azure Analysis Services.
-
Connect to Google Sheets Using the Script Function in Claris FileMaker Pro
-