Resources

SMS Code

SMS (Short Message Service) Code Login is a two-factor authentication (2FA) method that adds an extra layer of security to the login process. Here’s how it typically works:

  1. User Enters Credentials: The user enters their phone number on the login page.

  2. Send SMS Code: Upon successful entry of credentials, the server generates a unique verification code and sends it via SMS to the user’s registered mobile phone number.

  3. User Enters Code: The user receives the SMS with the code and enters it into the application.

  4. Verification: The server checks if the entered code matches the one sent via SMS. If it does, the user is granted access; if not, access is denied.


NOTE 💡

Benefits:

Enhanced Security: Even if an attacker has the user’s password, they would still need access to the user’s phone to log in.

User-Friendly: Most users are familiar with receiving SMS messages.

Reliance on Mobile Network: If the user is in an area with poor reception, they may not receive the code in a timely manner.

Security Risks: SMS can be vulnerable to interception through SIM swapping or other means.

User-Friendly: Most users are familiar with receiving SMS messages.

Drawbacks:

Reliance on Mobile Network: If the user is in an area with poor reception, they may not receive the code in a timely manner.

Security Risks: SMS can be vulnerable to interception through SIM swapping or other means.


How to Configure SMS Resource

To configure the SMS resource in the admin panel, follow these steps:

Step.1 Navigate to the Settings:

• Go to the “Settings” section in the Menu bar.

Step.2 Access the Resources Section:

• Click on “Resources.”

• In the Resources section, click the “+“ icon to add a new resource.

• You will be taken to the “Resource Info” page, where you need to fill out the followings:

  1. Name: Enter the name of your resource.

  2. Type: Select the type of resource from a multi-select option. (To use SMS, choose SMS from the list.)

  3. Environment: Specify the environment (e.g., production or development).

Step.3 Additional SMS Settings (After Selecting SMS as the Resource Type):

  • Type: Select the type of resource from a multi-select option. (To use SMS, choose SMS from the list.)

  • • Once you select SMS, five additional fields will appear. Fill them out as follows:

    1. Default OTP: Specify the default One-Time Password (OTP) format that will be used.

    2. Login: Enter the login credentials provided by your SMS provider (e.g., PlayMobile).

    3. Number of OTP Digits: Define the number of digits you want the OTP to have (e.g., 4 or 6 digits).

    4. Originator: Enter the name or number that will be shown to the recipient as the sender (this could be your project name or phone number).

    5. Password: Enter the password given by your SMS provider (e.g., PlayMobile).


SMTP

SMTP (Simple Mail Transfer Protocol) Login is primarily related to email services and allows applications to send emails through an SMTP server. Here’s how it generally works:

  1. User Credentials: The user provides their email address and password to authenticate with the SMTP server.

  2. Establish Connection: The application establishes a connection to the SMTP server, often using secure protocols like TLS (Transport Layer Security) to encrypt the communication.

  3. Send Email: After successful authentication, the application can send emails using the SMTP server. This may involve specifying the recipient’s address, subject, body of the email, and any attachments.

  4. Server Response: The SMTP server processes the request and sends back a response indicating whether the email was sent successfully or if there were errors (e.g., incorrect credentials, issues with the recipient’s address).


NOTE 💡

Benefits:

Reliable Email Delivery: SMTP is widely used and supported by most email services.

Integration: It allows applications to send automated emails (e.g., notifications, alerts) easily.

Drawbacks:

Security Concerns: If not implemented securely (e.g., using plaintext authentication), it may expose user credentials.

Limited to Email: It does not offer authentication for accessing application features but is focused solely on sending emails.

Summary

SMS Code Login is about securing user login with a second factor (the SMS code).

SMTP Login focuses on sending emails through a server and requires the user’s email credentials.


Email - write email

Password - need to get password from email 2FA

Default OTP - A default One-Time Password (OTP) is a simple, predefined code.

Number of OTP - refers to the number of digits or characters in the OTP

Environment - Project`

How to Configure SMTP Resource

To set up an SMTP resource, follow these steps:

Step.1 Navigate to the Settings:

• Go to the “Settings” section in Menu bar.

Step.2 Access the Resources Section:

• Click on “Resources.”

• In the Resources section, click the “+” icon to add a new resource.

Step.3 Fill in the Initial Resource Information:

  • On the “Resource Info” page, you will see three fields to fill:

    1. Name: Enter the name of the resource (e.g., SMTP for OTP).

    2. Type: Select the resource type from the multi-select options. To set up email-based OTP, choose SMTP.

    3. Environment: Specify the environment (e.g., production or development).

Step.4 Additional SMTP Settings (After Selecting SMTP as the Resource Type):

  • • Once you select SMTP, four additional fields will appear. Complete these fields as follows:

    1. Email: Enter the personal or company email address that will appear as the sender when the OTP is sent.

    2. Password: Provide the password associated with this email account. For example, for gmail, you can use the app-specific password generated through 2-factor authentication (2FA).

    3. Default OTP: Specify the default One-Time Password (OTP) format to be used.

    4. Number of OTP Digits: Define how many digits you want the OTP to have (e.g., 4 or 6 digits).


DataLens

DataLens is a tool developed by Yandex that is designed to visualize and analyze data from various sources. It allows users to create interactive dashboards and reports without requiring deep technical knowledge, making data insights more accessible to both technical and non-technical users.

Key Features of DataLens:

  1. Data Visualization: DataLens offers a variety of visualization options, such as charts, graphs, maps, and tables, to help users better understand their data and uncover insights.

  2. Interactive Dashboards: Users can create customizable, interactive dashboards that allow real-time exploration of data.

  3. Multiple Data Sources: It supports integration with different data sources, including databases like ClickHouse, Google BigQuery, PostgreSQL, and others. This allows seamless access to diverse data for analysis.

  4. Real-time Analytics: DataLens can be used for real-time data analysis, enabling businesses to make quick, data-driven decisions.

  5. Easy Query Building: It provides a no-code or low-code environment for building complex queries, making it accessible for users without SQL knowledge.

  6. Filters and Drill-downs: The tool allows users to filter data, drill down into details, and explore different layers of their data for in-depth analysis.

Use Cases:

Data Exploration: Analysts and decision-makers can explore data interactively, enabling deeper analysis of trends and anomalies.

Integration with ClickHouse:

Yandex DataLens is often integrated with ClickHouse to leverage its fast, high-performance data analytics capabilities. This combination enables businesses to process and visualize large datasets in real-time.

Step-by-Step Roadmap for Creating a DataLens(ClickHouse)

Step.1 Access the Settings

• In the main menu, go to the Settings option.

Step.2 Add a New Resource

• In the Resource section, click the “+” button next to the label to add a new resource.

Step.3 Create DataLens

A creation page will appear:

• Enter a Name for the DataLens.

• Select ClickHouse as the type.

• Choose the desired Environment from the options.

• Click the Save button.

Step.4 Auto generated ClickHouse Credentials

• After saving, Ucode will automatically generate the necessary credentials to connect ClickHouse to Yandex.Cloud DataLens.

These include:

Host

Port (e.g. 30090 or 30123)

Username

Password

Database (generated automatically)

Step.5 Airbyte Integration

• All sources for the users' database, destinations for ClickHouse, and connections between them will be created automatically. The connection for data retrieval will be set to the "full-refresh overwrite" type.

Step.6 Create a Connection to DataLens (Yandex.Cloud)

• Go to Yandex Cloud DataLens

• Navigate to the Connections section (with the Flash icon).

• Click the Create Connection button (located at the top-right corner).

Step.7 Manual Configuration

• Select ClickHouse as the data source.

• Choose the Manual Configuration option (Указать вручную).

Step.8 Enter Credentials

Copy the following credentials from Ucode into Yandex.Cloud:

Host

Port (30090 or 30123)

Username

Password (need to convert base64 format code to text code on Base64.ru)

Step.9 Configure Access and Settings:

• In the next step, you’ll see a checkbox for SQL access levels. Choose the needed option from the list.

• Go to Advanced Settings and turn off TLS (this step is crucial and must done).

Step.10 Complete the Connection

• After filling in all the required fields, click the Create Connection button to finalize the process.

Last updated