Microsoft Azure SQL
- Miguel Lauriano
- Aparna Rr
About The Device
Azure SQL Database is a relational database and fully managed platform as a service (PaaS). Azure SQL Database can create a highly available and high-performance data storage layer for the applications and solutions in Azure.
Device Information
 Entity | Particulars |
|---|---|
Vendor Name | Microsoft |
Product Name | Azure SQLÂ |
Type of Device | Cloud |
Collection Method
Log Type | Â Ingestion label | Preferred Logging Protocol - Format | Log Collection Method | Data Source |
|---|---|---|---|---|
 Azure SQL |  AZURE_SQL | JSON | CyberHub | https://cloud.google.com/chronicle/docs/reference/feed-management-api#azure_blobstore  |
Device Configuration
 Prerequisites:
Azure subscription that you can sign in to.
Azure Event Hub.
Reference URLs:
How to configure Event Hub: https://docs.microsoft.com/en-us/azure/event-hubs/event-hubs-create
Configurations Steps:
Log in to Azure Portal i.e https://portal.azure.com/
Navigate to Auditing under the Security heading in your SQL database or SQL server pane.
Â
If you prefer to set up a server auditing policy, you can select the View server settings link on the database auditing page. You can then view or modify the server auditing settings. Server auditing policies apply to all existing and newly created databases on this server.
If you prefer to enable auditing on the database level, switch Auditing to ON. If server auditing is enabled, the database-configured audit exists side-by-side with the server audit.
You have multiple options for configuring where audit logs are stored. You can write logs to an Azure storage account or to Event Hub.
To configure writing audit logs to an Event Hub, select Event Hub. Select the Event Hub where logs will be written and then click Save. Be sure that the event hub is in the same region as your database and server.
Â
Get Azure Event Hub Credentials: Get Credentials of Azure Storage and Azure EventHub
Integration Parameters
Parameters required from customer for Integration.
Property | Default value | Description |
|---|---|---|
Logging Source | N/A | Select EventHub |
eventHubConnectionString | N/A | Event hub connection string |
consumerGroupName | N/A | Optional and used if consumer Group is other than default |
Account Key | N/A | Access Key to access storage account |
Blob Container | N/A | Storage blob Container name |
Storage Account Name | N/A | Azure storage account name |
Subscription | N/A | Set Eventhub name |
About Accenture:
Accenture is a leading global professional services company that helps the world’s leading businesses, governments and other organizations build their digital core, optimize their operations, accelerate revenue growth and enhance citizen services—creating tangible value at speed and scale. We are a talent and innovation led company with 738,000 people serving clients in more than 120 countries. Technology is at the core of change today, and we are one of the world’s leaders in helping drive that change, with strong ecosystem relationships. We combine our strength in technology with unmatched industry experience, functional expertise and global delivery capability. We are uniquely able to deliver tangible outcomes because of our broad range of services, solutions and assets across Strategy & Consulting, Technology, Operations, Industry X and Accenture Song. These capabilities, together with our culture of shared success and commitment to creating 360° value, enable us to help our clients succeed and build trusted, lasting relationships. We measure our success by the 360° value we create for our clients, each other, our shareholders, partners and communities. Visit us at www.accenture.com.
About Accenture Security
Accenture Security is a leading provider of end-to-end cybersecurity services, including advanced cyber defense, applied cybersecurity solutions and managed security operations. We bring security innovation, coupled with global scale and a worldwide delivery capability through our network of Advanced Technology and Intelligent Operations centers. Helped by our team of highly skilled professionals, we enable clients to innovate safely, build cyber resilience and grow with confidence. Follow us @AccentureSecure on Twitter or visit us at www.accenture.com/security.
Legal notice: Accenture, the Accenture logo, and other trademarks, service marks, and designs are registered or unregistered trademarks of Accenture and its subsidiaries in the United States and in foreign countries. All trademarks are properties of their respective owners. This document is intended for general informational purposes only and does not take into account the reader’s specific circumstances, and may not reflect the most current developments. Accenture disclaims, to the fullest extent permitted by applicable law, any and all liability for the accuracy and completeness of the information in this presentation and for any acts or omissions made based on such information. Accenture does not provide legal, regulatory, audit, or tax advice. Readers are responsible for obtaining such advice from their own legal counsel or other licensed professionals.