CData Software - Knowledge Base
Recent Articles
-
Use the CData ODBC Driver for SAP in Microsoft Power Query
You can use the CData SAP ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SAP ERP/NetWeaver into Microsoft Power Query.
-
Analyze Exact Online with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Exact Online from Power Pivot. You will use the Table Import Wizard to load Exact Online. You can visually build the import query or use any SQL supported by the driver.
-
Analyze Shopify in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Shopify and visualize Shopify in SAP Analytics Cloud.
-
Connect and Visualize Live Oracle Eloqua Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Oracle Eloqua into the Databricks platform and create visualization dashboards with real-time Oracle Eloqua.
-
Integrating Dataiku with Google Ads via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Google Ads.
-
Create Informatica Mappings From/To a JDBC Data Source for Twitter
Create Twitter data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Query Live Facebook Ads in Perplexity MacOS Desktop
Connect to and query live Facebook Ads in Perplexity Desktop using the CData MCP Server.
-
How to Connect the Power BI Service to Odoo: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Add Basecamp to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Basecamp with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous Access Replication to MySQL
Use CData Sync for automated, continuous, customizable Access replication to MySQL.
-
How to Import Data from Act-On into Google Sheets
Import Act-On into a Google spreadsheet that is automatically refreshed.
-
Integrate with Azure Data Lake Storage in SnapLogic
Use CData Connect AI to connect to and integrate with live Azure Data Lake Storage in SnapLogic.
-
How to Connect to Live Quickbase in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Quickbase for you.
-
Analyze WooCommerce in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of WooCommerce and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
-
Automated Continuous xBase Replication to IBM DB2
Use CData Sync for automated, continuous, customizable xBase replication to IBM DB2.
-
Automated Continuous HDFS Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable HDFS replication to Azure SQL Database.
-
Consume Raisers Edge NXT OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Raisers Edge NXT feeds that reflect any changes in SAP Lumira.
-
Consume Access OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Access feeds that reflect any changes in SAP Lumira.
-
How to connect PolyBase to Printify
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Printify.
-
Edit and Search Azure Active Directory External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Azure Active Directory to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Azure Active Directory objects that you can access from apps and the dashboard.
-
Build Semantic Layer Views for Databricks in APOS Live Data Gateway
Use the CData Connector for Databricks in APOS Live Data Gateway to build Semantic Layer Views for Databricks.
-
How to Connect to & Open Microsoft Exchange in Microsoft Excel
This article uses the CData ODBC driver for Microsoft Exchange to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to connect to IBM Informix in DBVisualizer
Integrate IBM Informix with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Google Search Results through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Google Search Results using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Visualize Microsoft Exchange Data in Python with pandas
Use pandas and other modules to analyze and visualize live Microsoft Exchange in Python.
-
View Reports on Real-Time Oracle HCM Cloud in Power BI Report Server
Use the CData ODBC Driver for Oracle HCM Cloud to visualize Oracle HCM Cloud in Power BI Desktop and then publish them to Power BI Report Server.
-
How to import HCL Domino into Apache Solr
Use the CData Software JDBC Driver for HCL Domino in Data Import Handler and create an automated import of HCL Domino to Apache Solr Enterprise Search platform.
-
Connect to Wave Financial in JRuby
Create a simple JRuby app with access to live Wave Financial.
-
Use Biml to Build SSIS Tasks to Replicate Blackbaud FE NXT to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Blackbaud FE NXT to SQL Server.
-
Connect to HBase in SpagoBI
Create reports featuring live Apache HBase in SpagoBI Studio. Host HBase reports on SpagoBI Server.
-
Connect to and Query Google Campaign Manager 360 in QlikView over ODBC
Create data visualizations with Google Campaign Manager 360 in QlikView.
-
How to Connect DBeaver to Unbounce via a JDBC Driver
Manage Unbounce with visual tools in DBeaver like the query browser.
-
Automated Continuous Twitter Ads Replication to Snowflake
Use CData Sync for automated, continuous, customizable Twitter Ads replication to Snowflake.
-
Query QuickBooks Online in DataGrip
Create a Data Source for QuickBooks Online in DataGrip and use SQL to query live QuickBooks Online.
-
How to connect PolyBase to Oracle Financials Cloud
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Oracle Financials Cloud.
-
Connect to Outreach.io Using the Script Function in Claris FileMaker Pro
-