CData Software - Knowledge Base

Recent Articles

---

• «
• 1254
• 1255
• 1256
• 1257
• 1258
• 1259
• 1260
• 1261
• 1262
• 1263
• »

• Connect to Adobe Experience Manager Data in DBArtisan

  Use wizards in DBArtisan to configure Adobe Experience Manager as a data source.

• Connect to Tally Data from HeidiSQL

  Use CData Connect AI to connect to and query live Tally ERP from HeidiSQL.

• Replicate Microsoft Planner Data from PowerShell

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

• Use the CData SSIS Components to Insert New or Update Existing Amazon DynamoDB Records from SQL Server

  Easily push SQL Server data to Amazon DynamoDB using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Amazon DynamoDB or update existing records with data from a SQL Server database.

• Integrate Cline with Live GitLab Data via CData Connect AI

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

• Import Google Cloud Storage Data into Microsoft Power Query

  The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Google Cloud Storage. In this article, you will use the OData format to import Google Cloud Storage into Microsoft Power Query.

• Connect to Neo4J Data in DBeaver

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

• Integrate Zoho Inventory Data in the Pentaho Report Designer

  Publish reports based on Zoho Inventory in the Pentaho BI tool.

• Build GitLab Visualizations in Tableau Cloud

  Use CData Connect AI to connect to live GitLab and build visualizations in Tableau Cloud.

• Extract, Transform, and Load JobNimbus Data in Informatica PowerCenter

  Create a simple Workflow for JobNimbus in Informatica PowerCenter.

• How to Query Reckon Data in MySQL Workbench

  Execute MySQL queries against live Reckon from MySQL Workbench.

• Publish Crystal Reports on Paddle Data

  Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Paddle.

• Query Live Elasticsearch 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 Elasticsearch directly from the development environment.

• Connect to Cosmos DB Data 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 Azure Cosmos DB.

• Instagram Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on Instagram facts in real time.

• Use the CData API Server to Access Oracle HCM Cloud Data in Microsoft PowerPivot

  Use the CData API Server to connect to live Oracle HCM Cloud in the Power Pivot business intelligence tool.

• Connect to Azure Data Lake Storage Data in Claris FileMaker Pro

  Use the CData ODBC Driver for Azure Data Lake Storage in FileMaker Pro to connect to Azure Data Lake Storage and work with Azure Data Lake Storage in your FileMaker applications.

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

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

• Rapidly Develop Quaderno-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 Quaderno.

• Dynamics 365 Data Cloud Connectivity

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

• Using the CData Software ODBC Driver for Insightly in PyCharm

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

• Query Couchbase Data as a MySQL Database in Node.js

  Execute MySQL queries against Couchbase from Node.js.

• Query, Visualize, and Share live Amazon DynamoDB Data in Redash

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

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

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

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

• Connecting Agentforce with Jira Assets Data via CData Connect AI MCP Server

  Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Jira Assets for you.

• Import and Visualize OneNote Data in Power View

  Create data visualizations based on Microsoft OneNote in Excel.

• Connect to MailerSend Data in RazorSQL

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

• Perform Batch Operations with Spark Data in Apache NiFi

  Connect to Apache Spark SQL and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

• Automated Continuous Neo4J Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable Neo4J replication to Amazon Redshift.

• Analyze Gong Data with Power Pivot

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

• Build FTP-Powered Applications in GitHub Copilot with CData MCP Server

  Use the CData MCP Server for FTP to explore live FTP Data in GitHub Copilot to assist with building FTP-powered applications.

• Visualize Freshteam Data from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Freshteam.

• A PostgreSQL Interface for ZendeskSell Data using the CData ODBC Driver

  Use the SQL Gateway and ZendeskSell ODBC Driver to create a PostgreSQL entry-point for data access.

• Create Power BI Reports on Real-Time Freshservice Data

  Use the CData ODBC Driver for Freshservice to visualize Freshservice in Power BI Desktop.

• Integrating GitHub Copilot CLI with Wave Financial 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.

• A PostgreSQL Interface for Attio Data (MySQL Remoting via JDBC)

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

• Visualize Live Cosmos DB Data in Power BI (via CData Connect AI)

  Use the CData Power BI Connector and CData Connect AI to integrate live Azure Cosmos DB into custom reports in Power BI.

• Automated Continuous ADP Replication to MySQL

  Use CData Sync for automated, continuous, customizable ADP replication to MySQL.

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

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

• Work with Paylocity Data in FoxPro

  Load Paylocity into a FoxPro database. This article includes full code and a walk-through of the process.

• Working with Monday.com Data in LINQPad

  Execute LINQ queries to Monday.com in LINQPad.

• Build SAP Fieldglass-Powered Applications in Gemini Code Assist with CData MCP Server

  Use the CData MCP Server for SAP Fieldglass to explore live SAP Fieldglass Data in Gemini Code Assist to assist with building SAP Fieldglass-powered applications.

• Use Dash to Build Web Apps on Certinia Data via CData Connect AI

  Build interactive Dash web apps on live Certinia using pandas and the CData Connect AI Python SDK.

• DataBind TaxJar Data to the DevExpress Data Grid

  Use the CData ADO.NET Provider for TaxJar with the DevExpress Windows Forms and Web controls to provide TaxJar to a chart.

• Creating Dynamics 365-Connected Applications in Unqork

  You can use CData Connect AI to feed Microsoft Dynamics 365 to Unqork and build custom business apps.

• Query, Visualize, and Share live Microsoft Exchange Data in Redash

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

• Use the CData Software JDBC Driver for Salesforce CRM Analytics in MicroStrategy Desktop

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

• Replicate Close Data from PowerShell

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

• Connect to Anaplan Data in CloverDX (formerly CloverETL)

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

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

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

• Integrate with IBM Informix Data using Apache Camel2

  Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy IBM Informix to a JSON file on disk.

• Query PingOne Data in ColdFusion

  Write standard ColdFusion data access code to connect to PingOne.

• Prepare, Blend, and Analyze SAP Concur Data in Alteryx Designer (Connect AI)

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

• Connect to Rebilly Data from a Connection Pool in Jetty

  The Rebilly JDBC Driver supports connection pooling: This article shows how to connect faster to Rebilly from Web apps in Jetty.

• Integrate Live Google Campaign Manager 360 Data into Custom Business Apps Built in Power Apps

  Use CData Connect AI to connect to Google Campaign Manager 360 and integrate live Google Campaign Manager 360 into apps built in Microsoft Power Apps.

• Automated Continuous RSS Replication to AlloyDB

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

• Integrate Google

  Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Apache CouchDB using the Model Context Protocol.

• How to Connect to & Open Azure Table Data in Microsoft Excel

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

• Publish Reports with Pipedrive Data in SAP Crystal Reports

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

• Connect to and Visualize Live Elasticsearch Data in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Elasticsearch.

• Connect to MailerSend Data in RapidMiner

  Integrate MailerSend with standard components and data source configuration wizards in RapidMiner Studio.

• Natively Connect to Google Tasks Data in PHP

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

• Automate Amazon S3 Data Replication to SAP HANA

  Use CData Sync to customize and automate Amazon S3 replication to SAP HANA.

• Connect to Copper Data in RazorSQL

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

• Model Google Sheets Data Using Azure Analysis Services

  Leverage CData Connect AI to establish a connection between Azure Analysis Services and Google Sheets, enabling the direct import of real-time Google Sheets.

• Integrating Antigravity CLI with Google Calendar via CData CLI

  Connect Google Calendar to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.

• Back Up ScrapingBee to SQL Server through SSIS

  Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with ScrapingBee data.

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

  Replicate ConvertKit to disparate databases with a single configuration.

• How to Design ActiveCampaign Power Apps with Database-Like Connectivity

  Gain real-time, database-like connectivity to ActiveCampaign from mobile and tablet Power Apps.

• How to connect to Autopilot Data with Squirrel SQL client

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

• Build Semantic Layer Views for Box Data in APOS Live Data Gateway

  Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Box.

• Visualize Front Data in Sisense

  Create an ElastiCube in Sisense app with access to Front.

• Use Dash to Build Web Apps on Sybase Data via CData Connect AI

  Build interactive Dash web apps on live Sybase using pandas and the CData Connect AI Python SDK.

• How to Connect to Live SAP Netweaver Gateway Data in Mistral AI Workflows

  Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live SAP Netweaver Gateway without replication.

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

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

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

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

• How to Query MongoDB Data in MySQL Workbench

  Execute MySQL queries against live MongoDB from MySQL Workbench.

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

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

• How to publish and share Reply.io Data dashboards with Tableau Server

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

• How to Query Live PhantomBuster Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live PhantomBuster data in natural language using Python.

• Analyze MariaDB Data in SAP Analytics Cloud

  Use CData Connect AI to create an OData API on top of MariaDB and visualize MariaDB in SAP Analytics Cloud.

• How to connect Amazon QuickSight to AlloyDB Data

  Create a connection to Google AlloyDB in CData Connect AI and insert Google AlloyDB into Amazon QuickSight SPICE to build interactive dashboards.

• Automate Yelp Data Replication to Azure Synapse

  Use CData Sync to customize and automate Yelp replication to Azure Synapse.

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

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

• DataBind Codat Data to the DevExpress Data Grid

  Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Codat to a chart.

• Stream Sage 300 Data into Apache Kafka Topics

  Access and stream Sage 300 in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Choosing the Best Method to Connect Google Sheets to SQL Server: 5 Options Explained

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

• Validate Azure Data Catalog Data with QuerySurge

  Access and validate Azure Data Catalog in QuerySurge using the CData JDBC Driver.

• How to Create Power BI Visual Reports with Real-Time YouTube Analytics Data

  Use CData Power BI Connectors to visualize YouTube Analytics in Power BI.

• Build Hive-Powered Applications in Cursor with CData MCP Server

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

• Automated Continuous Zoom Replication to MySQL

  Use CData Sync for automated, continuous, customizable Zoom replication to MySQL.

• How to Query Oracle Eloqua Data in MySQL Workbench

  Execute MySQL queries against live Oracle Eloqua from MySQL Workbench.

• Explore Geographical Relationships in Front Data with Power Map

  Create data visualizations with Front in Power Map.

• Integrating GitHub Copilot CLI with Sybase IQ 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.

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

• Provide OData Services of Stack Exchange Data from a WCF Application

  In this article, we will demonstrate the process of generating an OData feed for Stack Exchange by developing a WCF Service Application.

• Query Excel Data in DataGrip

  Create a Data Source for Excel in DataGrip and use SQL to query live Microsoft Excel.

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

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

• Access Live Dotmailer Data in SAS JMP via ODBC

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

• «
• 1254
• 1255
• 1256
• 1257
• 1258
• 1259
• 1260
• 1261
• 1262
• 1263
• »