Overview
Version
| FineReport Version | Functional Change |
|---|---|
11.0 | / |
Application Scenario
This document introduces how to connect to YouTube with CData driver in FineReport.
Preparation
Version and Driver
Driver Download
According to different system environments Windows//Linux/Mac, choose the appropriate installation package to download on the CData official website.
Driver Installation
Install the driver to the local device, and the directory structure after installation is shown in the following figure.
Note:Driver Login
Note:The CData driver has a one-month trial period, and 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 FineReport.
Versions Before 11.0.5
Copy and paste files in the lib directory to the lib folder D:\FineReport_11.0\webapps\webroot\WEB-INF\lib in the FineReport project, as shown in the following figure.
Versions After 11.0.5
Refer to section "Creating a Data Connection" in Driver Management to upload the driver, and manually place the .lic file in D:\FineReport_11.0\webapps\webroot\WEB-INF\lib.
Getting a YouTube User ID
Connection Procedure
Connection Test with CData Test Connection Tools
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 a 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.
Connection Test with FineReport
1. Open the designer and create a data link Others.
2. Modify the driver by copying and pasting cdata.jdbc.youtubeanalytic.YouTubeAnalyticsDriver to the driver field.
3. Enter the URL with the copied link information from step 1, for example, jdbc:youtubeanalytics:AuthScheme=OAuth;ChannelId=user ID;InitiateOAuth=GETANDREFRESH.
4. Click Test Connection, and after the successful connection, click OK to proceed with the normal data fetching operation.
Adding Tables in the Database to FineReport
For details, see Dataset.
