SQL Connection

Owned by Pooja Yadav (Unlicensed), created
Last updated: Mar 09, 2022 by shreedutta.mukherjee (Unlicensed)
3 min read

Introduction

SQL connection helps to interact with the databases so that you can connect and integrate with their databases to automate workflows. For all the actions related to databases, an SQL connection is created.

Steps to configure

  1. To create a SQL connection you first need to click on the drop-down menu button on the connection type input field and choose SQL.



  2. Select the application, you wish to create a connection with. Provide the name for the connection and add a description of it for reference.

  3. Now, choose the desired database by clicking on the provider’s drop-down menu button. Provider section helps to display the information that are needed to communicate with a particular database. You need to select the desired provider details from the drop-down menu.

  4. For SnowFlake, the following form will appear and you will have to add the account name. An account name is the name of a person/ organization authorized to have an account, verifiable using specific personal information.

  5. Now, fill the warehouse section, The management data warehouse is a relational database that contains the data that is collected from a server that is a data collection target.

  6. Select the schema, in a SQL database, a schema is a list of logical structures of data.

  7. Provide the database as per your SnowFlake account requirements. A database in SQL Server is made up of a collection of tables that stores a specific set of structured data. A table contains a collection of rows, also referred to as records or tuples, and columns, also referred to as attributes.

    For Oracle and MySQL, the following form will appear and you will have to add the hostname. Hostname is a unique name or label assigned to any device that is connected to a specific computer network.

  8. Now fill the Port section. The port is a docking point that is used to connect an external device with the system.

  9. Provide the database, A database is an organized collection of structured information, or data, typically stored electronically in a computer system. A database is usually controlled by a database management system (DBMS).

  10. Provide the user name, and password of the respective account. An username allows you to maintain your personal identification when you use the particular application or connection. The requirement of passwords is to protect your sensitive information's. It’s can be generated with a unique combination of numerical and alphabetic characters.

     

  11. Now click on save to save the connection’s configuration. Once a connection is successfully created it can be used in any automation.