CData Software - Knowledge Base

Recent Articles

• «
• 106
• 107
• 108
• 109
• 110
• 111
• 112
• 113
• 114
• 115
• »

• Publish Crystal Reports on CockroachDB

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

• Access Live Microsoft OneDrive in AWS Lambda (with IntelliJ IDEA)

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

• Import Twilio Using Azure Data Factory

  Use CData Connect Cloud to connect to Twilio from Azure Data Factory and import live Twilio.

• Build SAP HANA-Connected Web Apps with Axios and CData Connect Cloud

  Use CData Connect Cloud to connect to live SAP HANA and build SAP HANA-connected web apps with Axios.

• Connect to eBay Analytics in RapidMiner

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

• Connect to Live Oracle Financials Cloud in MicroStrategy through CData Connect Cloud

  Create a live connection to Oracle Financials Cloud in CData Connect Cloud and connect to your Oracle Financials Cloud from MicroStrategy.

• Create Amazon Athena-Connected Business Apps in AppSheet

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

• Integrate DB2 with External Services using SnapLogic

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

• Build Automated Zoho Projects-Connected Workflows in Zapier

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

• Analyze Oracle in R

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

• Creating ADP-Connected Applications in Unqork

  You can use CData Connect Cloud to feed ADP to Unqork and build custom business apps.

• Connect to BigCommerce from a Connection Pool in JBoss

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

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

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

• Create Dynamic Sugar CRM Grids Using the Infragistics XamDataGrid

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

• Process & Analyze Google Sheets in Databricks (AWS)

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

• Viewing Presto in RAD Studio Data Explorer

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

• Create EnterpriseDB Reports on JasperReports Server

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

• DataBind Controls to Cvent in C++Builder

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

• Connect to BigCommerce in CloverDX (formerly CloverETL)

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

• Build an OLAP Cube in SSAS from SQL Analysis Services

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

• Visualize SurveyMonkey in TIBCO Spotfire through OData

  Integrate SurveyMonkey into dashboards in TIBCO Spotfire.

• Automated Continuous Avalara AvaTax Replication to Azure SQL

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

• Create Informatica Mappings From/To a JDBC Data Source for Dynamics GP

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

• Load CockroachDB to a Database Using Embulk

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

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

  Connect to Aha! 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.

• Connect to Google Analytics in NetBeans

  Connect to Google Analytics in NetBeans with the data source configuration wizard.

• Automate Spark Replication to SAP HANA

  Use CData Sync to customize and automate Apache Spark SQL replication to SAP HANA.

• Connect to Cassandra through External Services in Salesforce

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

• Import IBM Cloud Object Storage into Microsoft Power Query

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

• Build MVC Applications with Connectivity to Google Contacts

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

• Publish PayPal-Connected Dashboards in Tableau Server

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

• Replicate Multiple PostgreSQL Accounts

  Replicate multiple PostgreSQL accounts to one or many databases.

• Use the CData ODBC Driver for Dropbox in SAS JMP

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

• Import SAP Fieldglass into FileMaker Pro

  Create reports that integrate SAP Fieldglass in Filemaker Pro.

• How to create Drift federated tables in MySQL

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

• Provide OData Services of Shopify from a WCF Application

  In this article, we will demonstrate the process of generating an OData feed for Shopify by developing a WCF Service Application.

• Prepare, Blend, and Analyze Parquet in Alteryx Designer

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

• Add QuickBooks Time to Informatica Enterprise Data Catalog

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

• Create Procore Dataflows on PowerBI.com

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

• Use the CData Software JDBC Driver for Active Directory in MicroStrategy Web

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

• Create Data Visualizations in Cognos BI with EventBrite

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

• Automated Continuous JSON Replication to Local Delimited Files

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

• Build NetSuite-Connected Apps in Choreo

  Use CData Connect Cloud to connect to NetSuite from Choreo and build custom apps using live NetSuite CRM & ERP.

• Visualize Live SendGrid in the Power BI Service

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

• How to Visualize HDFS Data in Python with pandas

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

• Automated Continuous DocuSign Replication to Google Cloud SQL

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

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

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

• Access Live Airtable in Google Sheets

  Use CData Connect Cloud to gain access to live Airtable from your Google Sheets.

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

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

• Use the CData Software JDBC Driver for Dynamics 365 in MicroStrategy

  Connect to Microsoft Dynamics 365 in MicroStrategy Developer using the CData Software JDBC Driver for Dynamics 365.

• Connect to Redis from HeidiSQL

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

• How to connect and process HubSpot from Azure Databricks

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

• How to Access Live Azure Analysis Services in Power Automate Desktop via ODBC

  The CData ODBC Driver for Azure Analysis Services enables you to integrate Azure Analysis Services into workflows built using Microsoft Power Automate Desktop.

• Connect to LDAP Objects in JRuby

  Create a simple JRuby app with access to live LDAP.

• Build MVC Applications with Connectivity to SharePoint Excel Services

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

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

  Use CData Software Connect Server to create a virtual SQL Server Database for Calendly and integrate live Calendly into apps built in Microsoft Power Apps.

• Build Snapchat Ads-Connected Web Apps with Axios and CData Connect Cloud

  Use CData Connect Cloud to connect to live Snapchat Ads and build Snapchat Ads-connected web apps with Axios.

• How to connect to Couchbase from Spring Boot

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

• How to Visualize Kintone Data in Python with pandas

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

• How to Connect the Power BI Service to Zendesk: Complete Guide

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

• Connect to Excel Online from a Connection Pool in Jetty

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

• Explore Geographical Relationships in LDAP Objects with Power Map

  Create data visualizations with LDAP in Power Map.

• DataBind Controls to Adobe Analytics in C++Builder

  DataBind to Adobe Analytics in C++Builder with standard components and controls.

• Visualize TaxJar in Sisense

  Create an ElastiCube in Sisense app with access to TaxJar.

• Use the CData ODBC Driver for Dynamics NAV in SAS JMP

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

• Integrate Sage 300 into Automated Tasks with Power Automate

  Use CData Software Connect Server to create a virtual SQL Server database for Sage 300 and integrate live Sage 300 into your Power Automate (Microsoft Flow) tasks.

• Automated Continuous HubSpot Replication to Snowflake

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

• Automate Google Contacts Integration Tasks from PowerShell

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

• Use the CData SSIS Components to Insert New or Update Existing CouchDB Records from SQL Server

  Easily push SQL Server data to CouchDB using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into CouchDB or update existing records with data from a SQL Server database.

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

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

• Connect to Sybase in RapidMiner

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

• How to Create Power BI Visual Reports with Real-Time Google Contacts

  Use CData Power BI Connectors to visualize Google Contacts in Power BI.

• Access Reckon Accounts Hosted in PHP through Connect Server

  Connect to Reckon Accounts Hosted through the standard SQL Server libraries in PHP.

• How to Connect the Power BI Service to Salesforce Marketing: Complete Guide

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

• Create Tableau CRM Analytics-Connected Visualizations in Klipfolio

  Use CData Connect Cloud to connect to Tableau CRM Analytics from Klipfolio and build custom visualizations using live Tableau CRM Analytics.

• Create a Data Access Object for Klaviyo using JDBI

  A brief overview of creating a SQL Object API for Klaviyo in JDBI.

• Automated Continuous Clio Replication to SQL Server

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

• Connect to MarkLogic in NetBeans

  Connect to MarkLogic in NetBeans with the data source configuration wizard.

• How to Visualize Zoho Projects Data in Python with pandas

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

• Visualize Klipfolio in Sisense

  Create an ElastiCube in Sisense app with access to Klipfolio.

• How to connect to Box from MS Excel on Mac OS X

  Create a Data Source Name in iODBC with the CData ODBC Driver for Box and work with Box in Microsoft Excel on Mac OS X.

• PowerShell Scripting to Replicate Bitbucket to MySQL

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

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

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

• How to Connect to & Open Salesloft in Microsoft Excel

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

• Epicor Kinetic Reporting and Star Schemas in OBIEE

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

• How to update Gmail from Excel

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

• Integrate Access in the Pentaho Report Designer

  Publish reports based on Microsoft Access in the Pentaho BI tool.

• Access QuickBooks Online in PHP through Connect Server

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

• Import Azure Data Catalog into the Power BI Service for Visualizations

  Use CData Software Connect Server to create an OData feed for Azure Data Catalog and create custom reports in the Power BI Service.

• Integrating Adobe Analytics in Talend Cloud Data Management Platform

• «
• 106
• 107
• 108
• 109
• 110
• 111
• 112
• 113
• 114
• 115
• »