Module Configuration: Data Import Config

To configure the module, the following fields need to be set:

1. Use Existing Connection – Select this option if you want to use an already configured database connection.
2. Use New Connection – Choose this if you need to set up a new connection.
3. Data Source – Specify the type of data source (e.g., MySQL, PostgreSQL, etc.).
4. Host – Enter the hostname or IP address of the database server.
5. Port – Define the port number for the database connection.
6. User – Provide the username to authenticate with the database.
7. Password – Enter the corresponding password for authentication.
8. Multitenant – Enable this option if the user needs access to all databases.
9. Database – If Multitenant is enabled, specify the default database.
10. JWT Database Field / URL Param Name – Define the JWT field or URL parameter that holds the tenant/database value.
11. Prefix of Database – If the JWT field only contains part of the database name, specify a prefix to construct the full database name.

Multitenant Configuration Details

• Multitenant Option: When enabled, the data source dynamically switches based on the JWT token. Ensure the JWT token includes the tenant (database) information.
• JWT Database Field: This specifies which field in the decoded JWT contains the tenant/database value.
• Prefix of Database: If the JWT field only holds part of the database name, use this field to append a prefix.

📌 Example:

• If the JWT field contains the tenant value as 8
• And the actual database name is techbootstrap_8
• Set the Prefix of Database as techbootstrap_ to construct the full name dynamically.