CData Software - Knowledge Base
Recent Articles
-
Viewing TigerGraph in RAD Studio Data Explorer
How to view TigerGraph in RAD Studio Data Explorer using the CData ODBC Driver for TigerGraph.
-
Extract, Transform, and Load SAP Ariba Procurement in Informatica PowerCenter
Create a simple Workflow for SAP Ariba Procurement in Informatica PowerCenter.
-
Extend Google Sheets with Dynamics 365
Make calls to the API Server from Google Apps Script.
-
Connect to Epicor Kinetic from a Connection Pool in WebLogic
Use the CData JDBC Driver for Epicor Kinetic to connect to Epicor Kinetic from Web applications running on WebLogic.
-
Build Azure Synapse-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Azure Synapse from Zoho Analytics and import live Azure Synapse.
-
Automated Continuous SurveyMonkey Replication to MongoDB
Use CData Sync for automated, continuous, customizable SurveyMonkey replication to MongoDB.
-
Automated Continuous MailChimp Replication to Databricks
Use CData Sync for automated, continuous, customizable MailChimp replication to Databricks.
-
ETL Gmail in Oracle Data Integrator
This article shows how to transfer Gmail into a data warehouse using Oracle Data Integrator.
-
Automate Epicor Kinetic Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Epicor Kinetic and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Build Semantic Layer Views for Slack in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Slack.
-
Visualize Azure Analysis Services in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Azure Analysis Services into TIBCO Spotfire.
-
How to work with Typeform in Apache Spark using SQL
Access and process Typeform in Apache Spark using the CData Software JDBC Driver.
-
Analyze Splunk in Looker
Use CData Connect AI to connect to Splunk from Looker and build custom apps using live Splunk.
-
Model Microsoft Exchange Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Microsoft Exchange, enabling the direct import of real-time Microsoft Exchange.
-
Connect to Tableau CRM Analytics in the Denodo Platform
Use CData driver technologies to create a virtual data source for Tableau CRM Analytics in the Denodo Virtual DataPort Administrator.
-
Connect to Sybase from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Sybase to connect to Sybase and execute queries in PowerBuilder.
-
Process & Analyze Typeform in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Typeform .
-
How to Seamlessly Import Google Campaign Manager 360 Data into IBM SPSS Modeler
Integrate Google Campaign Manager 360 data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Use Claude to Talk to Your OneNote via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Microsoft OneNote for you.
-
Authorize.Net Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Authorize.Net facts in real time.
-
How to Connect to Zoho Inventory in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Zoho Inventory. Leverage the pyodbc module for ODBC in Python.
-
Visualize Facebook Ads from Tableau
Use the Tableau Desktop business intelligence tool to connect to Facebook Ads.
-
Connect to BigCommerce from Crystal Reports
Use CData Connect AI to connect to and report on live BigCommerce from Crystal Reports.
-
Connect to Adobe Commerce from Crystal Reports
Use CData Connect AI to connect to and report on live Adobe Commerce from Crystal Reports.
-
Trigger Reckon Accounts Hosted IFTTT Flows in Azure App Service
This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.
-
Integrate Real-Time Access to GraphQL in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to GraphQL in real time.
-
Build a Simple VCL Application for WooCommerce
How to build a simple VCL Application to view WooCommerce in RAD Studio using the CData ODBC Driver for WooCommerce.
-
Automated Continuous Amazon Athena Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Amazon Athena replication to delimited files (CSV/TSV).
-
How to Seamlessly Import Procore Data into IBM SPSS Modeler
Integrate Procore data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to HubSpot from Asprova with CData Software ODBC Driver for HubSpot
This article shows how to connect faster to HubSpot data from Asprova.
-
Automated Continuous Google Analytics Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Google Analytics replication to Google Cloud SQL.
-
Deploy the ADO.NET Provider for SAS xpt on an SSRS Report Server
Connect to SAS XPORT from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Automated Continuous WordPress Replication to SingleStore
Use CData Sync for automated, continuous, customizable WordPress replication to SingleStore.
-
Publish REST-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live REST.
-
Connect to BigQuery from a Connection Pool in WebLogic
Use the CData JDBC Driver for BigQuery to connect to Google BigQuery from Web applications running on WebLogic.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Pinterest to Power BI dashboards. Simply drag and drop Pinterest into data visuals on the Power BI canvas.
-
Automated Continuous Klaviyo Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Klaviyo replication to AlloyDB.
-
How to connect to Bing Ads with Squirrel SQL client
Connect to Bing Ads and execute queries in the Squirrel SQL Client.
-
Migrating data from Oracle SCM to Google BigQuery using CData SSIS Components.
Easily push Oracle SCM to Google BigQuery using the CData SSIS Tasks for Oracle SCM and Google BigQuery.
-
Visualize Amazon Marketplace in Sisense
Create an ElastiCube in Sisense app with access to Amazon Marketplace.
-
Query Zoho Books as a MySQL Database in Node.js
Execute MySQL queries against Zoho Books from Node.js.
-
How to integrate Metabase with Twitter
Use CData Connect AI to connect to live Twitter and create an interactive dashboard in Metabase from Twitter.
-
Excel Spreadsheet Automation on Greenplum with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Migrating data from Spark to Google BigQuery using CData SSIS Components.
Easily push Apache Spark SQL to Google BigQuery using the CData SSIS Tasks for Spark and Google BigQuery.
-
Connect to Teradata as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Teradata.
-
Edit and Search Sage 50 UK External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Sage 50 UK to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Sage 50 UK objects that you can access from apps and the dashboard.
-
Publish Unbounce-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Unbounce.
-
How to create Facebook Ads federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Facebook Ads in MySQL .
-
Connect to Redshift in ACL Analytics
Connect to Amazon Redshift via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Amazon Redshift.
-
Visualize Trello in TIBCO Spotfire through ADO.NET
Integrate Trello into dashboards in TIBCO Spotfire.
-
Access Live Blackbaud FE NXT in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Blackbaud FE NXT from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Stream LinkedIn Ads into Apache Kafka Topics
Access and stream LinkedIn Ads in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Visualize SendGrid in TIBCO Spotfire through OData
Integrate SendGrid into dashboards in TIBCO Spotfire.
-
How to Connect Flowise AI Agents to Live Stripe 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 Biml to Build SSIS Tasks to Replicate Lakebase to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Lakebase to SQL Server.
-
How to Connect to Live Zendesk 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 Zendesk for you.
-
Bind Live Jira Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Jira data
-
Feed Xero into FineReport
How to set Xero Accounting as a JDBC data source in FineReport.
-
Access Live SendGrid in AWS Lambda (with IntelliJ IDEA)
Connect to live SendGrid in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Data Flows from WordPress to SQL Server using SSIS
Easily back up WordPress to SQL Server using the SSIS components for WordPress.
-
Getting Started with the CData Python Connector for Bitbucket
Learn to install and license the CData Python Connector
-
Connecting Agentforce with OData Services 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 OData for you.
-
Integrating Microsoft Project in Talend Cloud Data Management Platform
-