CData Software - Knowledge Base
Recent Articles
-
Access Live Azure DevOps in Coginiti Pro
Connect to and query live Azure DevOps from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to ServiceNow as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live ServiceNow.
-
Establish a Live Connection with Greenhouse using Tableau Bridge
The CData ODBC Driver for Greenhouse enables you to integrate live Greenhouse into Tableau Cloud dashboards using the Tableau Bridge.
-
Getting Started with the CData SSIS Components for EventBrite
Complete guide to installing, licensing, and connecting with the CData SSIS Components for EventBrite.
-
Automated Continuous Dynamics 365 Business Central Replication to SingleStore
Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to SingleStore.
-
How to connect to IBM Cloud Object Storage from IntelliJ
Integrate connectivity to IBM Cloud Object Storage with wizards in IntelliJ.
-
How to import Sugar CRM into Apache Solr
Use the CData Software JDBC Driver for Sugar CRM in Data Import Handler and create an automated import of Sugar CRM to Apache Solr Enterprise Search platform.
-
LINQ to Microsoft OneDrive
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 Microsoft OneDrive Data Provider.
-
Query MariaDB using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume MariaDB entities in PHP by modeling them as objects.
-
Use ChatGPT to Talk to Your Twilio via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Twilio for you.
-
Excel Spreadsheet Automation on Vault CRM with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Automate BigQuery Replication to Azure Synapse
Use CData Sync to customize and automate Google BigQuery replication to Azure Synapse.
-
Connect to SAP Concur in the Denodo Platform
Use CData driver technologies to create a virtual data source for SAP Concur in the Denodo Virtual DataPort Administrator.
-
ETL Pinterest in Oracle Data Integrator
This article shows how to transfer Pinterest into a data warehouse using Oracle Data Integrator.
-
Easily Integrate OneNote in Lazarus Pascal IDE
Learn how to easily integrate live Microsoft OneNote in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to connect to Presto with Squirrel SQL client
Connect to Presto and execute queries in the Squirrel SQL Client.
-
Use the CData Software ODBC Driver for HCL Domino in MicroStrategy
Connect to HCL Domino in MicroStrategy Developer using the CData Software ODBC Driver for HCL Domino.
-
Replicate YouTube Analytics from PowerShell
Write a quick PowerShell script to query YouTube Analytics. Use connectivity to the live data to replicate YouTube Analytics to SQL Server.
-
Create Outreach.io-Connected Applications in Appsmith
Connect to Outreach.io via CData Connect AI in Appsmith and create custom business applications with real-time access to Outreach.io.
-
Use Claude to Talk to Your LinkedIn via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your LinkedIn for you.
-
DataBind Charts to eBay
Use the standard ADO.NET procedures for databinding to provide bidirectional access to eBay from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Analyze Reckon Accounts Hosted in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Reckon Accounts Hosted and visualize Reckon Accounts Hosted in SAP Analytics Cloud.
-
Getting Started with the CData SSIS Components for MongoDB
Complete guide to installing, licensing, and connecting with the CData SSIS Components for MongoDB.
-
Object-Relational Mapping (ORM) with Reckon Accounts Hosted 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 Reckon Accounts Hosted into a Java-based ORM framework, Hibernate.
-
Visualize Live Microsoft Teams in the Power BI Service
Use CData Connect AI to connect to live Microsoft Teams and create custom reports in the Power BI Service through the On-Premises Gateway.
-
CouchDB Reporting in OBIEE with the CouchDB JDBC Driver
Deploy the CouchDB JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to connect to Sage Intacct in DBVisualizer
Integrate Sage Intacct with visual data analysis tools and data connection wizards in DBVisualizer
-
How to publish and share Xero dashboards with Tableau Server
The CData ODBC driver for Xero enables you integrate Xero Accounting into Tableau dashboards.
-
Visualize Live Typeform in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Typeform.
-
Connect to eBay Analytics in Jaspersoft Studio
Execute SQL to remote eBay Analytics in Jaspersoft Studio.
-
Analyze Twitter in Cognos Analytics
Use CData Connect AI to connect to Twitter from Cognos Analytics and analyze live Twitter.
-
Use the CData Software ODBC Driver for SAP in MicroStrategy
Connect to SAP ERP/NetWeaver in MicroStrategy Developer using the CData Software ODBC Driver for SAP.
-
Automated Continuous Twilio Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Twilio replication to delimited files (CSV/TSV).
-
Prepare, Blend, and Analyze HCL Domino in Alteryx Designer (ODBC)
Build workflows to access live HCL Domino for self-service data analytics.
-
Import HubSpot into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access HubSpot. In this article, you will use the OData format to import HubSpot into Microsoft Power Query.
-
Automate Tasks in Power Automate Using the CData API Server
Automate actions like sending emails to a contact list, posting to social media, or syncing CRM and ERP.
-
Access eBay Analytics from MySQL in PHP
Connect to eBay Analytics through the standard MySQL libraries in PHP.
-
How to Build an ETL App for Shopify in Python with CData
Create ETL applications and real-time data pipelines for Shopify in Python with petl.
-
Automate Tasks in Power Automate Using the CData API Server
Automate actions like sending emails to a contact list, posting to social media, or syncing CRM and ERP.
-
Build Apps with Live Apache Cassandra in Adalo using CData Connect AI
Use CData Connect AI to integrate live Apache Cassandra into the Adalo platform and build custom mobile and web applications with real-time Apache Cassandra.
-
Connect to OneNote in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
DataBind Controls to Dynamics NAV in C++Builder
DataBind to Microsoft Dynamics NAV in C++Builder with standard components and controls.
-
Connect and Visualize Live Paylocity Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Paylocity into the Databricks platform and create visualization dashboards with real-time Paylocity.
-
Access Jira Assets from MySQL in Amazon QuickSight
Connect to Jira Assets and build visualizations of Jira Assets using a MySQL Connection in Amazon QuickSight.
-
Connect to SendGrid in the Denodo Platform
Use CData driver technologies to create a virtual data source for SendGrid in the Denodo Virtual DataPort Administrator.
-
How to Connect to Live Zoho Projects Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Zoho Projects securely in real time.
-
Integrate Google Search Results into Power Automate Desktop using CData Connect
CData Connect for Google Search Results enables you to integrate Google Search into workflows built using Microsoft Power Automate Desktop.
-
Build Data Flows from SQL Server to MongoDB through SSIS
Easily push SQL Server data to MongoDB using the CData SSIS Tasks for MongoDB.
-
Create SAP SuccessFactors-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to SAP SuccessFactors from OutSystems and build custom enterprise apps using live SAP SuccessFactors.
-
ETL Epicor Kinetic in Oracle Data Integrator
This article shows how to transfer Epicor Kinetic into a data warehouse using Oracle Data Integrator.
-
Connect to Google Spanner from a Connection Pool in WebLogic
Use the CData JDBC Driver for Google Spanner to connect to Google Spanner from Web applications running on WebLogic.
-
Connect to Act-On in ACL Analytics
Connect to Act-On via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Act-On.
-
Automated Continuous Zuora Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Zuora replication to Microsoft Access.
-
PowerShell Scripting to Replicate Microsoft OneDrive to MySQL
Write a simple PowerShell script to replicate Microsoft OneDrive to a MySQL database.
-
How to integrate Metabase with Sage Intacct
Use CData Connect AI to connect to live Sage Intacct and create an interactive dashboard in Metabase from Sage Intacct.
-
Integrate Live Snapchat Ads into Blue Prism for Intelligent Robotic Process Automation (RPA)
-