{"revision":"c10276e953456835cdbb1f3a60d58ae1980be353","document":{"id":1242,"path":"api-reference/web-services/configure-sql-api-overview.md","title":"Live Connect configuration on your ServiceNow instance","bundle":null,"doc_type":null,"release":"australia","body":"\n# Live Connect configuration on your ServiceNow instance\n\nComplete the three-step configuration that's required to enable Live Connect access.\n\nConfiguring Live Connect on your ServiceNow instance enables you to integrate your ServiceNow data with third-party BI tools and analytics platforms. You can connect to platforms such as Pyramid Analytics, Tableau, Power BI, DB Visualizer, or custom ODBC/JDBC clients to enhance your reporting and data analysis capabilities.\n\n## Before you begin\n\nConfirm the following prerequisites are in place before starting:\n\n-   The Live Connect plugin is installed on your instance.\n-   You have consulted your network team to identify the IP address range for your ODBC/JDBC client machines.\n-   You have identified which ServiceNow tables must be accessible via the Live Connect.\n\nRole required: admin\n\n## Configuration steps\n\nComplete the following procedures to configure Live Connect access on your instance:\n\n1.  [Assign roles and create service accounts](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/api-reference/web-services/create-service-account.md)\n2.  [Create Access Control Lists \\(ACLs\\) for Live Connect](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/api-reference/web-services/create-acls-sql-api.md)\n3.  [Create IP filter criteria](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/api-reference/web-services/create-ip-filter-criteria.md)\n\n## After configuration\n\nAfter completing all the procedures, your user account \\(personal or service account\\) can connect to your ServiceNow instance via ODBC or JDBC. You can then query tables for which access has been granted.\n\nAdditional considerations:\n\n-   You can assign roles to personal user accounts or create dedicated service accounts with different roles and access control settings to support different integrations or teams.\n\n    **Note:** Service accounts are recommended for production reports and dashboards because they promote continuity. Personal accounts will break if the user loses access or leaves the organization.\n\n-   Access is not granted globally. A user account can query a table only if it has explicit read access. Access is granted through table-level ACLs \\(`egress_sql` and `read`\\) or through a role with read permissions.\n-   Live Connect supports both individual user accounts \\(via OAuth\\) and service accounts.\n-   Non-interactive \\(machine\\) service accounts can't complete MFA challenges. If you're using non-interactive service accounts, turn off MFA for those accounts. Personal accounts using OAuth aren't subject to this limitation.\n\n-   **[Assign roles and create service accounts](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/api-reference/web-services/create-service-account.md)**  \nAssign the **sn\\_odbc\\_rest\\_access** or **sn\\_jdbc\\_rest\\_access** role to users who need Live Connect access. You can assign these roles to personal user accounts or create dedicated non-interactive \\(Machine\\) service accounts.\n-   **[Create Access Control Lists \\(ACLs\\) for Live Connect](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/api-reference/web-services/create-acls-sql-api.md)**  \nGrant user accounts query access to specific ServiceNow tables through Live Connect using table-level ACLs.\n-   **[Create IP filter criteria](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/api-reference/web-services/create-ip-filter-criteria.md)**  \nDefine which IP addresses or IP ranges are permitted to connect to your ServiceNow instance via the Live Connect ODBC/JDBC driver.\n\n**Parent Topic:**[Configuring Live Connect](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/api-reference/web-services/configuring-sql-api.md)\n\n"}}