Data Gateway

The installation, configuration and troubleshootings are discussed in this page.

Overview

T he AI-DBA Data Gateway service plays a crucial role in the AI-DBA ecosystem by facilitating the transfer of telemetry data from on-premises SQL Server instances to the Azure cloud repository. This data is essential for feeding the backend AI/ML (Artificial Intelligence/Machine Learning) engines, enabling them to analyze and generate insights for optimized database administration. Overview of the AI-DBA Data Gateway Service:

  1. Purpose:
    The primary purpose of the AI-DBA Data Gateway service is to establish a secure and reliable communication channel between the on-premises SQL Server instances and the Azure cloud repository. It ensures that telemetry data, including performance metrics, query execution details, and other relevant information, is seamlessly transmitted to the cloud for AI-powered analysis.
  2. Data Transfer:
    The Data Gateway service acts as an intermediary, collecting telemetry data from the SQL Server instances and securely transmitting it to the Azure cloud repository. This data transfer is essential to provide the necessary inputs to the AI/ML engines, enabling them to perform advanced analytics and generate actionable insights.
  3. Security:
    The Data Gateway service ensures the confidentiality and integrity of the transferred data. It employs encryption mechanisms to protect the telemetry data during transmission, safeguarding it against unauthorized access or tampering.
  4. Regional Data Endpoints:
    To function effectively, the Data Gateway service requires access to the regional data endpoints in Azure. These regional data endpoints are specific to the Azure cloud region where the Azure cloud repository is located. Access to these endpoints allows the Data Gateway service to establish a connection and transfer the telemetry data securely.
  5. Scalability and Reliability:
    The Data Gateway service is designed to handle large volumes of telemetry data from multiple SQL Server instances. It is built to scale horizontally, accommodating increased data loads as the number of enrolled instances grows. Additionally, the service is designed to be highly reliable, ensuring continuous data transfer even in the event of temporary network disruptions or service interruptions.
  6. Monitoring and Logging:
    The Data Gateway service includes monitoring and logging capabilities to track the status of data transfers, identify any issues or errors, and provide visibility into the overall health and performance of the service.

Access to regional data endpoints is essential for the Data Gateway service to establish connections and enable seamless data transfer.

Prerequisites

The prerequisites for installing and configuring the AI-DBA Data Gateway service are as follows:

  1. Administrator Privileges:
    To install the AI-DBA Data Gateway service, the user must have administrator privileges on the machine where the service will be installed. Administrator privileges are required to perform system-level operations, such as installing services and making changes to system configurations.
  2. Access to Regional Data Endpoints:
    The AI-DBA Data Gateway service requires access to the regional data endpoints in Azure. These regional data endpoints are specific to the Azure cloud region where the Azure cloud repository is located. Access to these endpoints allows the Data Gateway service to establish a connection and securely transfer telemetry data to the Azure cloud repository. Ensure that the machine where the service will be installed has network connectivity to the Azure regional data endpoints.
  3. Compatible Operating System:
    The AI-DBA Data Gateway service has specific operating system requirements. Ensure that the machine where the service will be installed meets the compatibility criteria.
    Compatible operating systems are listed below.
    - Windows 10 Pro
    - Windows 11 Pro
    - Windows Server 2016 Standard
    - Windows Server 2019 Standard
    - Windows Server 2022 Standard
  4. Sufficient System Resources:
    Ensure that the machine where the AI-DBA Data Gateway service will be installed has sufficient system resources, including CPU, memory, and disk space. The system resources should meet the minimum requirements specified by the AI-DBA team to ensure optimal performance of the Data Gateway service. The rule of thumb for system resources is 1 logical core, 1GB of memory and 2GB of disk space per two enrolled SQL Server instances. This is only required durin the health check process. 
  5. Network Connectivity:
    The machine where the AI-DBA Data Gateway service will be installed should have a stable and reliable network connection. This is necessary for the service to establish communication with the on-premises SQL Server instances and securely transfer telemetry data to the Azure cloud repository.
  6. Firewall and Security Considerations :
    If there are any firewalls or security measures in place, ensure that appropriate network configurations and firewall rules are set up to allow the AI-DBA Data Gateway service to communicate with the on-premises SQL Server instances and access the regional data endpoints in Azure. Consult with your network and security teams to ensure the necessary configurations are in place.

By meeting these prerequisites, you can ensure a smooth installation and configuration process for the AI-DBA Data Gateway service, enabling it to access regional data endpoints and securely transfer telemetry data to the Azure cloud repository.

     
The AI-DBA Data Gateway service must be able to communicate through HTTP/HTTPS protocol to the respective region's Data Endpoint service.

Region Data Endpoint URL
North America (Canada)
North America (United States)  https://dataendpoint-us.ai-dba.net
South America (Brazil)  https://dataendpoint-br.ai-dba.net
Africa (South Africa)  https://dataendpoint-sa.ai-dba.net
Asia Pacific (Singapore)  https://dataendpoint-sg.ai-dba.net
 https://dataendpoint-ca.ai-dba.net

Installation and Configuration

This outlines the steps to install and configure the AI-DBA Data Gateway. The AI-DBA Data Gateway is a component that allows secure communication between the AI-DBA portal and on-premises SQL Server instances.

Prerequisites:
Before proceeding, ensure you have the following:

  • Access to a Windows machine where the AI-DBA Data Gateway will be installed.
  • Administrative privileges on the machine.
  • Downloaded AI-DBA Data Gateway installer from the provided link in the  portal.ai-dba.net .

Installation and Configuration:
Follow the steps below to install and configure the AI-DBA Data Gateway:
Step 1: Download the AI-DBA Data Gateway installer from the provided link.
Step 2: Run the installer executable file to start the installation process.
Step 3: Follow the on-screen instructions to proceed with the installation. Choose the desired installation location and any additional options if prompted.
Step 4: After the installation completes, open the Command Prompt (CMD) with Administrator privileges.
Step 5: Navigate to the installation directory of the AI-DBA Data Gateway using the Command Prompt.
Step 6: Run the "Install Service.bat" file by typing its name in the Command Prompt and pressing Enter. This will install the AI-DBA Data Gateway service. Step 7: Once the service installation is complete, locate and run the "AI-DBA Data Gateway Configuration" application, which should be available in the installation directory.
Step 8: In the configuration application, enter the required account information. This includes the credentials needed to authenticate the AI-DBA Data Gateway with the AI-DBA portal.
Step 9: Select the appropriate region for the AI-DBA Data Gateway. Choose the region that aligns with your account regiona.
Step 10: After entering the account information and selecting the region, save the configuration by clicking on "Setup" button. Step 11: Start the "Ai-DBA Data Gateway Service" by either using the configuration application or through the Windows Services Manager. Step 12:  Right-click on the selected service and choose "Properties" from the context menu. The Service Properties window will appear.
Step 13: In the Service Properties window, navigate to the "Recovery" tab.
Step 14: In the "First failure", "Second failure", "Subsequent failure" sections, select "Restart the Service" from the drop-down menu.

This option ensures that the service will automatically restart after the unexpected failure.

Step 15: After configuring the desired recovery options, click on the "Apply" or "OK" button to save the changes.

See Also

 Solution Internals
AI-DBA Central Portal