CData Software - Knowledge Base

Recent Articles

---

• «
• 464
• 465
• 466
• 467
• 468
• 469
• 470
• 471
• 472
• 473
• »

• How to connect and process Clari from Azure Databricks

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

• How to Work with Teamwork Data in ETL Validator JDBC

  Connect to Teamwork from ETL Validator jobs using the CData Software JDBC Driver.

• Build a PostgreSQL Interface for SFTP Data using the CData JDBC Driver

  Use the Remoting features of the SFTP JDBC Driver to create a PostgreSQL entry-point for data access.

• Access Live Pinecone Data in Coginiti Pro

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

• Automated Continuous Wrike Replication to Vertica

  Use CData Sync for automated, continuous, customizable Wrike replication to Vertica.

• Build Amazon Athena Visualizations in Tableau Desktop

  Use CData Connect AI to connect to live Amazon Athena and build visualizations in Tableau.

• How to Seamlessly Import Egnyte Data into IBM SPSS Modeler

  Integrate Egnyte data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

• Import and Visualize Accelo Data in Power View

  Create data visualizations based on Accelo in Excel.

• Query Salesforce Data 360 Data from Node.js

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

• Connect to Smartsheet Data as an External Source in Dremio

  Use the CData JDBC Driver to connect to Smartsheet as an External Source in Dremio.

• Connecting Moonlit Workflow with Cloudant Data via CData Connect AI MCP Server

  Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your IBM Cloudant in real time.

• Excel Spreadsheet Automation on Microsoft Dataverse Data with the QUERY Formula

  Pull data from Microsoft Dataverse, automate spreadsheets, and more with the QUERY formula.

• Query Amazon DynamoDB Data in DataGrip

  Create a Data Source for Amazon DynamoDB in DataGrip and use SQL to query live Amazon DynamoDB.

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

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

• Visualize Live Google Analytics Data of Power BI Report Builder in Power BI Service

  Use CData Power BI Connectors to connect to live Google Analytics using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

• Automated Quickbase Data Replication to Teradata

  Use CData Sync to Customize and automate Quickbase replication to Teradata.

• Connect to Paylocity Data in the Denodo Platform

  Use CData driver technologies to create a virtual data source for Paylocity in the Denodo Virtual DataPort Administrator.

• Enable the Active Directory JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Active Directory.

• How to Seamlessly Import FreeAgent Data into IBM SPSS Modeler

  Integrate FreeAgent data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

• Analyze SAS xpt Data in Slingshot with CData API Server

  Use the CData API Server to build an OData API on top of SAS XPORT and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.

• Build SAP Business Warehouse-Powered Applications in Cursor with CData MCP Server

  Use the CData MCP Server for SAP Business Warehouse to explore live SAP Business Warehouse Data in Cursor to assist with building SAP Business Warehouse-powered applications.

• Integrate Real-Time Access to SAP Ariba Procurement in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SAP Ariba Procurement in real time.

• Create Reports from Epicor Kinetic Data in Looker Studio

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

• Excel Spreadsheet Automation on Supabase Data with the QUERY Formula

  Pull data from Supabase, automate spreadsheets, and more with the QUERY formula.

• Connecting Mastra with Phoenix Data via CData Connect AI MCP Server

  Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Apache Phoenix, no replication required.

• Connect to Samanage Data in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• How to Work with Salesforce Data 360 Data in ETL Validator JDBC

  Connect to Salesforce Data 360 from ETL Validator jobs using the CData Software JDBC Driver.

• Extract, Transform, and Load Google Spanner Data in Informatica PowerCenter

  Create a simple Workflow for Google Spanner in Informatica PowerCenter.

• Build Semantic Layer Views for Adobe Target Data in APOS Live Data Gateway

  Use the CData Connector for Adobe Target in APOS Live Data Gateway to build Semantic Layer Views for Adobe Target.

• Automate Wave Financial Tasks in Power Automate Using CData API Server

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

• Build SharePoint-Connected ETL Processes in Google Data Fusion

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

• Build Power BI XMLA-Connected Apps in Choreo

  Use CData Connect AI to connect to Power BI XMLA Data from Choreo and build custom apps using live Power BI XMLA.

• Automated Continuous EmailOctopus Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable EmailOctopus replication to PostgreSQL.

• Connect to Zoho Books Data in Google Apps Script via SQL Gateway

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

• Build NetSuite SuiteAnalytics-Connected Visualizations in datapine

  Use CData Connect AI and datapine to build visualizations and dashboards with access to live NetSuite SuiteAnalytics.

• Connect to Insightly Data from PowerBuilder via ADO.NET

  This article demonstrates how to access Insightly from Appeon PowerBuilder using the CData API Driver for ADO.NET.

• Build a PostgreSQL Interface for GitLab Data using the CData JDBC Driver

  Use the Remoting features of the GitLab JDBC Driver to create a PostgreSQL entry-point for data access.

• Automated Continuous Raisers Edge NXT Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to Amazon Redshift.

• Connect to Pinecone Data in Aqua Data Studio

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

• Build a Simple VCL Application for LDAP Objects

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

• Create Oracle Sales-Connected Enterprise Applications in OutSystems

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

• Automated Continuous Freshservice Replication to Vertica

  Use CData Sync for automated, continuous, customizable Freshservice replication to Vertica.

• Integrate Open WebUI with Live Azure DevOps Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Azure DevOps from within the chat interface.

• Extend Google Sheets with SQL Analysis Services Data

  Make calls to SQL Analysis Services from Google Apps Script via the API Server.

• How to Create Power BI Visual Reports with Real-Time Google Directory Data

  Use CData Power BI Connectors to visualize Google Directory in Power BI.

• Connecting GenSpark with HCL Domino Data via CData Connect AI MCP Server

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

• Natively Connect to Everhour Data in PHP

  The CData ODBC driver for Everhour enables you to create PHP applications with connectivity to Everhour. Leverage the native support for ODBC in PHP.

• Build Dashboards with Typeform Data in DBxtra

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

• How to publish and share Aircall Data dashboards with Tableau Server

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

• How to Query Perigon Data in MySQL Workbench

  Execute MySQL queries against live Perigon from MySQL Workbench.

• How to import Facebook Ads Data into Apache Solr

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

• Automated Continuous Microsoft Planner Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable Microsoft Planner replication to Amazon S3.

• Connect to QuickBooks Data in Claris FileMaker Pro

  Use the CData ODBC Driver for QuickBooks in FileMaker Pro to connect to QuickBooks and work with QuickBooks Desktop in your FileMaker applications.

• Connect to Invoiced Data in CloverDX (formerly CloverETL)

  Transfer Invoiced using the visual workflow in the CloverDX data integration tool.

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

• Create a Data Access Object for Hive Data using JDBI

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

• Integrate Theia IDE with Live Airtable Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Theia IDE

• Integrating Codex CLI with MailChimp 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.

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

• Build Dashboards with Billsby Data in Dundas BI

  Create dynamic dashboards and perform analytics based on Billsby in Dundas BI.

• Access Authorize.Net Data from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Authorize.Net from HeidiSQL.

• Keap Reporting in OBIEE with the Keap JDBC Driver

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

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

• Working with Highrise Data in LINQPad

  Execute LINQ queries to Highrise CRM in LINQPad.

• Consume Elasticsearch OData Feeds in SAP Lumira

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

• Build Sybase IQ-Connected Apps in Mendix

  Use CData Connect AI to create an OData feed for Sybase IQ Data and create custom apps in Mendix.

• How to connect to Shippo Data from IntelliJ

  Integrate connectivity to Shippo with wizards in IntelliJ.

• Migrating data from CircleCI to Databricks using CData SSIS Components.

  Easily push CircleCI to Databricks using the CData SSIS Tasks for CircleCI and Databricks.

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

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

• Connect to Blackbaud FE NXT Data in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Connect to Notion Data from Blazor Apps

  Build ASP.NET Core Blazor C# apps that integrate with real-time Notion using standard SQL.

• Access Live Adobe Commerce Data in TIBCO Data Virtualization

  Use the Adobe Commerce Tibco DV Adapter to create a Adobe Commerce data source in TIBCO Data Virtualization Studio and gain access to live Adobe Commerce from your TDV Server.

• Access Factorial Data from MySQL in Amazon QuickSight

  Connect to Factorial and build visualizations of Factorial using a MySQL Connection in Amazon QuickSight.

• Automate GitLab Integration Tasks from PowerShell

  Are you in search of a quick and easy way to access GitLab from PowerShell? This article demonstrates how to utilize the GitLab Cmdlets for tasks like connecting to GitLab, automating operations, downloading data, and more.

• Write a Simple Go Application to work with Jira Data on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Atlassian Jira.

• Query Google Drive Data from Node.js

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

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

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

• Connect to Gong from Asprova with CData Software ODBC Driver for Gong

  This article shows how to connect faster to Gong data from Asprova.

• Publish Reports with Guru Data in SAP Crystal Reports

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

• How to Visualize Brex Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Brex in Python.

• How to use SQLAlchemy ORM to access Shortcut Data in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Shortcut.

• Connect to Stack Exchange Data in RazorSQL

  Connect to Stack Exchange from wizards and query Stack Exchange from the GUI in the RazorSQL database management tool.

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

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

• Use Grok to Talk to Your Basecamp 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 Basecamp for you.

• Use Azure AI Foundry to Talk to Your OData Services 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 OData for you.

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

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

• Use the CData ODBC Driver for FreshBooks in Microsoft Power Query

  You can use the CData FreshBooks ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import FreshBooks into Microsoft Power Query.

• How to Visualize MarkLogic Data in Python with pandas via CData Connect AI

  Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live MarkLogic in Python.

• Build an OLAP Cube in SSAS from Nethunt Data

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

• Connect to eBay Analytics Data from PowerBuilder via JDBC

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

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

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

• Connect to Zuora Data as a SQL Server Linked Server

  Use CData Connect AI to create a linked server for live Zuora.

• Access Live Azure DevOps Data in Excel (Desktop) via Connect AI

  Use CData Connect AI to gain access to live Azure DevOps from your Excel spreadsheets.

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

  Replicate Jumpseller to disparate databases with a single configuration.

• Integrating LangGraph with Box Data via CData Connect AI

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

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

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

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

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

• Connect to Teamwork Data in JRuby

  Create a simple JRuby app with access to live Teamwork.

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

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

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

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

• «
• 464
• 465
• 466
• 467
• 468
• 469
• 470
• 471
• 472
• 473
• »