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:Driver Login
Note: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.
