CData Software - Knowledge Base

Recent Articles

---

• «
• 1093
• 1094
• 1095
• 1096
• 1097
• 1098
• 1099
• 1100
• 1101
• 1102
• »

• Query Box Data in DataGrip

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

• Feed CSV Data into FineReport

  How to set CSV/TSV Files as a JDBC data source in FineReport.

• Connect to GitLab Data as an External Source in Dremio

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

• Use JayDeBeApi to access Wave Financial Data in Python

  Use standard Python scripting and the development environment of your choice to access live Wave Financial.

• Integrate Simplesat Data in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Simplesat from Informatica Cloud.

• Replicate Oracle Data from PowerShell

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

• Access Salesforce Data 360 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 Salesforce Data 360.

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

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

• Integrate Google

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

• Extract, Transform, and Load Drift Data in Informatica PowerCenter

  Create a simple Workflow for Drift in Informatica PowerCenter.

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

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

• Integrate with Oracle Eloqua Reporting Data using Apache Camel2

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

• Connect to Deel Data in the Denodo Platform

  Use CData driver technologies to create a virtual data source for Deel in the Denodo Virtual DataPort Administrator.

• How to create Quaderno federated tables in MySQL

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

• Use CData Connect AI to Access SingleStore Data in Microsoft Power Pivot

  Use CData Connect AI to connect to live SingleStore in the Power Pivot business intelligence tool.

• Trigger Box IFTTT Flows in Azure App Service

  Automate IFTTT (if-this-then-that) workflows for Box with standard wizards in Logic Apps.

• Use the CData Software ODBC Driver for Dynamics 365 in MicroStrategy Desktop

  Connect to Microsoft Dynamics 365 in MicroStrategy Desktop using the CData Software ODBC Driver for Dynamics 365.

• Build a Simple VCL Application for Zuora Data

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

• Publish Reports with Google Translate Data in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Google Translate.

• Build an OLAP Cube in SSAS from Blackbaud FE NXT Data

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

• DataBind Controls to MySQL Data in Delphi

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

• Analyze Couchbase Data in Looker

  Use CData Connect AI to connect to Couchbase Data from Looker and build custom apps using live Couchbase.

• Object-Relational Mapping (ORM) with Tickspot Data Entities in Java

  Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Tickspot into a Java-based ORM framework, Hibernate.

• Connect to Google Sheets from Asprova with CData Software ODBC Driver for Google Sheets

  This article shows how to connect faster to Google Sheets data from Asprova.

• How to Query Live IBM Informix Data in Perplexity MacOS Desktop

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

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

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

• ETL Zendesk in Oracle Data Integrator

  This article shows how to transfer Zendesk into a data warehouse using Oracle Data Integrator.

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

  Create an ODBC connection to Google Analytics in Informatica and browse and transfer Google Analytics.

• Query Live Act-On Data in Zed Editor via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Act-On directly from the development environment.

• How to Connect the Power BI Service to YouTube Analytics: Complete Guide

  Connect to the CData Software Power BI Connector for YouTube Analytics from PowerBI.com to provide real-time YouTube Analytics across the organization.

• Automated Continuous BenchmarkEmail Replication to PostgreSQL

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

• Replicate Marketo Data to Multiple Databases

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

• Automate Invoiced Data Replication to Azure Synapse

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

• Automate AgileCRM Integration Tasks from PowerShell

  Are you in search of a quick and easy way to access AgileCRM from PowerShell? This article demonstrates how to utilize the AgileCRM Cmdlets for tasks like connecting to AgileCRM, automating operations, downloading data, and more.

• Viewing Vercel Data in RAD Studio Data Explorer

  How to view Vercel in RAD Studio Data Explorer using the CData ODBC Driver for Vercel.

• Use Biml to Build SSIS Tasks to Replicate MongoDB Data to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate MongoDB to SQL Server.

• Automated Continuous ShipStation Replication to Amazon S3

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

• View Reports on Real-Time Redshift Data in Power BI Report Server

  Use the CData ODBC Driver for Redshift to visualize Amazon Redshift in Power BI Desktop and then publish them to Power BI Report Server.

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

  Easily push RSS Feeds to Google BigQuery using the CData SSIS Tasks for RSS and Google BigQuery.

• Process & Analyze CSV Data in Databricks (AWS)

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

• Build Microsoft OneDrive-Connected Visualizations in datapine

  Use CData Connect AI and datapine to build visualizations and dashboards with access to live Microsoft OneDrive.

• Access CloudConvert Data as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access CloudConvert from your Oracle system.

• Automated Continuous API Replication to SingleStore

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

• How to load Hugging Face data into Elasticsearch via Logstash

  Introducing a simple method to load Hugging Face data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.

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

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

• Integrate with Asana Data in JReport Designer

  Create charts and reports based on Asana in JReport Designer.

• Publish Reports with CircleCI Data in SAP Crystal Reports

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

• Access Live Kintone Data in AWS Lambda

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

• Connect to Insightly Data in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Moving Data from Gong to SQL Server Using Toad Data Point and CData ODBC Driver

  Query, export, and automate live Gong data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.

• Analyze Azure Analysis Services Data in Infragistics Reveal

  Use CData Connect AI to create on OData API on top of Azure Analysis Services and visualize live Azure Analysis Services in Infragistics Reveal.

• Integrating Codex CLI with Discourse 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 Microsoft Planner Data in Pentaho Data Integration

  Build ETL pipelines based on Microsoft Planner in the Pentaho Data Integration tool.

• Connect and Visualize Live Twitter Ads Data in Databricks Lakehouse Federation with CData Connect AI

  Use CData Connect AI to integrate live Twitter Ads into the Databricks platform and create visualization dashboards with real-time Twitter Ads.

• Build Pipelines with Live QuickBooks Time Data in Google Cloud Data Fusion (via CData Connect AI)

  Use CData Connect AI to connect to QuickBooks Time from Google Cloud Data Fusion, enabling the integration of live QuickBooks Time into the building and management of effective data pipelines.

• Back Up Veeva Vault & Vault CRM to SQL Server through SSIS

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

• Connect to Freshservice Data in Aqua Data Studio

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

• Publish Reports with Cosmos DB Data in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Azure Cosmos DB.

• Integrating GitHub Copilot CLI with Airtable 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.

• Working with Impala Data in LINQPad

  Execute LINQ queries to Apache Impala in LINQPad.

• Integrate with Cassandra Data in SnapLogic

  Use CData Connect AI to connect to and integrate with live Apache Cassandra in SnapLogic.

• Creating Stripe-Connected Applications in Unqork

  You can use CData Connect AI to feed Stripe to Unqork and build custom business apps.

• Automated Continuous Adobe Target Replication to Google Cloud SQL

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

• Replicate Multiple DB2 for i Accounts via the CData Sync CLI

  Replicate multiple DB2 for i accounts to one or many databases.

• Build Azure Data Catalog-Powered Applications in Gemini Code Assist with CData MCP Server

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

• Automated Redis Data Replication to Teradata

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

• Stream ShipEngine Data into Apache Kafka Topics

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

• Build Charts with GitHub Data in Clear Analytics

  Create dynamic charts and perform analytics based on GitHub in Clear Analytics.

• Integrate with Azure Analysis Services Data using Apache Camel2

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

• Connect to Act CRM Data in HULFT Integrate

  Connect to Act CRM as a JDBC data source in HULFT Integrate

• Connect to Google Translate in SpagoBI

  Create reports featuring live Google Translate in SpagoBI Studio. Host Google Translate reports on SpagoBI Server.

• Build SAP Fieldglass-Connected Dashboards Using Zoho Analytics

  Use CData Connect AI to connect to SAP Fieldglass Data from Zoho Analytics and import live SAP Fieldglass.

• Access Live Shopify Data in Excel 365 Online (Excel for the web)

  Connect to Shopify from Excel 365 Online (Excel for the web) with CData Connect AI.

• Access Live GraphQL Data in AWS Lambda

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

• Getting Started with the CData Connect AI Python SDK for Twitter Ads

  Install the CData Connect AI Python SDK to read and write live Twitter Ads with standard DB-API 2.0 Python code.

• How to Connect DBeaver to SingleStore via a JDBC Driver

  Manage SingleStore with visual tools in DBeaver like the query browser.

• Create SSAS Tabular Models from Adobe Analytics Data

  How to build a SQL Server Analysis Service Tabular Model from Adobe Analytics using CData drivers.

• Build Visualizations of Billsby Data in Birst

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

• Automated Continuous MYOB AccountRight Replication to Amazon S3

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

• Analyze WordPress Data in Infragistics Reveal

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

• Visualize Box Data from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Box.

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

• Visualize Zoho Recruit Data in TIBCO Spotfire through ADO.NET

  Integrate Zoho Recruit into dashboards in TIBCO Spotfire.

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

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

• Extend Google Sheets with Dynamics 365 Business Central Data

  Make calls to Dynamics 365 Business Central from Google Apps Script via the API Server.

• How to create FTP federated tables in MySQL

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

• Connect to JSON Services in Google Apps Script via Connect AI

  Use CData Connect AI to access JSON in Google Apps Script.

• How to Import Data from Adobe Analytics into Google Sheets

  Import Adobe Analytics into a Google spreadsheet that is automatically refreshed.

• Work with Raisers Edge NXT Data in FoxPro

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

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

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

• Connect to Microsoft OneDrive Data from HeidiSQL

  Use CData Connect AI to connect to and query live Microsoft OneDrive from HeidiSQL.

• Create Data Visualizations in Cognos BI with Salesforce Pardot Data

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

• Use ChatGPT to Talk to Your Sage Cloud Accounting Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Sage Business Cloud Accounting for you.

• Access Live PayPal 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 PayPal through MCP integration.

• Connect to Toggl Data from Blazor Apps

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

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

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

• Work with Simplesat Data in FoxPro

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

• Enable the Oracle Eloqua JDBC Driver in KNIME

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

• Zuora Reporting and Star Schemas in OBIEE

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

• Create Reports with Timely Data in SAP Crystal Reports

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

• «
• 1093
• 1094
• 1095
• 1096
• 1097
• 1098
• 1099
• 1100
• 1101
• 1102
• »