Can you connect an administrator role to and ODCB drive connection? Are there any limitations?

AI generated answer (using internal Slack threads):

Based on the conversations, it appears that you can connect an administrator role to an ODBC drive connection. However, there are some limitations to consider: 1. SuiteAnalytics Connect and SAML SSO Limitation: According to SuiteAnswers, account administrators cannot add SAML Single Sign-on permission to a role that has SuiteAnalytics Connect permission. SAML access is not supported for SuiteAnalytics Connect. This means if you are using SAML SSO, you may not be able to use SuiteAnalytics Connect, which is required for ODBC connections. 2. Role Permissions: The role used for the ODBC connection needs to have the necessary permissions. In one of the conversations, a user mentioned that they were unable to see the

transactionline

table until they added additional permissions to their role. 3. Data Source: The ODBC settings should point to the correct data source (NetSuite2 was mentioned in the conversations). Remember, you may need to create a separate role with the necessary permissions if you want to avoid using the administrator role for ODBC connections. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******