1. Linux
    2. Windows
    3. IIS (Unavailable)
    1. Authentication Methods Overview
    2. Okta (SAML)
    3. OneLogin (SAML)
    4. Curator Users
    5. Azure AD (SAML)
    6. OneLogin (OIDC)
    7. Multifactor Authentication
    8. Signing SAML Login Requests
    9. Active Directory
    10. Windows LDAP (IIS) - DEPRECATED
    1. Windows SSL (IIS) - DEPRECATED
    2. Force SSL
    3. Linux SSL
    4. Windows SSL
    5. Basic HTTP Authentication
    1. High Availability
    1. Windows
    2. Linux
    1. Forward Proxy
    2. Reverse Proxy
    1. Getting Started
    2. Setting Up Your Portal
    3. Adding Your First Dashboard
    4. Creating Your First Page
    1. REST API Integration
    2. Tableau Cloud Setup
    3. Embed Authentication
    4. Trusted Tickets
    5. Alternative URL Routing
    6. Tableau Server Repository
    7. Tableau API Debugging
    8. API Connections Overview
    1. (Step 1) Azure App Setup
    2. (Step 2) Service Principal Setup
    3. (Step 3) Power BI Workspace Access
    4. (Step 4) Curator Connection
    5. Troubleshooting Power BI Access
    1. Integrating ThoughtSpot with Curator
    1. Replace Dashboard URLs
    2. Temporarily Disabling Connections
    1. Share Workbook
    2. Adding a Dashboard
    3. Tableau Worksheets and Stories
    4. Generating Titles
    5. Data Export
    6. Custom Views
    7. Email Subscriptions
    8. Download Workbook
    9. Pause and Resume Changes
    10. URL Action Overrides (Link Target)
    11. Dashboard Settings
    1. Adding a Pulse Metric
    1. Preloading Filters and Parameters
    2. Specify Filter Sheet
    3. Filters
    4. Parameters
    5. Hidden Sticky Filters and Parameters
    6. Apply Button
    7. Filter Categories
    8. Caching Filter and Parameter Options
    1. Updating Data Groups
    2. Sending Data to Webhooks
    3. Web Data Connector (WDC)
    4. Exporting Data
    5. Data Manager Basics
    6. Creating a Form
    7. Connecting to Data Manager
    8. User Commenting
    9. Field Calculations
    10. Mark Commenting
    11. Dashboard Feedback
    12. Importing Data
    1. Overview and Enabling
    2. Email Option
    3. Scheduled Reports
    4. Fallback Image
    5. Watermark Text
    6. Powerpoint
    1. Curator Styles
    2. Homepage
    3. Titles and Toolbars
    4. Group Overrides
    5. Page Meta Titles (SEO)
    1. Managing Menus
    2. Menu Items
    3. Restrict Access
    4. Tagged Workbooks
    5. Site Switcher
    1. Pages Overview
    2. Looker Embedding
    3. Tiles
    4. Explorer
    5. Forms
    6. Blogs
    7. User Customized Metrics
    8. Manual Embeds (iFrame)
    9. SSRS Embedding
    10. YouTube Embedding
    1. Files
    1. Hidden Content
    2. Search
    3. Keywords
    4. Favorites
    5. Featuring Content
    6. Thumbnail Preview Images
    1. Loading Screens
    1. Error Pages
    2. Tutorials
    3. Notices
    8. Email Formatting
    1. Users and Groups Overview
    2. User Sync and Membership Sync Overview
    3. Reset User's Password
    4. Frontend Users
    5. Automatic License Provisioning
    6. Just-in-time (JIT) Provisioning
    7. Username Mapping
    8. Custom Attributes
    1. Frontend User Permissions
    2. Password Change
    3. Password Reset
    4. Password Expiration and Complexity
    5. Disabling Link-preview Security
    6. User Throttling
    1. Third Party Cookies
    1. Overview
    2. Password Reset
    1. System Notifications
    2. Data Manager Notifications
    1. Troubleshooting Load Times
    2. Cache Warming
    1. Updating License Key
    1. Web Accessibility
    1. System Upgrade
    2. Disable Curator Upgrades
    3. Offline Upgrades (Airgapped)
    4. Dependency Updates
    5. Troubleshooting Upgrades
    1. Importing and Exporting
    1. Curator Backup
    2. Taking a Manual Full Backup
    3. Manual Restoration of Curator Backup
    1. Updating Curator Logging
    2. Disk Speed Metrics
    3. Server Hardening Procedures
    4. Filesystem Permissions
    5. Linux: Cron Troubleshooting
    1. Curator API Overview
    2. Curator Integration Overview
    1. Integration
    2. Curator API
    3. Tableau API
    4. Content
    5. User API
    6. Authentication
    1. Scripts
    2. Commands
    3. Subscription Routing
        1. Menu Tuning
        2. Cache Warming

      Embedding & Using Analytics: 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 from 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

      Linux

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

      mysql -u root -p

      Windows

      Navigate into MariaDB/MySQL root directory and then login to MySQL:

      cd C:\InterWorks\Curator\libs\MariaDB\bin
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 and password you'd like to use):

      CREATE USER 'USER'@'%' IDENTIFIED BY 'PASSWORD';

      3. 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' and 'PASSWORD' with a username and password you'd like to use):

      GRANT SELECT, SHOW VIEW ON curator.* TO 'USER'@'%' IDENTIFIED BY 'PASSWORD';
FLUSH PRIVILEGES;

      Important! 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. Use the connection details from the "Creating a Readonly MySQL User" and the database, hostname, and table name from the previous step to connect to your MySQL data source.

      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