CData Software - Knowledge Base

Recent Articles

• «
• 267
• 268
• 269
• 270
• 271
• 272
• 273
• 274
• 275
• 276
• »

• Connect to Zoho Inventory from Crystal Reports

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

• Integrating LangGraph with Spark via CData Connect AI

  Leverage CData Connect AI to enable LangGraph agents to securely access and act on Apache Spark SQL within automated workflows.

• Enable the Sybase JDBC Driver in KNIME

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

• Query CSV through ODBC in Node.js

  Use node-odbc to execute SQL queries against CSV/TSV Files from Node.js.

• How to integrate Google Data Catalog with Apache Airflow

  Access and process Google Data Catalog in Apache Airflow using the CData JDBC Driver.

• Connect to Amazon S3 from PowerBuilder via JDBC

  This article demonstrates how to access Amazon S3 from PowerBuilder using the Amazon S3 JDBC Driver.

• Connect to Unbounce in CloverDX (formerly CloverETL)

  Transfer Unbounce using the visual workflow in the CloverDX data integration tool.

• Visualize Live Invoiced of Power BI Report Builder in Power BI Service

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

• Access Dynamics 365 from MySQL in PHP

  Connect to Dynamics 365 through the standard MySQL libraries in PHP.

• Query FTP as a MySQL Database in Node.js

  Execute MySQL queries against FTP Servers from Node.js.

• Connect to Azure DevOps from HeidiSQL

  Use CData Connect AI to connect to and query live Azure DevOps from HeidiSQL.

• Bridge MySQL Connectivity with Apache NiFi

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

• Work with PayPal in FoxPro

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

• Connecting Moonlit Workflow with SingleStore via CData Connect AI MCP Server

  Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your SingleStore in real time.

• Build Automated Workflows with Live Adobe Commerce in Workato

  Use CData Connect AI to connect to live Adobe Commerce and build automated workflows in Workato.

• Query, Visualize, and Share live Zendesk in Redash

  Use CData Connect AI to connect to live Zendesk in Redash for querying, visualizing, and sharing.

• Publish Crystal Reports on PingOne

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

• Automated Continuous Microsoft OneLake Replication to SingleStore

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

• Connect to HarperDB in Aqua Data Studio

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

• Automated SAP HANA Replication to Teradata

  Use CData Sync to Customize and automate SAP HANA replication to Teradata.

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

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

• Build Automated Square-Connected Workflows in Zapier

  Use CData Connect AI to connect to live Square and build automated workflows in Zapier.

• Build SAP Hybris C4C-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to SAP Hybris C4C and build web apps with connectivity to live SAP Hybris C4C.

• How to Use a Microsoft Access Database to Update Quickbase in Real Time

  Update Quickbase data by creating a linked table in Microsoft Access with the CData Quickbase ODBC Driver.

• Automated Continuous Amazon Athena Replication to Amazon S3

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

• How to Query Live HBase Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live Apache HBase data in natural language using Python.

• Getting Started with the CData Excel Add-In for QuickBooks Online

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

• Getting Started with the CData JDBC Driver for MYOB AccountRight

  Complete guide to installing, licensing, and connecting with the CData JDBC Driver for MYOB AccountRight.

• Automate Reckon Accounts Hosted Replication to Azure Data Lake

  Use CData Sync to customize and automate Reckon Accounts Hosted replication to Azure Data Lake.

• Integrate Live Google Analytics into Amazon SageMaker Canvas with RDS

  Use CData Connect AI to connect to Google Analytics from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Google Analytics.

• Build Dashboards with SFTP in Dundas BI

  Create dynamic dashboards and perform analytics based on SFTP in Dundas BI.

• Access Salesforce Data in SharePoint External Lists

  Provide Salesforce data to SharePoint users as an external list.

• Visualize Zoom in TIBCO Spotfire through ADO.NET

  Integrate Zoom into dashboards in TIBCO Spotfire.

• Visualize Airtable in Sisense

  Create an ElastiCube in Sisense app with access to Airtable.

• Natively Connect to Drift in PHP

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

• View Reports on Real-Time Facebook Ads in Power BI Report Server

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

• Automated Continuous Google Contacts Replication to Google BigQuery

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

• Connect to SAP Business One from PowerBuilder via ADO.NET

  This article demonstrates how to access SAP Business One from Appeon PowerBuilder using the CData ADO.NET Provider for SAP Business One.

• Automated Continuous Drip Replication to MongoDB

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

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

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

• How to Connect DBeaver to MySQL via a JDBC Driver

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

• Edit and Search Snapchat Ads External Objects in Salesforce Connect (API Server)

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

• Access Live Box in AWS Lambda

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

• Automated Continuous Salesforce Marketing Replication to Amazon S3

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

• Automated Continuous Oracle HCM Cloud Replication to Snowflake

  Use CData Sync for automated, continuous, customizable Oracle HCM Cloud replication to Snowflake.

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

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

• Create Reports from PostgreSQL in Looker Studio

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

• How to Work with SAP SuccessFactors in ETL Validator JDBC

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

• Query Sage 50 UK as a MySQL Database in Node.js

  Execute MySQL queries against Sage 50 UK from Node.js.

• How to create an RPA flow for Oracle Eloqua Reporting in UiPath Studio

  Use the Oracle Eloqua Reporting ODBC Driver to create workflows that access real-time Oracle Eloqua Reporting without any coding.

• Build an OLAP Cube in SSAS from eBay

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

• Create Informatica Mappings From/To an ODBC Data Source for Azure Analysis Services

  Create an ODBC connection to Azure Analysis Services in Informatica and browse and transfer Azure Analysis Services.

• Automated Continuous Todoist Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable Todoist replication to Apache Kafka.

• Publish Crystal Reports on Confluence

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

• How to connect PolyBase to Sage Intacct

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

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

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

• Visualize Salesforce Data Cloud from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Salesforce Data Cloud.

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

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

• Integrate with Hive using Apache Camel2

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

• How to Create Power BI Visual Reports with Real-Time eBay

  Use CData Power BI Connectors to visualize eBay in Power BI.

• How to connect and process Salesforce Data Cloud from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Salesforce Data Cloud.

• Viewing Google Directory in RAD Studio Data Explorer

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

• How to use SQLAlchemy ORM to access Parquet in Python

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

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

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

• Prepare, Blend, and Analyze Reckon Accounts Hosted in Alteryx Designer (Connect AI)

  Build workflows to access live Reckon Accounts Hosted for self-service data analytics.

• How to Visualize Printful Data in Python with pandas

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

• Connect SAS Data Sets to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

  Connect to your SAS Data Sets using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

• Connect to ServiceNow from Excel & GoogleSheets!

  Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from ServiceNow, and over 250 other data sources, right inside your Excel and Google spreadsheets!

• Visualize DocuSign from Tableau

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

• Design BIRT Reports on Greenplum

  Provide current Pivotal GreenPlum to your embedded analytics.

• Provide OData Services of XML from a WCF Application

  In this article, we will demonstrate the process of generating an OData feed for XML Files by developing a WCF Service Application.

• Getting Started with the CData Python Connector for SAP Netweaver Gateway

  Learn to install and license the CData Python Connector

• Visualize Live Monday.com of Power BI Report Builder in Power BI Service

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

• Connect to MYOB AccountRight in Aqua Data Studio

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

• A PostgreSQL Interface for Klipfolio (MySQL Remoting via JDBC)

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

• Replicate Todoist to Multiple Databases

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

• How to Use a Microsoft Access Database to Update Dynamics 365 Business Central in Real Time

  Update Dynamics 365 Business Central data by creating a linked table in Microsoft Access with the CData Dynamics 365 Business Central ODBC Driver.

• Bidirectional Access to Google Spanner from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate Google Spanner in Filemaker Pro for Mac or Windows.

• Connect to Instagram from HeidiSQL

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

• Connect to Google Drive through External Services in Salesforce

  Use CData Connect AI to securely connect Salesforce External Services with Google Drive using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.

• Connect to Amazon Athena in Ruby

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

• How to Work with Oracle HCM Cloud in ETL Validator JDBC

  Connect to Oracle HCM Cloud from ETL Validator jobs using the CData Software JDBC Driver.

• Integrate Dynamics 365 Business Central in the Pentaho Report Designer

  Publish reports based on Dynamics 365 Business Central in the Pentaho BI tool.

• How to integrate Sage 300 with Apache Airflow

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

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

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

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

  Provide connectivity to Apache Avro through an SAP BusinessObjects universe.

• Query Cloudant in ColdFusion

  Write standard ColdFusion data access code to connect to IBM Cloudant.

• Visualize HDFS in Sisense

  Create an ElastiCube in Sisense app with access to Apache HDFS.

• Integrating LangChain with Paylocity via CData Connect AI

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

• Access Live Splunk in Excel (Desktop) through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Splunk from your Excel spreadsheets.

• Connecting Mastra with Presto via CData Connect AI MCP Server

  Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time data across 300+ enterprise sources no replication required.

• Build Data Flows from Printify to SQL Server using SSIS

  Easily back up Printify to SQL Server using the SSIS components for Printify.

• Connect to Jira Service Management as an External Source in Dremio

  Use the CData JDBC Driver to connect to Jira Service Management as an External Source in Dremio.

• Integrating Amazon DynamoDB in Talend Cloud Data Management Platform

• «
• 267
• 268
• 269
• 270
• 271
• 272
• 273
• 274
• 275
• 276
• »