CData Software - Knowledge Base

Recent Articles

• «
• 299
• 300
• 301
• 302
• 303
• 304
• 305
• 306
• 307
• 308
• »

• How to connect Amazon QuickSight to Zendesk

  Create a connection to Zendesk in CData Connect Cloud and insert Zendesk into Amazon QuickSight SPICE to build interactive dashboards.

• Connect to Databricks in Ruby

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

• Connect to Sage 50 UK as a Linked Server

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Sage 50 UK.

• Automated Continuous Databricks Replication to Apache Cassandra

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

• How to Visualize Salesforce Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Salesforce & Force.com in Python.

• Create Todoist-Connected Visualizations in Klipfolio

  Use CData Software Connect Server to connect to Todoist from Klipfolio and build custom visualizations using live Todoist.

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

  Create Python applications on Linux/UNIX machines with connectivity to NetSuite CRM & ERP. Leverage the pyodbc module for ODBC in Python.

• Query EventBrite in MySQL Workbench

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

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

  Connect to Microsoft Dynamics NAV from a connection pool in Tomcat.

• Connect to Impala from PowerBuilder

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

• Automated Continuous Xero Replication to Local Delimited Files

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

• Automate WooCommerce Replication to Couchbase

  Use CData Sync to Customize and automate WooCommerce replication to Couchbase.

• Prepare, Blend, and Analyze Avro in Alteryx Designer

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

• Server Certificate Verification Failed: Connection Aborted

  This entry details the typical causes of the error and proposes solutions to resolve it.

• Create DocuSign-Connected Nintex Workflows

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

• How to connect to Procore from Google Apps Script

  Use CData Software Connect Server to access Procore in Google Apps Script.

• Process & Analyze SharePoint Excel Services in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live SharePoint Excel Services .

• How to connect to Drift with Squirrel SQL client

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

• How to use SQLAlchemy ORM to access Cosmos DB in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Azure Cosmos DB.

• How to connect to HCL Domino in DBVisualizer

  Integrate HCL Domino with visual data analysis tools and data connection wizards in DBVisualizer

• LINQ to SAP Business One

  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 SAP Business One Data Provider.

• A Comparison of Database Drivers for MySQL

  A performance comparison of the CData JDBC & ODBC Drivers for MySQL and the native MySQL Connector/J & Connector/ODBC (updated May 2020)

• Create Reports with Zoho CRM in SAP Crystal Reports

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

• Visualize Live Salesforce Pardot in the Power BI Service

  Use CData Connect Cloud to connect to live Salesforce Pardot and create custom reports in the Power BI Service through the On-Premises Gateway.

• Feed NetSuite into FineReport

  How to set NetSuite CRM & ERP as a JDBC data source in FineReport.

• Automated Continuous SingleStore Replication to PostgreSQL

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

• Connect to CockroachDB in Airbyte ELT Pipelines

  Use CData Connect Cloud to build ELT pipelines for CockroachDB in Airbyte.

• Connect to Snowflake in HULFT Integrate

  Connect to Snowflake as a JDBC data source in HULFT Integrate

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

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

• Connect to Live OData Services in PostGresSQL Interface through CData Connect Cloud

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

• Connect to Jira from AWS Glue

  Use CData Connect Cloud to gain access to live Atlassian Jira from your AWS Glue jobs.

• ETL Box in Oracle Data Integrator

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

• Connect to Microsoft Planner in RazorSQL

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

• Automated Continuous eBay Replication to SQL Server

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

• How to connect PolyBase to WordPress

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live WordPress.

• Replicate Multiple Wave Financial Accounts

  Replicate multiple Wave Financial accounts to one or many databases.

• Connect to IBM Informix from Asprova with CData Software ODBC Driver for IBM Informix

  This article shows how to connect faster to IBM Informix data from Asprova.

• Analyze SAP BusinessObjects BI in Infragistics Reveal

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

• How to Work with Sage 200 in AWS Glue Jobs Using JDBC

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

• How to connect and process Cloudant from Azure Databricks

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

• How to Work with Paylocity in ETL Validator JDBC

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

• Connect to Oracle Sales in Airbyte ELT Pipelines

  Use CData Connect Cloud to build ELT pipelines for Oracle Sales in Airbyte.

• Connect to Sage Cloud Accounting in SpagoBI

  Create reports featuring live Sage Business Cloud Accounting in SpagoBI Studio. Host Sage Cloud Accounting reports on SpagoBI Server.

• How to Work with SFTP in AWS Glue Jobs Using JDBC

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

• Query Sage 300 as a MySQL Database in Node.js

  Execute MySQL queries against Sage 300 from Node.js.

• Access HCL Domino as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access HCL Domino from your Oracle system.

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

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

• Automated Continuous Klipfolio Replication to Microsoft Access

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

• Establish a Live Connection with Sugar CRM using Tableau Bridge

  The CData ODBC Driver for Sugar CRM enables you to integrate live Sugar CRM into Tableau Cloud dashboards using the Tableau Bridge.

• Automated Continuous Todoist Replication to AlloyDB

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

• Publish Bing Search-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Bing Search.

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

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

• Use the CData Software JDBC Driver for BambooHR in MicroStrategy

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

• Automated Continuous Shopify Replication to SQL Server

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

• Analyze Microsoft Project in R

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

• Automated Continuous Zuora Replication to Google BigQuery

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

• Use Biml to Build SSIS Tasks to Replicate Microsoft Teams to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Microsoft Teams to SQL Server.

• Connect to HCL Domino in as an External Source in Dremio

  Use the CData JDBC Driver to connect to HCL Domino as an External Source in Dremio.

• Create Reckon Accounts Hosted Dashboards in Bold BI

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

• Analyze Paylocity in R

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

• Build Visualizations of PostgreSQL in Birst

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

• How to create Access federated tables in MySQL

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

• How to load Salesforce Pardot data into Elasticsearch via Logstash

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

• How to Create Power BI Visual Reports with Real-Time SAS xpt

  Use CData Power BI Connectors to visualize SAS XPORT in Power BI.

• How to Visualize ADP Data in Python with pandas

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

• Work with Live Facebook in Power Query

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

• Analyze Exact Online in Cognos Analytics

  Use CData Connect Cloud to connect to Exact Online from Cognos Analytics and analyze live Exact Online.

• How to Query Live Square Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live Square data in natural language using Python.

• View Reports on Real-Time Sybase in Power BI Report Server

  Use the CData ODBC Driver for Sybase to visualize Sybase in Power BI Desktop and then publish them to Power BI Report Server.

• Visualize PostgreSQL in TIBCO Spotfire through OData

  Integrate PostgreSQL into dashboards in TIBCO Spotfire.

• Connect to Outreach.io from a Connection Pool in Jetty

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

• LINQ to Access

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

• Query Typeform through ODBC in Node.js

  Use node-odbc to execute SQL queries against Typeform from Node.js.

• Access GitHub from MySQL in PHP

  Connect to GitHub through the standard MySQL libraries in PHP.

• How to publish and share Avro dashboards with Tableau Server

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

• Build Dashboards with LinkedIn Ads in Dundas BI

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

• Using AngularJS to Build Dynamic Web Pages with HBase

  Use the CData Connect Server to create HBase OData feeds and build single-page applications with live Apache HBase.

• Integrate Oracle HCM Cloud in Your Informatica Cloud Instance

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

• Add Access to Informatica Enterprise Data Catalog

  Use the CData Software JDBC Driver for Access with the Informatica Enterprise Data Catalog to classify and organize data.

• Create Elasticsearch Reports on JasperReports Server

  Deploy the CData JDBC Driver on JasperReports Server to provide real-time Elasticsearch data access from reports, embedded analytics, and more.

• Natively Connect to HarperDB in PHP

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

• DataBind Controls to Facebook Ads in C++Builder

  DataBind to Facebook Ads in C++Builder with standard components and controls.

• Avalara AvaTax Reporting and Star Schemas in OBIEE

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

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

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

• Connect to SAP ByDesign in Jaspersoft Studio

  Execute SQL to remote SAP Business ByDesign in Jaspersoft Studio.

• How to create Avalara AvaTax federated tables in MySQL

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

• Using AngularJS to Build Dynamic Web Pages with Phoenix

  Use the CData Connect Server to create Phoenix OData feeds and build single-page applications with live Apache Phoenix.

• Publish Crystal Reports on GitHub

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

• Build Dashboards with Sage 300 in DBxtra

  Create dynamic dashboards and perform analytics based on Sage 300 in DBxtra.

• Visualize MarkLogic from Tableau

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

• Automated Continuous QuickBooks Online Replication to SingleStore

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

• Integrate HubSpot into Power Automate Desktop using CData Connect

  CData Connect for HubSpot enables you to integrate HubSpot into workflows built using Microsoft Power Automate Desktop.

• Replicate JSON Services to Multiple Databases

  Replicate JSON to disparate databases with a single configuration.

• Build Apps with Live Amazon Marketplace in Adalo using CData Connect Cloud

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

• How to connect to Authorize.Net from Google Apps Script

  Use CData Software Connect Server to access Authorize.Net in Google Apps Script.

• Analyze Salesloft with Power Pivot

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

• Replicate XML from PowerShell

  Write a quick PowerShell script to query XML Files. Use connectivity to the live data to replicate XML Files to SQL Server.

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

  Connect to Google Calendar 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.

• Visualize Adobe Analytics in TIBCO Spotfire through OData

  Integrate Adobe Analytics into dashboards in TIBCO Spotfire.

• Bidirectional Access to Couchbase from FileMaker Pro

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

• «
• 299
• 300
• 301
• 302
• 303
• 304
• 305
• 306
• 307
• 308
• »