CData Software - Knowledge Base
Recent Articles
-
Analyze HBase with Power Pivot
This article walks you through the process of using the CData ODBC Driver for HBase from Power Pivot. You will use the Table Import Wizard to load Apache HBase. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Azure DevOps from a Connection Pool in Jetty
The Azure DevOps JDBC Driver supports connection pooling: This article shows how to connect faster to Azure DevOps from Web apps in Jetty.
-
Replicate Sybase from PowerShell
Write a quick PowerShell script to query Sybase. Use connectivity to the live data to replicate Sybase to SQL Server.
-
Connecting Agentforce with Slack 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 Slack for you.
-
How to Access SAP Netweaver Gateway Using Entity Framework
This article shows how to access SAP Netweaver Gateway using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Create EventBrite Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time EventBrite data access from reports, embedded analytics, and more.
-
Automated Continuous LinkedIn Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable LinkedIn replication to Apache Kafka.
-
Excel Spreadsheet Automation on Act-On with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Add Lakebase to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Lakebase with the Informatica Enterprise Data Catalog to classify and organize data.
-
Access Live Zoho CRM in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Zoho CRM from your Google Sheets.
-
Access Live Adobe Commerce in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Adobe Commerce from your Excel spreadsheets.
-
Excel Spreadsheet Automation on Twilio with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Build Cassandra Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Apache Cassandra and build visualizations in Tableau.
-
Access Amazon DynamoDB from MySQL in PHP
Connect to Amazon DynamoDB through the standard MySQL libraries in PHP.
-
Import Real-Time Redshift via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Amazon Redshift in ColdFusion.
-
Access Bing Ads from MySQL in PHP
Connect to Bing Ads through the standard MySQL libraries in PHP.
-
Connect to Gmail from PowerBuilder via JDBC
This article demonstrates how to access Gmail from PowerBuilder using the Gmail JDBC Driver.
-
Connect to Microsoft Project from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Microsoft Project, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect SFTP to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SFTP using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create Reports with QuickBooks in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date QuickBooks Desktop.
-
Provide OData Services of RSS Feeds from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for RSS Feeds by developing a WCF Service Application.
-
How to Use a Microsoft Access Database to Update Basecamp in Real Time
Update Basecamp data by creating a linked table in Microsoft Access with the CData Basecamp ODBC Driver.
-
Connect to Outreach.io in ACL Analytics
Connect to Outreach.io via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Outreach.io.
-
Connect to Active Directory in the Denodo Platform
Use CData driver technologies to create a virtual data source for Active Directory in the Denodo Virtual DataPort Administrator.
-
A PostgreSQL Interface for SAP HANA XS Advanced (MySQL Remoting via JDBC)
Use the Remoting features of the SAP HANA XS Advanced JDBC Driver to create a PostgreSQL entry-point for data access.
-
Bind Live Coinbase Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Coinbase data
-
Build Data Flows from SendGrid to SQL Server using SSIS
Easily back up SendGrid to SQL Server using the SSIS components for SendGrid.
-
Use the CData ODBC Driver for Epicor Kinetic from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Epicor Kinetic to connect to Epicor Kinetic from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Epicor Kinetic in Excel.
-
Automate Google Ads Replication to Couchbase
Use CData Sync to Customize and automate Google Ads replication to Couchbase.
-
Build AI/ML Models with Live SAP BusinessObjects BI Data using Dataiku
-