CData Software - Knowledge Base

Recent Articles

---

• «
• 819
• 820
• 821
• 822
• 823
• 824
• 825
• 826
• 827
• 828
• »

• Connect to GitLab Data in RapidMiner

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

• Connect to REST Data from Blazor Apps

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

• Build AI/ML Models with Live Pipedrive Data using Dataiku

  Connect Pipedrive Data with Dataiku using the CData JDBC Driver for Pipedrive.

• Query Zoho Inventory Data in DataGrip

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

• How to Access Live Google Campaign Manager 360 Data in Visual Studio Code via Cline

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

• Connect to Workday Data in RapidMiner

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

• Analyze Salesforce Data with PowerPivot

  This article walks you through the process of using the CData ODBC Driver for Salesforce from PowerPivot. The technique described in this article can be used with any CData ODBC Driver.

• Integrating Kiro CLI with Google Ad Manager 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 to Asana Data from PowerBuilder via ADO.NET

  This article demonstrates how to access Asana from Appeon PowerBuilder using the CData ADO.NET Provider for Asana.

• Automated Continuous Hubstaff Replication to SingleStore

  Use CData Sync for automated, continuous, customizable Hubstaff replication to SingleStore.

• Use Databricks Agent Bricks to Talk to Your WordPress Data via CData Connect AI

  Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your WordPress for you.

• Query Campaigner Data through ODBC in Node.js

  Use node-odbc to execute SQL queries against Campaigner from Node.js.

• Integrating Antigravity CLI with Coda via CData CLI

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

• How to connect and process Microsoft SQL Server from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Microsoft SQL Server.

• Automate Supabase Data Replication to SAP HANA

  Use CData Sync to customize and automate Supabase replication to SAP HANA.

• How to Query HCL Domino Data in MySQL Workbench

  Execute MySQL queries against live HCL Domino from MySQL Workbench.

• Automated Continuous HDFS Replication to SQLite

  Use CData Sync for automated, continuous, customizable HDFS replication to SQLite.

• Enable the Dotmailer JDBC Driver in KNIME

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

• NetSuite Reporting in OBIEE with the NetSuite JDBC Driver

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

• Process & Analyze Amazon Athena Data in Databricks (AWS)

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

• Connect to Elasticsearch Data in Jaspersoft Studio

  Execute SQL to remote Elasticsearch in Jaspersoft Studio.

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

  Build interactive Dash web apps on live NetSuite CRM & ERP using pandas and the CData Connect AI Python SDK.

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

  Build interactive Dash web apps on live Salesforce & Force.com using pandas and the CData Connect AI Python SDK.

• Getting Started with the CData Excel Add-In for Salesforce Pardot

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

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

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

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

  Provide connectivity to WooCommerce through an SAP BusinessObjects universe.

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

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

• Getting Started with the CData Power BI Connector for Oracle Service Cloud

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

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

  Create ETL applications and real-time data pipelines for Bright Data in Python with petl.

• Getting Started with the CData JDBC Driver for Greenplum

  Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Greenplum.

• How to Work with Google Calendar Data in ETL Validator JDBC

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

• How to Easily Query Pipeline CRM Data in OpenOffice Base

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

• Work with HelloSign Data in FoxPro

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

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

• SAP Reporting and Star Schemas in OBIEE

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

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

• Connect to Office 365 Data from AWS Glue

  Use CData Connect AI to gain access to live Microsoft Office 365 from your AWS Glue jobs.

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

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

• Create Power BI Reports on Real-Time Pipeline CRM Data

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

• Automated Continuous VWO Data Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable VWO replication to OneLake in Microsoft Fabric.

• Migrating data from Mixpanel to Snowflake using CData SSIS Components.

  Easily push Mixpanel to Snowflake using the CData SSIS Tasks for Mixpanel and Snowflake.

• Build a Simple VCL Application for SparkPost Data

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

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

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

• Explore Geographical Relationships in MailerSend Data with Power Map

  Create data visualizations with MailerSend in Power Map.

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

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

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

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

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

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

• Replicate TaxJar Data from PowerShell

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

• Add Shortcut Data to Informatica Enterprise Data Catalog

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

• Process & Analyze ServiceDesk Plus Data in Databricks (AWS)

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

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

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

• Integrate ActiveCampaign Data into Automated Tasks with Power Automate

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

• Visualize SAS xpt Data in TIBCO Spotfire through ADO.NET

  Integrate SAS XPORT into dashboards in TIBCO Spotfire.

• How to Query Live Blackbaud FE NXT Data in Claude Desktop

  Connect to and query live Blackbaud FE NXT Data in Claude Desktop using CData MCP Server.

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

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

• Automated Exa Data Replication to Teradata

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

• Automate ADP Data Replication to Couchbase

  Use CData Sync to Customize and automate ADP replication to Couchbase.

• Integrate ConvertKit Data in the Pentaho Report Designer

  Publish reports based on ConvertKit in the Pentaho BI tool.

• Getting Started with the CData Python Connector for Confluence

  Learn to install and license the CData Python Connector

• Process & Analyze ChargeOver Data in Databricks (AWS)

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

• Connect to BigCommerce Data from PowerBuilder via JDBC

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

• DataBind Mouseflow Data to the DevExpress Data Grid

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

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

• Connect to BambooHR Data from Blazor Apps

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

• Visualize Live QuickBooks Online Data of Power BI Report Builder in Power BI Service

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

• Build Visualizations of Adobe Analytics Data in Birst

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

• Create Power BI Reports on Real-Time ClickUp Data

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

• How to Access Live Sage Intacct Data in Visual Studio Code via Cline

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

• Excel Spreadsheet Automation on Rebilly Data with the QUERY Formula

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

• Create Microsoft Ads-Connected Nintex Workflows

  Use CData Connect AI to connect to Microsoft Ads Data from Nintex Workflow Cloud and build custom workflows using live Microsoft Ads.

• Build Dashboards with Salesforce Data in DBxtra

  Create dynamic dashboards and perform analytics based on Salesforce & Force.com in DBxtra.

• Connect to Phoenix Data in Aqua Data Studio

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

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

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

• Connect to Trello Data Using the Script Function in Claris FileMaker Pro

  Use the CData ODBC Driver for Trello and the Script function in FileMaker Pro to connect to Trello and work with Trello in your FileMaker application.

• Excel Spreadsheet Automation on Testmonitor Data with the QUERY Formula

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

• DataBind Controls to Access Data in C++Builder

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

• Getting Started with the CData SSIS Components for Slack

  Complete guide to installing, licensing, and connecting with the CData SSIS Components for Slack.

• DataBind Dynamics NAV Data to the DevExpress Data Grid

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

• Connect to Redshift Data in Ruby

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

• Connect to Chargebee Data from PowerBuilder via JDBC

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

• Model Airtable Data Using Azure Analysis Services

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

• Add Browserless Data to Informatica Enterprise Data Catalog

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

• Natively Connect to SQL Analysis Services Data in PHP

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

• Automated Continuous Aweber Replication to Databricks

  Use CData Sync for automated, continuous, customizable Aweber replication to Databricks.

• Use the CData ODBC Driver for SAP ByDesign from SharePoint Excel Services

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

• Access Live SAP Business One Data in Tableau with CData API Server

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

• Create SAS xpt-Connected Dashboards in Grafana

  Connect to SAS xpt Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to SAS XPORT.

• Connect to SendGrid Data through External Services in Salesforce

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

• Enable the Klipfolio JDBC Driver in KNIME

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

• Bridge SAP BusinessObjects BI Connectivity with Apache NiFi

  Access and process SAP BusinessObjects BI in Apache NiFi using the CData JDBC Driver.

• Getting Started with the CData Power BI Connector for HubSpot

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

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

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

• DataBind WordPress Data to the DevExpress Data Grid

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

• Visualize CircleCI Data in TIBCO Spotfire through ADO.NET

  Integrate CircleCI into dashboards in TIBCO Spotfire.

• Deploy the ADO.NET Provider for Google Cloud Storage on an SSRS Report Server

  Connect to Google Cloud Storage 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.

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

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

• How to Query Live Amazon DynamoDB Data in Perplexity MacOS Desktop

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

• Automate MailerLite Data Replication to Azure Synapse

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

• Visualize Planio Data in Tableau

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

• Connect to Dynamics 365 Business Central from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Dynamics 365 Business Central to connect to Dynamics 365 Business Central from Web applications running on WebLogic.

• «
• 819
• 820
• 821
• 822
• 823
• 824
• 825
• 826
• 827
• 828
• »