Data Connection to YouTube- FineBI Help Document

Last update：June 18, 2024

Overview

Version

FineBI Version	Functional Change
6.0	-

Application Scenario

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

Preparation

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

Connection Procedure

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.

Configuration Item	Value
Auth Scheme	OAuth
Initiate OAuth	GETANDREFRESH
Channel ID	User ID obtained in section "Getting YouTube User ID."

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.