CData Software - Knowledge Base

Recent Articles

---

• «
• 235
• 236
• 237
• 238
• 239
• 240
• 241
• 242
• 243
• 244
• »

• How to create Parallel federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for Parallel in MySQL .

• Create Dashboards and Visualize Live FTP Data in Geckoboard

  Use CData Connect AI to connect to live FTP Servers and create dashboards for real-time monitoring and visualization in Geckoboard.

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

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

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

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

• Getting Started with the CData Tableau Connector for Google Sheets

  Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Google Spreadsheets.

• Connect to PivotalTracker Data in DBeaver

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

• How to connect to SendPulse Data from Spring Boot

  Connect to SendPulse in a Spring Boot Application using the CData API Driver for JDBC

• Build Dashboards with QuickBooks Time Data in DBxtra

  Create dynamic dashboards and perform analytics based on QuickBooks Time in DBxtra.

• Load Paymo Data to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Paymo to a database.

• Connect to Printify Data in RapidMiner

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

• Create Data Visualizations in Cognos BI with Postmark Data

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

• Use the CData ODBC Driver for Zoho Books from SharePoint Excel Services

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

• Create Okta-Connected Applications in Appsmith

  Connect to Okta Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Okta.

• Bidirectional Access to SQL Analysis Services Data from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate SQL Analysis Services in Filemaker Pro for Mac or Windows.

• Write a Simple Go Application to work with SAP BusinessObjects BI Data on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SAP BusinessObjects BI.

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

• Feed ServiceNow Data into FineReport

  How to set ServiceNow as a JDBC data source in FineReport.

• Query SAP Business One Data as a MySQL Database in Node.js

  Execute MySQL queries against SAP Business One from Node.js.

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

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

• Access Live SAP Netweaver Gateway 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 SAP Netweaver Gateway through MCP integration.

• Query Helpscout Data in DataGrip

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

• Create Dashboards and Visualize Live Okta Data in Geckoboard

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

• Access Cvent Data from MySQL in Amazon QuickSight

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

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

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

• How to Connect Freshdesk Data to Gemini Enterprise via CData Connect AI

  Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Freshdesk data in real time using natural language.

• Build a Simple VCL Application for WordPress Data

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

• How to connect to Customer.io Data from IntelliJ

  Integrate connectivity to Customer.io with wizards in IntelliJ.

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

  Use CData Power BI Connectors to visualize Templated in Power BI.

• Connect to Bitly Data in Claris FileMaker Pro

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

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

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

• How to connect PolyBase to Paylocity

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

• Publish Crystal Reports on FreshBooks Data

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

• Query SAP Ariba Source Data through ODBC in Node.js

  Use node-odbc to execute SQL queries against SAP Ariba Source from Node.js.

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

  Execute MySQL queries against Humanity from Node.js.

• Connect to IBM Informix from Asprova with CData Software ODBC Driver for IBM Informix

  This article shows how to connect faster to IBM Informix data from Asprova.

• Choosing the Best Method to Connect Short.io to SQL Server: 5 Options Explained

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

• Manage Zoho Creator Data in DBArtisan as a JDBC Source

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

• Prepare, Blend, and Analyze EnterpriseDB Data in Alteryx Designer (ODBC)

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

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

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

• How to connect SharePoint with Helpscout Data through external lists

  Provide Helpscout to SharePoint users as an external list.

• Analyze Google Ads Data in Cognos Analytics

  Use CData Connect AI to connect to Google Ads Data from Cognos Analytics and analyze live Google Ads.

• Integrate Cline with Live Hive Data via CData Connect AI

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

• Automated Continuous Salesloft Replication to SQLite

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

• Connect to and Query PagerDuty Data in QlikView over ODBC

  Create data visualizations with PagerDuty in QlikView.

• Use the CData SSIS Components to Insert New or Update Existing SAP Netweaver Gateway Records from SQL Server

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

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

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

• Connect to and Visualize Live Tickspot Data in Tableau Prep

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

• Migrating data from HCL Domino to Snowflake using CData SSIS Components.

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

• Connect to LightSpeedRetail Data in Aqua Data Studio

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

• Analyze BambooHR Data in Slingshot with CData API Server

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

• Analyze Google Contacts Data in Infragistics Reveal

  Use the CData API Server to create an OData API on top of Google Contacts and visualize live Google Contacts in Infragistics Reveal.

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

• Validate Helpscout Data with QuerySurge

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

• Back Up Bitbucket to SQL Server through SSIS

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

• Easily Integrate Basecamp Data in Lazarus Pascal IDE

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

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

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

• How to Access Live Google Ads Data in Visual Studio Code via Cline

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

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

• Perform Batch Operations with WordPress Data in Apache NiFi

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

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

• Enable the Teamwork JDBC Driver in KNIME

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

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

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

• Excel Spreadsheet Automation on Sage 200 Data with the QUERY Formula

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

• Connect to Workday Data in Claris FileMaker Pro

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

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

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

• Build Data Flows from SQL Server to Teradata through SSIS

  Easily push SQL Server data to Teradata using the CData SSIS Tasks for Teradata.

• Automated Continuous Moosend Replication to PostgreSQL

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

• Connect to Exact Online Data in RazorSQL

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

• Connect to SQL Analysis Services Data in CloverDX (formerly CloverETL)

  Transfer SQL Analysis Services using the visual workflow in the CloverDX data integration tool.

• Build a Simple VCL Application for Trello Data

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

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

  Create ETL applications and real-time data pipelines for IBM Informix in Python with petl.

• Access Live Box Data in SAS JMP via ODBC

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

• How to Import Data from CockroachDB into Google Sheets

  Import CockroachDB into a Google spreadsheet that is automatically refreshed.

• Build Voice Agents in ElevenLabs with access to Live Microsoft Dataverse Data

  Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Microsoft Dataverse (CDS).

• Create Power BI Reports on Real-Time Bright Data Data

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

• Feed Salesforce CRM Analytics Data into FineReport

  How to set Salesforce CRM Analytics as a JDBC data source in FineReport.

• Automated Vertica Data Replication to Teradata

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

• Create a Data Access Object for Email Data using JDBI

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

• Automate Float Data Replication to Azure Data Lake

  Use CData Sync to customize and automate Float replication to Azure Data Lake.

• Automate IBM Informix Tasks in Power Automate Using CData API Server

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

• Connect to MarkLogic Data in Jaspersoft Studio

  Execute SQL to remote MarkLogic in Jaspersoft Studio.

• Create Informatica Mappings From/To a JDBC Data Source for CSV

  Create CSV data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• Automated Continuous Delighted Data Replication to OneLake in Microsoft Fabric

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

• Import Amazon DynamoDB Data into Microsoft Power Query

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

• Integrate Gmail Data in the Pentaho Report Designer

  Publish reports based on Gmail in the Pentaho BI tool.

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

  Execute MySQL queries against Placid from Node.js.

• Use the CData API Server in Microsoft Power BI

  You can use the CData API Server to feed Bullhorn CRM to Power BI dashboards. Simply drag and drop Bullhorn CRM into data visuals on the Power BI canvas.

• Easily Integrate Figshare Data in Lazarus Pascal IDE

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

• Connect to Sybase IQ Data from PowerBuilder via ADO.NET

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

• Integrate Freshsales Data in the Pentaho Report Designer

  Publish reports based on Freshsales in the Pentaho BI tool.

• Explore Geographical Relationships in Adobe Commerce Data with Power Map

  Create data visualizations with Adobe Commerce in Power Map.

• Build Automated Workflows with Live SAP ByDesign Data in Workato

  Use CData Connect AI to connect to live SAP Business ByDesign and build automated workflows in Workato.

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

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

• Connect to Facebook Ads Data from AWS Glue

  Use CData Connect AI to gain access to live Facebook Ads from your AWS Glue jobs.

• Replicate ZohoDesk Data to Multiple Databases

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

• Query Clari Data from Node.js

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

• How to Access Live BenchmarkEmail Data in Power Automate Desktop via ODBC

  The CData ODBC Driver for BenchmarkEmail enables you to integrate BenchmarkEmail into workflows built using Microsoft Power Automate Desktop.

• How to Query Live PDFMonkey Data in Perplexity MacOS Desktop

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

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

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

• «
• 235
• 236
• 237
• 238
• 239
• 240
• 241
• 242
• 243
• 244
• »