How would creating a new role to reinstall the ODB...
# ask-stanley-ai
a
How would creating a new role to reinstall the ODBC driver and connect to the data source from Excel be a work around for that the SuiteAnalytics Connect role cannont be SSO? Give me detail on the workaround
c
AI generated answer (using internal Slack threads):
Creating a new role to reinstall the ODBC driver and connect to the data source from Excel can be a workaround for the issue that the SuiteAnalytics Connect role cannot be SSO (Single Sign-On) because it allows you to separate the permissions needed for SuiteAnalytics Connect from the SSO process. Here's a detailed step-by-step process: 1. Create a new role: This role should only have the SuiteAnalytics Connect permission. This allows the user to connect to the data source from Excel without needing the Admin role, which is a requirement for SSO. 2. Assign the new role to the user: The user should be assigned this new role, and they should download the install bundle using this role. This ensures that the user has the necessary permissions to connect to the data source. 3. Reinstall the ODBC driver: The ODBC driver should be reinstalled under this new role. This allows the user to connect to the data source from Excel using the ODBC driver. 4. Connect to the data source from Excel: With the new role and the reinstalled ODBC driver, the user should now be able to connect to the data source from Excel. Remember, the user might need additional permissions depending on the tables they need to access. If a table disappears from the possible table selections, it's likely because the new role doesn't have the necessary permissions to access that table. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.860513568
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.824824512
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.815135717
Please provide your feedback on this answer.