Data Connection to Facebook

Version

Application Scenario

This document introduces how to connect to Facebook with CData driver in FineReport.

Version and Driver

Driver Download

According to your system environment (Windows//Linux/Mac), choose and download the appropriate installation package on 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:

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

Driver Login

Note:

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

1. The document takes the trial version as an example, and a login account is registered. The following figure shows the generated lib directory.

2. 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 Facebook User ID

Connection Test with CData Test Connection Tools

1. In the driver installation directory, directly execute java -jar cdata.jdbc.facebookads.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:facebookads:AccountId=user ID; InitiateOAuth=GETANDREFRESH.

Connection Test with FineReport

1. Open the designer and define a data connection to Others.

2. Modify the driver, copy and paste cdata.jdbc.facebookads.FacebookAdsDriver to Driver.

3. Enter the URL with the copied link information from step 1, for example, jdbc:facebookads:AccountId=user ID;InitiateOAuth=GETANDREFRESH.

4. Click Test Connection. After a successful connection, click OK to proceed with normal data fetching operations.

For details, seeDataset.