CData Software - Knowledge Base

Recent Articles

• «
• 74
• 75
• 76
• 77
• 78
• 79
• 80
• 81
• 82
• 83
• »

• Connect to SAP Ariba Procurement in RapidMiner

  Integrate SAP Ariba Procurement with standard components and data source configuration wizards in RapidMiner Studio.

• DataBind Microsoft Dataverse to the DevExpress Data Grid

  Use the CData Software ADO.NET Provider for Microsoft Dataverse with the DevExpress Windows Forms and Web controls to provide Microsoft Dataverse (CDS) to a chart.

• How to Visualize Dynamics GP Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Microsoft Dynamics GP in Python.

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

• How to Work with Google Drive in AWS Glue Jobs Using JDBC

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

• Visualize SuiteCRM in Sisense

  Create an ElastiCube in Sisense app with access to SuiteCRM.

• Natively Connect to Veeva in PHP

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

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

• Query Databricks in MySQL Workbench

  Create a virtual MySQL database for Databricks in CData Software Connect (or Connect Server) and work with live Databricks in MySQL Workbench.

• How to pipe Google Drive to CSV in PowerShell

  Use standard PowerShell cmdlets to access Google Drive tables.

• How to Connect DBeaver to Okta via a JDBC Driver

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

• Analyze Drip with Power Pivot

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

• Build an OLAP Cube in SSAS from Slack

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

• Use Biml to Build SSIS Tasks to Replicate Oracle Sales to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Oracle Sales to SQL Server.

• Replicate Pinterest to Multiple Databases

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

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

  Connect to real-time Microsoft SQL Server in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SQL Server.

• DataBind Controls to SAP Ariba Source in C++Builder

  DataBind to SAP Ariba Source in C++Builder with standard components and controls.

• Replicate Multiple Twilio Accounts

  Replicate multiple Twilio accounts to one or many databases.

• Create Sage Intacct-Connected Visualizations in Klipfolio

  Use CData Connect Cloud to connect to Sage Intacct from Klipfolio and build custom visualizations using live Sage Intacct.

• Visualize IBM Cloud Object Storage in Tableau Desktop (through CData Connect)

  Create a virtual SQL Server database for IBM Cloud Object Storage in CData Software Connect (or Connect Server) and build visualizations from live IBM Cloud Object Storage in Tableau Desktop.

• Back Up Highrise CRM to SQL Server through SSIS

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

• Import Real-Time Avalara AvaTax in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Avalara AvaTax in ColdFusion.

• Access Act-On as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Act-On from your Oracle system.

• Create Reports with OneNote in SAP Crystal Reports

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

• Build Visualizations of Google Calendar in Birst

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

• How to Query Live SAP Ariba Source Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live SAP Ariba Source data in natural language using Python.

• Rapidly Develop SQL Analysis Services-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.

• Connect to Cassandra from Blazor Apps

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

• Connect to Office 365 from a Connection Pool in Jetty

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

• DataBind IBM Cloud Object Storage to the DevExpress Data Grid

  Use the CData Software ADO.NET Provider for IBM Cloud Object Storage with the DevExpress Windows Forms and Web controls to provide IBM Cloud Object Storage to a chart.

• Replicate Multiple Redis Accounts

  Replicate multiple Redis accounts to one or many databases.

• Access Live Quickbase in Coginiti Pro

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

• Automated Continuous Invoiced Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable Invoiced replication to Microsoft Access.

• Integrate Bing Search with External Services using SnapLogic

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

• Access Live SAP Hybris C4C in TIBCO Data Virtualization

  Use the CData Software TIBCO DV Adapter for SAP Hybris C4C to create a SAP Hybris C4C source in TIBCO Data Virtualization Studio and gain access to live SAP Hybris C4C from your TDV Server.

• Analyze QuickBooks Time in SAP Analytics Cloud

  Use CData Connect Cloud to create an OData API on top of QuickBooks Time and visualize QuickBooks Time in SAP Analytics Cloud.

• Connect to Klaviyo in CloverDX (formerly CloverETL)

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

• Connect to SharePoint Excel Services from PowerBuilder

  This article demonstrates how to access SharePoint Excel Services from PowerBuilder using the SharePoint Excel Services JDBC Driver.

• Connect to Hive in Ruby

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

• Automated Continuous SingleStore Replication to Apache Kafka

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

• Write a Simple Go Application to work with Klipfolio on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Klipfolio.

• Bidirectional Access to Google Cloud Storage from FileMaker Pro

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

• Connect to Xero in HULFT Integrate

  Connect to Xero as a JDBC data source in HULFT Integrate

• How to connect to Splunk from IntelliJ

  Integrate connectivity to Splunk with wizards in IntelliJ.

• Connect to SAS Data Sets in RunMyProcess through Connect Server

  Use CData Connect Server to create an OData API for SAS Data Sets and connect to SAS Data Sets in Akorbi Digital RunMyProcess.

• How to Connect the Power BI Service to Microsoft Exchange: Complete Guide

  Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.

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

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

• Connect to SQL Analysis Services from PowerBuilder

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

• Automate Access Replication to Azure Synapse

  Use CData Sync to customize and automate Microsoft Access replication to Azure Synapse.

• Create PayPal Dashboards in Bold BI

  Use CData Software Connect Server to create a virtual SQL Server Database for PayPal to build custom dashboards in Bold BI.

• Publish LDAP-Connected Dashboards in Tableau Server

  Use CData JDBC drivers and Tableau Server to visualize live LDAP.

• Query, Visualize, and Share live SAP HANA in Redash

  Use CData Connect Cloud to connect to live SAP HANA in Redash for querying, visualizing, and sharing.

• Publish Redis-Connected Dashboards in Tableau Server

  Use CData JDBC drivers and Tableau Server to visualize live Redis.

• Create Data Visualizations in Cognos BI with FHIR

  Access FHIR as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

• How to Visualize Zoho CRM Data in Python with pandas

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

• Replicate Klaviyo to Multiple Databases

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

• How to work with Amazon DynamoDB in Apache Spark using SQL

  Access and process Amazon DynamoDB in Apache Spark using the CData Software JDBC Driver.

• How to publish and share ConstantContact dashboards with Tableau Server

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

• Build Pipelines with Live Quickbase in Google Cloud Data Fusion (via CData Connect Cloud)

  Use CData Connect Cloud to connect to Quickbase from Google Cloud Data Fusion, enabling the integration of live Quickbase into the building and management of effective data pipelines.

• Oracle Service Cloud Reporting in OBIEE with the Oracle Service Cloud JDBC Driver

  Deploy the Oracle Service Cloud JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• Build Automated GitHub-Connected Workflows in Zapier

  Use CData Connect Cloud to connect to live GitHub and build automated workflows in Zapier.

• Connect to Greenhouse from PowerBuilder

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

• Visualize SAP Netweaver Gateway in TIBCO Spotfire through ADO.NET

  Integrate SAP Netweaver Gateway into dashboards in TIBCO Spotfire.

• How to Work with Zoho Projects in ETL Validator JDBC

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

• Validate Airtable with QuerySurge

  Access and validate Airtable in QuerySurge using the CData JDBC Driver.

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

• How to work with SingleStore in Apache Spark using SQL

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

• Access Wave Financial from MySQL in PHP

  Connect to Wave Financial through the standard MySQL libraries in PHP.

• ETL Parquet in Oracle Data Integrator

  This article shows how to transfer Apache Parquet into a data warehouse using Oracle Data Integrator.

• Automate Acumatica Integration Tasks from PowerShell

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

• Analyze Freshdesk in R

  Use standard R functions and the development environment of your choice to analyze Freshdesk with the CData JDBC Driver for Freshdesk.

• Configure the CData JDBC Driver for Shopify in a Connection Pool in Tomcat

  Connect to Shopify from a connection pool in Tomcat.

• Connect to Tableau CRM Analytics in SpagoBI

  Create reports featuring live Tableau CRM Analytics in SpagoBI Studio. Host Tableau CRM Analytics reports on SpagoBI Server.

• Analyze Live HubSpot in SAS Viya

  Use CData Connect Cloud to connect to HubSpot from SAS Viya and deploy self-service analytics using live HubSpot.

• How to Work with IBM Cloud Object Storage in ETL Validator JDBC

  Connect to IBM Cloud Object Storage from ETL Validator jobs using the CData Software JDBC Driver.

• Use the CData Software JDBC Driver for eBay Analytics in MicroStrategy Desktop

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

• Automated Continuous Sage Cloud Accounting Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to IBM DB2.

• Create ShipStation-Connected Business Apps in AppSheet

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

• Build Calendly-Connected ETL Processes in Google Data Fusion

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

• Automated Continuous xBase Replication to Local Delimited Files

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

• Build MariaDB-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to MariaDB and build web apps with connectivity to live MariaDB.

• Back Up Wave Financial to SQL Server through SSIS

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

• Connect to Gmail from Blazor Apps

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

• Automate Excel Replication to Couchbase

  Use CData Sync to Customize and automate Microsoft Excel replication to Couchbase.

• Excel Spreadsheet Automation with the QUERY Formula

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

• How to integrate SharePoint Excel Services with Apache Airflow

  Access and process SharePoint Excel Services in Apache Airflow using the CData JDBC Driver.

• Import HarperDB into Microsoft Power Query

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

• A PostgreSQL Interface for Redis

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

• Connect to CSV as a Linked Server

  Use CData Connect to set up a linked server for CSV/TSV Files.

• Automated Continuous Sugar CRM Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable Sugar CRM replication to Microsoft Access.

• Query HCL Domino in DataGrip

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

• Automated Continuous Azure Synapse Replication to PostgreSQL

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

• Create Workday-Connected Nintex Workflows

  Use CData Connect Cloud to connect to Workday from Nintex Workflow Cloud and build custom workflows using live Workday.

• Prepare, Blend, and Analyze Bullhorn CRM in Alteryx Designer

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

• Automated Continuous Adobe Commerce Replication to MySQL

  Use CData Sync for automated, continuous, customizable Adobe Commerce replication to MySQL.

• Import Real-Time Sage 200 in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Sage 200 in ColdFusion.

• How to integrate WordPress with Apache Airflow

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

• Access Live Klaviyo in AWS Lambda (with IntelliJ IDEA)

  Connect to live Klaviyo in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• Publish Act-On-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Act-On.

• Visualize REST from Tableau

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

• «
• 74
• 75
• 76
• 77
• 78
• 79
• 80
• 81
• 82
• 83
• »