CData Software - Knowledge Base

Recent Articles

---

• «
• 1130
• 1131
• 1132
• 1133
• 1134
• 1135
• 1136
• 1137
• 1138
• 1139
• »

• Manage Freshsales Data in DBArtisan as a JDBC Source

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

• Automated Continuous Redis Replication to SQLite

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

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

  Use CData JDBC drivers to import and use ShipEngine data in ColdFusion.

• Integrating Cursor with SAP Ariba Source 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.

• Use the CData Software ODBC Driver for Zendesk in SAS for Real-Time Reporting and Analytics

  Connect to real-time Zendesk data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Zendesk.

• Automated Continuous NetSuite Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable NetSuite replication to Google Cloud SQL.

• DataBind Controls to DocuSign Data in Delphi

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

• Connect to FreshBooks Data from PowerBuilder via JDBC

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

• Use the CData Software JDBC Driver for Slack in MicroStrategy Desktop

  Connect to Slack data in MicroStrategy Desktop using the CData Software JDBC Driver for Slack.

• How to Connect to & Open Mode Data in Microsoft Excel

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

• Replicate Mailjet Data in Heroku for Use in Salesforce Connect

  Replicate Mailjet data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Build LDAP Visualizations in Tableau Desktop

  Use CData Connect AI to connect to live LDAP objects and build visualizations in Tableau.

• Build an OLAP Cube in SSAS from Impala Data

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

• Connect to and Query OnePageCrm Data in QlikView over ODBC

  Create data visualizations with OnePageCrm data in QlikView.

• Integrating Cursor with Zoho CRM 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.

• Build Jira Assets Visualizations in Tableau Cloud

  Use CData Connect AI to connect to live Jira Assets data and build visualizations in Tableau Cloud.

• Connect to Planio Data in Ruby

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

• Integrate Devin with Live Amazon Marketplace 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 Amazon Marketplace data.

• Design BIRT Reports on LaunchDarkly Data

  Provide current LaunchDarkly data to your embedded analytics.

• How to connect to ClickTime Data from Spring Boot

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

• Integrate Cloudant Data in Pentaho Data Integration

  Build ETL pipelines based on Cloudant data in the Pentaho Data Integration tool.

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

  Execute MySQL queries against Apollo data from Node.js.

• Access Live Todoist Data in Coginiti Pro

  Connect to and query live Todoist data from the GUI in the Coginiti Pro: SQL Analytics Tool.

• Automated Continuous Microsoft Entra ID Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Microsoft Entra ID replication to SQL Server.

• Access Live ZohoPeople Data in AWS Lambda

  Connect to live ZohoPeople data in AWS Lambda using the CData JDBC Driver.

• Access ChartMogul Data from MySQL in PHP

  Connect to ChartMogul through the standard MySQL libraries in PHP.

• Validate Recurly Data with QuerySurge

  Access and validate Recurly data in QuerySurge using the CData JDBC Driver.

• How to Seamlessly Import Google Sheets Data into IBM SPSS Modeler

  Integrate Google Sheets data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

• Enable the Microsoft Entra ID JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Microsoft Entra ID data.

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

• Bridge Notion Connectivity with Apache NiFi

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

• Build Hubstaff-Connected Web Apps in Servoy

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

• Use the CData ODBC Driver for Hacker News from SharePoint Excel Services

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

• How to Visualize QuickBooks Online Data in Python with pandas

  Use pandas and other modules to analyze and visualize live QuickBooks Online data in Python.

• Connect to CouchDB Data from PowerBuilder via ODBC

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

• Connect to Telegram Data in Jaspersoft Studio

  Execute SQL to remote Telegram data in Jaspersoft Studio.

• Analyze GitHub Data with Power Pivot

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

• Getting Started with the CData Connect AI Python SDK for Procore

  Install the CData Connect AI Python SDK to read live Procore data with standard DB-API 2.0 Python code.

• Publish Crystal Reports on Google Directory Data

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

• Stream SharePoint Excel Services Data into Apache Kafka Topics

  Access and stream SharePoint Excel Services data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Back Up Guru data to SQL Server through SSIS

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

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

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

• Automated Continuous Teamgate Replication to Oracle

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

• Connect to Office 365 Data as an External Source in Dremio

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

• Use Dash to Build to Web Apps on Bannerbear Data

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

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

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

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

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

• Import Dynamics CRM Data Using Azure Data Factory

  Use CData Connect AI to connect to Dynamics CRM Data from Azure Data Factory and import live Dynamics CRM data.

• Automated Continuous WooCommerce Replication to Oracle

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

• Operational Reporting on Salesloft Data from Spotfire Server

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

• Manage GitLab Data in DBArtisan as a JDBC Source

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

• Prepare, Blend, and Analyze Moosend Data in Alteryx Designer (Connect AI)

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

• Use the CData Software JDBC Driver for Coinbase in MicroStrategy Desktop

  Connect to Coinbase data in MicroStrategy Desktop using the CData Software JDBC Driver for Coinbase.

• Connect to Nuclia Data in HULFT Integrate

  Connect to Nuclia as a JDBC data source in HULFT Integrate

• Use the CData Software JDBC Driver for BambooHR in MicroStrategy Desktop

  Connect to BambooHR data in MicroStrategy Desktop using the CData Software JDBC Driver for BambooHR.

• Work with Cloudflare Data in FoxPro

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

• Back Up ConstantContact data to SQL Server through SSIS

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

• Automated Continuous SAP BusinessObjects BI Data Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI data replication to OneLake in Microsoft Fabric.

• Access Live MongoDB Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

  Connect to MongoDB data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

• How to Query Microsoft OneDrive Data in MySQL Workbench

  Execute MySQL queries against live Microsoft OneDrive data from MySQL Workbench.

• Integrate with Live Azure Table Data in MuleSoft (via CData Connect AI)

  Use CData Connect AI to connect to Azure Table from the MuleSoft Anypoint Platform to integrate live Azure Table data into custom reports and dashboards.

• Establish a Live Connection with Recurly Data using Tableau Bridge

  The CData ODBC Driver for Recurly enables you to integrate live Recurly data into Tableau Cloud dashboards using the Tableau Bridge.

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

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

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

• Automated Continuous SAP BusinessObjects BI Replication to MySQL

  Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to MySQL.

• Build Automated Workflows with Live Anaplan Data in Workato

  Use CData Connect AI to connect to live Anaplan data and build automated workflows in Workato.

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

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

• Write a Simple Go Application to work with Pingdom Data on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Pingdom data.

• Access Shopify Data from MySQL in HeidiSQL

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

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

  Provide connectivity to Spotify data through an SAP BusinessObjects universe.

• Explore Geographical Relationships in Dotmailer Data with Power Map

  Create data visualizations with Dotmailer data in Power Map.

• Connect to Google Cloud Storage Data from Filemaker Pro (Mac)

  Use CData Connect AI to connect to and query live Google Cloud Storage data from Filemaker Pro on Mac.

• Connect to Bannerbear Data from a Connection Pool in Jetty

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

• Extract, Transform, and Load Microsoft Dataverse Data in Informatica PowerCenter

  Create a simple Workflow for Microsoft Dataverse data in Informatica PowerCenter.

• Automated Continuous EmailOctopus Replication to Amazon S3

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

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

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

• Use Claude to Talk to Your SendGrid Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your SendGrid data for you.

• Automated Continuous Productboard Replication to Oracle

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

• Create a Data Access Object for Basecamp Data using JDBI

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

• Natively Connect to Google Search Results in PHP via ODBC (Linux)

  Create PHP applications on Linux/UNIX machines with connectivity to Google Search results. Leverage the native support for ODBC in PHP.

• Analyze Live SuiteCRM Data in SAS Viya

  Use CData Connect AI to connect to SuiteCRM data from SAS Viya and deploy self-service analytics using live SuiteCRM data.

• Access Bright Data 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 Bright Data data.

• Access Live Miro Data in SAS JMP via ODBC

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

• Visualize Spark Data in Sisense

  Create an ElastiCube in Sisense app with access to Spark data.

• Create JSON-Connected Enterprise Applications in OutSystems

  Use CData Connect AI to connect to JSON Services from OutSystems and build custom enterprise apps using live JSON services.

• Integrate Google Contacts Data into Power Automate Desktop using CData Connect

  CData Connect for Google Contacts Data enables you to integrate Google Contacts data into workflows built using Microsoft Power Automate Desktop.

• Work with Aweber Data in FoxPro

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

• Automated Continuous Zoom Replication to MongoDB

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

• Create Salesforce Pardot Dataflows on PowerBI.com

  Connect to the CData Power BI Connector for Salesforce Pardot from PowerBI.com to create Power BI Dataflows with real-time data.

• Analyze SageHR Data in Cognos Analytics

  Use CData Connect AI to connect to SageHR Data from Cognos Analytics and analyze live SageHR data.

• Back Up Active Directory data to SQL Server through SSIS

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

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

  With CData API Server, easily create OData endpoints for live Elasticsearch data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.

• Access Sage 300 Data from MySQL in PHP

  Connect to Sage 300 through the standard MySQL libraries in PHP.

• Stream BigQuery Data into Apache Kafka Topics

  Access and stream BigQuery data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Connect to Bright Data Data in Ruby

  Connect to Bright Data data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

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

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

• Build Pipedrive-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Pipedrive data.

• Access Beeminder Data from MySQL in HeidiSQL

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

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

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

• Transfer data from Excel to QuickBooks using the CData Excel Add-In

  This article explains how to transfer data from Excel to QuickBooks using the CData Excel Add-In for QuickBooks. For this example, we will use the Customers table;however, the same process will work for any table that can be retrieved by the Excel Add-In.

• «
• 1130
• 1131
• 1132
• 1133
• 1134
• 1135
• 1136
• 1137
• 1138
• 1139
• »