CData Software - Knowledge Base
Recent Articles
-
Build Semantic Layer Views for Sugar CRM in APOS Live Data Gateway
Use the CData Connector for Sugar CRM in APOS Live Data Gateway to build Semantic Layer Views for Sugar CRM.
-
Connect to Avro as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Apache Avro.
-
Access Quickbase from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Quickbase from HeidiSQL.
-
Use the CData Software JDBC Driver for Sage 200 in MicroStrategy Desktop
Connect to Sage 200 in MicroStrategy Desktop using the CData Software JDBC Driver for Sage 200.
-
Build AI Agents with Greenplum Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can
-
Visualize Cloudant in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load IBM Cloudant into TIBCO Spotfire.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Google Calendar
Provide connectivity to Google Calendar through an SAP BusinessObjects universe.
-
Automated Elasticsearch Replication to Teradata
Use CData Sync to Customize and automate Elasticsearch replication to Teradata.
-
Trigger CouchDB IFTTT Flows in Azure App Service
This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.
-
Use the CData API Server to Access API in Microsoft PowerPivot
Use the CData API Server to connect to live API in the Power Pivot business intelligence tool.
-
View Reports on Real-Time Bitbucket in Power BI Report Server
Use the CData ODBC Driver for Bitbucket to visualize Bitbucket in Power BI Desktop and then publish them to Power BI Report Server.
-
Use the CData Software ODBC Driver for Jira in MicroStrategy Web
Connect to Atlassian Jira in MicroStrategy Web using the CData Software ODBC Driver for Jira.
-
Connect to DocuSign from a Connection Pool in JBoss
Integrate DocuSign into Java servlets: Use the Management Console in JBoss to install the DocuSign JDBC Driver.
-
How to Seamlessly Import LinkedIn Data into IBM SPSS Modeler
Integrate LinkedIn data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Automated MailChimp-Connected Workflows in Zapier
Use CData Connect AI to connect to live MailChimp and build automated workflows in Zapier.
-
How to Seamlessly Import Azure Data Lake Storage Data into IBM SPSS Modeler
Integrate Azure Data Lake Storage data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to Use a Microsoft Access Database to Update Workday in Real Time
Update Workday data by creating a linked table in Microsoft Access with the CData Workday ODBC Driver.
-
Consume Dynamics CRM OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Dynamics CRM feeds that reflect any changes in SAP Lumira.
-
Connect to Box from a Connection Pool in Jetty
The Box JDBC Driver supports connection pooling: This article shows how to connect faster to Box from Web apps in Jetty.
-
Create a Data Access Object for Zoom using JDBI
A brief overview of creating a SQL Object API for Zoom in JDBI.
-
Getting Started with the CData Excel Add-In for Salesforce Pardot
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Salesforce Pardot.
-
How to Connect to Live Salesforce from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Salesforce & Force.com for you.
-
Visualize Live Active Directory in the Power BI Service
Use CData Connect AI to connect to live Active Directory and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate Live Azure Data Lake Storage into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Azure Data Lake Storage from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Azure Data Lake Storage.
-
Build Automated SAP Ariba Procurement-Connected Workflows in Zapier
Use CData Connect AI to connect to live SAP Ariba Procurement and build automated workflows in Zapier.
-
Use CData Connect AI to Access SAP SuccessFactors in Microsoft Power Pivot
Use CData Connect AI to connect to live SAP SuccessFactors in the Power Pivot business intelligence tool.
-
Create Power BI Reports on Real-Time Shippo
Use the CData ODBC Driver for Shippo to visualize Shippo in Power BI Desktop.
-
Build Google Analytics Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Google Analytics and build visualizations in Tableau.
-
Automate Couchbase Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Couchbase from PowerShell? This article demonstrates how to utilize the Couchbase Cmdlets for tasks like connecting to Couchbase, automating operations, downloading data, and more.
-
Access Live Oracle Service Cloud in AWS Lambda
Connect to live Oracle Service Cloud in AWS Lambda using the CData JDBC Driver.
-
Extend Google Sheets with Workday
Make calls to the API Server from Google Apps Script.
-
Connect to Adobe Target in CloverDX (formerly CloverETL)
Transfer Adobe Target using the visual workflow in the CloverDX data integration tool.
-
Build Pipelines with Live Vault CRM in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Vault CRM from Google Cloud Data Fusion, enabling the integration of live Veeva Vault & Vault CRM into the building and management of effective data pipelines.
-
Import PostgreSQL Using Azure Data Factory
Use CData Connect AI to connect to PostgreSQL from Azure Data Factory and import live PostgreSQL.
-
Create Informatica Mappings From/To a JDBC Data Source for LDAP
Create LDAP data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Replicate Avalara AvaTax to Multiple Databases via the CData Sync CLI
Replicate Avalara AvaTax to disparate databases with a single configuration.
-
Automated Continuous Azure DevOps Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Azure DevOps replication to IBM DB2.
-
Build Amazon S3-Connected Apps in Choreo
Use CData Connect AI to connect to Amazon S3 from Choreo and build custom apps using live Amazon S3.
-
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 connect SharePoint with Box through external lists
Provide Box to SharePoint users as an external list.
-
Use CData Connect AI to Access Kintone in Microsoft Power Pivot
Use CData Connect AI to connect to live Kintone in the Power Pivot business intelligence tool.
-
Build MVC Applications with Connectivity to SQL Analysis Services
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SQL Analysis Services from an ASP.NET MVC application.
-
Connect to MailChimp from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from MailChimp, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Integrate Live Clio into Blue Prism for Intelligent Robotic Process Automation (RPA)
-