1. Titles and Toolbars

    2. Homepage

    3. Curator Styles

    4. Group Overrides

    1. Pages Overview

    2. Tiles

    3. Error Pages

    4. SSRS Embedding

    5. Explorer

    6. User Customized Metrics

    1. Tutorials

    2. Search

    3. Managing Menus

    4. Menu Items

    5. Keywords

    6. Files

    7. Notices

    8. Loading Screens

    1. Embedded Tableau Server Views

    2. Thumbnails

    3. Tagged Workbooks

    4. Favorites

    5. Email Subscriptions

    6. Data Export

    7. Download Workbook

    8. Share Workbook

    9. Custom Views

    10. Pause/Resume Changes

    11. Dashboard Titles

    1. Filters

    2. Parameters

    3. Apply Button

    4. Filter Categories

    5. Hidden Sticky Filters/Parameters

    6. Specify Filter Sheet

    7. Mark Commenting

    8. URL Action Overrides (Link Target)

    9. Hidden Dashboards

    10. Replace Dashboard URLs

    11. Site Switcher

    12. Cache Filter/Parameter Options

    1. Data Manager Basics

    2. Web Data Connector (WDC)

    3. Connecting to Data Manager

    4. User Commenting

    5. Field Calculations

    1. Overview and Enabling

    2. Report Builder: Scheduled Reports Option

    3. Report Builder: Email Option

    4. Report Builder: Watermark Text

    1. Automatic License Provisioning

    2. Just-in-time (JIT) Provisioning

    3. Users and Groups

    4. Reset User's Password

    1. Frontend User Permissions

    2. Password Change

    3. Password Reset

    4. Password Expiration and Complexity

    1. E-mail Configuration

    1. Force SSL

    2. Trusted Tickets

    3. Basic HTTP Authentication

    1. Import / Export

    2. Backend Users

    3. Frontend Users

    4. Updating License Key

    5. Linux: Cron Troubleshooting

    6. Filesystem Permissions

    7. Backend Administrator Password Reset

    8. Dependency Updates

    9. Manual Restoration of Curator Backup

    10. Updating Curator Logging

    11. Third Party Cookies

    12. Troubleshooting Load Times

    13. Curator Backup

    14. Taking a Manual Full Backup

    1. System Upgrade

    2. Disable Curator Upgrades

    3. Offline Upgrades (Airgapped)

    4. Troubleshooting Upgrades

    1. Scripts

    2. Commands

    3. Subscription Routing

    1. Curator API Overview

    2. Integration

    3. Curator API

    4. Tableau API

    5. Content

    6. User API

    1. Username Mapping

Documentation: Data Manager

Connecting to Data Manager

When using Data Manager you will likely need to connect to the underlying database that stores the data input by your users. You can find the connection information on the "Data Group" edit page, but first you'll need to create a readonly user (if one does not exist in the info.txt/info.json file found in the root directory of the Curator install).

Note: This will allow your readonly user to connect from anywhere. If you'd like to specify the IP address they can connect from replace the '%' with your IP address in the examples below to limit where they can query from.

Creating a Readonly MySQL User

  1. Log into MySQL as the root user:

    Linux Run the command below on your server to login to mysql:

    mysql -u root -p

    Windows Navigate into MySQL root directory (e.g. C:\Program Files\MySQL\MySQL Server 5.5\bin)

    C:\Program Files\MySQL\MySQL Server 5.5\bin

    and then login to MySQL:

    mysql -u root -p
  2. Create a new MySQL user:

Run the command below to create a new user that can run a connection from anywhere (replacing 'USER' and 'PASSWORD' with a username a password you'd like to use):

CREATE USER 'USER'@'%' IDENTIFIED BY ‘PASSWORD‘;
  1. Grant read-only permission to the MySQL user

Run the command below to create a new user that can read data from anywhere (again replacing 'USER' 'PASSWORD' with a username a password you'd like to use and ):

GRANT SELECT, SHOW VIEW ON curator.* TO 'USER'@'%′ IDENTIFIED BY ‘PASSWORD‘;
FLUSH PRIVILEGES;
  1. Be sure you keep these credentials secure, but also available for reference as they will be required to connect to your data.

Connecting to the Datamanager Database

  1. Find the connection information for the table you would like to view in the top section of the edit "Data Group" page

    Database Name: curator Host Name: 127.0.0.1 Table Name: a_reports_data_group

  2. Using the connection details from the "Creating a Readonly MySQL User" in the steps and use the database, hostname and table name from the previous step to connect to your MySQL datasource.

Troubleshooting Connections

  1. Ensure your firewall rules allow inbound traffic over port 3306 to allow remote connections to your database. If you are having trouble connecting please contact your hosting team for further help.
  2. By default, remote connections are not allowed on some operating systems (e.g. Ubuntu 20). You can run the commands below to set up remote connections:

    Determine the location of your MySQL config file by running the command below:

    mysql --help | grep "Default options" -A 1

    Open the file that is returned from these commands (i.e. /etc/my.cnf): Add the following line to the bottom of the file, where xxx.ip.xxx is replaced with your IP address, or you can use 0.0.0.0 to allow remote connections from anywhere:

     bind-address= xxx.ip.xxx

    Now save your file and restart mysql to allow remote connections:

    sudo systemctl restart mysql