CData Software - Knowledge Base

Recent Articles

---

• «
• 1222
• 1223
• 1224
• 1225
• 1226
• 1227
• 1228
• 1229
• 1230
• 1231
• »

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

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

• Create SSAS Tabular Models from GraphQL Data

  How to build a SQL Server Analysis Service Tabular Model from GraphQL data using CData drivers.

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

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

• Getting Started with the CData Tableau Connector for Google Sheets

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

• Integrate Devin with Live Salesforce CRM Analytics Data Using CData Connect AI

  Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Salesforce CRM Analytics data.

• Create Dynamic Kintone Grids Using the Infragistics XamDataGrid

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

• Connect to Printify Data in RapidMiner

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

• 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 data.

• Integrate Cursor with Live MySQL Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live MySQL data from within the editor.

• Build a Singer.io Tap for Clio With the CData Python Connector

  Learn how to easily build a Singer.io Tap for live Clio data using the CData Python Connector.

• Build Visualizations of Zoom Data in Birst

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

• Connect Contentful Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

  Connect to your Contentful data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

• Migrating data from PabblySubscriptions to Google BigQuery using CData SSIS Components.

  Easily push PabblySubscriptions data to Google BigQuery using the CData SSIS Tasks for PabblySubscriptions and Google BigQuery.

• Feed ServiceNow Data into FineReport

  How to set ServiceNow data 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 data from Node.js.

• How to Build an ETL App for HBase Data in Python with CData Connect AI

  Build ETL pipelines that read and write live HBase data in Python with petl and the CData Connect AI Python SDK.

• Using the CData Software ODBC Driver for Jira Assets in PyCharm

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

• Natively Connect to PhantomBuster Data in PHP via ODBC (Linux)

  Create PHP applications on Linux/UNIX machines with connectivity to PhantomBuster data. Leverage the native support for ODBC in PHP.

• Connect to EnterpriseDB Data in HULFT Integrate

  Connect to EnterpriseDB as a JDBC data source in HULFT Integrate

• Build a Simple VCL Application for WordPress Data

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

• Integrating GitHub Copilot with Avaza 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 connect to Customer.io Data from IntelliJ

  Integrate connectivity to Customer.io data with wizards in IntelliJ.

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

  Use Connect Spreadsheets by CData to gain access to live MySQL data from your Excel spreadsheets.

• Automate AdRoll Data Replication to Couchbase

  Use CData Sync to Customize and automate AdRoll data replication to Couchbase.

• Connecting Pipedream with SageHR Data via CData Connect AI MCP Server

  Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on SageHR data in real time.

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

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

• Connect FreeAgent Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

  Connect to your FreeAgent data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

• Replicate SAS Data Sets Data from PowerShell

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

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

  Execute MySQL queries against Humanity data from Node.js.

• Connect to QuickBooks Data in CloverDX (formerly CloverETL)

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

• Automated Continuous Smartsheet Replication to Google BigQuery

  Use CData Sync for automated, continuous, customizable Smartsheet replication to Google BigQuery.

• How to Connect to & Open Salesforce Data 360 Data in Microsoft Excel

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

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

  Execute MySQL queries against OneNote data from Node.js.

• Import and Visualize Placid Data in Power View

  Create data visualizations based on Placid data in Excel.

• Building Dynamic Web Pages with SAP Fieldglass Data Using AngularJS

  Create single-page applications with live connectivity to SAP Fieldglass using the CData API Server.

• Integrate with PabblySubscriptions Data using Apache Camel2

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

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

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

• Add CircleCI Data to Informatica Enterprise Data Catalog

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

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

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

• Back Up Bitbucket data 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 data.

• Migrating data from QuickBooks to Google BigQuery using CData SSIS Components.

  Easily push QuickBooks data to Google BigQuery using the CData SSIS Tasks for QuickBooks and Google BigQuery.

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

  Execute MySQL queries against Productboard data from Node.js.

• Perform Batch Operations with WordPress Data in Apache NiFi

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

• Automated Continuous Workable Replication to SingleStore

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

• Natively Connect to Wave Financial Data in PHP via ODBC (Linux)

  Create PHP applications on Linux/UNIX machines with connectivity to Wave Financial data. Leverage the native support for ODBC in PHP.

• Integrate Cline with Live Okta Data via CData Connect AI

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

• Natively Connect to Oracle Eloqua Reporting Data in PHP via ODBC (Linux)

  Create PHP applications on Linux/UNIX machines with connectivity to Oracle Eloqua Reporting data. Leverage the native support for ODBC in PHP.

• Create Salesforce Marketing-Connected Enterprise Applications in OutSystems

  Use CData Connect AI to connect to Salesforce Marketing Data from OutSystems and build custom enterprise apps using live Salesforce Marketing data.

• Create SurveyMonkey-Connected Visualizations in Klipfolio

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

• Connect to and Query Office 365 Data in QlikView over ODBC

  Create data visualizations with Office 365 data in QlikView.

• Automated Continuous Parallel Replication to Google BigQuery

  Use CData Sync for automated, continuous, customizable Parallel replication to Google BigQuery.

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

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

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

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

• Connect Gumroad to IBM WebSphere Using the CData JDBC Driver

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

• Automated Continuous Moosend Replication to PostgreSQL

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

• Analyze Wrike Data in R via JDBC

  Use standard R functions and the development environment of your choice to analyze Wrike data with the CData JDBC Driver for Wrike.

• Connect to Salesforce Data 360 Data in ACL Analytics

  Connect to Salesforce Data 360 data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Salesforce Data 360 data.

• Create Datasets from Elasticsearch in Domo Workbench and Build Visualizations of Elasticsearch Data in Domo

  Use the CData Software ODBC Driver for Elasticsearch to create datasets from Elasticsearch data in Domo Workbench and then build visualizations in the Domo service.

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

• Build an OLAP Cube in SSAS from Beeminder Data

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

• Connect Cosmos DB to AI Assistants With the CData Python MCP Server

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

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

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

• Automated Continuous AfterShip Replication to Snowflake

  Use CData Sync for automated, continuous, customizable AfterShip replication to Snowflake.

• Use Dash to Build Web Apps on Act-On Data via CData Connect AI

  Build interactive Dash web apps on live Act-On data using pandas and the CData Connect AI Python SDK.

• Getting Started with the CData SSIS Components for ShipEngine

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

• Analyze OneNote Data with Power Pivot

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

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

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

  Connect to ZohoInvoice data from a connection pool in Tomcat.

• Working with Figshare Data in LINQPad

  Execute LINQ queries to Figshare data in LINQPad.

• Connect to Amazon S3 Data from a Connection Pool in Jetty

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

• Build Bullhorn CRM-Connected Dashboards Using Zoho Analytics

  Use CData Connect AI to connect to Bullhorn CRM Data from Zoho Analytics and import live Bullhorn CRM data.

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

  Create an ODBC connection to EnterpriseDB in Informatica and browse and transfer EnterpriseDB data.

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

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

• Integrate Google's Antigravity Agent with Live GetResponse Data via CData Connect AI

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

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

• How to connect and process MySQL data from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live MySQL data.

• Integrate Freshsales Data in the Pentaho Report Designer

  Publish reports based on Freshsales data in the Pentaho BI tool.

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

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

• Publish AgileCRM-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live AgileCRM data.

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

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

• Build an OLAP Cube in SSAS from Mailjet Data

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

• Connect to Guru Data in RunMyProcess through Connect AI

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

• Import ShipEngine Data into the Power BI Service for Visualizations

  Use CData Connect AI to connect to ShipEngine Data and provide access to live ShipEngine data for custom reports in the Power BI Service.

• Automated Continuous Act CRM Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable Act CRM replication to Apache Kafka.

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

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

• Use the CData Software ODBC Driver for Quaderno in MicroStrategy

  Connect to Quaderno data in MicroStrategy Developer using the CData Software ODBC Driver for Quaderno.

• How to connect Amazon QuickSight to SAP HANA Data

  Create a connection to SAP HANA data in CData Connect AI and insert SAP HANA data into Amazon QuickSight SPICE to build interactive dashboards.

• Connect to and Query Printify Data in QlikView over ODBC

  Create data visualizations with Printify data in QlikView.

• LinkedIn Reporting and Star Schemas in OBIEE

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

• Connect to Klaviyo from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Klaviyo to connect to Klaviyo data from Web applications running on WebLogic.

• Connect to Splunk Data in HULFT Integrate

  Connect to Splunk as a JDBC data source in HULFT Integrate

• Design BIRT Reports on Oracle Data

  Provide current Oracle data to your embedded analytics.

• How to create Pinterest federated tables in MySQL

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

• Integrate Cline with Live ShipStation Data via CData Connect AI

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

• Power BI XMLA Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on Power BI XMLA facts in real time.

• Publish Reports with Accelo Data in SAP Crystal Reports

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

• Connect to Stack Exchange Data in DBArtisan

  Use wizards in DBArtisan to configure Stack Exchange data as a data source.

• Explore Geographical Relationships in Authorize.Net Data with Power Map

  Create data visualizations with Authorize.Net data in Power Map.

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

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

• Integrate with Salesforce Data 360 Data in JReport Designer

  Create charts and reports based on Salesforce Data 360 data in JReport Designer.

• «
• 1222
• 1223
• 1224
• 1225
• 1226
• 1227
• 1228
• 1229
• 1230
• 1231
• »