CData Software - Knowledge Base

Recent Articles

• «
• 305
• 306
• 307
• 308
• 309
• 310
• 311
• 312
• 313
• 314
• »

• Viewing Dropbox in RAD Studio Data Explorer

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

• How to connect to HDFS in DBVisualizer

  Integrate Apache HDFS with visual data analysis tools and data connection wizards in DBVisualizer

• Automated Continuous REST Replication to SingleStore

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

• DataBind Charts to Salesloft

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Salesloft 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 Snowflake in MicroStrategy Web

  Connect to Snowflake in MicroStrategy Web using the CData Software ODBC Driver for Snowflake.

• Integrate JotForm in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live JotForm from Informatica Cloud.

• How to connect to Slack from Spring Boot

  Connect to Slack in a Spring Boot Application using CData JDBC Slack Driver

• Automated Continuous IBM Informix Replication to Oracle

  Use CData Sync for automated, continuous, customizable IBM Informix replication to Oracle.

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

  Use CData Power BI Connectors to visualize SAP Concur in Power BI.

• Access Xero as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Xero Accounting from your Oracle system.

• Rapidly Develop Exact Online-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.

• How to Connect DBeaver to BambooHR via a JDBC Driver

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

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

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

• How to Work with Zoho Creator in AWS Glue Jobs Using JDBC

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

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

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

• Analyze SAP HANA XS Advanced in R

  Create data visualizations and use high-performance statistical functions to analyze SAP HANA XS Advanced in Microsoft R Open.

• Build Semantic Layer Views for Azure Active Directory in APOS Live Data Gateway

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

• Create Veeva Dashboards in Bold BI

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

• Analyze Teradata in R

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

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

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

• Integrate Live Splunk into Custom Business Apps Built in Power Apps

  Use CData Connect Cloud to connect to Splunk and integrate live Splunk into apps built in Microsoft Power Apps.

• Cvent Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on Cvent facts in real time.

• Use the CData ODBC Driver for WordPress in SAS JMP

  You can use the CData ODBC Driver to integrate WordPress into the statistical analysis tools available in SAS JMP. This article shows how to use WordPress in the Graph Builder and Query Builder.

• Query Salesforce Marketing through ODBC in Node.js

  Use node-odbc to execute SQL queries against Salesforce Marketing Cloud from Node.js.

• Analyze Typeform in Infragistics Reveal

  Use the CData Connect Server to create an OData API on top of Typeform and visualize live Typeform in Ingragistics Reveal.

• Excel Spreadsheet Automation with the QUERY Formula

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

• PowerShell Scripting to Replicate Freshdesk to MySQL

  Write a simple PowerShell script to replicate Freshdesk to a MySQL database.

• Work with Live Spark in Power Query

  Use CData Connect Cloud to connect to Apache Spark SQL and work with live Apache Spark SQL in Microsoft Power Query.

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

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

• How to Query Sage 200 in MySQL Workbench

  Execute MySQL queries against live Sage 200 from MySQL Workbench.

• Use the CData Software JDBC Driver for Couchbase in MicroStrategy Web

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

• Use the CData Software ODBC Driver for Printify in MicroStrategy

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

• How to Connect to & Open MYOB AccountRight in Microsoft Excel

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

• How to Visualize Salesloft Data in Python with pandas

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

• Connect to Harvest in RunMyProcess through Connect Server

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

• Analyze Typeform in R

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

• Publish Crystal Reports on Stripe

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

• Work with Live PostgreSQL in Power Query

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

• How to load Zoho Books data into Elasticsearch via Logstash

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

• A PostgreSQL Interface for MarkLogic

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

• How to update LDAP from Excel

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

• Connect to Azure Analysis Services in the Denodo Platform

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

• Viewing Couchbase in RAD Studio Data Explorer

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

• Use the CData Software JDBC Driver for Salesforce Pardot in MicroStrategy Web

  Connect to Salesforce Pardot in MicroStrategy Web using the CData Software JDBC Driver for Salesforce Pardot.

• Stream JDBC-ODBC Bridge into Apache Kafka Topics

  Access and stream JDBC-ODBC Bridge in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

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

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

• Automated Wave Financial Replication to Teradata

  Use CData Sync to Customize and automate Wave Financial replication to Teradata.

• Analyze Zoho Creator in R

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

• Automated Continuous Box Replication to Microsoft Access

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

• How to Build Dynamic React Apps with Typeform

  Use the CData Connect and React to Build Dynamic Web Apps with Live Typeform .

• Connect to ConstantContact from a Connection Pool in WebLogic

  Use the CData JDBC Driver for ConstantContact to connect to ConstantContact from Web applications running on WebLogic.

• Choosing the Best Method to Connect Act-On to SQL Server: 5 Options Explained

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

• Visualize Live Zoom in the Power BI Service

  Use CData Software Connect Server to create a virtual SQL Server database for Zoom and create custom reports in the Power BI Service.

• Automated Continuous Unbounce Replication to AlloyDB

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

• Analyze SQL Analysis Services in R

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

• Create SingleStore Dataflows on PowerBI.com

  Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.

• Analyze Sage Intacct in R

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

• How to work with Zendesk in Apache Spark using SQL

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

• Connect to Live Authorize.Net in MicroStrategy through CData Software Connect Server

  Create a virtual database for Authorize.Net in CData Software Connect Server and connect to it from MicroStrategy.

• Query Google Data Catalog in MySQL Workbench

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

• Create Apps from Basecamp in Qlik Sense Cloud

  Use the CData Connect Server to create an OData API for Basecamp and build apps from live Basecamp in Qlik Sense Cloud.

• Connect to and Visualize Live MarkLogic in Tableau Prep

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

• Access Presto from MySQL in HeidiSQL

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

• Access Excel Online in PHP through Connect Server

  Connect to Excel Online through the standard SQL Server libraries in PHP.

• Prepare, Blend, and Analyze Slack in Alteryx Designer

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

• Back Up Apache Spark SQL to SQL Server through SSIS

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

• How to connect to Salesforce Pardot from IntelliJ

  Integrate connectivity to Salesforce Pardot with wizards in IntelliJ.

• Automated Continuous Parquet Replication to Azure SQL

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

• Validate Monday.com with QuerySurge

  Access and validate Monday.com in QuerySurge using the CData JDBC Driver.

• Excel Spreadsheet Automation with the QUERY Formula

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

• Connect to HDFS in RunMyProcess through Connect Server

  Use CData Connect Server to create an OData API for HDFS and connect to Apache HDFS in Akorbi Digital RunMyProcess.

• How to Connect to & Open Zenefits in Microsoft Excel

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

• Build Charts with ShipStation in Clear Analytics

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

• Import Real-Time Facebook Ads in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Facebook Ads in ColdFusion.

• Replicate Odoo to Multiple Databases

  Replicate Odoo ERP to disparate databases with a single configuration.

• Connect to Live Harvest in MicroStrategy through CData Software Connect Server

  Create a virtual database for Harvest in CData Software Connect Server and connect to it from MicroStrategy.

• Access Live Blackbaud FE NXT in TIBCO Data Virtualization

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

• Connect to Greenplum from PowerBuilder

  This article demonstrates how to access Pivotal GreenPlum from PowerBuilder using the Greenplum JDBC Driver.

• Use the CData Software ODBC Driver for Sage 300 in MicroStrategy Web

  Connect to Sage 300 in MicroStrategy Web using the CData Software ODBC Driver for Sage 300.

• Connect to SAP Business One in Ruby

  Connect to SAP Business One in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Automated Continuous MarkLogic Replication to Databricks

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

• Connect to Google Calendar through External Services in Salesforce

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

• Create Redshift-Connected Visualizations in Klipfolio

  Use CData Connect Cloud to connect to Redshift from Klipfolio and build custom visualizations using live Amazon Redshift.

• Natively Connect to Microsoft Teams in PHP

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

• Automated Continuous TaxJar Replication to Amazon Redshift

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

• Analyze Box with Power Pivot

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

• Kafka Reporting in OBIEE with the Kafka JDBC Driver

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

• Automated Continuous Excel Online Replication to Oracle

  Use CData Sync for automated, continuous, customizable Excel Online replication to Oracle.

• Create MariaDB Dashboards in Bold BI

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

• Author and Share Power BI Reports on Real-Time Microsoft OneDrive

  Use the CData ODBC Driver for Microsoft OneDrive to visualize Microsoft OneDrive in Power BI Desktop and then upload to the Power BI service.

• Back Up Microsoft Dynamics CRM to SQL Server through SSIS

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

• Import Real-Time GraphQL in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use GraphQL in ColdFusion.

• Import Real-Time GraphQL in ColdFusion to Build Applications

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

• A PostgreSQL Interface for HDFS

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

• Natively Connect to PostgreSQL in PHP

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

• Import Real-Time Google Sheets in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Google Sheets in ColdFusion.

• Build Monday.com Visualizations in Tableau Cloud

  Use CData Connect Cloud to connect to live Monday.com and build visualizations in Tableau Cloud.

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

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

• Use Biml to Build SSIS Tasks to Replicate Tableau CRM Analytics to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Tableau CRM Analytics to SQL Server.

• Access Azure Data Catalog from MySQL in Amazon QuickSight

  Connect to Azure Data Catalog and build visualizations of Azure Data Catalog using a MySQL Connection in Amazon QuickSight.

• «
• 305
• 306
• 307
• 308
• 309
• 310
• 311
• 312
• 313
• 314
• »