CData Software - Knowledge Base

Recent Articles

---

• «
• 629
• 630
• 631
• 632
• 633
• 634
• 635
• 636
• 637
• 638
• »

• Integrate Live Acumatica Data into Blue Prism for Intelligent Robotic Process Automation (RPA)

  Connect live Acumatica ERP to Blue Prism using the CData ODBC Driver for Acumatica to create automated workflows for repetitive business tasks.

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

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

• Analyze PabblySubscriptions Data in R via ODBC

  Create data visualizations and use high-performance statistical functions to analyze PabblySubscriptions in Microsoft R Open.

• Automated Continuous Cvent Replication to Azure SQL Database

  Use CData Sync for automated, continuous, customizable Cvent replication to Azure SQL Database.

• Connect to Databricks Data in CloverDX (formerly CloverETL)

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

• Manage Harvest Data in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for Harvest.

• Automated Continuous FormSite Replication to Local Delimited Files

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

• Build Data Flows from Snowflake to SQL Server using SSIS

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

• Use the CData ODBC Driver for PayPal in Microsoft Power Query

  You can use the CData PayPal ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import PayPal into Microsoft Power Query.

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

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

• Build SAS xpt-Connected Web Apps with Axios and CData Connect AI

  Use CData Connect AI to connect to live SAS XPORT and build SAS xpt-connected web apps with Axios.

• How to Connect DBeaver to OData via a JDBC Driver

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

• Operational Reporting on Everhour Data from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Everhour.

• Automated Continuous Klipfolio Replication to Google Cloud SQL

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

• GraphQL Data Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to GraphQL through CData Connect AI using different applications and tools.

• Connect to Pinecone Data from a Connection Pool in Jetty

  The Pinecone JDBC Driver supports connection pooling: This article shows how to connect faster to Pinecone from Web apps in Jetty.

• Getting Started with the CData Power BI Connector for DocuSign

  Complete guide to installing, licensing, and connecting with the CData Power BI Connector for DocuSign.

• How to import ADP Data into Apache Solr

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

• Connect to Float Data in RazorSQL

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

• Connect to Jodoo Data as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Jodoo.

• Build Redis-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Redis.

• How to connect and process SparkPost from Azure Databricks

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

• Query SAP Concur Data in DataGrip

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

• Migrating data from Zoho Creator to Snowflake using CData SSIS Components.

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

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

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

• Building Dynamic Web Pages with Elasticsearch Data Using AngularJS

  Create single-page applications with live connectivity to Elasticsearch using the CData API Server.

• Connect to and Visualize Live Accelo Data in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Accelo.

• How to Seamlessly Import Grafana Data into IBM SPSS Modeler

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

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

  Replicate Procore to disparate databases with a single configuration.

• Automate Splunk Data Replication to Azure Synapse

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

• Automated Continuous Pipeline CRM Replication to Databricks

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

• Integrate Optimizely Data in Pentaho Data Integration

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

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

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

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

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

• Connect to Adobe Commerce Data in ACL Analytics

  Connect to Adobe Commerce via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Adobe Commerce.

• Access Customer.io Data from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Customer.io from HeidiSQL.

• Use the CData Software JDBC Driver for Facebook Ads in MicroStrategy Web

  Connect to Facebook Ads in MicroStrategy Web using the CData Software JDBC Driver for Facebook Ads.

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

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

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

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

• Replicate Multiple Zoho Projects Accounts via the CData Sync CLI

  Replicate multiple Zoho Projects accounts to one or many databases.

• Visualize Live Google Campaign Manager 360 Data of Power BI Report Builder in Power BI Service

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

• How to Connect to PivotalTracker Data in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to PivotalTracker. Leverage the pyodbc module for ODBC in Python.

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

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

• Integrate with Redshift Data in JReport Designer

  Create charts and reports based on Amazon Redshift in JReport Designer.

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

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

• Connect to SAP Concur Data in RazorSQL

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

• Access Live Grafana Data in Coginiti Pro

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

• Use Grok to Talk to Your Azure Data Lake Storage Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Azure Data Lake Storage for you.

• Integrate Sybase IQ with JetBrains RubyMine using CData JDBC Drivers

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

• Access Live CouchDB Data in Emergent via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Apache CouchDB through MCP integration.

• Connect to Google Ads Data from a Connection Pool in JBoss

  Integrate Google Ads into Java servlets: Use the Management Console in JBoss to install the Google Ads JDBC Driver.

• Integrate with Paymo Data using Apache Camel2

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

• Connect to Kafka Data in NetBeans

  Connect to Apache Kafka in NetBeans with the data source configuration wizard.

• Stream Contentful Data into Apache Kafka Topics

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

• Enable the TigerGraph JDBC Driver in KNIME

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

• Build SurveyMonkey-Connected Apps in Mendix

  Use CData Connect AI to create an OData feed for SurveyMonkey Data and create custom apps in Mendix.

• How to Work with ZohoSubscriptions Data in ETL Validator JDBC

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

• Automated Instagram Data Replication to Teradata

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

• Provide OData Services of NASA Data from a WCF Application

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

• Integrate Google

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

• Connect to LaunchDarkly Data Using the Script Function in Claris FileMaker Pro

  Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to LaunchDarkly and work with LaunchDarkly in your FileMaker application.

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

  Use the CData API Server to connect to live IBM DB2 in the Power Pivot business intelligence tool.

• Connect to CockroachDB Data from Crystal Reports

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

• Connect to SAP Business One Data from AWS Glue

  Use CData Connect AI to gain access to live SAP Business One from your AWS Glue jobs.

• Operational Reporting on ZohoMarketingHub Data from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote ZohoMarketingHub.

• Visualize Live Excel Data in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Microsoft Excel.

• Connect to SAP Hybris C4C Data in RapidMiner

  Integrate SAP Hybris C4C with standard components and data source configuration wizards in RapidMiner Studio.

• Use the CData ODBC Driver for Microsoft Teams from SharePoint Excel Services

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

• Integrate Google

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

• Feed Simplesat Data into FineReport

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

• Connect to Live Raisers Edge NXT Data in MicroStrategy through CData Connect AI

  Create a live connection to Raisers Edge NXT Data in CData Connect AI and connect to your Raisers Edge NXT from MicroStrategy.

• How to connect to Datadog Data with Squirrel SQL client

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

• Consume BigCommerce OData Feeds in PowerBuilder

  This article demonstrates how to consume BigCommerce as OData feeds from PowerBuilder using the API Server.

• Import Real-Time Salesforce CRM Analytics Data via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Salesforce CRM Analytics in ColdFusion.

• Connect to Greenhouse Data from Blazor Apps

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

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

  Replicate ZohoMarketingHub to disparate databases with a single configuration.

• Integrate Live Microsoft Entra ID Data into Amazon SageMaker Canvas with RDS

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

• Feed Salesforce Marketing Data into FineReport

  How to set Salesforce Marketing Cloud as a JDBC data source in FineReport.

• HDFS Reporting in OBIEE with the HDFS JDBC Driver

  Deploy the HDFS JDBC driver on OBIEE to provide real-time reporting across the enterprise.

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

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

• Build a Singer.io Tap for Excel Online With the CData Python Connector

  Learn how to easily build a Singer.io Tap for live Excel Online data using

• Build Microsoft Dataverse Visualizations in Tableau Cloud

  Use CData Connect AI to connect to live Microsoft Dataverse (CDS) and build visualizations in Tableau Cloud.

• Create SSAS Tabular Models from Cloudflare Data

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

• Visualize Tickspot Data in Tableau

  The CData ODBC driver for Tickspot enables you integrate Tickspot into Tableau dashboards.

• Excel Spreadsheet Automation on Qualaroo Data with the QUERY Formula

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

• Load Asana Data to a Database Using Embulk

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

• Connect to Sage Intacct Data in Google Apps Script via SQL Gateway

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

• Build Dashboards with Freshdesk Data in Dundas BI

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

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

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

• Query Printful Data in ColdFusion

  Write standard ColdFusion data access code to connect to Printful.

• Getting Started with the CData ODBC Driver for Placid

  Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Placid.

• Migrating data from Amazon Athena to Databricks using CData SSIS Components.

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

• Import and Visualize SFTP Data in Power View

  Create data visualizations based on SFTP in Excel.

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

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

• Use Agno to Talk to Your Sybase IQ Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Sybase IQ for you.

• Connect to MariaDB Data from Blazor Apps

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

• Connect to Mouseflow Data from PowerBuilder via JDBC

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

• Automated Continuous Accelo Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Accelo replication to SQL Server.

• How to connect and process Zoho Creator from Azure Databricks

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

• Work with Greenplum Data in FoxPro

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

• «
• 629
• 630
• 631
• 632
• 633
• 634
• 635
• 636
• 637
• 638
• »