CData Software - Knowledge Base
Recent Articles
-
Access Live SAP Concur in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live SAP Concur from your Excel spreadsheets.
-
PowerShell Scripting to Replicate SAP Fieldglass to MySQL
Write a simple PowerShell script to replicate SAP Fieldglass to a MySQL database.
-
Integrating Dataiku with ShipStation via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live ShipStation.
-
Connect to SharePoint from a Connection Pool in Jetty
The SharePoint JDBC Driver supports connection pooling: This article shows how to connect faster to Microsoft SharePoint from Web apps in Jetty.
-
Seamlessly Bring Asana into Retool Using CData Connect AI
Integrate Asana data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Enable the Pipedrive JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Pipedrive.
-
Connect to Dynamics 365 in RapidMiner
Integrate Microsoft Dynamics 365 with standard components and data source configuration wizards in RapidMiner Studio.
-
Bidirectional Access to Acumatica from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Acumatica ERP in Filemaker Pro for Mac or Windows.
-
Automated Continuous Oracle Eloqua Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to Microsoft Access.
-
How to connect to SAP Concur from Spring Boot
Connect to SAP Concur in a Spring Boot Application using CData JDBC SAP Concur Driver
-
Analyze Facebook with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Facebook from Power Pivot. You will use the Table Import Wizard to load Facebook. You can visually build the import query or use any SQL supported by the driver.
-
How to connect to SAP SuccessFactors LMS from IntelliJ
Integrate connectivity to SAP SuccessFactors LMS with wizards in IntelliJ.
-
Access Zoom from MySQL in Amazon QuickSight
Connect to Zoom and build visualizations of Zoom using a MySQL Connection in Amazon QuickSight.
-
Create Informatica Mappings From/To a JDBC Data Source for Azure Table
Create Azure Table data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous Azure Data Lake Storage Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to Azure SQL Database.
-
How to Access Adobe Analytics Using Entity Framework
This article shows how to access Adobe Analytics using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Access Live Twitter Ads in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Twitter Ads from your Google Sheets.
-
Use the CData Software JDBC Driver for IBM Informix in MicroStrategy Desktop
Connect to IBM Informix in MicroStrategy Desktop using the CData Software JDBC Driver for IBM Informix.
-
Analyze SendGrid with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SendGrid from Power Pivot. You will use the Table Import Wizard to load SendGrid. You can visually build the import query or use any SQL supported by the driver.
-
Create Datasets from Access in Domo Workbench and Build Visualizations of Access in Domo
Use the CData Software ODBC Driver for Access to create datasets from Microsoft Access in Domo Workbench and then build visualizations in the Domo service.
-
Create Data Visualizations in Cognos BI with CouchDB
Access Apache CouchDB as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create Twilio-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Twilio from Klipfolio and build custom visualizations using live Twilio.
-
A PostgreSQL Interface for ActiveCampaign using the CData ODBC Driver
Use the SQL Gateway and ActiveCampaign ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Access Live Zoho CRM in Power Automate Desktop via ODBC
The CData ODBC Driver for Zoho CRM enables you to integrate Zoho CRM into workflows built using Microsoft Power Automate Desktop.
-
Connecting GenSpark with BigCommerce via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to enterprise data across 300+ systems without any replication or custom integration required.
-
Query ServiceNow through ODBC in Node.js
Use node-odbc to execute SQL queries against ServiceNow from Node.js.
-
Connect and Query Live Excel Online Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Microsoft Excel Online into Databricks
-
Build MVC Applications with Connectivity to Printful
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Printful from an ASP.NET MVC application.
-
How to Import Data from Oracle into Google Sheets
Import Oracle Database into a Google spreadsheet that is automatically refreshed.
-
Analyze Jira in Cognos Analytics
Use CData Connect AI to connect to Jira from Cognos Analytics and analyze live Atlassian Jira.
-
Automate SAP ByDesign Replication to Azure Synapse
Use CData Sync to customize and automate SAP Business ByDesign replication to Azure Synapse.
-
How to connect Amazon QuickSight to eBay
Create a connection to eBay in CData Connect AI and insert eBay into Amazon QuickSight SPICE to build interactive dashboards.
-
Validate eBay with QuerySurge
Access and validate eBay in QuerySurge using the CData JDBC Driver.
-
Natively Connect to DB2 in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to IBM DB2. Leverage the native support for ODBC in PHP.
-
Getting Started with the CData Power BI Connector for Impala
-