Machine Overview

• Machine Name : MS SQL
• Title : MS SQL
• Short Description :
  The MS SQL Connection Machine serves as a critical component within the Quantum Datalytica platform, responsible for establishing, verifying, and managing connections to MS SQL databases. It simplifies backend integration by handling connection logistics, ensuring smooth data access for downstream processes.
• Detail Description :

  The MS SQL Connection Machine plays a foundational role in the Quantum Datalytica workflow by streamlining connectivity to MS SQL databases.

   

  It accepts essential credentials and configuration parameters—such as host, port, database name, username, and password—as input. Upon receiving these inputs, the machine initiates a connection test to validate the credentials and ensure accessibility to the specified database instance.

   

  Once verified, it generates a secure and reusable connection string that is passed forward to subsequent machines within the workflow. By automating this process, the MS SQL Connection Machine eliminates the need for manual setup and configuration, reducing errors and enabling seamless, efficient interactions with the database throughout the data pipeline.

• Machine Document : Download

Classification

• Industry : IT
• Category : Database
• Sub Category : -

Compatibility and Dependencies

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

Specifications

• Input Specification : Download

  Requires database credentials to establish database connection:

  
  
  • Database Username (String): The username required to authenticate and connect to the database.
  • Database Password (String): The secure password associated with the database username.
  • Database Host (String): The endpoint or IP address of the database server.
  • Database Port (Number): The port number for connecting to the database. (commonly 3306 for MS SQL)
  • Database Name (String): The name of the database to be connected to.
• Output Specification : Download

  Returns the following output for use in downstream processes:

  • Database Connection String (String): The database connection string to be passed on to the next machine.

Infrastructure Requirement

• OS Requirement : Linux
• CPU : 500m
• Cloud : AWS
• RAM : 256Mi

Usage Stats

• Total OnBoarded : -
• Active OnBoarding : -