CData Software - Knowledge Base

Recent Articles

• «
• 517
• 518
• 519
• 520
• 521
• 522
• 523
• 524
• 525
• 526
• »

• Visualize Google Directory in TIBCO Spotfire through ADO.NET

  Integrate Google Directory into dashboards in TIBCO Spotfire.

• Build Charts with OneNote in Clear Analytics

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

• Process & Analyze PingOne in Databricks (AWS)

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

• Connect to Cassandra in DBeaver

  Use the CData ODBC Driver to connect to Apache Cassandra in DBeaver.

• Back Up Klipfolio to SQL Server through SSIS

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

• How to connect to xBase from IntelliJ

  Integrate connectivity to xBase with wizards in IntelliJ.

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

• Automated Continuous Google Ad Manager Replication to MySQL

  Use CData Sync for automated, continuous, customizable Google Ad Manager replication to MySQL.

• Automated Continuous Power BI XMLA Replication to Databricks

  Use CData Sync for automated, continuous, customizable Power BI XMLA replication to Databricks.

• Connect to Zoho Creator in Google Apps Script via Connect Cloud

  Use CData Connect Cloud to access Zoho Creator in Google Apps Script.

• How to Access Live QuickBooks Online in Visual Studio Code via Cline

  Run the CData MCP Server for QuickBooks Online on Windows Subsytem for Linux (WSL) and connect to live QuickBooks Online from the Cline extension in Visual Studio Code.

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

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

• Visualize Jira in Tableau

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

• Excel Spreadsheet Automation on ActiveCampaign with the QUERY Formula

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

• Visualize MySQL in Sisense

  Create an ElastiCube in Sisense app with access to MySQL.

• How to Seamlessly Import Parquet Data into IBM SPSS Modeler

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

• How to Connect to & Open ClickUp in Microsoft Excel

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

• How to Query Monday.com in MySQL Workbench

  Execute MySQL queries against live Monday.com from MySQL Workbench.

• Use the CData API Server to Access Drip in Microsoft PowerPivot

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

• How to connect to Shopify in DBVisualizer

  Integrate Shopify with visual data analysis tools and data connection wizards in DBVisualizer

• Connect to Azure Synapse from Blazor Apps

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

• Integrate PostgreSQL into Automated Tasks with Power Automate

  Use CData Connect Cloud to connect to PostgreSQL and integrate live PostgreSQL into your Power Automate tasks.

• How to update Salesloft from Excel

  This article explains how to transfer data from Excel to Salesloft using the Excel Add-In for Salesloft.

• Validate Microsoft Teams with QuerySurge

  Access and validate Microsoft Teams in QuerySurge using the CData JDBC Driver.

• Automated Continuous Couchbase Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable Couchbase replication to AlloyDB.

• Visualize Live Hive in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Apache Hive.

• Access HDFS as a Remote Oracle Database

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

• Manage Splunk in DBArtisan as a JDBC Source

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

• How to create Visio diagrams from Oracle Sales

  Automatically update Oracle Sales with the changes you make to Visio master shapes.

• Automated Continuous eBay Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable eBay replication to AlloyDB.

• Automate SAP ByDesign Replication to Azure Data Lake

  Use CData Sync to customize and automate SAP Business ByDesign replication to Azure Data Lake.

• Use the CData Software ODBC Driver for Tableau CRM Analytics in MicroStrategy Desktop

  Connect to Tableau CRM Analytics in MicroStrategy Desktop using the CData Software ODBC Driver for Tableau CRM Analytics.

• Query Avalara AvaTax using the OData SDK for PHP

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

• Replicate Twitter in Heroku for Use in Salesforce Connect

  Replicate Twitter to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• How to Access Google Calendar Using Entity Framework

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

• Edit and Search External SurveyMonkey Objects in Salesforce Connect

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

• Integrate with Live Square in MuleSoft (via CData Connect Cloud)

  Use CData Connect Cloud to connect to Square from the MuleSoft Anypoint Platform to integrate live Square into custom reports and dashboards.

• Choosing the Best Method to Connect Quickbase to SQL Server: 5 Options Explained

  Discover multiple ways to connect and use Quickbase from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.

• Easily Integrate HBase in Lazarus Pascal IDE

  Learn how to easily integrate live Apache HBase in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

• Automated Continuous Drip Replication to Google BigQuery

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

• Connect to SurveyMonkey in Ruby

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

• Analyze Salesforce Data Cloud with Power Pivot

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

• Visualize Live Sage Intacct in Power BI (via CData Connect Cloud)

  Use the CData Power BI Connector and CData Connect Cloud to integrate live Sage Intacct into custom reports in Power BI.

• How to Import Data from Google Campaign Manager 360 into Google Sheets

  Import Google Campaign Manager 360 into a Google spreadsheet that is automatically refreshed.

• Access Live Dynamics CRM in Coginiti Pro

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

• Analyze Bullhorn CRM in Cognos Analytics

  Use CData Connect Cloud to connect to Bullhorn CRM from Cognos Analytics and analyze live Bullhorn CRM.

• Query SAS xpt using the OData SDK for PHP

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

• Connect to Xero in DBeaver

  Use the CData ODBC Driver to connect to Xero Accounting in DBeaver.

• Build Semantic Layer Views for MongoDB in APOS Live Data Gateway

  Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for MongoDB.

• Rapidly Develop TigerGraph-Driven Apps with Active Query Builder

  Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.

• Analyze Okta in R via ODBC

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

• How to Connect to HubSpot in Using Python: 6 Steps

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

• How to import Cosmos DB into Apache Solr

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

• Import Twilio into Microsoft Power Query

  The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Twilio. In this article, you will use the OData format to import Twilio into Microsoft Power Query.

• Use the CData Software ODBC Driver for Oracle Service Cloud in MicroStrategy

  Connect to Oracle Service Cloud in MicroStrategy Developer using the CData Software ODBC Driver for Oracle Service Cloud.

• How to Visualize Parquet Data in Python with pandas

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

• Stream Neo4J into Apache Kafka Topics

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

• Connect to IBM Cloud Object Storage in Aqua Data Studio

  Access IBM Cloud Object Storage from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Process & Analyze Dynamics NAV in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live Dynamics NAV .

• Operational Reporting on SAP HANA from Spotfire Server

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

• Connect to Salesforce in SpagoBI

  Create reports featuring live Salesforce & Force.com in SpagoBI Studio. Host Salesforce reports on SpagoBI Server.

• Connect to Google Data Catalog from PowerBuilder via ODBC

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

• Connect to Zoom in the Denodo Platform

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

• How to Work with EventBrite in ETL Validator JDBC

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

• Replicate Todoist to Multiple Databases via the CData Sync CLI

  Replicate Todoist to disparate databases with a single configuration.

• Connect to eBay in RapidMiner

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

• Connect and Visualize Live WordPress Data in Databricks Lakehouse Federation with CData Connect Cloud

  Use CData Connect Cloud to integrate live WordPress into the Databricks platform and create visualization dashboards with real-time WordPress.

• Use the CData Software JDBC Driver for DocuSign in MicroStrategy

  Connect to DocuSign in MicroStrategy Developer using the CData Software JDBC Driver for DocuSign.

• How to Seamlessly Import QuickBooks Time Data into IBM SPSS Modeler

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

• DataBind Controls to Cloudant in Delphi

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

• Create Data Visualizations Based On SurveyMonkey in Mode

  Use CData Connect Cloud to connect to SurveyMonkey from Mode and build visualizations using live

• Create Reports with Instagram in SAP Crystal Reports

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

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

  Provide connectivity to SuiteCRM through an SAP BusinessObjects universe.

• How to Connect to & Open Avro in Microsoft Excel

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

• Process & Analyze eBay in Databricks (AWS)

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

• Connect and Visualize Live Google Campaign Manager 360 Data in Databricks Lakehouse Federation with CData Connect Cloud

  Use CData Connect Cloud to integrate live Google Campaign Manager 360 into the Databricks platform and create visualization dashboards with real-time Google Campaign Manager 360.

• How to Access Live Certinia in Visual Studio Code via Cline

  Run the CData MCP Server for Certinia on Windows Subsytem for Linux (WSL) and connect to live Certinia from the Cline extension in Visual Studio Code.

• Integrate Real-Time Access to SAP HANA in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SAP HANA in real time.

• How to Import Data from Couchbase into Google Sheets

  Import Couchbase into a Google spreadsheet that is automatically refreshed.

• Choosing the Best Method to Connect Amazon S3 to SQL Server: 5 Options Explained

  Discover multiple ways to connect and use Amazon S3 from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.

• Automate Klipfolio Tasks in Power Automate Using CData API Server

  With CData API Server, easily create OData endpoints for live Klipfolio and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.

• LINQ to Phoenix

  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 Phoenix Data Provider.

• Automated Continuous AlloyDB Replication to PostgreSQL

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

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

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

• Automate Dynamics 365 Replication to SAP HANA

  Use CData Sync to customize and automate Microsoft Dynamics 365 replication to SAP HANA.

• Building Dynamic Web Pages with Couchbase Using AngularJS

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

• Viewing Cloudant in RAD Studio Data Explorer

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

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

• Use the CData Software JDBC Driver for Redshift in MicroStrategy

  Connect to Amazon Redshift in MicroStrategy Developer using the CData Software JDBC Driver for Redshift.

• Integrate Live Databricks into Amazon SageMaker Canvas with RDS

  Use CData Connect Cloud to connect to Databricks from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Databricks.

• Create GitHub-Connected Business Apps in AppSheet

  Connect to GitHub via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to GitHub.

• Bidirectional Access to HDFS from FileMaker Pro

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

• DataBind Charts to SurveyMonkey

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to SurveyMonkey from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.

• Query Azure Data Catalog in ColdFusion

  Write standard ColdFusion data access code to connect to Azure Data Catalog.

• FHIR Cloud Connectivity

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

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

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

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

• How to load Calendly data into Elasticsearch via Logstash

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

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for SAP BusinessObjects BI

  Provide connectivity to SAP BusinessObjects BI through an SAP BusinessObjects universe.

• Connect to JDBC-ODBC Bridge as an External Source in Dremio

  Use the CData JDBC Driver to connect to JDBC-ODBC Bridge as an External Source in Dremio.

• «
• 517
• 518
• 519
• 520
• 521
• 522
• 523
• 524
• 525
• 526
• »