Connect Resource
Learn how to connect the data resource quickly.
Afer create application, you need to establish data connections for the application. ZEUSDEL support most databases and APIs, user can also connect to the common data sources using built-in tools with minimal configuration.
Step 1：Add data model
-
Click App Management -> Data Model Management.
-
Click Add button to add Data model.
-
Fill in the model name and data label.
-
Select the data model or BI model.
-
Fill in the model description.
The difference of Data model and BI model as follows:
Data model:
Mapping the tables created in the database into a data model. Associating the data model with the tables. When configuring the front-end page,you can directly access the data fields within the data model.This is commonly used for operations related to a single table.
BI model:
When dealing with complex business queries, you can create a query data model by writing SQL statements. By using the constructed query model, you can introduce the model into the front-end. This allows you to display the corresponding query data.
Step 2 ：Model Configuration
When setting up the model, if the corresponding data tables are already established in the database, you can directly establish data relationships. If the corresponding data tables have not been created, you can create new data tables.
A.Data table association
If data tables have already been created in the database, you can click on "Associate Tables" to select the data tables.
Select the corresponding tables within the Schema, the system can automatically retrieve the fields of selected tables.
You can choose the needed fields of the selected tables.
After the selection, click the save & sync button, then the data model synchronize in the database.
B.Creation Data Table
Click the create table
Select the schema and fill in the table name and desciption.
System automatically generates the system fields after creation.
Click the add field symbol to add other business fields continually.
Fill in english name,field name, data type, length, display type, and select whether it is a related field and whether it is a mandatory field.
Click the save and sync button to synchronize the data model in the database after creation related data fileds.