CData Software - Knowledge Base

Recent Articles

---

• «
• 326
• 327
• 328
• 329
• 330
• 331
• 332
• 333
• 334
• 335
• »

• Build SAP HANA XS Advanced-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SAP HANA XS Advanced.

• Load JotForm Data to a Database Using Embulk

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

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

  Execute MySQL queries against ChargeOver from Node.js.

• How to Connect the Power BI Service to Exact Online: Complete Guide

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

• Edit and Search External Sugar CRM Objects in Salesforce Connect

  Use CData Connect AI to securely provide OData feeds of Sugar CRM to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Sugar CRM Data objects that you can access from apps and the dashboard.

• Automate Todoist Data Replication to Azure Data Lake

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

• Access SFTP Data from MySQL in PHP

  Connect to SFTP through the standard MySQL libraries in PHP.

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

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

• Automate LeadDesk Data Replication to Couchbase

  Use CData Sync to Customize and automate LeadDesk replication to Couchbase.

• How to Query Cosmos DB Data in MySQL Workbench

  Execute MySQL queries against live Azure Cosmos DB from MySQL Workbench.

• Import and Visualize AlloyDB Data in Power View

  Create data visualizations based on Google AlloyDB in Excel.

• ETL Shortcut in Oracle Data Integrator

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

• Create Power BI Reports on Real-Time Redis Data

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

• Connect to Greenhouse in SpagoBI

  Create reports featuring live Greenhouse in SpagoBI Studio. Host Greenhouse reports on SpagoBI Server.

• Automate Tasks in Power Automate Using the CData API Server

  Automate Sugar CRM actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.

• Add Exa Data to Informatica Enterprise Data Catalog

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

• How to integrate SpaceX with Apache Airflow

  Access and process SpaceX in Apache Airflow using the CData JDBC Driver.

• Integrate with Spark Data using Apache Camel2

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

• Integrate Google

  Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Splunk within intelligent workflows.

• Connect to Postmark Data in Claris FileMaker Pro

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

• How to Query Workday Data in MySQL Workbench

  Execute MySQL queries against live Workday from MySQL Workbench.

• How to connect and process Datadog from Azure Databricks

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

• Replicate Multiple OneNote Accounts via the CData Sync CLI

  Replicate multiple OneNote accounts to one or many databases.

• Add Jira Assets Data to Informatica Enterprise Data Catalog

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

• How to connect PolyBase to CouchDB

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

• Create SSAS Tabular Models from Printify Data

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

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

  Use CData JDBC drivers to import and use Factorial in ColdFusion.

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

  With CData API Server, easily create OData endpoints for live MailChimp data

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

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

• Connecting GenSpark with Google Sheets Data via CData Connect AI MCP Server

  Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Google Sheets without any replication or custom integration required.

• How to Query Live Suadeo Data in Perplexity MacOS Desktop

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

• Use the CData Software JDBC Driver for Azure Data Catalog in MicroStrategy Web

  Connect to Azure Data Catalog in MicroStrategy Web using the CData Software JDBC Driver for Azure Data Catalog.

• Object-Relational Mapping (ORM) with VWO 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 VWO into a Java-based ORM framework, Hibernate.

• Connect to ServiceDesk Plus from a Connection Pool in WebLogic

  Use the CData JDBC Driver for ServiceDesk Plus to connect to ServiceDesk Plus from Web applications running on WebLogic.

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

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

• Connect to Google Ads Data from PowerBuilder via JDBC

  This article demonstrates how to access Google Ads from PowerBuilder using the Google Ads JDBC Driver.

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

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

• Create Dynamic Slack Grids Using the Infragistics XamDataGrid

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

• How to connect to TaxJar Data with Squirrel SQL client

  Connect to TaxJar and execute queries in the Squirrel SQL Client.

• Connect to and Query PhantomBuster Data in QlikView over ODBC

  Create data visualizations with PhantomBuster in QlikView.

• How to Visualize Timely Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Timely in Python.

• Connect to HubSpot Data from Crystal Reports

  Use CData Connect AI to connect to and report on live HubSpot from Crystal Reports.

• Integrate with Live Exact Online Data in MuleSoft (via CData Connect AI)

  Use CData Connect AI to connect to Exact Online from the MuleSoft Anypoint Platform to integrate live Exact Online into custom reports and dashboards.

• Replicate Multiple Exa Accounts

  Replicate multiple Exa accounts to one or many databases.

• How to Import Data from Google Analytics into Google Sheets

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

• Connect to ServiceDesk Plus Data from PowerBuilder via JDBC

  This article demonstrates how to access ServiceDesk Plus from PowerBuilder using the ServiceDesk Plus JDBC Driver.

• Build Semantic Layer Views for Hugging Face Data in APOS Live Data Gateway

  Use the CData Connector for Hugging Face in APOS Live Data Gateway to build Semantic Layer Views for Hugging Face.

• Connect to Google Search Results in RapidMiner

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

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

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

• Automate SuiteCRM Data Replication to Azure Data Lake

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

• Natively Connect to Gmail Data in PHP

  The CData ODBC driver for Gmail enables you to create PHP applications with connectivity to Gmail. Leverage the native support for ODBC in PHP.

• Replicate Spark Data to Multiple Databases via the CData Sync CLI

  Replicate Apache Spark SQL to disparate databases with a single configuration.

• Visualize FreshBooks Data in Sisense

  Create an ElastiCube in Sisense app with access to FreshBooks.

• Connect to JotForm from a Connection Pool in WebLogic

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

• Create Data Visualizations Based On Adobe Commerce Data in Mode

  Use CData Connect AI to connect to Adobe Commerce Data from Mode and build visualizations using live

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

• Import Real-Time Brex Data via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Brex in ColdFusion.

• How to work with SAP SuccessFactors Data in Apache Spark using SQL

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

• How to connect PolyBase to Simplesat

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

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

• Automated Continuous Asana Replication to Google BigQuery

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

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

  Create a simple Workflow for Delighted in Informatica PowerCenter.

• Visualize Live Azure Synapse Data of Power BI Report Builder in Power BI Service

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

• How to Access Google Search Results Using Entity Framework

  This article shows how to access Google Search using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

• Analyze Zoho Creator Data with Power Pivot

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

• How to Seamlessly Import SingleStore Data into IBM SPSS Modeler

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

• Integrating Antigravity CLI with SendInBlue via CData CLI

  Connect SendInBlue to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.

• Connect to Telegram Data in HULFT Integrate

  Connect to Telegram as a JDBC data source in HULFT Integrate

• Analyze SAP Fieldglass Data with Power Pivot

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

• Getting Started with the CData Tableau Connector for SAP Ariba Source

  Complete guide to installing, licensing, and connecting with the CData Tableau Connector for SAP Ariba Source.

• Integrate Google

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

• Access Live Google Directory Data in TIBCO Data Virtualization

  Use the Google Directory Tibco DV Adapter to create a Google Directory data source in TIBCO Data Virtualization Studio and gain access to live Google Directory from your TDV Server.

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

• ETL Keap in Oracle Data Integrator

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

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

  Easily push Xero Accounting to Google BigQuery using the CData SSIS Tasks for Xero and Google BigQuery.

• Publish Crystal Reports on Vercel Data

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

• How to Easily Query BenchmarkEmail Data in OpenOffice Base

  Connect to BenchmarkEmail data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.

• Extend Google Sheets with Snapchat Ads Data

  Make calls to Snapchat Ads from Google Apps Script via the API Server.

• Working with Sybase IQ Data in LINQPad

  Execute LINQ queries to Sybase IQ in LINQPad.

• Automated Continuous Pipeline CRM Replication to Snowflake

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

• Connect to Salesforce Pardot Data in RunMyProcess through Connect AI

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

• Create SAP Concur-Connected Dashboards in Grafana

  Connect to SAP Concur Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to SAP Concur.

• Integrating LangChain with Act-On Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Act-On within automated workflows.

• Create Billsby Reports on JasperReports Server

  Deploy the CData JDBC Driver on JasperReports Server to provide real-time Billsby data access from reports, embedded analytics, and more.

• Use the CData Software ODBC Driver for Spotify in MicroStrategy

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

• Integrate with Sage 300 Data in JReport Designer

  Create charts and reports based on Sage 300 in JReport Designer.

• Build Dashboards with Salesforce Data 360 Data in Dundas BI

  Create dynamic dashboards and perform analytics based on Salesforce Data 360 in Dundas BI.

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

• Build Google Calendar-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Google Calendar and build web apps with connectivity to live Google Calendar.

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

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

• Create Reports from Google Drive Data in Looker Studio

  Use CData Connect AI to gain access to live Google Drive and create custom reports in Looker Studio.

• Automated Continuous LaunchDarkly Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable LaunchDarkly replication to Amazon Redshift.

• Work with Opsgenie Data in FoxPro

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

• Connect to Real-Time SingleStore Data in Power Apps Using Dataflows to Build Custom Applications

  Use CData Power BI Connector for SingleStore and Dataflow to import and use SingleStore in Power Apps.

• Connect to Factorial Data in RazorSQL

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

• Getting Started with the CData Python Connector for Spotify

  Learn to install and license the CData Python Connector

• Create Data Visualizations in Cognos BI with Cvent Data

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

• How to Visualize Microsoft Teams Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Microsoft Teams in Python.

• Connect to Twitter Ads Data as an External Source in Dremio

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

• Create Reports with SAP Hybris C4C Data in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date SAP Hybris C4C.

• «
• 326
• 327
• 328
• 329
• 330
• 331
• 332
• 333
• 334
• 335
• »