CData Software - Knowledge Base

Recent Articles

---

• «
• 740
• 741
• 742
• 743
• 744
• 745
• 746
• 747
• 748
• 749
• »

• Connect to Invoiced in SpagoBI

  Create reports featuring live Invoiced in SpagoBI Studio. Host Invoiced reports on SpagoBI Server.

• Automated Continuous Cassandra Replication to IBM DB2

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

• Visualize NetSuite Data in TIBCO Spotfire through OData

  Integrate NetSuite CRM & ERP into dashboards in TIBCO Spotfire.

• Integrate Live Xero Data into Blue Prism for Intelligent Robotic Process Automation (RPA)

  Connect live Xero Accounting to Blue Prism using the CData ODBC Driver for Xero to create automated workflows for repetitive business tasks.

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

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

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

  Connect to Coinbase from a connection pool in Tomcat.

• Integrate Customer.io Data in the Pentaho Report Designer

  Publish reports based on Customer.io in the Pentaho BI tool.

• Perigon Reporting and Star Schemas in OBIEE

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

• How to Work with LinkedIn Data in ETL Validator JDBC

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

• Automate Access Tasks in Power Automate Using CData API Server

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

• Create SAP Ariba Procurement-Connected Nintex Workflows

  Use CData Connect AI to connect to SAP Ariba Procurement Data from Nintex Workflow Cloud and build custom workflows using live SAP Ariba Procurement.

• Use the CData Software JDBC Driver for Outreach.io in MicroStrategy

  Connect to Outreach.io in MicroStrategy Developer using the CData Software JDBC Driver for Outreach.io.

• Bind Live JSON Data in Wijmo FlexGrid with CData API Server

  With CData API Server, easily create OData endpoints for live JSON data

• Getting Started with the CData Excel Add-In for Outreach.io

  Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Outreach.io.

• How to connect to EnterpriseDB Data in DBVisualizer

  Integrate EnterpriseDB with visual data analysis tools and data connection wizards in DBVisualizer

• Build an OLAP Cube in SSAS from Pingdom Data

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

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

• Analyze Google Ads Data with Power Pivot

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

• How to connect SharePoint with Kafka Data through external lists

  Provide Apache Kafka to SharePoint users as an external list.

• Integrate RSS with External Services using SnapLogic

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

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

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

• Build Semantic Layer Views for SQL Analysis Services Data in APOS Live Data Gateway

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

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

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

• Connect to Greenplum Data as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Pivotal GreenPlum.

• Create SSAS Tabular Models from Dynamics 365 Business Central Data

  How to build a SQL Server Analysis Service Tabular Model from Dynamics 365 Business Central using CData drivers.

• Access Flowlu Data from MySQL in HeidiSQL

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

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

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

• Automated Elasticsearch Data Replication to Teradata

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

• Automated Continuous Zoho Books Replication to MongoDB

  Use CData Sync for automated, continuous, customizable Zoho Books replication to MongoDB.

• Connect to HubSpot from Excel & GoogleSheets!

  Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from HubSpot, and over 250 other data sources, right inside your Excel and Google spreadsheets!

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

• Automate Tasks in Power Automate Using the CData API Server

  Automate Zoho CRM actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.

• How to Work with Printify Data in AWS Glue Jobs Using JDBC

  Connect to Printify from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• How to Connect to Live YouTube Analytics Data from Sourcegraph Amp (via CData Connect AI)

  Integrate Sourcegraph Amp with CData Connect AI to query and manage live YouTube Analytics securely in real time.

• How to Access Live Salesforce Pardot Data in Visual Studio Code via Cline

  Run CData MCP Server for Salesforce Pardot on Windows Subsytem for Linux (WSL) and connect to live Salesforce Pardot from the Cline extension in Visual Studio Code.

• Create Informatica Mappings From/To an ODBC Data Source for Zoho CRM

  Create an ODBC connection to Zoho CRM in Informatica and browse and transfer Zoho CRM.

• Create Informatica Mappings From/To an ODBC Data Source for Webflow

  Create an ODBC connection to Webflow in Informatica and browse and transfer Webflow.

• Build Bitly-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Bitly and build web apps with connectivity to live Bitly.

• Work with Cassandra Data in FoxPro

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

• Integrating LlamaIndex with PostgreSQL Data via CData Connect AI

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

• Access Salesforce Data as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Salesforce & Force.com from your Oracle system.

• Connect to ConstantContact Data in CloverDX (formerly CloverETL)

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

• Use the CData Software JDBC Driver for Placid in MicroStrategy Web

  Connect to Placid in MicroStrategy Web using the CData Software JDBC Driver for Placid.

• How to Work with PingOne Data in AWS Glue Jobs Using JDBC

  Connect to PingOne from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

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

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

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

• Query ShipEngine Data in DataGrip

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

• Integrate Google

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

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

  Execute MySQL queries against Teamwork from Node.js.

• Use Dash to Build to Web Apps on Google Forms Data

  Create Python applications that use pandas and Dash to build Google Forms-connected web apps.

• Query Presto Data from Node.js

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

• How to load Suadeo data into Elasticsearch via Logstash

  Introducing a simple method to load Suadeo data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.

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

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

• Create Dynamic Gmail Grids Using the Infragistics XamDataGrid

  Learn how you can connect Gmail to Infragistics XamDataGrid to build dynamic grids.

• Viewing MailerLite Data in RAD Studio Data Explorer

  How to view MailerLite in RAD Studio Data Explorer using the CData ODBC Driver for MailerLite.

• Connect to Exa Data in Ruby

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

• Getting Started with the CData Power BI Connector for MySQL

  Complete guide to installing, licensing, and connecting with the CData Power BI Connector for MySQL.

• Connect to Salesforce Marketing Data in CloverDX (formerly CloverETL)

  Transfer Salesforce Marketing Cloud using the visual workflow in the CloverDX data integration tool.

• Build an OLAP Cube in SSAS from Exa Data

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

• Import and Visualize SAP SuccessFactors Data in Power View

  Create data visualizations based on SAP SuccessFactors in Excel.

• Integrate BigCommerce Data into Automated Tasks with Power Automate

  Use CData Connect AI to connect to BigCommerce and integrate live BigCommerce into your Power Automate tasks.

• Connect to RSS Feeds in NetBeans

  Connect to RSS Feeds in NetBeans with the data source configuration wizard.

• Connect to and Visualize Live SAS xpt Data in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live SAS XPORT.

• Use the CData Software JDBC Driver for Avro in MicroStrategy

  Connect to Apache Avro in MicroStrategy Developer using the CData Software JDBC Driver for Avro.

• Validate Pushbullet Data with QuerySurge

  Access and validate Pushbullet in QuerySurge using the CData JDBC Driver.

• Integrating Cursor CLI with Pinecone 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 Power BI Reports on Real-Time WordPress Data

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

• Connect to Postmark Data in Ruby

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

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

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

• Publish Parquet-Connected Dashboards in Tableau Server

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

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

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

• Connect to Bullhorn CRM Data from Blazor Apps

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

• Build Visualizations of Scrapfly Data in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Scrapfly in Birst.

• How to load Vimeo data into Elasticsearch via Logstash

  Introducing a simple method to load Vimeo data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.

• Publish Reports with AlloyDB Data in SAP Crystal Reports

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

• Import and Visualize Airtable Data in Power View

  Create data visualizations based on Airtable in Excel.

• Connect to LionDesk Data as an External Source in Dremio

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

• Connect to Cosmos DB Data as an External Source in Dremio

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

• Integrating Gumloop with Adobe Commerce Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Adobe Commerce within automated workflows.

• Connect to Google Drive Data in Aqua Data Studio

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

• Create Twilio-Connected Visualizations in Klipfolio

  Use CData Connect AI to connect to Twilio Data from Klipfolio and build custom visualizations using live Twilio.

• Integrate Google

  Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Sybase IQ within intelligent workflows.

• Integrating LangChain with Azure Analysis Services Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Azure Analysis Services within automated workflows.

• How to work with Unbounce Data in Apache Spark using SQL

  Access and process Unbounce Data in Apache Spark using the CData Software JDBC Driver.

• Create Power BI Reports on Real-Time Shortcut Data

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

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

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

• Query Oracle Service Cloud Data from Node.js

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

• Getting Started with the CData Excel Add-In for Azure Data Lake Storage

  Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Azure Data Lake Storage.

• Create Reports with GraphQL Data in SAP Crystal Reports

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

• Explore Geographical Relationships in Oracle Sales Data with Power Map

  Create data visualizations with Oracle Sales in Power Map.

• Operational Reporting on CloudConvert Data from Spotfire Server

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

• Automated Continuous Workday Replication to Amazon S3

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

• How to Use a Microsoft Access Database to Update Adobe Commerce Data in Real Time

  Update Adobe Commerce data by creating a linked table in Microsoft Access with the CData Adobe Commerce ODBC Driver.

• Automated Stripe Data Replication to Teradata

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

• Manage FormSite Data in DBArtisan as a JDBC Source

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

• How to connect PolyBase to Miro

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

• Visualize Webex Data in TIBCO Spotfire through ADO.NET

  Integrate Webex into dashboards in TIBCO Spotfire.

• How to Connect to Live Redshift 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 Amazon Redshift without replication.

• Create Data Visualizations in Cognos BI with Billsby Data

  Access Billsby as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

• Connect to Snowflake Data in RunMyProcess through Connect AI

  Use CData Connect AI to create on OData API for Snowflake Data and connect to Snowflake in Akorbi Digital RunMyProcess.

• «
• 740
• 741
• 742
• 743
• 744
• 745
• 746
• 747
• 748
• 749
• »