Tableau Connector for Facebook Ads

Build 22.0.8462

Tableau Desktop

The CData Tableau Connector for Facebook Ads includes comprehensive high-performance data access, real-time integration, extensive metadata discovery, and robust SQL-92 support.

Prerequisites

Before you start you must have installed a supported Tableau application. This includes Tableau Desktop 2020.1 or later and Tableau Prep 2020.4.1 or later.

For older versions of Tableau Desktop, please use either the CData ODBC Driver or the JDBC Driver for Facebook Ads instead.

Install the Connector

Once the prerequisites are satisfied you can complete the following steps to install the connector:

  1. Download and run the CData setup.
  2. If you have Tableau Desktop 2020.3 or later, the setup will automatically install the connector into your personal repository.
  3. Once the installation is complete, click Finish.

License the Connector

On Windows, the connector setup prompts for a product key and registers a license as part of the install process.

On Mac, the licensing tool must be run after the setup is completed. Open up a terminal and run the following commands to license the connector. To activate a trial, omit the <key> input:

cd "/Applications/CData Tableau Connector for Facebook Ads 2022/bin"
sudo ./install-license <key>

The second command may prompt for a password. If it does, provide the password you use to login to your Mac user account.

Files Installed by the Connector

The automatic install process will try to register both the driver and the connector with your Tableau install. By default it will copy the driver JAR file into either of these locations:

  • Windows: C:\Program Files\Tableau\Drivers
  • Mac: /Users/myuser/Library/Tableau/Drivers

It will also attempt to copy the connector TACO file into one of these locations. The exact path will depend upon your platform language settings:

  • Windows: C:\Users\myuser\My Tableau Repository\Connectors
  • Mac: /Users/myuser/Documents/My Tableau Repository/Connectors

Manual Registration

If you are using Tableau Prep or an earlier version of Tableau Desktop, the setup will not be able to detect your Tableau install and you will need to register the connector manually. Once the setup is done you can perform these steps to register the connector:

  1. Find the connector install directory. This will usually be in either C:\Program Files\CData\CData Tableau Connector for Facebook Ads 2022 or /Applications/CData Tableau Connector for Facebook Ads 2022 depending upon your platform.
  2. Find your Tableau repository. Your repository will usually be located in your documents folder with the name My Tableau Repository. If you are using Prep it will be called My Tableau Prep Repository.
  3. Go to the install directory and open the lib directory. Copy cdata.facebookads.legacy.taco into the Connectors directory within your Tableau repository.

    Note: As of Tableau Prep 21.2+, standard taco files are supported instead of legacy taco files.

Next Step

See Configuring a Connection for the next step, which includes establishing a connection via the connection builder.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462