{"revision":"c10276e953456835cdbb1f3a60d58ae1980be353","document":{"id":9095,"path":"delta-zurich-australia/australia-zurich-sqlapi-release-notes.md","title":"Combined SQL API release notes for upgrades from Zurich to Australia","bundle":null,"doc_type":null,"release":"australia","body":"\n# Combined SQL API release notes for upgrades from Zurich to Australia\n\nConsolidated page of all release notes for SQL API from Zurich to Australia.\n\n## How to use this page\n\nTo help you prepare for your upgrade, we have combined the cross-family SQL API release notes onto one page. Read this summary of the new features, changes, and updated information for your product from Zurich to Australia.\n\n**Tip:** If there were no updates for a release notes section in a certain family release, we included a short note for your reference. For example, if a product did not have any updates in Tokyo, the row says \"No updates for this release.\"\n\n## Important information for upgrading SQL API to Australia\n\nBefore you upgrade to Australia, review these pre- and post-upgrade tasks and complete the tasks as needed.\n\n<table class=\"custom-rows\"><thead><tr><th class=\"filter\">\n\nRelease\n\n</th><th>\n\nRelease notes\n\n</th></tr></thead><tbody><tr><td>\n\nZurich\n\n</td><td>\n\n-   **Upgrade information**\n\nServiceNow provided customers with a free SOAP‑based ODBC client. If you have an active RaptorDB Pro entitlement, you can migrate to the REST‑based SQL API client by completing the required configuration on both the server and client sides. For more information, see [Configure](https://www.servicenow.com/docs/access?context=configuring-sql-api&family=zurich&ft:locale=en-US).\n\n\n</td></tr><tr><td>\n\nAustralia\n\n</td><td>\n\nNo updates for this release.\n\n</td></tr></tbody>\n</table>## New features\n\nBetween your current release family and Australia, new features were introduced for SQL API.\n\n<table class=\"custom-rows\"><thead><tr><th class=\"filter\">\n\nRelease\n\n</th><th>\n\nRelease notes\n\n</th></tr></thead><tbody><tr><td>\n\nZurich\n\n</td><td>\n\n-   **[Access your ServiceNow data using Live Connect](https://www.servicenow.com/docs/access?context=accessing-your-servicenow-data-using-sql-api&family=zurich&ft:locale=en-US)**\n\nThe ServiceNow Live Connect enables you to access your ServiceNow instance data through ODBC and JDBC drivers. Using SQL API, you can directly access your instance data from third-party BI tools and other data analysis applications without exporting or replicating your data. The ServiceNow Live Connect plugin uses ServiceNow web services support for a query-only interface.\n\n\n</td></tr><tr><td>\n\nAustralia\n\n</td><td>\n\nNo updates for this release.\n\n</td></tr></tbody>\n</table>## Changes\n\nBetween your current release family and Australia, some changes were made to existing SQL API features.\n\n<table class=\"custom-rows\"><thead><tr><th class=\"filter\">\n\nRelease\n\n</th><th>\n\nRelease notes\n\n</th></tr></thead><tbody><tr><td>\n\nZurich\n\n</td><td>\n\nNo updates for this release.\n\n</td></tr><tr><td>\n\nAustralia\n\n</td><td>\n\nNo updates for this release.\n\n</td></tr></tbody>\n</table>## Removed\n\nBetween your current release family and Australia, some SQL API features or functionality were removed.\n\n<table class=\"custom-rows\"><thead><tr><th class=\"filter\">\n\nRelease\n\n</th><th>\n\nRelease notes\n\n</th></tr></thead><tbody><tr><td>\n\nZurich\n\n</td><td>\n\nNo updates for this release.\n\n</td></tr><tr><td>\n\nAustralia\n\n</td><td>\n\nNo updates for this release.\n\n</td></tr></tbody>\n</table>## Deprecations\n\nBetween your current release family and Australia, some SQL API features or functionality were deprecated.\n\n<table class=\"custom-rows\"><thead><tr><th class=\"filter\">\n\nRelease\n\n</th><th>\n\nRelease notes\n\n</th></tr></thead><tbody><tr><td>\n\nZurich\n\n</td><td>\n\nNo updates for this release.\n\n</td></tr><tr><td>\n\nAustralia\n\n</td><td>\n\nNo updates for this release.\n\n</td></tr></tbody>\n</table>## Activation information\n\nReview information on how to activate SQL API.\n\n<table class=\"custom-rows\"><thead><tr><th class=\"filter\">\n\nRelease\n\n</th><th>\n\nRelease notes\n\n</th></tr></thead><tbody><tr><td>\n\nZurich\n\n</td><td>\n\n-   **Activation information**\n\nLive Connect is a ServiceNow feature that is available with the activation of Live Connect plugin \\(com.glide.rest.sqlapiserver\\). The ServiceNow instance requires RaptorDB Pro entitlement to activate the SQL API server-side plugin. The SQL API drivers are freely available for download by anyone with a valid account to the ServiceNow Store. However, the SQL API client would not be able to connect to the ServiceNow instance until the server-side plugin is enabled. For more information, see [Install Live Connect on your ServiceNow instance](https://www.servicenow.com/docs/access?context=install-sql-api-plugin&family=zurich&ft:locale=en-US).\n\n\n**Important:** Live Connect is available in the ServiceNow Store. For details, see the \"Activation information\" section of these release notes.\n\n</td></tr><tr><td>\n\nAustralia\n\n</td><td>\n\nNo updates for this release.\n\n</td></tr></tbody>\n</table>## Additional requirements\n\nIf any additional requirements were introduced or changed for SQL API we have noted them here.\n\n<table class=\"custom-rows\"><thead><tr><th class=\"filter\">\n\nRelease\n\n</th><th>\n\nRelease notes\n\n</th></tr></thead><tbody><tr><td>\n\nZurich\n\n</td><td>\n\n-   **Additional requirements**\n\nYou must download the SQL API ODBC and JDBC drivers on your client machine. These drivers enable your BI tools and data analysis platforms to connect to your ServiceNow data and run the Live Connect queries. You can download the ODBC and JDBC drivers from ServiceNow store.\n\n\n</td></tr><tr><td>\n\nAustralia\n\n</td><td>\n\nNo updates for this release.\n\n</td></tr></tbody>\n</table>## Browser requirements\n\nIf any specific browser requirements were introduced or changed for SQL API we have noted them here.\n\n<table class=\"custom-rows\"><thead><tr><th class=\"filter\">\n\nRelease\n\n</th><th>\n\nRelease notes\n\n</th></tr></thead><tbody><tr><td>\n\nZurich\n\n</td><td>\n\nNo updates for this release.\n\n</td></tr><tr><td>\n\nAustralia\n\n</td><td>\n\nNo updates for this release.\n\n</td></tr></tbody>\n</table>## Accessibility information\n\nReview details on accessibility information for SQL API, such as specific requirements or compliance levels.\n\n<table class=\"custom-rows\"><thead><tr><th class=\"filter\">\n\nRelease\n\n</th><th>\n\nRelease notes\n\n</th></tr></thead><tbody><tr><td>\n\nZurich\n\n</td><td>\n\nNo updates for this release.\n\n</td></tr><tr><td>\n\nAustralia\n\n</td><td>\n\nNo updates for this release.\n\n</td></tr></tbody>\n</table>## Localization information\n\nIf there are specific localization considerations for SQL API we have noted them here.\n\n<table class=\"custom-rows\"><thead><tr><th class=\"filter\">\n\nRelease\n\n</th><th>\n\nRelease notes\n\n</th></tr></thead><tbody><tr><td>\n\nZurich\n\n</td><td>\n\nNo updates for this release.\n\n</td></tr><tr><td>\n\nAustralia\n\n</td><td>\n\nNo updates for this release.\n\n</td></tr></tbody>\n</table>## Highlight information\n\nIf there are specific highlight considerations for SQL API we have noted them here.\n\n<table class=\"custom-rows\"><thead><tr><th class=\"filter\">\n\nRelease\n\n</th><th>\n\nRelease notes\n\n</th></tr></thead><tbody><tr><td>\n\nZurich\n\n</td><td>\n\n-   Query your ServiceNow data directly without replicating it to external repositories or data warehouses.\n-   Access data using read-only operations to prevent unintended changes to your ServiceNow records. Allow access only to the desired tables.\n-   Integrate standard BI platforms such as Power BI, DBvisualizer, and other ODBC/JDBC-compatible tools directly with your ServiceNow data.\n-   Merge your ServiceNow data with third-party datasets in your data lakes and analytical platforms for comprehensive analysis.\n-   Write targeted SQL queries to retrieve only the data you need, reducing network overhead on data pipeline and data transformation, and improving performance.\n\n For more information, see [Access your ServiceNow data using Live Connect](https://www.servicenow.com/docs/access?context=accessing-your-servicenow-data-using-sql-api&family=zurich&ft:locale=en-US).\n\n</td></tr><tr><td>\n\nAustralia\n\n</td><td>\n\nNo updates for this release.\n\n</td></tr></tbody>\n</table>**Parent Topic:**[Products combined by family](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/delta-zurich-australia/rn-combined-intro.md)\n\n"}}