CData Software - Knowledge Base
Recent Articles
-
Connect to Freshservice Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Freshservice as an External Source in Dremio.
-
Automated Continuous Nethunt Replication to SingleStore
Use CData Sync for automated, continuous, customizable Nethunt replication to SingleStore.
-
Gumroad Reporting in OBIEE with the Gumroad JDBC Driver
Deploy the Gumroad JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build MVC Applications with Connectivity to ADP Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access ADP from an ASP.NET MVC application.
-
Object-Relational Mapping (ORM) with Microsoft OneDrive Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Microsoft OneDrive into a Java-based ORM framework, Hibernate.
-
Process & Analyze Act CRM Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Act CRM Data.
-
Automated Continuous Salesforce Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Salesforce replication to Google Cloud SQL.
-
Connect to Okta Data in HULFT Integrate
Connect to Okta as a JDBC data source in HULFT Integrate
-
How to Seamlessly Import Pipeliner CRM Data into IBM SPSS Modeler
Integrate Pipeliner CRM data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Natively Connect to LinkedIn Ads Data in PHP
The CData ODBC driver for LinkedIn Ads enables you to create PHP applications with connectivity to LinkedIn Ads. Leverage the native support for ODBC in PHP.
-
Integrate with Microsoft Teams Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Microsoft Teams to a JSON file on disk.
-
Integrating GitHub Copilot CLI with Tickspot via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Work with SendInBlue Data in FoxPro
Load SendInBlue into a FoxPro database. This article includes full code and a walk-through of the process.
-
Access Live ADP Data in TIBCO Data Virtualization
Use the ADP Tibco DV Adapter to create a ADP data source in TIBCO Data Virtualization Studio and gain access to live ADP from your TDV Server.
-
How to Query Azure Synapse Data in MySQL Workbench
Execute MySQL queries against live Azure Synapse from MySQL Workbench.
-
Analyze Live Sugar CRM Data in SAS Viya
Use CData Connect AI to connect to Sugar CRM from SAS Viya and deploy self-service analytics using live Sugar CRM.
-
Connect to and Visualize Live Bullhorn CRM Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Bullhorn CRM.
-
Automated Continuous FreeAgent Replication to MySQL
Use CData Sync for automated, continuous, customizable FreeAgent replication to MySQL.
-
Build Shippo-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Shippo and build web apps with connectivity to live Shippo.
-
Analyze Live FreshBooks Data in SAS Viya
Use CData Connect AI to connect to FreshBooks from SAS Viya and deploy self-service analytics using live FreshBooks.
-
Connect to EmailOctopus Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for EmailOctopus and the SQL Gateway to access EmailOctopus from Google Apps Script.
-
Query eBay Data from Node.js
Use the OData endpoint of the CData API Server to connect to your eBay and perform CRUD operations on eBay from Node.js.
-
Integrate Real-Time Access to Avalara AvaTax in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Avalara AvaTax in real time.
-
Connect to Azure DevOps Data in Claris FileMaker Pro
Use the CData ODBC Driver for Azure DevOps in FileMaker Pro to connect to Azure DevOps and work with Azure DevOps in your FileMaker applications.
-
Connect to Drift Data in NetBeans
Connect to Drift in NetBeans with the data source configuration wizard.
-
How to Import Data from Adobe Target into Google Sheets
Import Adobe Target into a Google spreadsheet that is automatically refreshed.
-
Explore Geographical Relationships in SAP Ariba Procurement Data with Power Map
Create data visualizations with SAP Ariba Procurement in Power Map.
-
Query SAP HANA Data as a MySQL Database in Node.js
Execute MySQL queries against SAP HANA from Node.js.
-
DataBind Controls to FTP Data in C++Builder
DataBind to FTP Servers in C++Builder with standard components and controls.
-
Integrating Antigravity CLI with Oracle Service Cloud via CData CLI
Connect Oracle Service Cloud to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrating OpenCode Terminal with Reckon Accounts Hosted Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Configure the CData JDBC Driver for Snowflake in a Connection Pool in Tomcat
Connect to Snowflake from a connection pool in Tomcat.
-
Automated Continuous ShipStation Replication to Vertica
Use CData Sync for automated, continuous, customizable ShipStation replication to Vertica.
-
Query SAP Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SAP ERP/NetWeaver from Node.js.
-
Replicate Multiple Mailjet Accounts via the CData Sync CLI
Replicate multiple Mailjet accounts to one or many databases.
-
Model Snapchat Ads Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Snapchat Ads, enabling the direct import of real-time Snapchat Ads.
-
Connecting to Apache Doris with a CData MySQL Connector
A guide to using the CData MySQL JDBC Driver to talk to Apache Doris
-
Automate Salesforce Data Replication to Azure Synapse
Use CData Sync to customize and automate Salesforce & Force.com replication to Azure Synapse.
-
Automated Continuous Twilio Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Twilio replication to IBM DB2.
-
Integrating Antigravity CLI with Aweber via CData CLI
Connect Aweber to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to Connect to Live Impala Data 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 Impala for you.
-
Build a PostgreSQL Interface for AdRoll Data using the CData JDBC Driver
Use the Remoting features of the AdRoll JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build AI/ML Models with Live HDFS Data using Dataiku
Connect HDFS Data with Dataiku using the CData JDBC Driver for HDFS.
-
Connect to QuickBooks Time Data from PowerBuilder via JDBC
This article demonstrates how to access QuickBooks Time from PowerBuilder using the QuickBooks Time JDBC Driver.
-
Access Live CockroachDB Data in Coginiti Pro
Connect to and query live CockroachDB from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Manage Oracle Sales Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Oracle Sales.
-
Moving Data from Perplexity to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Perplexity data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Import Kintone Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Kintone Data and provide access to live Kintone for custom reports in the Power BI Service.
-
Automate Notion Data Replication to Azure Synapse
Use CData Sync to customize and automate Notion replication to Azure Synapse.
-
Extract, Transform, and Load Gmail Data in Informatica PowerCenter
Create a simple Workflow for Gmail in Informatica PowerCenter.
-
Build AI/ML Models with Live Active Directory Data using Dataiku
Connect Active Directory Data with Dataiku using the CData JDBC Driver for Active Directory.
-
Create SSAS Tabular Models from Sentry Data
How to build a SQL Server Analysis Service Tabular Model from Sentry using CData drivers.
-
Getting Started with the CData ADO.NET Provider for Sugar CRM
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Sugar CRM.
-
Create SendGrid-Connected Dashboards in Grafana
Connect to SendGrid Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to SendGrid.
-
How to publish and share QuickBooks Time Data dashboards with Tableau Server
The CData ODBC driver for QuickBooks Time enables you integrate QuickBooks Time into Tableau dashboards.
-
Build AI Agents with Cassandra Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Apache Cassandra through CData Connect AI.
-
Connect to Telegram Data in DBArtisan
Use wizards in DBArtisan to configure Telegram as a data source.
-
Viewing SAP Data in RAD Studio Data Explorer
How to view SAP ERP/NetWeaver in RAD Studio Data Explorer using the CData ODBC Driver for SAP.
-
Automated Continuous Unbounce Replication to Vertica
Use CData Sync for automated, continuous, customizable Unbounce replication to Vertica.
-
Model Sage Cloud Accounting Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Sage Cloud Accounting, enabling the direct import of real-time Sage Business Cloud Accounting.
-
Use Biml to Build SSIS Tasks to Replicate Onfleet Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Onfleet to SQL Server.
-
Import Real-Time Dynamics CRM Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Microsoft Dynamics CRM in ColdFusion.
-
How to integrate Metabase with Smartsheet Data
Use CData Connect AI to connect to live Smartsheet and create an interactive dashboard in Metabase from Smartsheet.
-
Build SAP Ariba Source-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live SAP Ariba Source.
-
Getting Started with the CData Excel Add-In for Presto
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Presto.
-
Use Microsoft Copilot Studio to talk to your Jira Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Atlassian Jira for you.
-
Automated Continuous Phoenix Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Phoenix replication to AlloyDB.
-
Integrate Goose with Live Dropbox Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Dropbox from within the local AI agent.
-
How to Connect the Power BI Service to Oracle HCM Cloud: Complete Guide
Connect to the CData Software Power BI Connector for Oracle HCM Cloud from PowerBI.com to provide real-time Oracle HCM Cloud across the organization.
-
Integrating GitHub Copilot CLI with SAP Fieldglass via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Connect to Pipeliner CRM Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Pipeliner CRM and work with Pipeliner CRM in your FileMaker applications.
-
Create Dashboards and Visualize Live Presto Data in Geckoboard
Use CData Connect AI to connect to live Presto and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Work with Live Salesforce Marketing Data in Power Query
Use CData Connect AI to connect to Salesforce Marketing Cloud and work with live Salesforce Marketing Cloud in Microsoft Power Query.
-
Connect to Quickbase Data in HULFT Integrate
Connect to Quickbase as a JDBC data source in HULFT Integrate
-
Automated Continuous CData Connect AI Replication to SingleStore
Use CData Sync for automated, continuous, customizable CData Connect AI replication to SingleStore.
-
Build Shopify-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Shopify.
-
How to Access Oracle SCM Data Using Entity Framework
This article shows how to access Oracle SCM using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Asana Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Asana in Airbyte.
-
Import and Visualize QuickBooks Online Data in Power View
Create data visualizations based on QuickBooks Online in Excel.
-
Connect to and Query PDFMonkey Data in QlikView over ODBC
Create data visualizations with PDFMonkey in QlikView.
-
How to create Visio diagrams from Marketo Data
Automatically update Marketo with the changes you make to Visio master shapes.
-
Natively Connect to Omnisend Data in PHP
The CData ODBC driver for Omnisend enables you to create PHP applications with connectivity to Omnisend. Leverage the native support for ODBC in PHP.
-
Getting Started with the CData SSIS Components for AdRoll
Complete guide to installing, licensing, and connecting with the CData SSIS Components for AdRoll.
-
Import Amazon DynamoDB Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Amazon DynamoDB Data and provide access to live Amazon DynamoDB for custom reports in the Power BI Service.
-
Visualize Live Zoho CRM Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Zoho CRM into custom reports in Power BI.
-
How to create an RPA flow for Act-On Data in UiPath Studio
Use the Act-On ODBC Driver to create workflows that access real-time Act-On without any coding.
-
Analyze Impala Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Apache Impala and visualize Apache Impala in SAP Analytics Cloud.
-
Use the CData Software ODBC Driver for Dynamics 365 Business Central in SAS for Real-Time Reporting and Analytics
Connect to real-time Dynamics 365 Business Central in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Dynamics 365 Business Central.
-
Automated Continuous Egnyte Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Egnyte replication to IBM DB2.
-
Automated Continuous SAP ByDesign Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SAP ByDesign replication to Amazon S3.
-
DataBind Controls to Sage 200 Data in C++Builder
DataBind to Sage 200 in C++Builder with standard components and controls.
-
Connect to HelloSign Data in Jaspersoft Studio
Execute SQL to remote HelloSign in Jaspersoft Studio.
-
Query CouchDB Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Apache CouchDB from Node.js.
-
Manage SharePoint Excel Services Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SharePoint Excel Services.
-
Connect to Hive Data from PowerBuilder via ADO.NET
This article demonstrates how to access Apache Hive from Appeon PowerBuilder using the CData ADO.NET Provider for Hive.
-
LINQ to Google Ads Data
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 Google Ads Data Provider.
-
Analyze Square Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Square with the CData JDBC Driver for Square.
-
Use the CData Software JDBC Driver for Clari in MicroStrategy Web
Connect to Clari in MicroStrategy Web using the CData Software JDBC Driver for Clari.
-
Connect to ADP Data in NetBeans
Connect to ADP in NetBeans with the data source configuration wizard.
-
Connect to Oracle Eloqua Reporting Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital