CData Software - Knowledge Base
Recent Articles
-
Access EventBrite 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 Eventbrite.
-
Connect to Twilio in RapidMiner
Integrate Twilio with standard components and data source configuration wizards in RapidMiner Studio.
-
Use the CData Software ODBC Driver for SAS xpt in MicroStrategy Web
Connect to SAS XPORT in MicroStrategy Web using the CData Software ODBC Driver for SAS xpt.
-
Automated Continuous Google Ads Replication to Databricks
Use CData Sync for automated, continuous, customizable Google Ads replication to Databricks.
-
How to connect and process MarkLogic from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live MarkLogic.
-
Visualize Live Facebook Ads of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Facebook Ads using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Replicate Multiple SAP HANA Accounts via the CData Sync CLI
Replicate multiple SAP HANA accounts to one or many databases.
-
Connect to Office 365 in NetBeans
Connect to Microsoft Office 365 in NetBeans with the data source configuration wizard.
-
Automated Continuous QuickBooks Online Replication to SQLite
Use CData Sync for automated, continuous, customizable QuickBooks Online replication to SQLite.
-
Publish Oracle Eloqua Reporting-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Oracle Eloqua Reporting.
-
Automated Continuous SAP Hybris C4C Replication to MySQL
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to MySQL.
-
Analyze Raisers Edge NXT in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Raisers Edge NXT and visualize Raisers Edge NXT in SAP Analytics Cloud.
-
Query FHIR in ColdFusion
Write standard ColdFusion data access code to connect to FHIR.
-
Connect to Todoist from a Connection Pool in WebLogic
Use the CData JDBC Driver for Todoist to connect to Todoist from Web applications running on WebLogic.
-
Visualize Redshift from Tableau
Use the Tableau Desktop business intelligence tool to connect to Amazon Redshift.
-
Access ShipStation from MySQL in Amazon QuickSight
Connect to ShipStation and build visualizations of ShipStation using a MySQL Connection in Amazon QuickSight.
-
How to connect and process Databricks from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Databricks.
-
Connect to GitHub in RazorSQL
Connect to GitHub from wizards and query GitHub from the GUI in the RazorSQL database management tool.
-
Connect to Tableau CRM Analytics from a Connection Pool in Jetty
The Tableau CRM Analytics JDBC Driver supports connection pooling: This article shows how to connect faster to Tableau CRM Analytics from Web apps in Jetty.
-
Build Drift-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Drift.
-
How to work with MongoDB in Apache Spark using SQL
Access and process MongoDB in Apache Spark using the CData Software JDBC Driver.
-
Integrating Gumloop with Twitter via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Twitter within automated workflows.
-
Publish Crystal Reports on Bullhorn CRM
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Bullhorn CRM.
-
How to Connect the Power BI Service to Google Ads: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Automated Continuous Snapchat Ads Replication to SingleStore
Use CData Sync for automated, continuous, customizable Snapchat Ads replication to SingleStore.
-
Use the CData ODBC Driver for IBM Informix in Microsoft Power Query
You can use the CData IBM Informix ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import IBM Informix into Microsoft Power Query.
-
Integrating Claude Code with Cloudant via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on IBM Cloudant within assisted coding and automated development workflows.
-
Automated Continuous Airtable Replication to Snowflake
Use CData Sync for automated, continuous, customizable Airtable replication to Snowflake.
-
Use the CData Software ODBC Driver for Shippo in SAS for Real-Time Reporting and Analytics
Connect to real-time Shippo in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Shippo.
-
Connect to Live Cloudant in PostGresSQL Interface through CData Connect AI
Create a live connection to Cloudant in CData Connect AI and connect to your IBM Cloudant from PostgreSQL.
-
How to Query Microsoft Project in MySQL Workbench
Execute MySQL queries against live Microsoft Project from MySQL Workbench.
-
Connect to and Visualize Live ShipStation in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live ShipStation.
-
Replicate Cosmos DB from PowerShell
Write a quick PowerShell script to query Azure Cosmos DB. Use connectivity to the live data to replicate Azure Cosmos DB to SQL Server.
-
Build Semantic Layer Views for Box in APOS Live Data Gateway
Use the CData Connector for Box in APOS Live Data Gateway to build Semantic Layer Views for Box.
-
Establish a Live Connection with Active Directory using Tableau Bridge
The CData ODBC Driver for Active Directory enables you to integrate live Active Directory into Tableau Cloud dashboards using the Tableau Bridge.
-
Automate Airtable Replication to SAP HANA
Use CData Sync to customize and automate Airtable replication to SAP HANA.
-
Connect to Exact Online from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Exact Online, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to Import Data from Highrise into Google Sheets
Import Highrise CRM into a Google spreadsheet that is automatically refreshed.
-
Shopify Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Shopify facts in real time.
-
How to Connect to Live Salesforce from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Salesforce & Force.com for you.
-
Automate Couchbase Replication to Azure Data Lake
Use CData Sync to customize and automate Couchbase replication to Azure Data Lake.
-
Create Data Visualizations in Cognos BI with Parquet
Access Apache Parquet as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Connect to Live Spark from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Apache Spark SQL for you.
-
Build Dashboards with PingOne in Dundas BI
Create dynamic dashboards and perform analytics based on PingOne in Dundas BI.
-
Excel Spreadsheet Automation on SharePoint with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for PayPal
Provide connectivity to PayPal through an SAP BusinessObjects universe.
-
Build Outreach.io-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Outreach.io.
-
Query Couchbase as a MySQL Database in Node.js
Execute MySQL queries against Couchbase from Node.js.
-
Connect to Azure Data Catalog as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Azure Data Catalog.
-
How to Connect the Power BI Service to WordPress: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Analyze Xero in Cognos Analytics
Use CData Connect AI to connect to Xero from Cognos Analytics and analyze live Xero Accounting.
-
Create Power BI Reports on Real-Time Azure DevOps
Use the CData ODBC Driver for Azure DevOps to visualize Azure DevOps in Power BI Desktop.
-
Configure the CData JDBC Driver for Pipedrive in a Connection Pool in Tomcat
Connect to Pipedrive from a connection pool in Tomcat.
-
Getting Started with the CData Excel Add-In for JSON
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for JSON.
-
Build Semantic Layer Views for BigQuery in APOS Live Data Gateway
Use the CData Connector for BigQuery in APOS Live Data Gateway to build Semantic Layer Views for Google BigQuery.
-
Use JayDeBeApi to access Coinbase in Python
Use standard Python scripting and the development environment of your choice to access live Coinbase.
-
Connect to Live LinkedIn in MicroStrategy through CData Connect AI
Create a live connection to LinkedIn in CData Connect AI and connect to your LinkedIn from MicroStrategy.
-
LINQ to SAP Concur
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the SAP Concur Data Provider.
-
Automated Typeform Replication to Teradata
Use CData Sync to Customize and automate Typeform replication to Teradata.
-
Easily Integrate Drift in Lazarus Pascal IDE
Learn how to easily integrate live Drift in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to JotForm Using the Script Function in Claris FileMaker Pro
-