Data Connection to YouTube

Version

Application Scenario

This document introduces how to connect to YouTube with the CData driver in FineBI.

Version and Driver

Driver Download

According to your system environment (Windows//Linux/Mac), choose and download the appropriate installation package on the CData official website.

Driver Installation

Install the driver to the local. The following figure shows the directory structure after installation.

Note:

The readme.htm file contains instructions for using the driver and can be used for reference.

Driver Login

Note:

The CData driver provides a one-month free trial. Continued use afterward requires payment.

1. The document takes the trial version as an example, and a login account is registered.

2. The following figure shows the generated lib directory.

3. Upload the driver to FineBI.

Upload the driver by referring to section "Creating a Data Connection" in Driver Management, and manually place the .lic file to D:\FineBI_6.0\webapps\webroot\WEB-INF\lib.

Getting a YouTube User ID

Testing Connection with CData's Test Connection Tool

1. In the driver installation directory, directly execute java -jar cdata.jdbc.youtubeanalytics.jar to open the test connection window provided by CData and enter the relevant information.

2. After successfully testing the connection, copy and paste the link information in Connection String, for example, jdbc:youtubeanalytics:AuthScheme=OAuth;ChannelId=user ID;InitiateOAuth=GETANDREFRESH.