CData Software - Knowledge Base

Recent Articles

• «
• 284
• 285
• 286
• 287
• 288
• 289
• 290
• 291
• 292
• 293
• »

• Import and Visualize Exact Online in Power View

  Create data visualizations based on Exact Online in Excel.

• Visualize HubSpot in TIBCO Spotfire through ODBC

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

• How to create NetSuite federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for NetSuite CRM & ERP in MySQL .

• How to connect to Salesloft from Spring Boot

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

• Connect to Google Calendar from a Connection Pool in Jetty

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

• Build Pipelines with Live Power BI XMLA in Google Cloud Data Fusion (via CData Connect Cloud)

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

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

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

• Work with SharePoint in FoxPro

  Load Microsoft SharePoint into a FoxPro database. This article includes full code and a walk-through of the process.

• Build Visualizations of Live Salesloft in Power BI (through CData Connect)

  Use CData Connect to create a virtual database for Salesloft and build custom reports in Power BI.

• Build Data Flows from Klaviyo to SQL Server using SSIS

  Easily back up Klaviyo to SQL Server using the SSIS components for Klaviyo.

• Visualize Live Trello of Power BI Report Builder in Power BI Service

  Use CData Power BI Connectors to connect to live Trello using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

• Automated Continuous Marketo Replication to Local Delimited Files

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

• A PostgreSQL Interface for Bullhorn CRM using the CData ODBC Driver

  Use the SQL Gateway and Bullhorn CRM ODBC Driver to create a PostgreSQL entry-point for data access.

• Connect to and Query Oracle SCM in QlikView over ODBC

  Create data visualizations with Oracle SCM in QlikView.

• Natively Connect to RSS Feeds in PHP via ODBC (Linux)

  Create PHP applications on Linux/UNIX machines with connectivity to RSS Feeds. Leverage the native support for ODBC in PHP.

• Using the CData Software ODBC Driver for Twitter Ads in PyCharm

  Connect to Twitter Ads as an ODBC data source in PyCharm using the CData Software ODBC Driver for Twitter Ads.

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

  Provide connectivity to Splunk through an SAP BusinessObjects universe.

• Use the CData Software ODBC Driver for Google Contacts in MicroStrategy Desktop

  Connect to Google Contacts in MicroStrategy Desktop using the CData Software ODBC Driver for Google Contacts.

• Replicate BambooHR for Use in Salesforce Connect

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

• Bridge BigCommerce Connectivity with Apache NiFi

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

• Edit and Search External HarperDB Objects in Salesforce Connect

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

• Analyze AlloyDB in Looker

  Use CData Connect Cloud to connect to AlloyDB from Looker and build custom apps using live Google AlloyDB.

• Connect to Google Drive in Airbyte ELT Pipelines

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

• How to connect to Veeva Vault from Spring Boot

  Connect to Veeva Vault in a Spring Boot Application using CData JDBC Veeva Vault Driver

• Build SAS Data Sets-Connected Dashboards in Redash

  Use CData Software Connect Server to create a virtual SQL Server Database for SAS Data Sets and build visualizations and dashbaords from SAS Data Sets in Redash.

• Automate Trello Replication to Azure Synapse

  Use CData Sync to customize and automate Trello replication to Azure Synapse.

• Connect to Asana in Airbyte ELT Pipelines

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

• Connect to Office 365 in HULFT Integrate

  Connect to Office 365 as a JDBC data source in HULFT Integrate

• Publish Excel Online-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Microsoft Excel Online.

• Write a Simple Go Application to work with Epicor Kinetic on Linux

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

• Import Dynamics 365 Using Azure Data Factory

  Use CData Connect Cloud to connect to Dynamics 365 from Azure Data Factory and import live Microsoft Dynamics 365.

• Create PCA Sales-Connected Dashboards in Grafana

  Connect to PCA Sales via CData Connect Cloud in Grafana and create custom business dashboards with real-time access to PCA Sales.

• Natively Connect to Microsoft Project in PHP

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

• Connect to ServiceNow in JRuby

  Create a simple JRuby app with access to live ServiceNow.

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

  Create an ODBC connection to Couchbase in Informatica and browse and transfer Couchbase.

• Connect to ADP from PowerBuilder via ADO.NET

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

• A Performance Comparison of Drivers for Salesforce.com

  An article comparing the read performance of CData Software Drivers for Salesforce with comparable drivers by other vendors.

• Connect to Active Directory 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 Active Directory.

• Build Backlog-Connected Dashboards Using Zoho Analytics

  Use CData Connect Cloud to connect to Backlog from Zoho Analytics and import live Backlog.

• Import Wave Financial into the Power BI Service for Visualizations

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

• Build Cassandra-Connected Dashboards Using Zoho Analytics

  Use CData Connect Cloud to connect to Cassandra from Zoho Analytics and import live Apache Cassandra.

• Replicate Redshift to Multiple Databases

  Replicate Amazon Redshift to disparate databases with a point-and-click configuration.

• Automated Continuous Monday.com Replication to Vertica

  Use CData Sync for automated, continuous, customizable Monday.com replication to Vertica.

• Connect to Google Directory in Aqua Data Studio

  Access Google Directory from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Query Twitter through ODBC in Node.js

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

• How to connect to Zoom from IntelliJ

  Integrate connectivity to Zoom with wizards in IntelliJ.

• Build an OLAP Cube in SSAS from LinkedIn

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

• DataBind Controls to Google Data Catalog in Delphi

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

• How to Connect DBeaver to Zoho Inventory via a JDBC Driver

  Manage Zoho Inventory with visual tools in DBeaver like the query browser.

• Access Oracle HCM Cloud from MySQL in PHP

  Connect to Oracle HCM Cloud through the standard MySQL libraries in PHP.

• Integrate Access in the Pentaho Report Designer

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

• Query Google Sheets through ODBC in Node.js

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

• Build Visualizations of Wave Financial in Birst

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

• Publish Amazon DynamoDB-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Amazon DynamoDB.

• Create Jira Service Management Dashboards in Bold BI

  Use CData Software Connect Server to create a virtual SQL Server Database for Atlassian Jira Service Management to build custom dashboards in Bold BI.

• Bidirectional Access to LDAP Objects from FileMaker Pro

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

• Model Oracle Financials Cloud Using Azure Analysis Services

  Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Oracle Financials Cloud, enabling the direct import of real-time Oracle Financials Cloud.

• Use the CData Software ODBC Driver for QuickBooks Time in MicroStrategy Web

  Connect to QuickBooks Time in MicroStrategy Web using the CData Software ODBC Driver for QuickBooks Time.

• How to Use CData Connect to Access Live REST in Power Automate

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

• Connect to Oracle Eloqua from PowerBuilder via JDBC

  This article demonstrates how to access Oracle Eloqua from PowerBuilder using the Oracle Eloqua JDBC Driver.

• Connect to Oracle Financials Cloud from PowerBuilder via ADO.NET

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

• Visualize Live Impala in Power BI (via CData Connect Cloud)

  Use the CData Power BI Connector and CData Connect Cloud to integrate live Apache Impala into custom reports in Power BI.

• Access Live SAP HANA in AWS Lambda

  Connect to live SAP HANA in AWS Lambda using the CData JDBC Driver.

• How to Visualize Excel Data in Python with pandas

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

• Build Data Flows from SAS xpt to SQL Server using SSIS

  Easily back up SAS XPORT to SQL Server using the SSIS components for SAS xpt.

• Connect to Act CRM in RapidMiner

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

• Publish Reports with Azure Data Catalog in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Azure Data Catalog.

• Enable the Workday JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Workday.

• Create Informatica Mappings From/To an ODBC Data Source for Oracle Service Cloud

  Create an ODBC connection to Oracle Service Cloud in Informatica and browse and transfer Oracle Service Cloud.

• Visualize Presto in Sisense

  Create an ElastiCube in Sisense app with access to Presto.

• HubDB Reporting and Star Schemas in OBIEE

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

• Provide OData Services of Microsoft Exchange from a WCF Application

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

• Integrating Microsoft Planner in Talend Cloud Data Management Platform

• «
• 284
• 285
• 286
• 287
• 288
• 289
• 290
• 291
• 292
• 293
• »