CData Software - Knowledge Base

Recent Articles

---

• «
• 1017
• 1018
• 1019
• 1020
• 1021
• 1022
• 1023
• 1024
• 1025
• 1026
• »

• Build an OLAP Cube in SSAS from Certinia Data

  Establish a connection to Certinia data from SQL Server Analysis Services, and use the Certinia Data Provider to build OLAP cubes for use in analytics and reporting.

• Query Pinterest Data in ColdFusion

  Write standard ColdFusion data access code to connect to Pinterest.

• Build a Simple VCL Application for Excel Online Data

  How to build a simple VCL Application to view Microsoft Excel Online in RAD Studio using the CData ODBC Driver for Excel Online.

• Getting Started with the CData SSIS Components for Freshsales

  Complete guide to installing, licensing, and connecting with the CData SSIS Components for Freshsales.

• Build a Simple VCL Application for Grafana Data

  How to build a simple VCL Application to view Grafana in RAD Studio using the CData ODBC Driver for Grafana.

• Getting Started with the CData Connect AI Python SDK for GitLab

  Install the CData Connect AI Python SDK to read and write live GitLab with standard DB-API 2.0 Python code.

• Connect to Adobe Experience Manager Data in DBeaver

  Use the CData ODBC Driver to connect to Adobe Experience Manager in DBeaver.

• Publish Cassandra-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Apache Cassandra.

• Connect to Impala Data in ACL Analytics

  Connect to Apache Impala via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Apache Impala.

• Using the CData Software ODBC Driver for SAP HANA XS Advanced in PyCharm

  Connect to SAP HANA XS Advanced as an ODBC data source in PyCharm using the CData Software ODBC Driver for SAP HANA XS Advanced.

• Create SSAS Tabular Models from Drip Data

  How to build a SQL Server Analysis Service Tabular Model from Drip using CData drivers.

• How to Query JobNimbus Data in MySQL Workbench

  Execute MySQL queries against live JobNimbus from MySQL Workbench.

• Create Reports from MYOB AccountRight Data in Looker Studio

  Use CData Connect AI to gain access to live MYOB AccountRight and create custom reports in Looker Studio.

• Connect to Marketo Data in Ruby

  Connect to Marketo in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Integrate Cline with Live Google Contacts Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Google Contacts from within your IDE.

• Query Microsoft Dataverse Data through ODBC in Node.js

  Use node-odbc to execute SQL queries against Microsoft Dataverse (CDS) from Node.js.

• Migrating data from Reckon Accounts Hosted to Databricks using CData SSIS Components.

  Easily push Reckon Accounts Hosted to Databricks using the CData SSIS Tasks for Reckon Accounts Hosted and Databricks.

• Integrating LlamaIndex with Cosmos DB Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Azure Cosmos DB in real time.

• Migrating data from Miro to Google BigQuery using CData SSIS Components.

  Easily push Miro to Google BigQuery using the CData SSIS Tasks for Miro and Google BigQuery.

• Build Pipelines with Live Amazon Marketplace Data in Google Cloud Data Fusion (via CData Connect AI)

  Use CData Connect AI to connect to Amazon Marketplace from Google Cloud Data Fusion, enabling the integration of live Amazon Marketplace into the building and management of effective data pipelines.

• Create Datasets from SuiteCRM in Domo Workbench and Build Visualizations of SuiteCRM Data in Domo

  Use the CData Software ODBC Driver for SuiteCRM to create datasets from SuiteCRM in Domo Workbench and then build visualizations in the Domo service.

• Connect to Live Marketo Data in MicroStrategy through CData Connect AI

  Create a live connection to Marketo Data in CData Connect AI and connect to your Marketo from MicroStrategy.

• LINQ to Quaderno 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 Quaderno Data Provider.

• Replicate Cassandra Data to Multiple Databases via the CData Sync CLI

  Replicate Apache Cassandra to disparate databases with a single configuration.

• Visualize SAP SuccessFactors Data in Sisense

  Create an ElastiCube in Sisense app with access to SAP SuccessFactors.

• Connect to MarkLogic Data in HULFT Integrate

  Connect to MarkLogic as a JDBC data source in HULFT Integrate

• Integrating OpenCode Terminal with Mailgun 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.

• Build a Simple VCL Application for Zoho Inventory Data

  How to build a simple VCL Application to view Zoho Inventory in RAD Studio using the CData ODBC Driver for Zoho Inventory.

• Build Apps with Live LinkedIn Data Using the Low-Code Development Platform of Mendix

  Connect LinkedIn with Mendix to build apps using the CData JDBC Driver for LinkedIn.

• DataBind Controls to Dynamics NAV Data in C++Builder

  DataBind to Microsoft Dynamics NAV in C++Builder with standard components and controls.

• Gmail Data Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to Gmail through CData Connect AI using different applications and tools.

• Build Dashboards with Qualaroo Data in DBxtra

  Create dynamic dashboards and perform analytics based on Qualaroo in DBxtra.

• Query Sugar CRM Data from Node.js

  Use the OData endpoint of the CData API Server to connect to your Sugar CRM and perform CRUD operations on Sugar CRM from Node.js.

• Import Real-Time Odoo Data via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Odoo ERP in ColdFusion.

• Access Hugging Face Data from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Hugging Face from HeidiSQL.

• Connect to Oracle Sales Data in Ruby

  Connect to Oracle Sales in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Create Datasets from Amazon DynamoDB in Domo Workbench and Build Visualizations of Amazon DynamoDB Data in Domo

  Use the CData Software ODBC Driver for Amazon DynamoDB to create datasets from Amazon DynamoDB in Domo Workbench and then build visualizations in the Domo service.

• Connect to Cassandra Data in Aqua Data Studio

  Access Apache Cassandra from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Natively Connect to Bannerbear Data in PHP via ODBC (Linux)

  Create PHP applications on Linux/UNIX machines with connectivity to Bannerbear. Leverage the native support for ODBC in PHP.

• Connect to Neo4J Data in Google Apps Script via SQL Gateway

  Use the ODBC Driver for Neo4J and the SQL Gateway to access Neo4J from Google Apps Script.

• Create a Data Access Object for Phoenix Data using JDBI

  A brief overview of creating a SQL Object API for Apache Phoenix in JDBI.

• How to Connect to Live Dynamics 365 Business Central Data from OpenAI Python Applications (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Dynamics 365 Business Central through natural language.

• Bidirectional Access to DocuSign Data from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate DocuSign in Filemaker Pro for Mac or Windows.

• Integrate Live Freshservice Data in the Windsurf IDE via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Windsurf

• Create OneNote Reports on JasperReports Server

  Deploy the CData JDBC Driver on JasperReports Server to provide real-time OneNote data access from reports, embedded analytics, and more.

• Choosing the Best Method to Connect Zoho Creator to SQL Server: 5 Options Explained

  Discover multiple ways to connect and use Zoho Creator from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.

• Deploy the ADO.NET Provider for SAP Netweaver Gateway on an SSRS Report Server

  Connect to SAP Netweaver Gateway from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

• Use the CData Software JDBC Driver for Zoho Recruit in MicroStrategy Desktop

  Connect to Zoho Recruit in MicroStrategy Desktop using the CData Software JDBC Driver for Zoho Recruit.

• Integrating LangGraph with Certinia Data via CData Connect AI

  Leverage CData Connect AI to enable LangGraph agents to securely access and act on Certinia within automated workflows.

• Connecting GenSpark with Azure Data Lake Storage Data via CData Connect AI MCP Server

  Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Azure Data Lake Storage without any replication or custom integration required.

• Automate SQL Analysis Services Tasks in Power Automate Using CData API Server

  With CData API Server, easily create OData endpoints for live SQL Analysis Services and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.

• How to Connect the Power BI Service to MongoDB: Complete Guide

  Connect to the CData Software Power BI Connector for MongoDB from PowerBI.com to provide real-time MongoDB across the organization.

• Visualize Contentful Data in TIBCO Spotfire through ODBC

  The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Contentful into TIBCO Spotfire.

• Import Real-Time VWO Data via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use VWO in ColdFusion.

• Automated Continuous Active Directory Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable Active Directory replication to AlloyDB.

• Analyze Mailjet Data with Power Pivot

  This article walks you through the process of using the CData ODBC Driver for Mailjet from Power Pivot. You will use the Table Import Wizard to load Mailjet. You can visually build the import query or use any SQL supported by the driver.

• How to Connect to Databricks Data in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to Databricks. Leverage the pyodbc module for ODBC in Python.

• Query Live IBM Cloud Object Storage Data in Zed Editor via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live IBM Cloud Object Storage directly from the development environment.

• Operational Reporting on Wistia Data from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Wistia.

• Integrate NetSuite Data into Automated Tasks with Power Automate

  Use CData Connect AI to connect to NetSuite CRM & ERP and integrate live NetSuite CRM & ERP into your Power Automate tasks.

• Visualize OData Services in Sisense

  Create an ElastiCube in Sisense app with access to OData.

• Build Data Flows from Planio to SQL Server using SSIS

  Easily back up Planio to SQL Server using the SSIS components for Planio.

• Connect to Clockify Data from PowerBuilder via JDBC

  This article demonstrates how to access Clockify from PowerBuilder using the Clockify JDBC Driver.

• Configure the CData JDBC Driver for Twilio in a Connection Pool in Tomcat

  Connect to Twilio from a connection pool in Tomcat.

• Create Datasets from Smartsheet in Domo Workbench and Build Visualizations of Smartsheet Data in Domo

  Use the CData Software ODBC Driver for Smartsheet to create datasets from Smartsheet in Domo Workbench and then build visualizations in the Domo service.

• How to Easily Query Oracle Eloqua Data in OpenOffice Base

  Connect to Oracle Eloqua data in OpenOffice Base using the CData ODBC Driver for Oracle Eloqua and generate reports with live data insights.

• Integrate Pingdom with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Pingdom with External Services.

• Object-Relational Mapping (ORM) with TaxJar 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 TaxJar into a Java-based ORM framework, Hibernate.

• How to Access Live MySQL Data in Power Automate Desktop via ODBC

  The CData ODBC Driver for MySQL enables you to integrate MySQL into workflows built using Microsoft Power Automate Desktop.

• Replicate Twilio Data from PowerShell

  Write a quick PowerShell script to query Twilio. Use connectivity to the live data to replicate Twilio to SQL Server.

• View Reports on Real-Time Sage 300 Data in Power BI Report Server

  Use the CData ODBC Driver for Sage 300 to visualize Sage 300 in Power BI Desktop and then publish them to Power BI Report Server.

• Create MYOB AccountRight-Connected Enterprise Applications in OutSystems

  Use CData Connect AI to connect to MYOB AccountRight Data from OutSystems and build custom enterprise apps using live MYOB AccountRight.

• Connect to FormSite Data in HULFT Integrate

  Connect to FormSite as a JDBC data source in HULFT Integrate

• Build Dashboards with Facebook Ads Data in DBxtra

  Create dynamic dashboards and perform analytics based on Facebook Ads in DBxtra.

• Create SSAS Tabular Models from Hugging Face Data

  How to build a SQL Server Analysis Service Tabular Model from Hugging Face using CData drivers.

• Analyze Wistia Data with Power Pivot

  This article walks you through the process of using the CData ODBC Driver for Wistia from Power Pivot. You will use the Table Import Wizard to load Wistia. You can visually build the import query or use any SQL supported by the driver.

• Process & Analyze Procore Data in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live Procore Data.

• Build a Simple VCL Application for HubSpot Data

  How to build a simple VCL Application to view HubSpot in RAD Studio using the CData ODBC Driver for HubSpot.

• Moving Data from VWO to SQL Server Using Toad Data Point and CData ODBC Driver

  Query, export, and automate live VWO data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.

• How to connect PolyBase to Mode

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Mode.

• Publish Reports with Gong Data in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Gong.

• Build Google Campaign Manager 360-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Google Campaign Manager 360.

• Automated Continuous Gorgias Replication to Local Delimited Files

  Use CData Sync for automated, continuous, customizable Gorgias replication to delimited files (CSV/TSV).

• Validate Wave Financial Data with QuerySurge

  Access and validate Wave Financial in QuerySurge using the CData JDBC Driver.

• Connect to Nuclia Data in DBeaver

  Use the CData ODBC Driver to connect to Nuclia in DBeaver.

• Build Apps with Live Google Drive in Adalo using CData Connect AI

  Use CData Connect AI to integrate live Google Drive into the Adalo platform and build custom mobile and web applications with real-time Google Drive.

• Analyze Google Contacts Data with Power Pivot

  This article walks you through the process of using the CData ODBC Driver for Google Contacts from Power Pivot. You will use the Table Import Wizard to load Google Contacts. You can visually build the import query or use any SQL supported by the driver.

• Using the CData Software ODBC Driver for Reply.io in PyCharm

  Connect to Reply.io as an ODBC data source in PyCharm using the CData Software ODBC Driver for Reply.io.

• Use the CData ODBC Driver for Twilio from SharePoint Excel Services

  This article demonstrates how to use the CData ODBC Driver for Twilio to connect to Twilio from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Twilio in Excel.

• Connect to PostgreSQL Data from Filemaker Pro (Mac)

  Use CData Connect AI to connect to and query live PostgreSQL from Filemaker Pro on Mac.

• How to Connect to Cohere Data in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to Cohere. Leverage the pyodbc module for ODBC in Python.

• Build Apps with Live Webex Data Using the Low-Code Development Platform of Mendix

  Connect Webex with Mendix to build apps using the CData API Driver for JDBC.

• Analyze Omnisend Data in R via ODBC

  Create data visualizations and use high-performance statistical functions to analyze Omnisend in Microsoft R Open.

• Process & Analyze Smartsheet Data in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live Smartsheet Data.

• Integrate Aweber Data in the Pentaho Report Designer

  Publish reports based on Aweber in the Pentaho BI tool.

• Build Auth0-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Auth0.

• Build Databricks-Connected Dashboards Using Zoho Analytics

  Use CData Connect AI to connect to Databricks Data from Zoho Analytics and import live Databricks.

• Process & Analyze ConvertAPI Data in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live ConvertAPI Data.

• Build Semantic Layer Views for Microsoft Dataverse Data in APOS Live Data Gateway

  Use the CData Connector for Microsoft Dataverse in APOS Live Data Gateway to build Semantic Layer Views for Microsoft Dataverse (CDS).

• How to create Visio diagrams from Redshift Data

  Automatically update Amazon Redshift with the changes you make to Visio master shapes.

• «
• 1017
• 1018
• 1019
• 1020
• 1021
• 1022
• 1023
• 1024
• 1025
• 1026
• »