CData Software - Knowledge Base
Recent Articles
-
Connect to NetSuite in Ruby
Connect to NetSuite CRM & ERP in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Model, Search, and Visualize Live API in ThoughtSpot
Use CData Connect AI to connect to live API for modeling, searching, and visualizing.
-
Connect to Microsoft Exchange as an External Source in Dremio
Use the CData JDBC Driver to connect to Microsoft Exchange as an External Source in Dremio.
-
Natively Connect to Twilio in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Twilio. Leverage the native support for ODBC in PHP.
-
Connect Harvest to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Harvest with IBM WebSphere for seamless data integration and connectivity.
-
Integrate with Twitter Ads using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Twitter Ads to a JSON file on disk.
-
Build Apps with Live Raisers Edge NXT in Adalo using CData Connect AI
Use CData Connect AI to integrate live Raisers Edge NXT into the Adalo platform and build custom mobile and web applications with real-time Raisers Edge NXT.
-
Build Dynamics 365 Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Microsoft Dynamics 365 and build visualizations in Tableau.
-
Query HBase as a MySQL Database in Node.js
Execute MySQL queries against Apache HBase from Node.js.
-
Access Live Square in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Square from your Excel spreadsheets.
-
How to Connect to Live PayPal in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live PayPal without replication.
-
Access Live Quickbase in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Quickbase from your Google Sheets.
-
Use the CData SSIS Components to Insert New or Update Existing Sugar CRM Records from SQL Server
Easily push SQL Server data to Sugar CRM using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Sugar CRM or update existing records with data from a SQL Server database.
-
Getting Started with the CData Excel Add-In for Reckon
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Reckon.
-
Automated Continuous Splunk Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Splunk replication to OneLake in Microsoft Fabric.
-
Integrate Invoiced with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Invoiced with External Services.
-
Automated Continuous Redis Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Redis replication to AlloyDB.
-
Access Vault CRM from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Veeva Vault & Vault CRM from HeidiSQL.
-
Connect and Visualize Live Adobe Analytics Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Adobe Analytics into the Databricks platform and create visualization dashboards with real-time Adobe Analytics.
-
Prepare, Blend, and Analyze REST in Alteryx Designer (ODBC)
Build workflows to access live REST for self-service data analytics.
-
Query SAP using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume SAP entities in PHP by modeling them as objects.
-
Analyze eBay in R via JDBC
Use standard R functions and the development environment of your choice to analyze eBay with the CData JDBC Driver for eBay.
-
Publish Monday.com-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Monday.com.
-
A PostgreSQL Interface for LinkedIn Ads using the CData ODBC Driver
Use the SQL Gateway and LinkedIn Ads ODBC Driver to create a PostgreSQL entry-point for data access.
-
Rapidly Develop Kintone-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
DataBind Neo4J to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Neo4J with the DevExpress Windows Forms and Web controls to provide Neo4J to a chart.
-
How to Work with ServiceNow in ETL Validator JDBC
Connect to ServiceNow from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Act CRM Replication to Vertica
Use CData Sync for automated, continuous, customizable Act CRM replication to Vertica.
-
Getting Started with the CData SSIS Components for Twitter Ads
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Twitter Ads.
-
Use the CData Software JDBC Driver for HubDB in MicroStrategy Web
Connect to HubDB in MicroStrategy Web using the CData Software JDBC Driver for HubDB.
-
How to Access Live Databricks in Power Automate Desktop via ODBC
The CData ODBC Driver for Databricks enables you to integrate Databricks into workflows built using Microsoft Power Automate Desktop.
-
Use the CData Software JDBC Driver for Google Ads in MicroStrategy Web
Connect to Google Ads in MicroStrategy Web using the CData Software JDBC Driver for Google Ads.
-
Integrate Bing Ads in the Pentaho Report Designer
Publish reports based on Bing Ads in the Pentaho BI tool.
-
Excel Spreadsheet Automation on Salesforce Marketing with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
How to Work with Access in ETL Validator JDBC
Connect to Access from ETL Validator jobs using the CData Software JDBC Driver.
-
Getting Started with the CData Excel Add-In for Procore
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Procore.
-
Integrate Parquet in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Apache Parquet from Informatica Cloud.
-
Visualize YouTube Analytics in Sisense
Create an ElastiCube in Sisense app with access to YouTube Analytics.
-
A PostgreSQL Interface for PingOne (MySQL Remoting via JDBC)
Use the Remoting features of the PingOne JDBC Driver to create a PostgreSQL entry-point for data access.
-
View Reports on Real-Time Kintone in Power BI Report Server
Use the CData ODBC Driver for Kintone to visualize Kintone in Power BI Desktop and then publish them to Power BI Report Server.
-
Automated Spark Replication to Teradata
Use CData Sync to Customize and automate Apache Spark SQL replication to Teradata.
-
Build MVC Applications with Connectivity to Azure Data Lake Storage
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Azure Data Lake Storage from an ASP.NET MVC application.
-
How to create Salesforce Marketing federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Salesforce Marketing Cloud in MySQL .
-
Use the CData API Server to Access Drift in Microsoft PowerPivot
Use the CData API Server to connect to live Drift in the Power Pivot business intelligence tool.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for LinkedIn Ads
Provide connectivity to LinkedIn Ads through an SAP BusinessObjects universe.
-
Natively Connect to Teradata in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Teradata. Leverage the native support for ODBC in PHP.
-
Manage Amazon S3 in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Amazon S3.
-
How to Connect the Power BI Service to Harvest: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Connect to HBase Using the Script Function in Claris FileMaker Pro
-