CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Certinia Replication to Oracle
Use CData Sync for automated, continuous, customizable Certinia replication to Oracle.
-
Build Visualizations of Splunk in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Splunk in Birst.
-
Access Klaviyo from MySQL in Amazon QuickSight
Connect to Klaviyo and build visualizations of Klaviyo using a MySQL Connection in Amazon QuickSight.
-
Rapidly Develop MongoDB-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.
-
Establish a Live Connection with Oracle HCM Cloud using Tableau Bridge
The CData ODBC Driver for Oracle HCM Cloud enables you to integrate live Oracle HCM Cloud into Tableau Cloud dashboards using the Tableau Bridge.
-
A PostgreSQL Interface for FTP using the CData ODBC Driver
Use the SQL Gateway and FTP ODBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Azure Synapse from Tableau
Use the Tableau Desktop business intelligence tool to connect to Azure Synapse.
-
Automate Vault CRM Replication to Azure Synapse
Use CData Sync to customize and automate Veeva Vault & Vault CRM replication to Azure Synapse.
-
How to create an RPA flow for Oracle Financials Cloud in UiPath Studio
Use the Oracle Financials Cloud ODBC Driver to create workflows that access real-time Oracle Financials Cloud without any coding.
-
Quickbase Reporting in OBIEE with the Quickbase JDBC Driver
Deploy the Quickbase JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build Dashboards with Twitter Ads in Dundas BI
Create dynamic dashboards and perform analytics based on Twitter Ads in Dundas BI.
-
Excel Spreadsheet Automation on MarkLogic with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
How to Create Power BI Visual Reports with Real-Time JotForm
Use CData Power BI Connectors to visualize JotForm in Power BI.
-
ETL Sugar CRM in Oracle Data Integrator
This article shows how to transfer Sugar CRM into a data warehouse using Oracle Data Integrator.
-
DataBind Dynamics CRM to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Dynamics CRM with the DevExpress Windows Forms and Web controls to provide Microsoft Dynamics CRM to a chart.
-
Connect to and Query RSS Feeds in QlikView over ODBC
Create data visualizations with RSS Feeds in QlikView.
-
Build SAP BusinessObjects BI-Connected Apps in Choreo
Use CData Connect AI to connect to SAP BusinessObjects BI from Choreo and build custom apps using live SAP BusinessObjects BI.
-
How to Connect to Live Microsoft Planner from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Microsoft Planner for you.
-
How to import Workday into Apache Solr
Use the CData Software JDBC Driver for Workday in Data Import Handler and create an automated import of Workday to Apache Solr Enterprise Search platform.
-
ETL ClickUp in Oracle Data Integrator
This article shows how to transfer ClickUp into a data warehouse using Oracle Data Integrator.
-
Connect to Calendly from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Calendly using standard SQL.
-
Query, Visualize, and Share live Azure Table in Redash
Use CData Connect AI to connect to live Azure Table Storage in Redash for querying, visualizing, and sharing.
-
Connect Zoho CRM to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Zoho CRM with IBM WebSphere for seamless data integration and connectivity.
-
Visualize Spark in Sisense
Create an ElastiCube in Sisense app with access to Apache Spark SQL.
-
How to Connect to Live SingleStore from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your SingleStore for you.
-
Automated Continuous Google Search Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Google Search replication to delimited files (CSV/TSV).
-
Publish Crystal Reports on SAP Concur
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SAP Concur.
-
How to work with Google Cloud Storage in Apache Spark using SQL
Access and process Google Cloud Storage in Apache Spark using the CData Software JDBC Driver.
-
How to integrate QuickBooks Online with Apache Airflow
Access and process QuickBooks Online in Apache Airflow using the CData JDBC Driver.
-
How to Create Power BI Visual Reports with Real-Time Amazon DynamoDB
Use CData Power BI Connectors to visualize Amazon DynamoDB in Power BI.
-
Analyze Redshift in R via JDBC
Use standard R functions and the development environment of your choice to analyze Amazon Redshift with the CData JDBC Driver for Redshift.
-
LINQ to Excel
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 Excel Data Provider.
-
Migrating data from Basecamp to Databricks using CData SSIS Components.
Easily push Basecamp to Databricks using the CData SSIS Tasks for Basecamp and Databricks.
-
Visualize Live OneNote of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Microsoft OneNote using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Connect to Live GraphQL 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 GraphQL for you.
-
Build a Simple VCL Application for IBM Informix
How to build a simple VCL Application to view IBM Informix in RAD Studio using the CData ODBC Driver for IBM Informix.
-
DataBind Charts to YouTube Analytics
Use the standard ADO.NET procedures for databinding to provide bidirectional access to YouTube Analytics 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.
-
View Reports on Real-Time ShipStation in Power BI Report Server
Use the CData ODBC Driver for ShipStation to visualize ShipStation in Power BI Desktop and then publish them to Power BI Report Server.
-
Access Live Salesforce Marketing in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Salesforce Marketing Cloud into the statistical analysis tools available in SAS JMP. This article shows how to use Salesforce Marketing Cloud in the Graph Builder and Query Builder.
-
How to connect to Sage 300 with Squirrel SQL client
Connect to Sage 300 and execute queries in the Squirrel SQL Client.
-
Visualize Lakebase in Tableau
The CData ODBC driver for Lakebase enables you integrate Lakebase into Tableau dashboards.
-
Create Informatica Mappings From/To a JDBC Data Source for Amazon S3
Create Amazon S3 data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Salesforce Pardot in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Create Informatica Mappings From/To an ODBC Data Source for Coinbase
Create an ODBC connection to Coinbase in Informatica and browse and transfer Coinbase.
-
Edit and Search SharePoint Excel Services External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of SharePoint Excel Services to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create SharePoint Excel Services objects that you can access from apps and the dashboard.
-
Import Kintone Using Azure Data Factory
Use CData Connect AI to connect to Kintone from Azure Data Factory and import live Kintone.
-
How to create LinkedIn federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for LinkedIn in MySQL .
-
How to connect to Salesforce from IntelliJ
Integrate connectivity to Salesforce & Force.com with wizards in IntelliJ.
-
How to Import Data from Presto into Google Sheets
Import Presto into a Google spreadsheet that is automatically refreshed.
-
Use the CData Software ODBC Driver for Certinia in MicroStrategy Web
Connect to Certinia in MicroStrategy Web using the CData Software ODBC Driver for Certinia.
-
Add Zendesk to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Zendesk with the Informatica Enterprise Data Catalog to classify and organize data.
-
Visualize Oracle Eloqua in Sisense
Create an ElastiCube in Sisense app with access to Oracle Eloqua.
-
Visualize Adobe Analytics in TIBCO Spotfire through OData
Integrate Adobe Analytics into dashboards in TIBCO Spotfire.
-
How to integrate EnterpriseDB with Apache Airflow
Access and process EnterpriseDB in Apache Airflow using the CData JDBC Driver.
-
Access Live Google Directory in TIBCO Data Virtualization
-