2022.01.06 update-data source capability improvement

付费版功能

Richer data sources

In order to better realize the existing local database system and spreadsheet data, it should be combined with suitable applications in business scenarios.

Now for the paid version YIDA, seven common data sources are supported ([5 databases] +[2 data files]) to further realize data exchange and enrichment.

Add a data source type

This YIDA added 7 types of data sources to connect information and data.

• Database (Database):

• SupportMySQL,SQL Server,Oracle,Postgre,HologresDatabase Connection

• File:

• SupportExcel and CSVFile connection

What is the data source

• Definition: Data Source (Data Source): describes the Data Source information. YIDA supports the management and maintenance of Data sources such as files and databases.
• Path:Go to the application form page> application data management> data source management

Noun introduction:

• A correct understanding of the definitions and usage scenarios of datasets and data sources can help you use YIDA data services more efficiently.

• In one word
• Where data is used and consumed, standardized datasets are used, such as charts and reports.
• A data source is a description that defines data source information in different fields, such as a Mysql database connected to a company.

Dataset

• Definition: Dataset (Data Set): unified management of standard forms, charts (multi-table Association), Data Preparation (big Data offline solution), and cross-application (form) Data generation, A dataset is a standard data collection unit.
• Path:Go to the application form page> application data

Use data sources

1. Create a database data source

Select the desired database type from the drop-down list and set a custom data source name.

2. Select set data source information

Set relevant database information, database address, port number, account number, password, database name and other information, and support the useJDBCThe string is parsed with one click.

JDBC example for MySQL: jdbc:mysql:// aliwork:3306/test_demo? useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=UTC

3. Edit data source information

You can edit the information of the created data source to update the data.

Dataset type

1. Create a dataset from a database

Features

Function: data can be extracted and processed by interconnecting existing cloud databases.

Supported types: Mysql, SQLServer, Oracle, PostgreSQL, HologreSQL

Security: in addition to the database password input when creating the data source, all passwords will be encrypted and protected to ensure the information security of the database throughout the process.

Scenario optimization: for database drivers of different Mysql and SQLServer versions, the cloud automatically parses and identifies them, and intelligently matches the corresponding database drivers.

Procedure

1. Click create dataset

2. Set database information

3. Use database data

• On the report page and data preparation page, you can select relevant datasets to create report analysis with one click.

• The data effect of using a specific Mysql database in the report

2. Create data from a fileSet

Features

Function: Through the interconnection of information sources of existing text types, data based on text informatization and file informatization can be quickly extracted and processed. As a simple file type, you can directly create a dataset corresponding to a file data source in the dataset without creating a separate data source.

Supported types: Excel .xls and. xlsx files commonly used in enterprise informatization, andFor big data text processingCVS file (Comma-Separated Values).

Scenario optimization: By default, the uploaded fields are processed in string type, and the field type adjustment (value, date, etc.) is supported to facilitate the use of more reasonable data types in the scene.

Procedure

1. Select and upload files

2. Field settings

3. Use file content data