CData Software - Knowledge Base
Recent Articles
-
Automated Continuous GitHub Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable GitHub replication to Amazon Redshift.
-
Model, Search, and Visualize Live AlloyDB in ThoughtSpot
Use CData Connect AI to connect to live Google AlloyDB for modeling, searching, and visualizing.
-
Design BIRT Reports on QuickBooks
Provide current QuickBooks Desktop to your embedded analytics.
-
Model Hive Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Hive, enabling the direct import of real-time Apache Hive.
-
Automated Continuous Procore Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Procore replication to Apache Kafka.
-
Visualize Google Ad Manager in TIBCO Spotfire through ADO.NET
Integrate Google Ad Manager into dashboards in TIBCO Spotfire.
-
Build an OLAP Cube in SSAS from SharePoint
Establish a connection to Microsoft SharePoint data from SQL Server Analysis Services, and use the SharePoint Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Google Search Results in Aqua Data Studio
Access Google Search from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Excel Spreadsheet Automation on Zoho Books with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Integrate Zoho Inventory in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Zoho Inventory from Informatica Cloud.
-
Query Oracle Eloqua as a MySQL Database in Node.js
Execute MySQL queries against Oracle Eloqua from Node.js.
-
How to publish and share Google Drive dashboards with Tableau Server
The CData ODBC driver for Google Drive enables you integrate Google Drive into Tableau dashboards.
-
Manage Google Ads in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Google Ads.
-
Connect to Live ServiceNow in MicroStrategy through CData Connect AI
Create a live connection to ServiceNow in CData Connect AI and connect to your ServiceNow from MicroStrategy.
-
Automated Continuous Drip Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Drip replication to AlloyDB.
-
Build Dynamics 365-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Microsoft Dynamics 365.
-
Trigger Highrise IFTTT Flows in Azure App Service
This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.
-
Migrating data from SAP ByDesign to Google BigQuery using CData SSIS Components.
Easily push SAP Business ByDesign to Google BigQuery using the CData SSIS Tasks for SAP ByDesign and Google BigQuery.
-
Visualize IBM Informix in Sisense
Create an ElastiCube in Sisense app with access to IBM Informix.
-
Automated Continuous MariaDB Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable MariaDB replication to delimited files (CSV/TSV).
-
Choosing the Best Method to Connect eBay Analytics to SQL Server: 5 Options Explained
Discover multiple ways to connect and use eBay Analytics from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Create Data Visualizations in Cognos BI with Amazon Marketplace
Access Amazon Marketplace as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connecting Moonlit Workflow with Facebook Ads via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Facebook Ads in real time.
-
Automate Shopify Replication to Azure Data Lake
Use CData Sync to customize and automate Shopify replication to Azure Data Lake.
-
Work with Oracle HCM Cloud in FoxPro
Load Oracle HCM Cloud into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to and Query Email in QlikView over ODBC
Create data visualizations with Email in QlikView.
-
Connect and Visualize Live Azure Data Lake Storage Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Azure Data Lake Storage into the Databricks platform and create visualization dashboards with real-time Azure Data Lake Storage.
-
How to connect to Authorize.Net in DBVisualizer
Integrate Authorize.Net with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Cosmos DB as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Azure Cosmos DB.
-
Integrate with Live Raisers Edge NXT in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Raisers Edge NXT from the MuleSoft Anypoint Platform to integrate live Raisers Edge NXT into custom reports and dashboards.
-
How to Work with Spark in ETL Validator JDBC
Connect to Spark from ETL Validator jobs using the CData Software JDBC Driver.
-
Provide OData Services of PingOne from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for PingOne by developing a WCF Service Application.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for MYOB AccountRight
Provide connectivity to MYOB AccountRight through an SAP BusinessObjects universe.
-
Consume SAP HANA OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SAP HANA feeds that reflect any changes in SAP Lumira.
-
Access Cvent in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Cvent.
-
Access BambooHR from MySQL in PHP
Connect to BambooHR through the standard MySQL libraries in PHP.
-
Edit and Search External Google Calendar Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Google Calendar to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Google Calendar objects that you can access from apps and the dashboard.
-
Feed QuickBooks Time into FineReport
How to set QuickBooks Time as a JDBC data source in FineReport.
-
Build Trello Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Trello and build visualizations in Tableau.
-
Build Google Analytics-Connected Apps in Choreo
Use CData Connect AI to connect to Google Analytics from Choreo and build custom apps using live Google Analytics.
-
Create Data Visualizations Based On ShipStation in Mode
Use CData Connect AI to connect to ShipStation from Mode and build visualizations using live
-
Create Data Visualizations in Cognos BI with Blackbaud FE NXT
Access Blackbaud FE NXT as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Consume Hive OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Hive feeds that reflect any changes in SAP Lumira.
-
Visualize eBay in Tableau
The CData ODBC driver for eBay enables you integrate eBay into Tableau dashboards.
-
Automated Continuous Blackbaud FE NXT Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to Microsoft Access.
-
Publish Reports with Lakebase in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Lakebase.
-
Use Dash to Build to Web Apps on Twitter
Create Python applications that use pandas and Dash to build Twitter-connected web apps.
-
How to create an RPA flow for Parquet in UiPath Studio
Use the Parquet ODBC Driver to create workflows that access real-time Apache Parquet without any coding.
-
Integrate with Avalara AvaTax using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Avalara AvaTax to a JSON file on disk.
-
Create SSAS Tabular Models from Google Calendar
How to build a SQL Server Analysis Service Tabular Model from Google Calendar using CData drivers.
-
Automate EventBrite Replication to Azure Synapse
Use CData Sync to customize and automate Eventbrite replication to Azure Synapse.
-
Connect to Paylocity from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Paylocity, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to connect SharePoint with Oracle Service Cloud through external lists
Provide Oracle Service Cloud to SharePoint users as an external list.
-
Visualize Twitter Ads in TIBCO Spotfire through ADO.NET
Integrate Twitter Ads into dashboards in TIBCO Spotfire.
-
Connect to WordPress in Google Apps Script via Connect AI
Use CData Connect AI to access WordPress in Google Apps Script.
-
Query DB2 in DataGrip
Create a Data Source for DB2 in DataGrip and use SQL to query live IBM DB2.
-
Viewing Office 365 in RAD Studio Data Explorer
How to view Microsoft Office 365 in RAD Studio Data Explorer using the CData ODBC Driver for Office 365.
-
Use the CData ODBC Driver for Bing Ads in Microsoft Power Query
You can use the CData Bing Ads ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Bing Ads into Microsoft Power Query.
-
Integrate Live SendGrid into Blue Prism for Intelligent Robotic Process Automation (RPA)
-