CData Software - Knowledge Base

Recent Articles

• «
• 110
• 111
• 112
• 113
• 114
• 115
• 116
• 117
• 118
• 119
• »

• Create Reports with Hive in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Apache Hive.

• Connect to Salesloft from PowerBuilder

  This article demonstrates how to access Salesloft from Appeon PowerBuilder using the CData ADO.NET Provider for Salesloft.

• Author and Share Power BI Reports on Real-Time Cvent

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

• DataBind Controls to Google Ads in C++Builder

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

• Query Exact Online in MySQL Workbench

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

• Replicate SAP Ariba Source to Multiple Databases

  Replicate SAP Ariba Source to disparate databases with a point-and-click configuration.

• Integrate Quickbase into Power Automate Desktop using CData Connect

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

• Operational Reporting on EventBrite from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Eventbrite.

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

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

• Connect to MYOB AccountRight as an External Data Source using PolyBase

  Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live MYOB AccountRight.

• Create Informatica Mappings From/To a JDBC Data Source for JDBC-ODBC Bridge

  Create JDBC-ODBC Bridge data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• Build Dashboards with Sugar CRM in DBxtra

  Create dynamic dashboards and perform analytics based on Sugar CRM in DBxtra.

• Viewing Azure Table in RAD Studio Data Explorer

  How to view Azure Table Storage in RAD Studio Data Explorer using the CData ODBC Driver for Azure Table.

• Publish Klipfolio-Connected Dashboards in Tableau Server

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

• Use the CData ODBC Driver for Google Calendar in Microsoft Power Query

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

• Process & Analyze Hive in Databricks (AWS)

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

• Publish Reports with Dropbox in SAP Crystal Reports

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

• Visualize Azure Data Lake Storage in TIBCO Spotfire through OData

  Integrate Azure Data Lake Storage into dashboards in TIBCO Spotfire.

• Replicate Multiple Quickbase Accounts

  Replicate multiple Quickbase accounts to one or many databases.

• Visualize Live Email in Tableau

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

• Automated Continuous SAP HANA XS Advanced Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to Microsoft Access.

• Excel Spreadsheet Automation with the QUERY Formula

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

• Author and Share Power BI Reports on Real-Time Email

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

• Access Live Hive in Google Sheets

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

• Connect to WooCommerce in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• How to connect to Microsoft Planner from Spring Boot

  Connect to Microsoft Planner in a Spring Boot Application using CData JDBC Microsoft Planner Driver

• Connect to Cvent in JRuby

  Create a simple JRuby app with access to live Cvent.

• Automated Continuous Cosmos DB Replication to Google BigQuery

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

• DataBind Controls to Google Spanner in Delphi

  DataBind to Google Spanner in Delphi with standard data access components and controls.

• Automated Continuous Microsoft Teams Replication to PostgreSQL

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

• Connect to Sage Cloud Accounting from a Connection Pool in Jetty

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

• Integrate with Twitter using Apache Camel2

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

• How to use SQLAlchemy ORM to access Paylocity in Python

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

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

• ETL Power BI XMLA in Oracle Data Integrator

  This article shows how to transfer Power BI XMLA into a data warehouse using Oracle Data Integrator.

• Connect to CSV in SpagoBI

  Create reports featuring live CSV/TSV Files in SpagoBI Studio. Host CSV reports on SpagoBI Server.

• Create Informatica Mappings From/To a JDBC Data Source for SAS xpt

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

• Replicate Zoho Inventory from PowerShell

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

• Import Oracle Service Cloud into the Power BI Service for Visualizations

  Use CData Connect Cloud to connect to Oracle Service Cloud and provide access to live Oracle Service Cloud for custom reports in the Power BI Service.

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

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

• Automated Continuous Trello Replication to Google BigQuery

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

• Automated Continuous LinkedIn Ads Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable LinkedIn Ads replication to IBM DB2.

• Work with SAP Hybris C4C in FoxPro

  Load SAP Hybris C4C into a FoxPro database. This article includes full code and a walk-through of the process.

• Access Google Drive from MySQL in HeidiSQL

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

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

  Create ETL applications and real-time data pipelines for NetSuite CRM & ERP in Python with petl.

• Query SAP ByDesign in ColdFusion

  Write standard ColdFusion data access code to connect to SAP Business ByDesign.

• Access Couchbase from MySQL in Amazon QuickSight

  Connect to Couchbase and build visualizations of Couchbase using a MySQL Connection in Amazon QuickSight.

• Connect to DocuSign in RunMyProcess through Connect Cloud

  Use CData Connect Cloud to create on OData API for DocuSign and connect to DocuSign in Akorbi Digital RunMyProcess.

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

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

• Build Dashboards with Raisers Edge NXT in Dundas BI

  Create dynamic dashboards and perform analytics based on Raisers Edge NXT in Dundas BI.

• Process & Analyze Salesforce in Databricks (AWS)

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

• Process & Analyze SQL Server in Databricks (AWS)

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

• Create Informatica Mappings From/To an ODBC Data Source for Outreach.io

  Create an ODBC connection to Outreach.io in Informatica and browse and transfer Outreach.io.

• Create Data Visualizations in Cognos BI with Microsoft Exchange

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

• Build SendGrid Visualizations in Tableau Cloud

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

• DataBind Wijmo Grid to FHIR

  Provide real-time FHIR to interactive controls.

• How to connect to Shopify with Squirrel SQL client

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

• Automated Continuous SendGrid Replication to MySQL

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

• Connect to Kintone from a Connection Pool in Jetty

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

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

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

• Building Dynamic React Apps with Database Data

  Use Connect Server and React to Build Dynamic Web Apps with Live Database Data.

• Automate ADP Replication to SAP HANA

  Use CData Sync to customize and automate ADP replication to SAP HANA.

• Connect to Real-Time Sybase IQ Data in Power Apps Using Dataflows to Build Custom Applications

• «
• 110
• 111
• 112
• 113
• 114
• 115
• 116
• 117
• 118
• 119
• »