CData Software - Knowledge Base

Recent Articles

• «
• 108
• 109
• 110
• 111
• 112
• 113
• 114
• 115
• 116
• 117
• »

• Connect to Excel Online in Jaspersoft Studio

  Execute SQL to remote Microsoft Excel Online in Jaspersoft Studio.

• Use the CData Software ODBC Driver for Oracle HCM Cloud in MicroStrategy Web

  Connect to Oracle HCM Cloud in MicroStrategy Web using the CData Software ODBC Driver for Oracle HCM Cloud.

• Access Live Azure Synapse in Excel (Desktop)

  Use CData Connect Cloud to gain access to live Azure Synapse from your Excel spreadsheets.

• Visualize Bullhorn CRM in TIBCO Spotfire through ADO.NET

  Integrate Bullhorn CRM into dashboards in TIBCO Spotfire.

• How to integrate Metabase with Splunk

  Use CData Connect Cloud to connect to live Splunk and create an interactive dashboard in Metabase from Splunk.

• Write a Simple Go Application to work with IBM Cloud Data Engine on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to IBM Cloud Data Engine.

• Connect to MailChimp in SpagoBI

  Create reports featuring live MailChimp in SpagoBI Studio. Host MailChimp reports on SpagoBI Server.

• Automate Airtable Replication to Couchbase

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

• How to Work with Pinterest in ETL Validator JDBC

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

• How to create an RPA flow for Redshift in UiPath Studio

  Use the Redshift ODBC Driver to create workflows that access real-time Amazon Redshift without any coding.

• Connect to SAP ByDesign in RapidMiner

  Integrate SAP Business ByDesign with standard components and data source configuration wizards in RapidMiner Studio.

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

• Validate Google Ad Manager with QuerySurge

  Access and validate Google Ad Manager in QuerySurge using the CData JDBC Driver.

• How to create Bitbucket federated tables in MySQL

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

• Build FHIR-Connected Apps in Bubble

  Use CData Connect Cloud to create an OData feed for FHIR and create custom apps in Bubble.

• Build SAP Concur-Connected Apps in Bubble

  Use CData Connect Cloud to create an OData feed for SAP Concur and create custom apps in Bubble.

• Klaviyo Reporting in OBIEE with the Klaviyo JDBC Driver

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

• Automated Continuous Zoom Replication to SQL Server

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

• Integrate SharePoint into Automated Tasks with Power Automate

  Use CData Connect Cloud to connect to Microsoft SharePoint and integrate live Microsoft SharePoint into your Power Automate tasks.

• Export Data from SQL Server to Cassandra through SSIS

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

• How to Work with JotForm in ETL Validator JDBC

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

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

  Connect to GitHub 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 Live Twilio in the Power BI Service

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

• Use the CData Software ODBC Driver for Microsoft Exchange in MicroStrategy

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

• Export Data from SQL Server to SAP HANA through SSIS

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

• Integrate Real-Time Access to Zoho Creator in SAPUI5 MVC Apps

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

• Create GraphQL-Connected Visualizations in Klipfolio

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

• Create Databricks Dashboards in Bold BI

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

• How to use SQLAlchemy ORM to access DB2 in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of IBM DB2.

• Create SAP ByDesign-Connected Visualizations in Klipfolio

  Use CData Connect Cloud to connect to SAP ByDesign from Klipfolio and build custom visualizations using live SAP Business ByDesign.

• Automated Continuous Sybase Replication to SQLite

  Use CData Sync for automated, continuous, customizable Sybase replication to SQLite.

• Connect to Live Zoho CRM in MicroStrategy through CData Connect Cloud

  Create a live connection to Zoho CRM in CData Connect Cloud and connect to your Zoho CRM from MicroStrategy.

• How to create Visio diagrams from Sage Cloud Accounting

  Automatically update Sage Business Cloud Accounting with the changes you make to Visio master shapes.

• Working with Dynamics GP in LINQPad

  Execute LINQ queries to Microsoft Dynamics GP in LINQPad.

• Oracle Sales Reporting in OBIEE with the Oracle Sales JDBC Driver

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

• Connect to Sage 200 in as an External Source in Dremio

  Use the CData JDBC Driver to connect to Sage 200 as an External Source in Dremio.

• Automated Continuous Salesforce Pardot Replication to Apache Kafka

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

• Access Couchbase from MySQL in HeidiSQL

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

• Publish Crystal Reports on SFTP

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

• How to load Dropbox data into Elasticsearch via Logstash

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

• Build SAP BusinessObjects BI-Connected ETL Processes in Google Data Fusion

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

• How to update Oracle from Excel

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

• DataBind Controls to SAP in C++Builder

  DataBind to SAP ERP/NetWeaver in C++Builder with standard components and controls.

• How to connect PolyBase to Zoom

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

• Outreach.io Reporting in OBIEE with the Outreach.io JDBC Driver

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

• Query Harvest in MySQL Workbench

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

• Bridge Twitter Ads Connectivity with Apache NiFi

  Access and process Twitter Ads in Apache NiFi using the CData JDBC Driver.

• Build xBase-Connected Web Apps in Servoy

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

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

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

• Access JotForm from MySQL in HeidiSQL

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

• Author and Share Power BI Reports on Real-Time Dynamics 365

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

• Visualize HCL Domino in Sisense

  Create an ElastiCube in Sisense app with access to HCL Domino.

• Access Live Slack in Coginiti Pro

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

• Import and Visualize Google Calendar in Power View

  Create data visualizations based on Google Calendar in Excel.

• Perform Batch Operations with SharePoint Excel Services in Apache NiFi

  Connect to SharePoint Excel Services and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

• Use the CData Software ODBC Driver for Google Cloud Storage in MicroStrategy

  Connect to Google Cloud Storage in MicroStrategy Developer using the CData Software ODBC Driver for Google Cloud Storage.

• Using AngularJS to Build Dynamic Web Pages with Oracle Service Cloud

  Use the CData Connect Server to create Oracle Service Cloud OData feeds and build single-page applications with live Oracle Service Cloud.

• Prepare, Blend, and Analyze Calendly in Alteryx Designer

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

• Add Zenefits to Informatica Enterprise Data Catalog

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

• Access Live Google Campaign Manager 360 in TIBCO Data Virtualization

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

• Google Calendar Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to Google Calendar through CData Connect Cloud using different applications and tools.

• How to Use a Microsoft Access Database to Update QuickBooks in Real Time

  Update QuickBooks data by creating a linked table in Microsoft Access with the CData QuickBooks ODBC Driver.

• How to connect and process Dynamics 365 Business Central from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Dynamics 365 Business Central

• Automated Continuous MariaDB Replication to Local Delimited Files

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

• Analyze CSV in SAP Analytics Cloud

  Use the CData Connect Server to create an OData API on top of CSV/TSV Files and visualize CSV/TSV Files in SAP Analytics Cloud.

• Access Live Google Directory in TIBCO Data Virtualization

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

• Connect to Stripe from a Connection Pool in WebLogic

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

• Connect to Salesforce Marketing from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Salesforce Marketing to connect to Salesforce Marketing Cloud from Web applications running on WebLogic.

• Connect to Excel Online from HeidiSQL

  Use CData Connect Cloud to connect to and query live Microsoft Excel Online from HeidiSQL.

• DataBind Charts to SharePoint

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Microsoft SharePoint 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.

• Build Charts with Email in Clear Analytics

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

• How to connect to Reckon in DBVisualizer

  Integrate Reckon with visual data analysis tools and data connection wizards in DBVisualizer

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for Pinterest

  Provide connectivity to Pinterest through an SAP BusinessObjects universe.

• Create Informatica Mappings From/To an ODBC Data Source for SAP Concur

  Create an ODBC connection to SAP Concur in Informatica and browse and transfer SAP Concur.

• Integrate with Azure Synapse using Apache Camel2

  Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Azure Synapse to a JSON file on disk.

• Replicate Google Analytics for Use in Salesforce Connect

  Replicate Google Analytics to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• A PostgreSQL Interface for GraphQL

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

• Build Oracle Service Cloud-Connected Apps in Mendix

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

• Visualize Live OneNote in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Microsoft OneNote.

• Publish Crystal Reports on Printify

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

• Extract, Transform, and Load Splunk in Informatica PowerCenter

  Create a simple Workflow for Splunk in Informatica PowerCenter.

• Build FHIR-Connected Apps in Mendix

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

• Connect to MySQL in Jaspersoft Studio

  Execute SQL to remote MySQL in Jaspersoft Studio.

• Connect to SAS Data Sets in NetBeans

  Connect to SAS Data Sets in NetBeans with the data source configuration wizard.

• Use the CData Software ODBC Driver for Okta in MicroStrategy

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

• Automated Continuous LinkedIn Replication to Microsoft Access

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

• Use the CData Software JDBC Driver for Access in MicroStrategy

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

• Import Highrise into Microsoft Power Query

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

• Visualize Azure Table from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Azure Table Storage.

• Stream Twilio into Apache Kafka Topics

  Access and stream Twilio in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Access Basecamp as a Remote Oracle Database

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

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

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

• How to Access Live Printify in Power Automate Desktop via ODBC

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

• Connect to Zoho Projects from AWS Glue

  Use CData Connect Cloud to gain access to live Zoho Projects from your AWS Glue jobs.

• How to Connect to Snapchat Ads in Using Python: 6 Steps

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

• How to load Impala data into Elasticsearch via Logstash

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

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

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

• Use the CData ODBC Driver for CSV in SAS JMP

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

• How to Create Power BI Visual Reports with Real-Time Zoho Creator

  Use CData Power BI Connectors to visualize Zoho Creator in Power BI.

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

• «
• 108
• 109
• 110
• 111
• 112
• 113
• 114
• 115
• 116
• 117
• »