Facebook DB Connector

Set-Up Instructions

Task 1 – Create a Database Collection in SearchBlox

After logging in to the Admin Console, go to the Collections tab and click on Create New Collection or the “+” icon.

Next, choose Database Collection as the Collection Type.

Enter a unique name, select the access type, choose the language, and click Save to create the collection. This will add a database collection to the SearchBlox server.

Task 2 – Getting a OAuthAccess Token from Facebook

Go to https://developers.facebook.com/ and log in to your account.

Go to https://developers.facebook.com/tools/explorer and click Get Token and the dropdown Get User Access Token.

In the resulting pop up, select all checkboxes and click Get Access Token.

Go to https://developers.facebook.com/tools/accesstoken/ and click the Debug button against User Token.

Click Extend Access Token button.

Task 3 – Database Collection Settings

Select Facebook as the database type from the dropdown menu.

Enter the database URL string in the format as shown here:
jdbc:facebook:InitiateOAuth=GETANDREFRESH;
OR
jdbc:facebook:OAuthClientId=xxxx;OAuthAccessToken=CAACEdkkhdpkejodmdhkflde5evvtBQE2OdReTn5ffkVzTLjkstSkPsWxuA1cBu1hlrTXODyZBtC7VuE5ZAENxG389jkdflsju0lkjdBpjHbGCVkB7siA0lDZBI;

Enter the OAuthAccessToken from the developer page in the string.

Provide SQL Query to fetch the data from Facebook. The Query format is:
SELECT <index field> as uid , <column name2> as title, <column name3> as content FROM <tablename> LIMIT 100

📘

Configure SQL Query

Some of the commonly used tables and common queries in Facebook are:

SELECT * FROM Posts

SELECT * FROM Comments

SELECT Id, Name, Picture FROM Likes

SELECT FROM Users
SELECT FROM Groups WHERE SearchTerms = ‘facebook’
SELECT * FROM Users WHERE SearchTerms = ‘facebook’
SELECT ID as uid,FromName as title FROM Wall WHERE Target = ‘facebook’

For more data tables that can be indexed from Facebook, use the following links:

https://cdn.cdata.com/help/RBG/jdbc/pg_select.htm

https://cdn.cdata.com/help/RBG/jdbc/pg_systemtablesintro.htm

If you have more than 100 entries in a table, specify the number of documents to be indexed by providing the LIMIT value in the query. For example:

SELECT * FROM Wall LIMIT 300

Otherwise, a minimum of 100 rows will be indexed.

Save the settings and click Test Connection. You will be redirected to the Facebook login page.

Then, click Test Database Collection to verify the settings. Note that the database connection must be successful for indexing to work.

Task 4 – Schedule and Index

Go to the Manage Collection page, open the Schedule tab, and set up indexing.

Once the maximum number of documents is reached, click Stop if continuous indexing is not required.

The search results in faceted search are displayed here:

Task 5 – Viewing Search Results in Kibana

Indexed content from Facebook can be viewed using Kibana.

The following example uses the maximum number of fields available in the data table account. The query used is:
SELECT * FROM Groups WHERE SearchTerms = 'facebook'

Steps in Kibana

1.Start Kibana.
How to start Kibana Visualizations
2. Add the collection ID.

**3. After adding the index, you can view the mapped fields.

**4. Create visualizations by following the steps in the reference link provided in the previous Step 1.

A sample visualization generated for Facebook data indexed in SearchBlox is shown here: