Machine Overview

• Machine Name : Rateshop Lighthouse
• Title : Lighthouse Rate shop
• Short Description :
  This Rateshop Lighthouse connects to a database, retrieves property information, fetches Lighthouse reports from Outlook, processes rate shop data, and updates the database with the new rate information for further analysis.
• Detail Description : This Rateshop Lighthouse machine automates the entire process of managing rate shop data for properties. It first establishes a secure connection to a database to fetch essential property details. Afterward, the machine retrieves reports from the Lighthouse Report system via Outlook, ensuring the latest rate shop data is available. These reports contain vital rate information, which the machine processes according to predefined business rules. Once the rate data is processed, the machine updates the database, ensuring that the property’s rate shop data is always accurate and up-to-date.
• Machine Document : -

Classification

• Industry : Hospitality
• Category : Rateshop
• Sub Category : -

Compatibility and Dependencies

• Dependent Machines : -
• Compatible Machines : -
• Version : 1.0.2

Specifications

• Input Specification : Download

  Retrieves client credentials, authentication details, email configuration, and database access settings required for API communication, Outlook integration, and report processing. Also includes configuration for handling future data windows.

  Authentication and Email Configuration:
  • Ms Client Id (String): The Microsoft application client ID used for authenticating with Microsoft services such as Graph API.
  • Ms Tenant Id (String): The Microsoft Azure tenant ID associated with the client's organization.
  • Client Secret (String): The secret key used in combination with the client ID for secure API authentication.
  • SMTP Email (String): The sender email address used for sending emails via Outlook or SMTP services.
  Database Credentials:
  • Client Id (Number): The internal identifier representing the client within the system.
  • Property Code (String): A unique code representing the property or entity associated with the database configuration.
  • DB Host (String): The hostname or IP address of the database server.
  • DB Port (Number): The port number used to connect to the database instance.
  • DB Name (String): The name of the database to which the system connects.
  • DB Username (String): The username used for database authentication.
  • DB Password (String): The password associated with the database username for authentication.
  Future Configuration:
  • Future Days (Number): The number of upcoming days for which data or configurations should be considered or processed.
• Output Specification : Download

  Passes secure database credentials and connection parameters to be utilized by the next machine in the workflow for accessing the specified database.

  Database Credential Structure:

  • Client Id (Number): A numeric identifier representing the client within the system.
  • Property Code (String): A unique code corresponding to the client’s property or project context.
  • DB Username (String): The username used to authenticate access to the database.
  • DB Password (String): The password associated with the database username for authentication.
  • DB Host (String): The hostname or IP address of the database server.
  • DB Port (Number): The port number on which the database server is accepting connections.
  • DB Name (String): The name of the target database to which the connection should be made.

Infrastructure Requirement

• OS Requirement : Linux
• CPU : 1
• Cloud : AWS
• RAM : 2Gi

Usage Stats

• Total OnBoarded : -
• Active OnBoarding : -