CData Software - Knowledge Base

Recent Articles

---

• «
• 555
• 556
• 557
• 558
• 559
• 560
• 561
• 562
• 563
• 564
• »

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

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

• Connect to Google Spanner Data in CloverDX (formerly CloverETL)

  Transfer Google Spanner using the visual workflow in the CloverDX data integration tool.

• Visualize Live Oracle Service Cloud Data in Power BI (via CData Connect AI)

  Use the CData Power BI Connector and CData Connect AI to integrate live Oracle Service Cloud into custom reports in Power BI.

• How to Query Live SQL Server Data in Perplexity MacOS Desktop

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

• Use Databricks Agent Bricks to Talk to Your Neo4J Data via CData Connect AI

  Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Neo4J for you.

• DataBind CockroachDB Data to the DevExpress Data Grid

  Use the CData ADO.NET Provider for CockroachDB with the DevExpress Windows Forms and Web controls to provide CockroachDB to a chart.

• Analyze Oracle Service Cloud Data in Looker

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

• Query ADP Data in DataGrip

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

• Automated Continuous Parquet Replication to Databricks

  Use CData Sync for automated, continuous, customizable Parquet replication to Databricks.

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

  Create an ODBC connection to Spark in Informatica and browse and transfer Apache Spark SQL.

• Connect to Mocean Data in Jaspersoft Studio

  Execute SQL to remote Mocean in Jaspersoft Studio.

• How to import FTP Data into Apache Solr

  Use the CData Software JDBC Driver for FTP in Data Import Handler and create an automated import of FTP Servers to Apache Solr Enterprise Search platform.

• Visualize IBM Cloud Object Storage Data in Sisense

  Create an ElastiCube in Sisense app with access to IBM Cloud Object Storage.

• Integrate Kintone with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Kintone with External Services.

• Excel Spreadsheet Automation on FreeAgent Data with the QUERY Formula

  Pull data from FreeAgent, automate spreadsheets, and more with the QUERY formula.

• Natively Connect to Snapchat Ads Data in PHP

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

• Connect to Google Contacts Data in NetBeans

  Connect to Google Contacts in NetBeans with the data source configuration wizard.

• Automated Continuous DocuSign Replication to Local Delimited Files

  Use CData Sync for automated, continuous, customizable DocuSign replication to delimited files (CSV/TSV).

• Automated Continuous VWO Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable VWO replication to IBM DB2.

• Build Agents in Relevance AI with Access to Live Amazon Athena Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Amazon Athena within intelligent agent workflows.

• Connect to SAP Ariba Procurement Data in DBArtisan

  Use wizards in DBArtisan to configure SAP Ariba Procurement as a data source.

• Publish Crystal Reports on CSV Data

  Use the Report Wizard and standard ADO.NET to design a report based on up-to-date CSV/TSV Files.

• Feed Workday Data into FineReport

  How to set Workday as a JDBC data source in FineReport.

• Create SSAS Tabular Models from Productboard Data

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

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

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

• Integrate with Salesforce Pardot Data using Apache Camel2

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

• Integrate with Sugar CRM Data in JReport Designer

  Create charts and reports based on Sugar CRM in JReport Designer.

• Connect to and Query Dynamics CRM Data in QlikView over ODBC

  Create data visualizations with Microsoft Dynamics CRM in QlikView.

• Access Live GitHub Data in Google Sheets through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live GitHub from your Google Sheets.

• Automated Continuous Clari Replication to MongoDB

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

• Build Charts with Dynamics 365 Data in Clear Analytics

  Create dynamic charts and perform analytics based on Microsoft Dynamics 365 in Clear Analytics.

• Edit and Search Salesforce CRM Analytics External Objects in Salesforce Connect (API Server)

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

• How to import SAP Fieldglass Data into Apache Solr

  Use the CData Software JDBC Driver for SAP Fieldglass in Data Import Handler and create an automated import of SAP Fieldglass to Apache Solr Enterprise Search platform.

• Access Cvent 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 Cvent.

• How to Access Eventbrite Data Using Entity Framework

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

• Integrate Trello with JetBrains RubyMine using CData JDBC Drivers

  Learn how to integrate Trello with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Trello.

• Operational Reporting on Salesforce Data from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Salesforce & Force.com.

• Connect to Drip Data in Ruby

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

• Load Marketo Data to a Database Using Embulk

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

• How to Connect to Live Cassandra Data in n8n Workflows and Agents (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Apache Cassandra for you.

• Automated Email Data Replication to Teradata

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

• How to connect and process CSV/TSV Files from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live CSV/TSV Files.

• Build Okta-Connected Visualizations in datapine

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

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

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

• Enable the ADP JDBC Driver in KNIME

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

• Integrate with live IBM Cloud Object Storage Data in Jitterbit

  Use CData Connect AI to connect to and integrate live IBM Cloud Object Storage in Jitterbit.

• Automate Box Data Replication to Azure Synapse

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

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

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

• Access Live Dynamics CRM Data in Coginiti Pro

  Connect to and query live Microsoft Dynamics CRM from the GUI in the Coginiti Pro: SQL Analytics Tool.

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

• Bridge DocuSign Connectivity with Apache NiFi

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

• Integrate Salesforce Data into Power Automate Desktop using CData Connect

  CData Connect for Salesforce Data enables you to integrate Salesforce & Force.com into workflows built using Microsoft Power Automate Desktop.

• How to Easily Query GitHub Data in OpenOffice Base

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

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

  Easily push Sybase IQ to Google BigQuery using the CData SSIS Tasks for Sybase IQ and Google BigQuery.

• Getting Started with the CData SSIS Components for Google Analytics

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

• Automated Continuous HubSpot Replication to Amazon S3

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

• Build Dashboards with ZohoSubscriptions Data in DBxtra

  Create dynamic dashboards and perform analytics based on ZohoSubscriptions in DBxtra.

• Connect to SAP HANA XS Advanced Data in RapidMiner

  Integrate SAP HANA XS Advanced with standard components and data source configuration wizards in RapidMiner Studio.

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

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

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

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

• How to integrate SingleStore with Apache Airflow

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

• Create Oracle-Connected Visualizations in Klipfolio

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

• Getting Started with the CData Excel Add-In for Zoho Creator

  Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Zoho Creator.

• Build an OLAP Cube in SSAS from ZarMoney Data

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

• Connect to MailChimp Data in the Denodo Platform

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

• Google Campaign Manager 360 Reporting in OBIEE with the Google Campaign Manager 360 JDBC Driver

  Deploy the Google Campaign Manager 360 JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• Getting Started with the CData Excel Add-In for Timely

  Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Timely.

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

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

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

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

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

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

• Query AlloyDB Data using the OData SDK for PHP

  Use the API Server and the OData PHP SDK to easily consume AlloyDB entities in PHP by modeling them as objects.

• Access Live Certinia Data in Coginiti Pro

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

• Use the CData SSIS Components to Insert New or Update Existing Databricks Records from SQL Server

  Easily push SQL Server data to Databricks using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Databricks or update existing records with data from a SQL Server database.

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

• Connect to Email Data from PowerBuilder via ODBC

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

• Publish Epicor Kinetic-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Epicor Kinetic.

• How to Easily Query Vimeo Data in OpenOffice Base

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

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

• Connect to Okta Data as an External Data Source using PolyBase

  Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Okta.

• Connect to Cassandra Data from Crystal Reports

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

• Connect to Live Azure Analysis Services Data in MicroStrategy through CData Connect AI

  Create a live connection to Azure Analysis Services Data in CData Connect AI and connect to your Azure Analysis Services from MicroStrategy.

• Import ServiceNow Data into the Power BI Service for Visualizations

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

• Automated Continuous Microsoft Planner Replication to Google BigQuery

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

• Integrate Exa with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Exa with External Services.

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

• Integrate Cline with Live Tally Data via CData Connect AI

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

• How to use SQLAlchemy ORM to access JSON Services in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of JSON.

• Build Charts with Zoho Creator Data in Clear Analytics

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

• Connect to Workable Data in Aqua Data Studio

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

• Build Semantic Layer Views for Short.io Data in APOS Live Data Gateway

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

• Integrate Cursor with Live Cosmos DB Data via CData Connect AI

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

• How to Work with ClickTime Data in ETL Validator JDBC

  Connect to ClickTime from ETL Validator jobs using the CData Software JDBC Driver.

• Work with Live OneNote Data in Power Query

  Use CData Connect AI to connect to Microsoft OneNote and work with live Microsoft OneNote in Microsoft Power Query.

• DataBind Exact Online Data to the DevExpress Data Grid

  Use the CData ADO.NET Provider for Exact Online with the DevExpress Windows Forms and Web controls to provide Exact Online to a chart.

• Use the CData API Server to Access Sybase IQ Data in Microsoft PowerPivot

  Use the CData API Server to connect to live Sybase IQ in the Power Pivot business intelligence tool.

• Excel Reporting and Star Schemas in OBIEE

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

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

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

• How to Import Data from Bullhorn CRM into Google Sheets

  Import Bullhorn CRM into a Google spreadsheet that is automatically refreshed.

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

  Execute MySQL queries against WooCommerce from Node.js.

• Publish Crystal Reports on IBM Informix Data

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

• «
• 555
• 556
• 557
• 558
• 559
• 560
• 561
• 562
• 563
• 564
• »