CN116881983A - Low-code platform data transmission method based on BI platform - Google Patents
Low-code platform data transmission method based on BI platform Download PDFInfo
- Publication number
- CN116881983A CN116881983A CN202311155188.2A CN202311155188A CN116881983A CN 116881983 A CN116881983 A CN 116881983A CN 202311155188 A CN202311155188 A CN 202311155188A CN 116881983 A CN116881983 A CN 116881983A
- Authority
- CN
- China
- Prior art keywords
- data
- platform
- low
- code
- transmission
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 230000005540 biological transmission Effects 0.000 title claims abstract description 66
- 238000000034 method Methods 0.000 title claims abstract description 33
- 238000004458 analytical method Methods 0.000 claims abstract description 32
- 238000012545 processing Methods 0.000 claims abstract description 18
- 238000005065 mining Methods 0.000 claims abstract description 14
- 230000002159 abnormal effect Effects 0.000 claims description 11
- 238000013499 data model Methods 0.000 claims description 10
- 238000004364 calculation method Methods 0.000 claims description 8
- 238000012544 monitoring process Methods 0.000 claims description 8
- 238000006243 chemical reaction Methods 0.000 claims description 5
- 230000000007 visual effect Effects 0.000 claims description 5
- 238000005259 measurement Methods 0.000 claims description 4
- 238000013519 translation Methods 0.000 claims description 4
- 238000004891 communication Methods 0.000 claims description 3
- 238000012216 screening Methods 0.000 claims description 3
- 238000012550 audit Methods 0.000 description 6
- 230000000903 blocking effect Effects 0.000 description 3
- 230000006870 function Effects 0.000 description 2
- 238000007726 management method Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000002955 isolation Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/64—Protecting data integrity, e.g. using checksums, certificates or signatures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/30—Authentication, i.e. establishing the identity or authorisation of security principals
- G06F21/31—User authentication
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/602—Providing cryptographic facilities or services
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D30/00—Reducing energy consumption in communication networks
- Y02D30/70—Reducing energy consumption in communication networks in wireless communication networks
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computer Security & Cryptography (AREA)
- Computer Hardware Design (AREA)
- Software Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Health & Medical Sciences (AREA)
- Bioethics (AREA)
- General Health & Medical Sciences (AREA)
- Computer And Data Communications (AREA)
Abstract
The invention relates to the field of data transmission methods, in particular to a low-code platform data transmission method based on a BI platform. Firstly, processing and deep mining are carried out on source data through a BI platform, and the data are converted into intelligent analysis reports according to classification, so that the data relationship of the source data is more visualized. And then analyzing and detecting the processed data through the cross-platform data exchange channel, so that the safety and reliability of the data are ensured. And finally, the low-code platform transmits and converts the intelligent analysis report form through codes to obtain data and data relation. Through the combination of the BI platform and the low-code platform, the universality and the convenience of the low-code platform are guaranteed, the deep mining of the data relationship is realized, the data value is improved, and the safety of data transmission is guaranteed.
Description
Technical Field
The invention relates to the field of data transmission methods, in particular to a low-code platform data transmission method based on a BI platform.
Background
When the conventional BI platform is applied, because the threshold of a technical system is higher, report development and production are often conducted mainly by IT, but technicians cannot understand business well in most cases, and technical capability of business personnel is very limited, so that IT is required to communicate with business departments back and forth to determine requirements.
Low code platforms are a trend in modern software development that can help businesses build business applications quickly with simple natural language logic, improving the efficiency and productivity of the business. But its function is mainly focused on the code layer, and the aspects of data processing, data analysis and data display are not superior to those of BI platform. How to associate BI platforms with low code platforms becomes a critical issue.
Disclosure of Invention
Aiming at the problems in the background technology, a low code platform data transmission method based on a BI platform is provided. Firstly, processing and deep mining are carried out on source data through a BI platform, and the data are converted into intelligent analysis reports according to classification, so that the data relationship of the source data is more visualized. And then analyzing and detecting the processed data through the cross-platform data exchange channel, so that the safety and reliability of the data are ensured. And finally, the low-code platform transmits and converts the intelligent analysis report form through codes to obtain data and data relation. Through the combination of the BI platform and the low-code platform, the universality and the convenience of the low-code platform are guaranteed, the deep mining of the data relationship is realized, the data value is improved, and the safety of data transmission is guaranteed.
The invention provides a BI platform-based low-code platform data transmission method, which comprises the following steps:
s1, building a BI platform, a low-code platform and a cross-platform data exchange channel between the BI platform and the low-code platform;
s2, a user logs in a low-code platform and sends out a data transmission request;
s3, processing the source data by the BI platform, classifying the source data through a data model established in advance, visualizing the source data, and deeply mining the data relationship;
s4, determining the type and format of data to be transmitted, configuring a data exchange protocol and related parameters, and establishing an intelligent analysis report with a data hierarchy relation by the BI platform;
s5, establishing connection between the BI platform and the low-code platform through the cross-platform data exchange channel for corresponding intelligent analysis report data transmission, and monitoring the safety of the data in the transmission process;
and S6, writing data transmission and conversion codes by the low-code platform, and translating the intelligent analysis report data to realize transmission of target data and data relation associated with the target data.
Preferably, a data processing engine is arranged on the BI platform, table relation definition, dimension definition and measurement definition are carried out on source data through the data processing engine, MDX calculation and ETL calculation are carried out, and a visual data set is obtained.
Preferably, the low code platform needs to determine the customized form, flow and service rule when being built, and also needs to build translation and code resource library.
Preferably, the user enters the low code platform by sending the public key, then sending the private key, unlocking the secret protocol file, and confirming the data transmission level.
Preferably, the data model working method is as follows:
a. establishing dynamic connection with each data set through a data source interface, and screening related data according to the data transmission grade;
b. correcting and unifying the screened data, and creating an intelligent analysis report;
c. and finally, the corresponding intelligent analysis report is sent to a cross-platform data exchange channel.
Preferably, the low-code platform acquires the instruction of the user side and the related information of data transmission in real time, and generates log information of a tree structure.
Preferably, when data transmission is performed through the cross-platform data exchange channel, the data source needs to be verified, the IP address and the communication port information of the data source are confirmed, and unsafe data need to be screened.
Preferably, a safety monitoring center is arranged in the cross-platform data exchange channel, and abnormal characteristic data is extracted by monitoring transmission data of each connection node of the BI platform and the low-code platform; and when abnormal characteristic data appear, positioning the connection node of the data, and forcibly interrupting abnormal transmission.
Compared with the prior art, the invention has the following beneficial technical effects:
firstly, processing and deep mining are carried out on source data through a BI platform, and the data are converted into intelligent analysis reports according to classification, so that the data relationship of the source data is more visualized. And then analyzing and detecting the processed data through the cross-platform data exchange channel, so that the safety and reliability of the data are ensured. And finally, the low-code platform transmits and converts the intelligent analysis report form through codes to obtain data and data relation. Through the combination of the BI platform and the low-code platform, the universality and the convenience of the low-code platform are guaranteed, the deep mining of the data relationship is realized, the data value is improved, and the safety of data transmission is guaranteed.
Drawings
FIG. 1 is a flow chart of a low code platform data transmission method based on a BI platform;
FIG. 2 is a flow chart of a data model work method.
Detailed Description
Examples
As shown in fig. 1, the low code platform data transmission method based on the BI platform provided by the invention comprises the following steps:
s1, building a BI platform, a low-code platform and a cross-platform data exchange channel between the BI platform and the low-code platform;
s2, a user logs in a low-code platform and sends out a data transmission request;
s3, carrying out batch processing on all source data by the BI platform, classifying the source data through a data model established in advance, visualizing the source data, and deeply mining the data relationship;
s4, determining the type and format of data to be transmitted, configuring a data exchange protocol and related parameters, and establishing an intelligent analysis report with a data hierarchy relation by the BI platform;
s5, establishing connection between the BI platform and the low-code platform through the cross-platform data exchange channel for corresponding intelligent analysis report data transmission, and monitoring the safety of the data in the transmission process;
and S6, writing data transmission and conversion codes by the low-code platform, and translating the intelligent analysis report data to realize transmission of target data and data relation associated with the target data.
The working principle of this embodiment is as follows: firstly, processing and deep mining are carried out on source data through a BI platform, and the data are converted into intelligent analysis reports according to classification, so that the data relationship of the source data is more visualized. And then analyzing and detecting the processed data through the cross-platform data exchange channel, so that the safety and reliability of the data are ensured. And finally, the low-code platform transmits and converts the intelligent analysis report form through codes to obtain data and data relation. The method not only ensures the universality and convenience of the low-code platform, but also realizes the deep mining of the data relationship, improves the data value, and simultaneously ensures the safety of data transmission.
Examples
As shown in fig. 1, the low code platform data transmission method based on the BI platform provided by the invention comprises the following steps:
s1, building a BI platform, a low-code platform and a cross-platform data exchange channel between the BI platform and the low-code platform;
s2, a user logs in a low-code platform and sends out a data transmission request;
s3, carrying out batch processing on all source data by the BI platform, classifying the source data through a data model established in advance, visualizing the source data, and deeply mining the data relationship;
s4, determining the type and format of data to be transmitted, configuring a data exchange protocol and related parameters, and establishing an intelligent analysis report with a data hierarchy relation by the BI platform;
s5, establishing connection between the BI platform and the low-code platform through the cross-platform data exchange channel for corresponding intelligent analysis report data transmission, and monitoring the safety of the data in the transmission process;
and S6, writing data transmission and conversion codes by the low-code platform, and translating the intelligent analysis report data to realize transmission of target data and data relation associated with the target data.
It should be further noted that, the BI platform is provided with a data processing engine, which can store, process and protect data, generate database items by using SQL Server Management Studio, then perform table relation definition, dimension definition and measurement definition on source data by the data processing engine, perform MDX calculation and ETL calculation, and parse data by performing actions such as slicing, blocking, rotation and the like on multidimensional data, so as to finally obtain a visual dataset.
It should be further described that, when the low-code platform is built, the user-defined forms, processes and service rules, such as fields, field types and configuration attributes of the forms, need to be determined, while the processes include a workflow and an audit flow, the workflow is responsible for associating a plurality of forms, so that form linkage can be achieved, and the audit flow is in a single form, so that form audit state change is realized. In addition, a translation and a code resource library are required to be established on the low-code platform, and the transmitted intelligent analysis report data is accurately converted.
It should be further noted that, the user enters the low code platform by sending the public key, then sends the private key, unlocks the secret protocol file, and confirms the data transmission level. The data transmission level needs to establish a user level list in advance. And distributing corresponding public keys and private keys to users of different grades, and carrying out authentication and file transmission restriction on the users through the cooperation of the public keys and the private keys.
Examples
As shown in fig. 1, the low code platform data transmission method based on the BI platform provided by the invention comprises the following steps:
s1, building a BI platform, a low-code platform and a cross-platform data exchange channel between the BI platform and the low-code platform;
s2, a user logs in a low-code platform and sends out a data transmission request;
s3, carrying out batch processing on all source data by the BI platform, classifying the source data through a data model established in advance, visualizing the source data, and deeply mining the data relationship;
s4, determining the type and format of data to be transmitted, configuring a data exchange protocol and related parameters, and establishing an intelligent analysis report with a data hierarchy relation by the BI platform;
s5, establishing connection between the BI platform and the low-code platform through the cross-platform data exchange channel for corresponding intelligent analysis report data transmission, and monitoring the safety of the data in the transmission process;
and S6, writing data transmission and conversion codes by the low-code platform, and translating the intelligent analysis report data to realize transmission of target data and data relation associated with the target data.
It should be further noted that, the BI platform is provided with a data processing engine, which can store, process and protect data, generate database items by using SQL Server Management Studio, then perform table relation definition, dimension definition and measurement definition on source data by the data processing engine, perform MDX calculation and ETL calculation, and parse data by performing actions such as slicing, blocking, rotation and the like on multidimensional data, so as to finally obtain a visual dataset.
It should be further described that, when the low-code platform is built, the user-defined forms, processes and service rules, such as fields, field types and configuration attributes of the forms, need to be determined, while the processes include a workflow and an audit flow, the workflow is responsible for associating a plurality of forms, so that form linkage can be achieved, and the audit flow is in a single form, so that form audit state change is realized. In addition, a translation and a code resource library are required to be established on the low-code platform, and the transmitted intelligent analysis report data is accurately converted.
It should be further noted that, the user enters the low code platform by sending the public key, then sends the private key, unlocks the secret protocol file, and confirms the data transmission level. The data transmission level needs to establish a user level list in advance. And distributing corresponding public keys and private keys to users of different grades, and carrying out authentication and file transmission restriction on the users through the cooperation of the public keys and the private keys.
As shown in fig. 2, the data model operation method is as follows:
a. establishing dynamic connection with each data set through a data source interface, and screening related data according to the data transmission grade;
b. correcting and unifying the screened data, and creating an intelligent analysis report;
c. and finally, the corresponding intelligent analysis report is sent to a cross-platform data exchange channel.
In the embodiment, by combining the visual performance of the BI platform, an intelligent analysis report is established through a data model, so that a multidimensional deep mining data relationship is realized.
It should be further noted that, the low-code platform acquires the instruction and the data transmission related information of the user end in real time, and generates the log information of the tree structure. And the subsequent inquiry and self-checking are convenient.
It should be further noted that when data is transmitted through the cross-platform data exchange channel, the data source needs to be verified, the IP address and the communication port information of the data source need to be confirmed, and unsafe data needs to be screened.
The method is characterized in that a safety monitoring center is arranged in a cross-platform data exchange channel, and abnormal characteristic data is extracted by monitoring transmission data of each connection node of the BI platform and the low-code platform; and when abnormal characteristic data appear, positioning the connection node of the data, and forcibly interrupting abnormal transmission. For example, by linking a hook subroutine at a connection node, under the condition of abnormal access, a hook function of a corresponding type is generated, and abnormal access data is captured, so that the purposes of rapid blocking and isolation are achieved.
The embodiments of the present invention have been described in detail with reference to the drawings, but the present invention is not limited thereto, and various changes can be made within the knowledge of those skilled in the art without departing from the spirit of the present invention.
Claims (8)
1. A low-code platform data transmission method based on a BI platform is characterized by comprising the following steps:
s1, building a BI platform, a low-code platform and a cross-platform data exchange channel between the BI platform and the low-code platform;
s2, a user logs in a low-code platform and sends out a data transmission request;
s3, processing the source data by the BI platform, classifying the source data through a data model established in advance, visualizing the source data, and deeply mining the data relationship;
s4, determining the type and format of data to be transmitted, configuring a data exchange protocol and related parameters, and establishing an intelligent analysis report with a data hierarchy relation by the BI platform;
s5, establishing connection between the BI platform and the low-code platform through the cross-platform data exchange channel for corresponding intelligent analysis report data transmission, and monitoring the safety of the data in the transmission process;
and S6, writing data transmission and conversion codes by the low-code platform, and translating the intelligent analysis report data to realize transmission of target data and data relation associated with the target data.
2. The method for transmitting low-code platform data based on the BI platform according to claim 1, wherein a data processing engine is arranged on the BI platform, table relation definition, dimension definition and measurement definition are carried out on source data through the data processing engine, MDX calculation and ETL calculation are carried out, and a visual data set is obtained.
3. The method for transmitting data of a low-code platform based on a BI platform according to claim 1, wherein the low-code platform is constructed by determining a customized form, process and service rule, and constructing a translation and code resource library.
4. The BI platform-based low code platform data transmission method of claim 1, wherein the user confirms the data transmission level by sending a public key, entering the low code platform, then sending a private key, unlocking the security protocol file.
5. The method for low code platform data transmission based on BI platform according to claim 4, wherein the data model working method is as follows:
a. establishing dynamic connection with each data set through a data source interface, and screening related data according to the data transmission grade;
b. correcting and unifying the screened data, and creating an intelligent analysis report;
c. and finally, the corresponding intelligent analysis report is sent to a cross-platform data exchange channel.
6. The method for transmitting data of a low-code platform based on a BI platform according to claim 1, wherein the low-code platform acquires the instruction of the user side and the data transmission related information in real time, and generates log information of a tree structure.
7. The BI platform-based low code platform data transmission method of claim 1, wherein the data source is required to be verified when the data is transmitted through the cross-platform data exchange channel, the IP address and the communication port information of the data source are confirmed, and unsafe data are required to be screened.
8. The method for transmitting low-code platform data based on the BI platform according to claim 7, wherein a safety monitoring center is arranged in a cross-platform data exchange channel, and abnormal characteristic data is extracted by monitoring transmission data of each connection node of the BI platform and the low-code platform; and when abnormal characteristic data appear, positioning the connection node of the data, and forcibly interrupting abnormal transmission.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311155188.2A CN116881983A (en) | 2023-09-08 | 2023-09-08 | Low-code platform data transmission method based on BI platform |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311155188.2A CN116881983A (en) | 2023-09-08 | 2023-09-08 | Low-code platform data transmission method based on BI platform |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN116881983A true CN116881983A (en) | 2023-10-13 |
Family
ID=88260920
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311155188.2A Pending CN116881983A (en) | 2023-09-08 | 2023-09-08 | Low-code platform data transmission method based on BI platform |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116881983A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US10536352B1 (en) * | 2015-08-05 | 2020-01-14 | Quest Software Inc. | Systems and methods for tuning cross-platform data collection |
| CN115098567A (en) * | 2022-06-20 | 2022-09-23 | 上海纽酷信息科技有限公司 | Low code platform data transmission method based on BI platform |
| CN115796549A (en) * | 2022-12-23 | 2023-03-14 | 福建华鼎智造技术有限公司 | Comprehensive energy management and control platform constructed based on low-code platform |
| CN115935301A (en) * | 2022-12-29 | 2023-04-07 | 中企云链（北京）金融信息服务有限公司 | Application program generation method based on visual configuration, client and development platform |
| CN116089495A (en) * | 2022-12-26 | 2023-05-09 | 浪潮云信息技术股份公司 | Self-service analysis platform based on big data |
-
2023
- 2023-09-08 CN CN202311155188.2A patent/CN116881983A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US10536352B1 (en) * | 2015-08-05 | 2020-01-14 | Quest Software Inc. | Systems and methods for tuning cross-platform data collection |
| CN115098567A (en) * | 2022-06-20 | 2022-09-23 | 上海纽酷信息科技有限公司 | Low code platform data transmission method based on BI platform |
| CN115796549A (en) * | 2022-12-23 | 2023-03-14 | 福建华鼎智造技术有限公司 | Comprehensive energy management and control platform constructed based on low-code platform |
| CN116089495A (en) * | 2022-12-26 | 2023-05-09 | 浪潮云信息技术股份公司 | Self-service analysis platform based on big data |
| CN115935301A (en) * | 2022-12-29 | 2023-04-07 | 中企云链（北京）金融信息服务有限公司 | Application program generation method based on visual configuration, client and development platform |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11226975B2 (en) | Method and system for implementing machine learning classifications | |
| CN102918534B (en) | Inquiry pipeline | |
| CN108428141B (en) | Food traceability information management system based on ERP system and block chain | |
| US8365195B2 (en) | Systems and methods for generating sets of model objects having data messaging pipes | |
| CN104717085B (en) | A kind of daily record analysis method and device | |
| CN110708322A (en) | Method for realizing proxy service of industrial internet identification analysis system | |
| CN106209488B (en) | Method and device for detecting website attack | |
| US20170034200A1 (en) | Flaw Remediation Management | |
| CN107832391B (en) | Data query method and system | |
| US8719908B1 (en) | Digital certificate management | |
| CN112835784B (en) | Method for evaluating and optimizing interoperation capacity of complex giant system | |
| CN113836237A (en) | Method and device for auditing data operation of database | |
| CN113793158A (en) | Textile inspection detection information query method and system | |
| US20190066012A1 (en) | Enterprise customer website | |
| CN113179267A (en) | Network security event correlation analysis method and system | |
| CN112801623A (en) | Patent process management system and method | |
| CN116881983A (en) | Low-code platform data transmission method based on BI platform | |
| CN112288317A (en) | Industrial big data analysis platform and method based on multi-source heterogeneous data governance | |
| CN114722037B (en) | Industrial Internet middleware data processing method, middleware and readable storage medium | |
| CN116010480A (en) | Time sequence database auditing method and system | |
| CN115696337A (en) | Mobile terminal safety monitoring analysis method and device | |
| CN114706839A (en) | Log data processing method and device, electronic equipment and storage medium | |
| CN113032089B (en) | Distributed simulation service construction method based on API gateway | |
| CN112631222B (en) | Processing method and system of Internet industrial control system and computing equipment | |
| US11693851B2 (en) | Permutation-based clustering of computer-generated data entries |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |