Sisense / Periscope
Follow these steps to connect your Sisense/Periscope instance to Select Star.
Before you start
To connect Periscope to Select Star, you will need...
- Active Periscope Account email and password credentials or Google Account credentials, for Google SSO-enabled accounts
- To calculate lineage and popularity based on the last 90 days of users' activity, you'll need to connect Select Star to the Data Warehouse that your Periscope instance is using to run queries.
- To calculate popularity and top users, Select Star requires a mapping of periscope users to their email addresses, you'll need to prepare a CSV file with a
user name: emailmapping.
Complete all of the following steps to see Periscope metadata, lineage, and popularity in Select Star.
- 1.
1. Create an Account Authentication Token
Optional, only for Google SSO-enabled accounts
Prepare your Google Account credentials and contact Select Star support to help you with the setup process.
After completing the procedure, you should receive a file named
periscope-credentials.json. Please save it, as you will need this file in step 2.2. Connect Periscope to Select Star
Go to the Select Star
Settings. Click Data in the sidebar, then + Add to create a new Data Source.
Choose
Sisense/Periscope in the Source Type dropdown and provide the following information:For email / password authentication please leave the default
Email and Password Credentials checked. If your account uses Google SSO to authenticate, check Cookies json.Email and Password
- Display Name: This value is
Sisense / Periscopeby default, but you can override it if desired. - Email: Your Periscope Account email
- Password: Your Periscope Account password
- DB Connection: The database you are running Periscope on top of.
- DB Username: The name of the service account user that runs Periscope queries in your DB Connection. It is not a Select Star service account. This is used to identify which queries Periscope runs so that Select Star can generate lineage between the database and Periscope.
Google SSO Authentication
- Display Name: This value is
Sisense / Periscopeby default, but you can override it if desired. - DB Connection: The database you are running Periscope on top of.
- DB Username: The name of the service account user that runs Periscope queries in your DB Connection. It is not a Select Star service account. This is used to identify which queries Periscope runs so that Select Star can generate lineage between the database and Periscope.
Click the
Connect button.Your metadata should start loading automatically. Please allow 24-48 hours to completely generate popularity and lineage.
When the sync is complete, you'll be able to explore Periscope in Select Star.
3. Import User Catalog
Although this step is optional, you won't see popularity / top users unless the catalog is imported.
To complete the import, please prepare a CSV file with at least the following columns:
- First Name
- Last Name
- Email
Alternatively:
- Full Name
- Email
and then contact Select Star support, [email protected] to do the import for you.
Last modified 4mo ago