Data Connection to Facebook

Version

Application Scenario

This document introduces how to connect to Facebook 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 directory. The following figure shows the directory structure after the 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. The following figure shows the generated lib directory.

2. Upload the driver to FineReport.

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

Testing Connection with CData's Test Connection Tool

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

Configuration Item	Value
Initiate OAuth	GETANDREFRESH
Account ID	ID obtained in section "Getting a Facebook User ID".

2. When the connection is successful, copy the connection information in Connection String, for example, jdbc:facebookads:AccountId=user ID; InitiateOAuth=GETANDREFRESH.