CData Software - Knowledge Base
Recent Articles
-
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.
-
Automated Continuous REST Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable REST replication to Google BigQuery.
-
Integrate with SAP Concur Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SAP Concur data to a JSON file on disk.
-
How to load SAS xpt data into Elasticsearch via Logstash
Introducing a simple method to load SAS xpt data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Access Live Zendesk Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Zendesk data from your Excel spreadsheets.
-
Connect to MailChimp Data in Aqua Data Studio
Access MailChimp data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Optimizely Data from a Connection Pool in Jetty
The Optimizely JDBC Driver supports connection pooling: This article shows how to connect faster to Optimizely data from Web apps in Jetty.
-
Integrate Real-Time Access to HBase in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to HBase data in real time.
-
Integrate with HDFS Data in SnapLogic
Use CData Connect AI to connect to and integrate with live HDFS data in SnapLogic.
-
Publish Reports with Vimeo Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Vimeo data.
-
Use the CData ODBC Driver for Okta in Microsoft Power Query
You can use the CData Okta ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Okta data into Microsoft Power Query.
-
Migrating data from Outreach.io to Databricks using CData SSIS Components.
Easily push Outreach.io data to Databricks using the CData SSIS Tasks for Outreach.io and Databricks.
-
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.
-
Easily Integrate Simplesat Data in Lazarus Pascal IDE
Learn how to easily integrate live Simplesat data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Nuclia Data in HULFT Integrate
Connect to Nuclia as a JDBC data source in HULFT Integrate
-
Testmonitor Reporting in OBIEE with the Testmonitor JDBC Driver
Deploy the Testmonitor JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous Adobe Commerce Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to delimited files (CSV/TSV).
-
Excel Spreadsheet Automation on Miro Data with the QUERY Formula
Pull data from Miro, automate spreadsheets, and more with the QUERY formula.
-
How to connect to Sentry Data with Squirrel SQL client
Connect to Sentry data and execute queries in the Squirrel SQL Client.
-
Publish Reports with CSV Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date CSV data.
-
Connect to SAP Ariba Procurement Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with SAP Ariba Procurement Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Automated Continuous Reckon Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Reckon replication to Apache Kafka.
-
Integrate Mistral AI with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Mistral AI with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Mistral AI data.
-
Automated Continuous SAP BusinessObjects BI Replication to MySQL
Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to MySQL.
-
Query Zoho Books Data as a MySQL Database in Node.js
Execute MySQL queries against Zoho Books data from Node.js.
-
View Reports on Real-Time OnePageCrm Data in Power BI Report Server
Use the CData ODBC Driver for OnePageCrm to visualize OnePageCrm data in Power BI Desktop and then publish them to Power BI Report Server.
-
Automated Continuous Odoo Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Odoo replication to delimited files (CSV/TSV).
-
Integrating Codex with Parquet 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.
-
Integrate Dify with Live RSS Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live RSS feeds.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Spotify
Provide connectivity to Spotify data through an SAP BusinessObjects universe.
-
Connect to Brex Data in DBArtisan
Use wizards in DBArtisan to configure Brex data as a data source.
-
Build Dashboards with Twilio Data in Dundas BI
Create dynamic dashboards and perform analytics based on Twilio data in Dundas BI.
-
Create Dynamic Rootly Grids Using the Infragistics XamDataGrid
Learn how you can connect Rootly to Infragistics XamDataGrid to build dynamic grids.
-
How to use SQLAlchemy ORM to access Office 365 Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Office 365 data.
-
Automate Splunk Data Replication to Azure Data Lake
Use CData Sync to customize and automate Splunk data replication to Azure Data Lake.
-
Getting Started with the CData Tableau Connector for Oracle Service Cloud
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Oracle Service Cloud.
-
Create Informatica Mappings From/To an ODBC Data Source for Insightly
Create an ODBC connection to Insightly in Informatica and browse and transfer Insightly 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.
-
Publish SendGrid-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SendGrid data.
-
Query Amazon Marketplace Data as a MySQL Database in Node.js
Execute MySQL queries against Amazon Marketplace data from Node.js.
-
Automated Continuous Exact Online Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Exact Online replication to Google BigQuery.
-
Create Power BI Reports on Real-Time ZeroBounce Data
Use the CData ODBC Driver for ZeroBounce to visualize ZeroBounce data in Power BI Desktop.
-
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.
-
Use Dash to Build to Web Apps on Rebilly Data
Create Python applications that use pandas and Dash to build Rebilly-connected web apps.
-
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.
-
How to connect PolyBase to Aircall
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Aircall data.
-
Build Agents in Relevance AI with Access to Live GetResponse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on GetResponse data within intelligent agent workflows.
-
How to use SQLAlchemy ORM to access Grafana Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Grafana data.
-
Easily Integrate Quaderno Data in Lazarus Pascal IDE
Learn how to easily integrate live Quaderno data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Access Sage 300 Data from MySQL in PHP
Connect to Sage 300 through the standard MySQL libraries in PHP.
-
Publish HCL Domino-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live HCL Domino data.
-
How to Query Live Timely Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Timely data data in natural language using Python.
-
Interact with Live Microsoft Exchange Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Microsoft Exchange data.
-
Connect to Azure Analysis Services from a Connection Pool in WebLogic
Use the CData JDBC Driver for Azure Analysis Services to connect to Azure Analysis Services data from Web applications running on WebLogic.
-
Validate iContact Data with QuerySurge
Access and validate iContact data in QuerySurge using the CData JDBC Driver.
-
Query IBM Cloud Object Storage Data through ODBC in Node.js
Use node-odbc to execute SQL queries against IBM Cloud Object Storage data from Node.js.
-
Integrate Cline with Live Microsoft Dataverse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Microsoft Dataverse data from within your IDE.
-
Write a Simple Go Application to work with Factorial Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Factorial data.
-
Connect to Bitbucket Data in HULFT Integrate
Connect to Bitbucket as a JDBC data source in HULFT Integrate
-
Query Live Power BI XMLA Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Power BI XMLA data through a conversational interface.
-
How to Access Rebilly Data Using Entity Framework
This article shows how to access Rebilly data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to SAP SuccessFactors Data in Aqua Data Studio
Access SAP SuccessFactors data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Publish Azure Synapse-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Azure Synapse data.
-
Integrate HDFS Data in the Pentaho Report Designer
Publish reports based on HDFS data in the Pentaho BI tool.
-
Integrate Devin with Live Office 365 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 Office 365 data.
-
Build an OLAP Cube in SSAS from Wave Financial Data
Establish a connection to Wave Financial data data from SQL Server Analysis Services, and use the Wave Financial Data Provider to build OLAP cubes for use in analytics and reporting.
-
Replicate SAP SuccessFactors LMS Data from PowerShell
Write a quick PowerShell script to query SAP SuccessFactors LMS data. Use connectivity to the live data to replicate SAP SuccessFactors LMS data to SQL Server.
-
Import Dropbox Data Using Azure Data Factory
Use CData Connect AI to connect to Dropbox Data from Azure Data Factory and import live Dropbox data.
-
Operational Reporting on Amazon DynamoDB Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Amazon DynamoDB data.
-
Create Reports from Smartsheet Data in Looker Studio
Use CData Connect AI to gain access to live Smartsheet data and create custom reports in Looker Studio.
-
Choosing the Best Method to Connect Dropbox to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Dropbox data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrating Codex with Marketo 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 integrate Oracle Sales with Apache Airflow
Access and process Oracle Sales data in Apache Airflow using the CData JDBC Driver.
-
Manage Short.io Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Short.io.
-
Automate ConvertAPI Integration Tasks from PowerShell
Are you in search of a quick and easy way to access ConvertAPI data from PowerShell? This article demonstrates how to utilize the ConvertAPI Cmdlets for tasks like connecting to ConvertAPI data, automating operations, downloading data, and more.
-
Replicate Multiple Timely Accounts via the CData Sync CLI
Replicate multiple Timely accounts to one or many databases.
-
Connect to Live Exa Data in MicroStrategy through CData Connect AI
Create a live connection to Exa Data in CData Connect AI and connect to your Exa data from MicroStrategy.
-
Connect to ConvertKit Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to ConvertKit.
-
Access Coda 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 Coda data.
-
Build Charts with Trello Data in Clear Analytics
Create dynamic charts and perform analytics based on Trello data in Clear Analytics.
-
Access Google Calendar Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Google Calendar data from HeidiSQL.
-
Prepare, Blend, and Analyze Salesforce Marketing Data in Alteryx Designer (Connect AI)
Build workflows to access live Salesforce Marketing data for self-service data analytics.
-
Connect to Bitly Data in Google Apps Script via Connect AI
Use CData Connect AI to access Bitly data in Google Apps Script.
-
Create SSAS Tabular Models from Oracle Sales Data
How to build a SQL Server Analysis Service Tabular Model from Oracle Sales data using CData drivers.
-
Integrate Sugar CRM Data into Power Automate Desktop using CData Connect
CData Connect for Sugar CRM Data enables you to integrate Sugar CRM data into workflows built using Microsoft Power Automate Desktop.
-
Connect Salesforce Data 360 to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Salesforce Data 360 with IBM WebSphere for seamless data integration and connectivity.
-
Build a Singer.io Tap for Adobe Analytics With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Adobe Analytics data using the CData Python Connector.
-
Bridge Twilio Connectivity with Apache NiFi
Access and process Twilio data in Apache NiFi using the CData JDBC Driver.
-
Validate PhantomBuster Data with QuerySurge
Access and validate PhantomBuster data in QuerySurge using the CData JDBC Driver.
-
Connect to Cloudflare Data in RapidMiner
Integrate Cloudflare data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to AlloyDB Data in DBeaver
Use the CData ODBC Driver to connect to AlloyDB data in DBeaver.
-
Getting Started with the CData Python Connector for Neo4J
Learn to install and license the CData Python Connector and configure a connection to live Neo4J data.
-
Manage SpaceX Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SpaceX.
-
Build an OLAP Cube in SSAS from SAP SuccessFactors LMS Data
Establish a connection to SAP SuccessFactors LMS data data from SQL Server Analysis Services, and use the SAP SuccessFactors LMS Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build Automated Workflows with Live SAP SuccessFactors LMS Data in Workato
Use CData Connect AI to connect to live SAP SuccessFactors LMS data and build automated workflows in Workato.
-
Replicate SAP Fieldglass Data in Heroku for Use in Salesforce Connect
Replicate SAP Fieldglass data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Import Basecamp Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Basecamp Data and provide access to live Basecamp data for custom reports in the Power BI Service.
-
Access Live Greenplum Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Greenplum data into the statistical analysis tools available in SAS JMP. This article shows how to use Greenplum data in the Graph Builder and Query Builder.
-
Visualize Telegram Data in TIBCO Spotfire through ADO.NET
Integrate Telegram data into dashboards in TIBCO Spotfire.