CData Software - Knowledge Base

Recent Articles

• «
• 466
• 467
• 468
• 469
• 470
• 471
• 472
• 473
• 474
• 475
• »

• How to connect to Azure Data Catalog with Squirrel SQL client

  Connect to Azure Data Catalog and execute queries in the Squirrel SQL Client.

• Build Apps with Live Presto in Adalo using CData Connect Cloud

  Use CData Connect Cloud to integrate live Presto into the Adalo platform and build custom mobile and web applications with real-time Presto.

• Use the CData ODBC Driver for Google Cloud Storage from SharePoint Excel Services

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

• Use the CData Software JDBC Driver for Oracle Eloqua in MicroStrategy Web

  Connect to Oracle Eloqua in MicroStrategy Web using the CData Software JDBC Driver for Oracle Eloqua.

• DataBind Charts to Sage 50 UK

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Sage 50 UK 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.

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

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

• Connect to FHIR from PowerBuilder via ODBC

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

• Query REST from Node.js

  Use the OData endpoint of the CData API Server to connect to your REST and perform CRUD operations on REST from Node.js.

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

  Build workflows to access live Microsoft Dataverse (CDS) for self-service data analytics.

• Automate Aha Integration Tasks from PowerShell

  Are you in search of a quick and easy way to access Aha! from PowerShell? This article demonstrates how to utilize the Aha Cmdlets for tasks like connecting to Aha!, automating operations, downloading data, and more.

• Migrating data from Bullhorn CRM to Snowflake using CData SSIS Components.

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

• Replicate Multiple Google Search Accounts

  Replicate multiple Google Search accounts to one or many databases.

• Import BCart into the Power BI Service for Visualizations

  Use CData Connect Cloud to connect to BCart and provide access to live BCart for custom reports in the Power BI Service.

• Process & Analyze Oracle Sales in Databricks (AWS)

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

• Create SSAS Tabular Models from Tally

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

• Work with Live Asana in Power Query

  Use CData Connect Cloud to connect to Asana and work with live Asana in Microsoft Power Query.

• Query Sybase using the OData SDK for PHP

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

• Connect to Live Sage Cloud Accounting in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to Sage Cloud Accounting in CData Connect Cloud and connect to your Sage Business Cloud Accounting from PostgreSQL.

• How to integrate Sage 50 UK with Apache Airflow

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

• Automated Continuous OneNote Replication to Amazon S3

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

• Analyze Oracle SCM with Power Pivot

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

• Build Visualizations of GitHub in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of GitHub in Birst.

• Analyze Airtable with Power Pivot

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

• Use CData Connect Cloud to Access Quickbase in Microsoft Power Pivot

  Use CData Connect Cloud to connect to live Quickbase in the Power Pivot business intelligence tool.

• Automated Continuous NetSuite SuiteAnalytics Replication to SQL Server

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

• Automated Continuous Phoenix Replication to Google Cloud SQL

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

• Build MVC Applications with Connectivity to Google Analytics

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Google Analytics from an ASP.NET MVC application.

• Build Visualizations of Avalara AvaTax in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Avalara AvaTax in Birst.

• How to Work with Google Campaign Manager 360 in AWS Glue Jobs Using JDBC

  Connect to Google Campaign Manager 360 from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• Rapidly Develop SAP Fieldglass-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.

• Edit and Search External PostgreSQL Objects in Salesforce Connect

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

• Create Power BI Reports on Real-Time Amazon S3

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

• Automated Continuous MYOB AccountRight Replication to Oracle

  Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to Oracle.

• Access Live Azure DevOps in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

  Connect to Azure DevOps from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

• Query Shopify as a MySQL Database in Node.js

  Execute MySQL queries against Shopify from Node.js.

• How to create Google Contacts federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for Google Contacts in MySQL .

• Build MVC Applications with Connectivity to xBase

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access xBase from an ASP.NET MVC application.

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

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

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

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

• Deploy the ADO.NET Provider for Procore on an SSRS Report Server

  Connect to Procore from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

• Automated Continuous PostgreSQL Replication to Amazon S3

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

• Create Dynamic Couchbase Grids Using the Infragistics XamDataGrid

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

• Access Snapchat Ads from MySQL in Amazon QuickSight

  Connect to Snapchat Ads and build visualizations of Snapchat Ads using a MySQL Connection in Amazon QuickSight.

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

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

  Provide connectivity to Microsoft Access through an SAP BusinessObjects universe.

• How to integrate Procore with Apache Airflow

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

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

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

• Build Salesforce-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Salesforce & Force.com and build web apps with connectivity to live Salesforce & Force.com.

• How to create Visio diagrams from Certinia

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

• Replicate Cassandra to Multiple Databases

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

• Feed SAP BusinessObjects BI into FineReport

  How to set SAP BusinessObjects BI as a JDBC data source in FineReport.

• How to connect to Microsoft Dataverse from IntelliJ

  Integrate connectivity to Microsoft Dataverse (CDS) with wizards in IntelliJ.

• Automated Continuous Google Contacts Replication to SingleStore

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

• Extract, Transform, and Load NetSuite in Informatica PowerCenter

  Create a simple Workflow for NetSuite CRM & ERP in Informatica PowerCenter.

• Google Directory Cloud Connectivity

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

• Connect to Salesloft in DBArtisan

  Use wizards in DBArtisan to configure Salesloft as a data source.

• Bridge ADP Connectivity with Apache NiFi

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

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

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

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

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

• Use the CData Software ODBC Driver for Calendly in MicroStrategy

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

• Integrate Real-Time Access to PayPal in SAPUI5 MVC Apps

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

• Natively Connect to Dynamics NAV in PHP via ODBC (Linux)

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

• How to publish and share Wave Financial dashboards with Tableau Server

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

• Consume Twitter OData Feeds in PowerBuilder

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

• Access Live Outreach.io in Excel (Desktop) via Connect Cloud

  Use CData Connect Cloud to gain access to live Outreach.io from your Excel spreadsheets.

• Connect to Live ServiceNow in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to ServiceNow in CData Connect Cloud and connect to your ServiceNow from PostgreSQL.

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

  Connect to Veeva Vault & Vault CRM in MicroStrategy Desktop using the CData Software ODBC Driver for Vault CRM.

• Import and Visualize Presto in Power View

  Create data visualizations based on Presto in Excel.

• Analyze Jira Assets in R via ODBC

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

• Build a Simple VCL Application for FTP

  How to build a simple VCL Application to view FTP Servers in RAD Studio using the CData ODBC Driver for FTP.

• Query eBay as a MySQL Database in Node.js

  Execute MySQL queries against eBay from Node.js.

• Use the CData Software JDBC Driver for Sugar CRM in MicroStrategy Desktop

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

• Connect to HubSpot in Jaspersoft Studio

  Execute SQL to remote HubSpot in Jaspersoft Studio.

• How to Connect to Avalara AvaTax in Using Python: 6 Steps

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

• Connect to Outreach.io in ACL Analytics

  Connect to Outreach.io via CData Connect Cloud in ACL Analytics to run your data analysis workflows with real-time access to Outreach.io.

• How to connect to Cvent in DBVisualizer

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

• Automated Continuous Twitter Ads Replication to Databricks

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

• Automated Continuous Microsoft Planner Replication to Apache Kafka

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

• Create Shopify-Connected Business Apps in AppSheet

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

• Replicate Multiple Jira Service Management Accounts

  Replicate multiple Jira Service Management accounts to one or many databases.

• Connect to Epicor Kinetic in the Denodo Platform

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

• Build Visualizations of AlloyDB in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Google AlloyDB in Birst.

• Build Automated Workflows with Live Databricks in Workato

  Use CData Connect Cloud to connect to live Databricks and build automated workflows in Workato.

• Automated Continuous Jira Service Management Replication to Oracle

  Use CData Sync for automated, continuous, customizable Jira Service Management replication to Oracle.

• Access Microsoft Planner from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Microsoft Planner from HeidiSQL.

• Automated Continuous eBay Replication to Azure SQL Database

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

• Access Live TigerGraph in Coginiti Pro

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

• Import Oracle into Microsoft Power Query

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

• Load Reckon to a Database Using Embulk

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

• Validate SharePoint with QuerySurge

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

• Automated Continuous SAP HANA Replication to Amazon Redshift

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

• Create Hive-Connected Applications in Appsmith

  Connect to Hive via CData Connect Cloud in Appsmith and create custom business applications with real-time access to Apache Hive.

• Automated Continuous Wave Financial Replication to Local Delimited Files

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

• Automated Continuous EnterpriseDB Replication to Snowflake

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

• Perform Batch Operations with BigCommerce in Apache NiFi

  Connect to BigCommerce and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

• Connect to Sugar CRM from a Connection Pool in JBoss

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

• Automated Continuous Act-On Replication to SQLite

  Use CData Sync for automated, continuous, customizable Act-On replication to SQLite.

• Connect to Act CRM in Aqua Data Studio

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

• Load Elasticsearch to a Database Using Embulk

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

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

  Connect to Veeva Vault & Vault CRM from Excel 365 Online (Excel for the web) with CData Connect Cloud.

• «
• 466
• 467
• 468
• 469
• 470
• 471
• 472
• 473
• 474
• 475
• »