CData Software - Knowledge Base

Recent Articles

---

• «
• 1246
• 1247
• 1248
• 1249
• 1250
• 1251
• 1252
• 1253
• 1254
• 1255
• »

• ETL Greenplum in Oracle Data Integrator

  This article shows how to transfer Pivotal GreenPlum into a data warehouse using Oracle Data Integrator.

• How to Connect to Live BigQuery Data from Google ADK Agents (via CData Connect AI)

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

• Access Missive Data from MySQL in Amazon QuickSight

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

• Back Up SAP Ariba Procurement to SQL Server through SSIS

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

• How to Connect to & Open SAP SuccessFactors LMS Data in Microsoft Excel

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

• Explore Geographical Relationships in Aha! Data with Power Map

  Create data visualizations with Aha! in Power Map.

• Access Live Spotify Data in SAS JMP via ODBC

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

• Build an OLAP Cube in SSAS from Elorus Data

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

• Integrating Gumloop with Google Ads Data via CData Connect AI

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

• Create Reports from Avalara AvaTax Data in Looker Studio

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

• Connect to MariaDB Data in Jaspersoft Studio

  Execute SQL to remote MariaDB in Jaspersoft Studio.

• Work with ConvertAPI Data in FoxPro

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

• Visualize Live SAP HANA Data in Power BI (via CData Connect AI)

  Use the CData Power BI Connector and CData Connect AI to integrate live SAP HANA into custom reports in Power BI.

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

  Execute MySQL queries against Billsby from Node.js.

• Visualize Live Procore Data of Power BI Report Builder in Power BI Service

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

• Easily Integrate Greenhouse Data in Lazarus Pascal IDE

  Learn how to easily integrate live Greenhouse in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

• Connect to Optimizely Data in HULFT Integrate

  Connect to Optimizely as a JDBC data source in HULFT Integrate

• Access Live Google Sheets Data in Excel (Desktop) through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Google Sheets from your Excel spreadsheets.

• How to Connect to Live Salesforce 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 Salesforce & Force.com for you.

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

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

• Create Power BI Reports on Real-Time Bannerbear Data

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

• Connect to Facebook Data in Jaspersoft Studio

  Execute SQL to remote Facebook in Jaspersoft Studio.

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

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

• Connecting Mastra with Zoho Creator 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 Zoho Creator, no replication required.

• Replicate Quaderno Data to Multiple Databases

  Replicate Quaderno to disparate databases with a point-and-click configuration.

• Consume Blackbaud FE NXT OData Feeds in PowerBuilder

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

• How to Access Google Ad Manager Data Using Entity Framework

  This article shows how to access Google Ad Manager using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

• Prepare, Blend, and Analyze Google Cloud Storage Data in Alteryx Designer (ODBC)

  Build workflows to access live Google Cloud Storage for self-service data analytics.

• Automate GetResponse Data Replication to Azure Synapse

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

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

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

• Publish Missive-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Missive.

• Replicate Multiple Printify Accounts via the CData Sync CLI

  Replicate multiple Printify accounts to one or many databases.

• Access Live ZeroBounce Data in SAS JMP via ODBC

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

• Import Zoho Inventory Data Using Azure Data Factory

  Use CData Connect AI to connect to Zoho Inventory Data from Azure Data Factory and import live Zoho Inventory.

• Enable the Zoho Books JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Zoho Books.

• Visualize MYOB AccountRight Data in Sisense

  Create an ElastiCube in Sisense app with access to MYOB AccountRight.

• Publish Reports with SAP Business Warehouse Data in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date SAP Business Warehouse.

• Integrate Calendly Data in the Pentaho Report Designer

  Publish reports based on Calendly in the Pentaho BI tool.

• Build Apps with Live Apache Impala in Adalo using CData Connect AI

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

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

  Connect to PivotalTracker from a connection pool in Tomcat.

• Use the CData Software ODBC Driver for Auth0 in MicroStrategy Web

  Connect to Auth0 in MicroStrategy Web using the CData Software ODBC Driver for Auth0.

• Connect Grafana to AI Assistants With the CData Python MCP Server

  Learn how to give AI assistants like Claude direct access to live Grafana using the CData Python MCP Server.

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

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

• Connect to BambooHR Data in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Access Salesloft Data from MySQL in HeidiSQL

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

• Automated Monday.com Data Replication to Teradata

  Use CData Sync to Customize and automate Monday.com replication to Teradata.

• Connect to Lakebase Data in Aqua Data Studio

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

• Bind Live SharePoint Excel Services Data in Wijmo FlexGrid with CData API Server

  With CData API Server, easily create OData endpoints for live SharePoint Excel Services data

• Query Microsoft Planner Data in DataGrip

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

• Connect to Snowflake Data from PowerBuilder via JDBC

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

• Access VWO Data in Mule Applications Using the CData JDBC Driver

  Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for VWO.

• Integrating Elorus Data in Talend Cloud Data Management Platform

  Connect Elorus Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.

• Create Power BI Reports on Real-Time Aweber Data

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

• Integrating LangGraph with Hive Data via CData Connect AI

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

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

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

• Consume Sugar CRM OData Feeds in PowerBuilder

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

• Visualize Flowlu Data from Tableau

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

• Connect to SAP HANA Data through External Services in Salesforce

  Use CData Connect AI to securely connect Salesforce External Services with SAP HANA Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.

• Access Live Exact Online Data in Excel 365 Online (Excel for the web)

  Connect to Exact Online from Excel 365 Online (Excel for the web) with CData Connect AI.

• Getting Started with the CData Power BI Connector for Auth0

  Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.

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

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

• Use the CData Software ODBC Driver for Sage 300 in MicroStrategy Web

  Connect to Sage 300 in MicroStrategy Web using the CData Software ODBC Driver for Sage 300.

• How to load Neo4J data into Elasticsearch via Logstash

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

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

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

• Manage Azure Table Data in DBArtisan as a JDBC Source

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

• Automated Continuous LinkedIn Ads Replication to SQL Server

  Use CData Sync for automated, continuous, customizable LinkedIn Ads replication to SQL Server.

• Bridge MailChimp Connectivity with Apache NiFi

  Access and process MailChimp in Apache NiFi using the CData JDBC Driver.

• Create Dashboards and Visualize Live Excel Online Data in Geckoboard

  Use CData Connect AI to connect to live Microsoft Excel Online and create dashboards for real-time monitoring and visualization in Geckoboard.

• Connect to Reckon Accounts Hosted Data in the Denodo Platform

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

• Access AdRoll Data in Mule Applications Using the CData JDBC Driver

  Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for AdRoll.

• Create Power BI Reports on Real-Time MariaDB Data

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

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

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

• Build an OLAP Cube in SSAS from QuickBooks Online Data

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

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

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

• Use the CData Software ODBC Driver for Cassandra in MicroStrategy Web

  Connect to Apache Cassandra in MicroStrategy Web using the CData Software ODBC Driver for Cassandra.

• Automated Continuous Elasticsearch Replication to Oracle

  Use CData Sync for automated, continuous, customizable Elasticsearch replication to Oracle.

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for Aircall

  Provide connectivity to Aircall through an SAP BusinessObjects universe.

• How to Work with Excel Online Data in ETL Validator JDBC

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

• Build Dashboards with Pipeliner CRM Data in DBxtra

  Create dynamic dashboards and perform analytics based on Pipeliner CRM in DBxtra.

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

  Use CData JDBC drivers to import and use LinkedIn Ads in ColdFusion.

• Integrating Kiro CLI with Bitbucket 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.

• Access Live JSON Data in Tableau with CData API Server

  With CData API Server, easily create OData endpoints for live JSON data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.

• Connect to ZeroBounce Data from PowerBuilder via ODBC

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

• Integrating LangGraph with SAP HANA Data via CData Connect AI

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

• Query Miro Data in DataGrip

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

• Visualize Authorize.Net Data in TIBCO Spotfire through ADO.NET

  Integrate Authorize.Net into dashboards in TIBCO Spotfire.

• Connect to OData Services in RazorSQL

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

• Build Charts with Phoenix Data in Clear Analytics

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

• JotForm Reporting in OBIEE with the JotForm JDBC Driver

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

• Use Agno to Talk to Your Dynamics 365 Business Central 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 Dynamics 365 Business Central for you.

• DataBind Controls to SAP Fieldglass Data in Delphi

  DataBind to SAP Fieldglass in Delphi with standard data access components and controls.

• Build a Simple VCL Application for Slack Data

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

• Connect to Procore Data from PowerBuilder via ODBC

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

• How to connect PolyBase to JSON

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

• Process & Analyze Strava Data in Databricks (AWS)

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

• Access Live Box Data in Roo Code via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Box through MCP integration.

• How to Access Live SQL Analysis Services Data in Visual Studio Code via Cline

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

• Connect to PayPal in SpagoBI

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

• Integrating Claude Code CLI with Eventbrite 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.

• Connect Dynamics NAV to IBM WebSphere Using the CData JDBC Driver

  Use the CData JDBC Driver to connect Dynamics NAV with IBM WebSphere for seamless data integration and connectivity.

• «
• 1246
• 1247
• 1248
• 1249
• 1250
• 1251
• 1252
• 1253
• 1254
• 1255
• »