CData Software - Knowledge Base
Recent Articles
-
Model, Search, and Visualize Live Twitter in ThoughtSpot
Use CData Connect AI to connect to live Twitter for modeling, searching, and visualizing.
-
Perform Batch Operations with SAS Data Sets in Apache NiFi
Connect to SAS Data Sets and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Analyze Redshift with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Redshift from Power Pivot. You will use the Table Import Wizard to load Amazon Redshift. You can visually build the import query or use any SQL supported by the driver.
-
Bind Live Excel Online Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Excel Online data
-
Automated Continuous Neo4J Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Neo4J replication to Google BigQuery.
-
Use the CData ODBC Driver for Cassandra from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Cassandra to connect to Apache Cassandra from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Apache Cassandra in Excel.
-
How to update HubDB from Excel
This article explains how to transfer data from Excel to HubDB using the Excel Add-In for HubDB.
-
Access MySQL from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live MySQL from HeidiSQL.
-
Automated Continuous SAP Concur Replication to Snowflake
Use CData Sync for automated, continuous, customizable SAP Concur replication to Snowflake.
-
Connect to Dynamics CRM in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Dynamics CRM and connect to Microsoft Dynamics CRM in Akorbi Digital RunMyProcess.
-
Connect to Freshdesk in HULFT Integrate
Connect to Freshdesk as a JDBC data source in HULFT Integrate
-
Publish Reports with Twitter in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Twitter.
-
LinkedIn Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on LinkedIn facts in real time.
-
Getting Started with the CData ODBC Driver for Raisers Edge NXT
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Raisers Edge NXT.
-
Connecting Mastra with Hive via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time data across 300+ enterprise sources no replication required.
-
Create Data Visualizations in Cognos BI with Oracle Financials Cloud
Access Oracle Financials Cloud as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Import and Visualize Google Directory in Power View
Create data visualizations based on Google Directory in Excel.
-
Automated Continuous CouchDB Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable CouchDB replication to Apache Cassandra.
-
Import NetSuite into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access NetSuite CRM & ERP. In this article, you will use the OData format to import NetSuite CRM & ERP into Microsoft Power Query.
-
How to Connect the Power BI Service to Google Spanner: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Integrate BigCommerce in Pentaho Data Integration
Build ETL pipelines based on BigCommerce in the Pentaho Data Integration tool.
-
Visualize Azure Active Directory from Tableau
Use the Tableau Desktop business intelligence tool to connect to Azure Active Directory.
-
How to load Calendly data into Elasticsearch via Logstash
Introducing a simple method to load Calendly data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Work with Greenplum in FoxPro
Load Pivotal GreenPlum into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build a Singer.io Tap for Box With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Box data using
-
How to Connect DBeaver to SharePoint Excel Services via a JDBC Driver
Manage SharePoint Excel Services with visual tools in DBeaver like the query browser.
-
Analyze Parquet in Infragistics Reveal
Use the CData API Server to create an OData API on top of Apache Parquet and visualize live Apache Parquet in Infragistics Reveal.
-
Build a PostgreSQL Interface for SAP Netweaver Gateway using the CData JDBC Driver
Use the Remoting features of the SAP Netweaver Gateway JDBC Driver to create a PostgreSQL entry-point for data access.
-
Enable the Salesforce JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Salesforce & Force.com.
-
How to Connect the Power BI Service to Salesforce Pardot: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Build SQL Server-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Microsoft SQL Server and build web apps with connectivity to live Microsoft SQL Server.
-
Automated Continuous Wave Financial Replication to SQL Server
Use CData Sync for automated, continuous, customizable Wave Financial replication to SQL Server.
-
Analyze IBM Informix in Cognos Analytics
Use CData Connect AI to connect to IBM Informix from Cognos Analytics and analyze live IBM Informix.
-
Work with Procore in FoxPro
Load Procore into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous Adobe Commerce Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to Apache Kafka.
-
Automated Continuous Calendly Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Calendly replication to PostgreSQL.
-
How to Access Presto Using Entity Framework
This article shows how to access Presto using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Blackbaud FE NXT from Asprova with CData Software ODBC Driver for Blackbaud FE NXT
This article shows how to connect faster to Blackbaud FE NXT data from Asprova.
-
PowerShell Scripting to Replicate Splunk to MySQL
Write a simple PowerShell script to replicate Splunk to a MySQL database.
-
Connect to Live Outreach.io in MicroStrategy through CData Connect AI
Create a live connection to Outreach.io in CData Connect AI and connect to your Outreach.io from MicroStrategy.
-
Build a Singer.io Tap for Acumatica With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Acumatica data using
-
Automate SAP BusinessObjects BI Replication to Azure Data Lake
Use CData Sync to customize and automate SAP BusinessObjects BI replication to Azure Data Lake.
-
Automated Continuous Reckon Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Reckon replication to Apache Kafka.
-
Query Blackbaud FE NXT using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Blackbaud FE NXT entities in PHP by modeling them as objects.
-
Create Microsoft Planner-Connected Business Apps in AppSheet
Connect to Microsoft Planner via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Microsoft Planner.
-
Query, Visualize, and Share live Sage Cloud Accounting in Redash
Use CData Connect AI to connect to live Sage Business Cloud Accounting in Redash for querying, visualizing, and sharing.
-
Unbounce Reporting in OBIEE with the Unbounce JDBC Driver
Deploy the Unbounce JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Access Live Salesforce Marketing in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Salesforce Marketing Cloud from your Google Sheets.
-
Integrate EnterpriseDB with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate EnterpriseDB with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to EnterpriseDB.
-
Connect to EnterpriseDB from Asprova with CData Software ODBC Driver for EnterpriseDB
This article shows how to connect faster to EnterpriseDB data from Asprova.
-
Connect to Elasticsearch from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Elasticsearch from Filemaker Pro on Mac.
-
Access Live Tableau CRM Analytics in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Tableau CRM Analytics into the statistical analysis tools available in SAS JMP. This article shows how to use Tableau CRM Analytics in the Graph Builder and Query Builder.
-
Integrating LinkedIn in Talend Cloud Data Management Platform
-