CData Software - Knowledge Base

Recent Articles

• «
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• »

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

  Connect to real-time SAP Business ByDesign in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SAP ByDesign.

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

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

• Process & Analyze Kintone in Databricks (AWS)

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

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

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

• Create Salesforce Pardot Dashboards in Bold BI

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

• Connect to HCL Domino in DBeaver

  Use the CData ODBC Driver to connect to HCL Domino in DBeaver.

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

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

• Use the Connect Server to Access LDAP Objects in Microsoft Power Pivot

  Use the Connect Server to connect to live LDAP in the Power Pivot business intelligence tool.

• Query Excel Online in DataGrip

  Create a Data Source for Excel Online in DataGrip and use SQL to query live Microsoft Excel Online.

• Connect to and Visualize Live Salesforce Pardot in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Salesforce Pardot.

• Use the CData Software JDBC Driver for Dynamics GP in MicroStrategy Web

  Connect to Microsoft Dynamics GP in MicroStrategy Web using the CData Software JDBC Driver for Dynamics GP.

• Connect to Amazon DynamoDB from HeidiSQL

  Use CData Connect Cloud to connect to and query live Amazon DynamoDB from HeidiSQL.

• Connect to Dynamics 365 Business Central in RapidMiner

  Integrate Dynamics 365 Business Central with standard components and data source configuration wizards in RapidMiner Studio.

• Build Hive-Connected Visualizations in datapine

  Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Apache Hive.

• How to publish and share SharePoint Excel Services dashboards with Tableau Server

  The CData ODBC driver for SharePoint Excel Services enables you integrate SharePoint Excel Services into Tableau dashboards.

• Establish a Live Connection with Google Sheets using Tableau Bridge

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

• Prepare, Blend, and Analyze SAS xpt in Alteryx Designer

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

• Integrate with live FHIR in Jitterbit

  Use CData Connect Cloud to connect to and integrate live FHIR in Jitterbit.

• Access Live Bullhorn CRM in Coginiti Pro

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

• Create Datasets from Amazon S3 in Domo Workbench and Build Visualizations of Amazon S3 in Domo

  Use the CData Software ODBC Driver for Amazon S3 to create datasets from Amazon S3 in Domo Workbench and then build visualizations in the Domo service.

• Query Presto through ODBC in Node.js

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

• Build HCL Domino-Connected Apps in Mendix

  Use CData Connect Cloud to create an OData feed for HCL Domino and create custom apps in Mendix.

• Analyze Quickbase with Power Pivot

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

• Automated Continuous DocuSign Replication to AlloyDB

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

• Export Data from SQL Server to Paylocity through SSIS

  Easily push SQL Server data to Paylocity using the CData SSIS Tasks for Paylocity.

• Connect to PayPal from HeidiSQL

  Use CData Connect Cloud to connect to and query live PayPal from HeidiSQL.

• Visualize Oracle Service Cloud in TIBCO Spotfire through ODBC

  The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Oracle Service Cloud into TIBCO Spotfire.

• Automated Continuous HubSpot Replication to Apache Kafka

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

• Automated Continuous Phoenix Replication to SingleStore

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

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

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

• Publish Crystal Reports on SAP ByDesign

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

• Automated Continuous Reckon Replication to PostgreSQL

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

• Edit and Search External Sybase IQ Objects in Salesforce Connect

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

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

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

• Integrate with BambooHR in JReport Designer

  Create charts and reports based on BambooHR in JReport Designer.

• Visualize Elasticsearch in Sisense

  Create an ElastiCube in Sisense app with access to Elasticsearch.

• Build Dashboards with Teradata in DBxtra

  Create dynamic dashboards and perform analytics based on Teradata in DBxtra.

• Connect to Azure Data Lake Storage from AWS Glue

  Use CData Connect Cloud to gain access to live Azure Data Lake Storage from your AWS Glue jobs.

• Use CData Connect Cloud to Access Act CRM in Microsoft Power Pivot

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

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

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

• Visualize Live Gmail in the Power BI Service

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

• Connect to HubDB in RapidMiner

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

• Author and Share Power BI Reports on Real-Time Twitter Ads

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

• Analyze Dynamics CRM with Power Pivot

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

• Automate Square Replication to Couchbase

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

• Access Live Exact Online in TIBCO Data Virtualization

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

• Access Live Twitter in Coginiti Pro

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

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

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

• Query Microsoft Exchange as a SQL Server Database in Node.js

  Execute SQL Server queries against Microsoft Exchange from Node.js.

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

  Provide connectivity to Shopify through an SAP BusinessObjects universe.

• Automate Asana Replication to Azure Data Lake

  Use CData Sync to customize and automate Asana replication to Azure Data Lake.

• Manage Azure Synapse in DBArtisan as a JDBC Source

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

• How to connect PolyBase to Presto

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

• Connect to Klipfolio in RunMyProcess through Connect Server

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

• Connect to Confluence from Crystal Reports

  Use CData Connect Cloud to connect to and report on live Atlassian Confluence from Crystal Reports.

• Build a Simple VCL Application for MySQL

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

• DataBind Wijmo Grid to Printify

  Provide real-time Printify to interactive controls.

• Build a Simple VCL Application for ServiceNow

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

• How to Build an ETL App for Klaviyo in Python with CData

  Create ETL applications and real-time data pipelines for Klaviyo in Python with petl.

• How to Connect to QuickBooks Online in Using Python: 6 Steps

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

• A PostgreSQL Interface for Adobe Commerce

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

• Connect to and Query SQL Analysis Services in QlikView over ODBC

  Create data visualizations with SQL Analysis Services in QlikView.

• Connect to Basecamp from a Connection Pool in Jetty

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

• Automated Continuous SAP HANA Replication to MySQL

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

• Visualize Live Redis in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Redis.

• How to create Reckon Accounts Hosted federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for Reckon Accounts Hosted in MySQL .

• Create SSAS Tabular Models from Dropbox

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

• Use the CData Software JDBC Driver for Sage Intacct in MicroStrategy Web

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

• Automated Continuous CSV Replication to Amazon S3

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

• Integrating Sage Intacct in Talend Cloud Data Management Platform

• «
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• »