CData Software - Knowledge Base

Recent Articles

---

• «
• 608
• 609
• 610
• 611
• 612
• 613
• 614
• 615
• 616
• 617
• »

• Connect to Avalara AvaTax Data in NetBeans

  Connect to Avalara AvaTax in NetBeans with the data source configuration wizard.

• Consume Sage Intacct OData Feeds in SAP Lumira

  Use the API Server to create data visualizations on Sage Intacct feeds that reflect any changes in SAP Lumira.

• Analyze Tally Data in Looker

  Use CData Connect AI to connect to Tally Data from Looker and build custom apps using live Tally ERP.

• Model, Search, and Visualize Live Salesforce Data in ThoughtSpot

  Use CData Connect AI to connect to live Salesforce & Force.com for modeling, searching, and visualizing.

• Build Azure DevOps-Powered Applications in Cursor with CData MCP Server

  Use the CData MCP Server for Azure DevOps to explore live Azure DevOps Data in Cursor to assist with building Azure DevOps-powered applications.

• Rapidly Develop Calendly-Driven Apps with Active Query Builder

  Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Calendly.

• Build Twitter Ads-Connected Visualizations in datapine

  Use CData Connect AI and datapine to build visualizations and dashboards with access to live Twitter Ads.

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

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

• Import and Visualize BigQuery Data in Power View

  Create data visualizations based on Google BigQuery in Excel.

• Use the CData Software JDBC Driver for Highrise in MicroStrategy Desktop

  Connect to Highrise CRM in MicroStrategy Desktop using the CData Software JDBC Driver for Highrise.

• How to connect and process Clio from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Clio.

• Build SAP Ariba Procurement-Connected Apps in Choreo

  Use CData Connect AI to connect to SAP Ariba Procurement Data from Choreo and build custom apps using live SAP Ariba Procurement.

• Access Live FormSite Data in Coginiti Pro

  Connect to and query live FormSite from the GUI in the Coginiti Pro: SQL Analytics Tool.

• Connect ZendeskSell Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

  Connect to your ZendeskSell using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

• How to import ActiveCampaign Data into Apache Solr

  Use the CData Software JDBC Driver for ActiveCampaign in Data Import Handler and create an automated import of ActiveCampaign to Apache Solr Enterprise Search platform.

• Deploy the ADO.NET Provider for Keap on an SSRS Report Server

  Connect to Keap 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.

• DataBind Controls to Jodoo Data in C++Builder

  DataBind to Jodoo in C++Builder with standard components and controls.

• Work with Live Spark Data in Power Query

  Use CData Connect AI to connect to Apache Spark SQL and work with live Apache Spark SQL in Microsoft Power Query.

• Connect to Live QuickBooks Time Data in PostGresSQL Interface through CData Connect AI

  Create a live connection to QuickBooks Time in CData Connect AI and connect to your QuickBooks Time from PostgreSQL.

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

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

• Automated Continuous SpaceX Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable SpaceX replication to IBM DB2.

• Access Live Google Search Results in AWS Lambda

  Connect to live Google Search in AWS Lambda using the CData JDBC Driver.

• Replicate Wave Financial Data to Multiple Databases via the CData Sync CLI

  Replicate Wave Financial to disparate databases with a single configuration.

• Connect to Oracle SCM Data in Ruby

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

• Connect to Templated from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Templated to connect to Templated from Web applications running on WebLogic.

• Visualize Act-On Data in Sisense

  Create an ElastiCube in Sisense app with access to Act-On.

• Integrating Dataiku with Databricks Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Databricks.

• Visualize OpenWeatherMap Data in TIBCO Spotfire through ADO.NET

  Integrate OpenWeatherMap into dashboards in TIBCO Spotfire.

• Access Live Front Data in SAS JMP via ODBC

  You can use the CData ODBC Driver to integrate Front into the statistical analysis tools available in SAS JMP. This article shows how to use Front in the Graph Builder and Query Builder.

• How to Connect to Live PostgreSQL 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 PostgreSQL through natural language.

• How to connect SharePoint with Outreach.io Data through external lists

  Provide Outreach.io to SharePoint users as an external list.

• Automated Continuous Copper Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable Copper replication to Apache Kafka.

• Using the CData JDBC drivers with the Pentaho Report Designer

  The CData Data Providers (JDBC, ODBC, and ADO.NET) implement standards based access to various data source which enables third party tools to interoperate. In this article we use the CData JDBC Driver for Salesforce in Pentaho (a BI tool) to publish reports based on Salesforce data. A similar approach can be used with any other CData JDBC Driver.

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

• Process & Analyze Copper Data in Databricks (AWS)

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

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

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

• Connect to MessageBird Data in Jaspersoft Studio

  Execute SQL to remote MessageBird in Jaspersoft Studio.

• Build MVC Applications with Connectivity to Jumpseller Data

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Jumpseller from an ASP.NET MVC application.

• Automate Google Search Tasks in Power Automate Using CData API Server

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

• Connect SQL Server Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

  Connect to your Microsoft SQL Server using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

• Use CData Connect AI to Access GitHub Data in Microsoft Power Pivot

  Use CData Connect AI to connect to live GitHub in the Power Pivot business intelligence tool.

• Manage Webflow Data in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for Webflow.

• Integrate with Spark Data in JReport Designer

  Create charts and reports based on Apache Spark SQL in JReport Designer.

• Connect to SuiteCRM Data from PowerBuilder via ODBC

  This article demonstrates how to use the CData ODBC Driver for SuiteCRM to connect to SuiteCRM and execute queries in PowerBuilder.

• Connect Short.io Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

  Connect to your Short.io using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

• Integrating Cursor CLI with Cassandra 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.

• How to connect to Bright Data Data from Spring Boot

  Connect to Bright Data in a Spring Boot Application using the CData API Driver for JDBC

• 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.

• How to connect PolyBase to HubDB

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

• Connect and Visualize Live SAS Data Sets Data in Databricks Lakehouse Federation with CData Connect AI

  Use CData Connect AI to integrate live SAS Data Sets into the Databricks platform and create visualization dashboards with real-time SAS Data Sets.

• Query Zoho Inventory Data using the OData SDK for PHP

  Use the API Server and the OData PHP SDK to easily consume Zoho Inventory entities in PHP by modeling them as objects.

• Integrate ZendeskSell Data in the Pentaho Report Designer

  Publish reports based on ZendeskSell in the Pentaho BI tool.

• How to Build an ETL App for SAP ByDesign Data in Python with CData

  Create ETL applications and real-time data pipelines for SAP Business ByDesign in Python with petl.

• Build Charts with Drift Data in Clear Analytics

  Create dynamic charts and perform analytics based on Drift in Clear Analytics.

• How to connect to Opsgenie Data with Squirrel SQL client

  Connect to Opsgenie and execute queries in the Squirrel SQL Client.

• Getting Started with the CData ADO.NET Provider for Shortcut

  Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.

• Prepare, Blend, and Analyze Instantly Data in Alteryx Designer (ODBC)

  Build workflows to access live Instantly for self-service data analytics.

• Visualize SAP Hybris C4C Data in Sisense

  Create an ElastiCube in Sisense app with access to SAP Hybris C4C.

• Use the CData API Server to Access LinkedIn Data in Microsoft PowerPivot

  Use the CData API Server to connect to live LinkedIn in the Power Pivot business intelligence tool.

• Access Live Shippo Data in AWS Lambda (with IntelliJ IDEA)

  Connect to live Shippo in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• Create Informatica Mappings From/To a JDBC Data Source for Freshteam

  Create Freshteam data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• Connect to SendGrid Data in HULFT Integrate

  Connect to SendGrid as a JDBC data source in HULFT Integrate

• Automated Continuous Salesforce CRM Analytics Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable Salesforce CRM Analytics replication to AlloyDB.

• Automated Continuous Dynamics NAV Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable Dynamics NAV replication to AlloyDB.

• Consume Teradata OData Feeds in PowerBuilder

  This article demonstrates how to consume Teradata as OData feeds from PowerBuilder using the API Server.

• Query, Visualize, and Share live Basecamp Data in Redash

  Use CData Connect AI to connect to live Basecamp in Redash for querying, visualizing, and sharing.

• Edit and Search CouchDB External Objects in Salesforce Connect (API Server)

  Use the API Server to securely provide OData feeds of Apache CouchDB to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create CouchDB objects that you can access from apps and the dashboard.

• Build Pipelines with Live Raisers Edge NXT Data in Google Cloud Data Fusion (via CData Connect AI)

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

• Build a Singer.io Tap for Hubstaff With the CData Python Connector

  Learn how to easily build a Singer.io Tap for live Hubstaff data using

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

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

• Use Grok to Talk to Your Acumatica Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Acumatica ERP for you.

• How to Easily Query HDFS Data in OpenOffice Base

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

• Visualize CockroachDB 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 CockroachDB into TIBCO Spotfire.

• Query Azure DevOps Data as a MySQL Database in Node.js

  Execute MySQL queries against Azure DevOps from Node.js.

• Working with Phoenix Data in LINQPad

  Execute LINQ queries to Apache Phoenix in LINQPad.

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

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

• Analyze Amazon Athena Data in Cognos Analytics

  Use CData Connect AI to connect to Amazon Athena Data from Cognos Analytics and analyze live Amazon Athena.

• Use Agno to Talk to Your ServiceNow Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your ServiceNow for you.

• Add Neo4J Data to Informatica Enterprise Data Catalog

  Use the CData Software JDBC Driver for Neo4J with the Informatica Enterprise Data Catalog to classify and organize data.

• Access Google Spanner Data from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Google Spanner from HeidiSQL.

• Explore Geographical Relationships in Snowflake Data with Power Map

  Create data visualizations with Snowflake in Power Map.

• How to Connect to & Open ElevenLabs Data in Microsoft Excel

  This article uses the CData ODBC driver for ElevenLabs to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

• Create Informatica Mappings From/To a JDBC Data Source for TaxJar

  Create TaxJar data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• Automated Power BI XMLA Data Replication to Teradata

  Use CData Sync to Customize and automate Power BI XMLA replication to Teradata.

• Use Azure AI Foundry to Talk to Your ADP Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your ADP for you.

• Visualize Zendesk Data in Tableau

  The CData ODBC driver for Zendesk enables you integrate Zendesk into Tableau dashboards.

• How to Connect to & Open Unbounce Data in Microsoft Excel

  This article uses the CData ODBC driver for Unbounce to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

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

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

• Build Oracle Eloqua-Connected Apps in Choreo

  Use CData Connect AI to connect to Oracle Eloqua Data from Choreo and build custom apps using live Oracle Eloqua.

• Create Reports from Xero Data in Looker Studio

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

• Couchbase Reporting in OBIEE with the Couchbase JDBC Driver

  Deploy the Couchbase JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• Bidirectional Access to Gorgias Data from FileMaker Pro

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

• How to Query Live Confluence Data in Perplexity MacOS Desktop

  Connect to and query live Confluence Data in Perplexity Desktop using CData MCP Server.

• Connect to Outreach.io Data as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Outreach.io.

• Use Biml to Build SSIS Tasks to Replicate Hive Data to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Apache Hive to SQL Server.

• Integrating Cursor CLI with Paddle 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.

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

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

• How to Connect to Live Google Ads Data in n8n Workflows and Agents (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Google Ads for you.

• Access Figshare Data as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Figshare from your Oracle system.

• Access Live Odoo Data in SAS JMP via ODBC

  You can use the CData ODBC Driver to integrate Odoo ERP into the statistical analysis tools available in SAS JMP. This article shows how to use Odoo ERP in the Graph Builder and Query Builder.

• «
• 608
• 609
• 610
• 611
• 612
• 613
• 614
• 615
• 616
• 617
• »