CN116881983A - Low-code platform data transmission method based on BI platform - Google Patents

Low-code platform data transmission method based on BI platform Download PDF

Info

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
Application number
CN202311155188.2A
Other languages
Chinese (zh)
Inventor
何立娟
石龙
刘刚
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Beijing Guqi Data Technology Co ltd
Original Assignee
Beijing Guqi Data Technology Co ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Beijing Guqi Data Technology Co ltd filed Critical Beijing Guqi Data Technology Co ltd
Priority to CN202311155188.2A priority Critical patent/CN116881983A/en
Publication of CN116881983A publication Critical patent/CN116881983A/en
Pending legal-status Critical Current

Links

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

本发明涉及数据传输方法领域，尤其涉及一种基于BI平台的低代码平台数据传输方法。首先通过BI平台对源数据进行加工和深度挖掘，将数据按照分类转化为智能分析报表，使得源数据的数据关系更加的可视化。接着跨平台数据交换通道对处理后的数据进行分析、检测，保证数据的安全可靠。最后低代码平台通过代码对智能分析报表进行传输、转化，获得数据以及数据关系。通过BI平台和低代码平台的结合，既保证了低代码平台的通用性、便捷性，又实现对数据关系的深度挖掘，提高了数据价值，同时也保证了数据传输的安全性。

The present invention relates to the field of data transmission methods, and in particular, to a low-code platform data transmission method based on a BI platform. First, the source data is processed and deeply mined through the BI platform, and the data is converted into intelligent analysis reports according to classification, making the data relationships of the source data more visual. Then the cross-platform data exchange channel analyzes and detects the processed data to ensure the safety and reliability of the data. Finally, the low-code platform transmits and transforms intelligent analysis reports through code to obtain data and data relationships. Through the combination of the BI platform and the low-code platform, it not only ensures the versatility and convenience of the low-code platform, but also enables in-depth exploration of data relationships, improves the value of the data, and also ensures the security of data transmission.

Description

一种基于BI平台的低代码平台数据传输方法A low-code platform data transmission method based on BI platform

技术领域Technical field

本发明涉及数据传输方法领域，尤其涉及一种基于BI平台的低代码平台数据传输方法。The present invention relates to the field of data transmission methods, and in particular, to a low-code platform data transmission method based on a BI platform.

背景技术Background technique

传统BI平台应用时，由于技术系统的门槛比较高，报表的开发与制作往往以IT为主导，但技术人员大多时候并不能很好的理解业务，而业务人员的技术能力又非常有限，因此需要IT部门与业务部门来回的沟通确定需求才能完成。When applying traditional BI platforms, due to the relatively high threshold of technical systems, the development and production of reports are often IT-led. However, most of the time, technical personnel do not understand the business well, and the technical capabilities of business personnel are very limited, so it is necessary to The IT department and the business department communicate back and forth to determine the requirements before it can be completed.

低代码平台是现代软件开发的趋势，其可以帮助企业快速用简单的自然语言逻辑来搭建业务应用，提高企业的效率和生产力。但其功能主要聚焦在代码层，数据处理、数据分析、数据显示方面没有优于BI平台。如何将BI平台和低代码平台进行关联成为关键问题。Low-code platform is a trend in modern software development. It can help enterprises quickly build business applications using simple natural language logic and improve enterprise efficiency and productivity. However, its functions mainly focus on the code layer, and are not better than the BI platform in terms of data processing, data analysis, and data display. How to connect the BI platform and the low-code platform has become a key issue.

发明内容Contents of the invention

针对背景技术中存在的问题，提出一种基于BI平台的低代码平台数据传输方法。首先通过BI平台对源数据进行加工和深度挖掘，将数据按照分类转化为智能分析报表，使得源数据的数据关系更加的可视化。接着跨平台数据交换通道对处理后的数据进行分析、检测，保证数据的安全可靠。最后低代码平台通过代码对智能分析报表进行传输、转化，获得数据以及数据关系。通过BI平台和低代码平台的结合，既保证了低代码平台的通用性、便捷性，又实现对数据关系的深度挖掘，提高了数据价值，同时也保证了数据传输的安全性。In view of the problems existing in the background technology, a low-code platform data transmission method based on the BI platform is proposed. First, the source data is processed and deeply mined through the BI platform, and the data is converted into intelligent analysis reports according to classification, making the data relationships of the source data more visual. Then the cross-platform data exchange channel analyzes and detects the processed data to ensure the safety and reliability of the data. Finally, the low-code platform transmits and transforms intelligent analysis reports through code to obtain data and data relationships. Through the combination of the BI platform and the low-code platform, it not only ensures the versatility and convenience of the low-code platform, but also enables in-depth exploration of data relationships, improves the value of the data, and also ensures the security of data transmission.

本发明提出一种基于BI平台的低代码平台数据传输方法，步骤如下：The present invention proposes a low-code platform data transmission method based on BI platform. The steps are as follows:

S1、搭建BI平台、低代码平台以及两者之间的跨平台数据交换通道；S1. Build a BI platform, a low-code platform and a cross-platform data exchange channel between the two;

S2、用户登录低代码平台，发出数据传输请求；S2. The user logs in to the low-code platform and issues a data transmission request;

S3、BI平台对源数据进行加工，并通过提前建立的数据模型对源数据进行分类，使其可视化，深度挖掘数据关系；The S3 and BI platform process the source data and classify the source data through the data model established in advance to visualize it and deeply mine the data relationships;

S4、BI平台确定需要传输的数据类型和格式，配置数据交换协议和相关参数，建立带数据层级关系的智能分析报表；S4. The BI platform determines the data type and format that needs to be transmitted, configures the data exchange protocol and related parameters, and establishes an intelligent analysis report with data hierarchical relationships;

S5、跨平台数据交换通道建立BI平台和低代码平台之间的连接，供对应的智能分析报表数据传输，在传输过程中对数据的安全性进行监测；S5. The cross-platform data exchange channel establishes a connection between the BI platform and the low-code platform to provide corresponding intelligent analysis report data transmission and monitor the security of the data during the transmission process;

S6、低代码平台编写数据传输和转换代码，对智能分析报表数据进行翻译，实现传输目标数据以及与目标数据相关联的数据关系。S6. The low-code platform writes data transmission and conversion codes, translates intelligent analysis report data, and realizes the transmission of target data and data relationships associated with the target data.

优选的，BI平台上设置有数据处理引擎，通过数据处理引擎对源数据进行表关系定义、维度定义、度量定义，并进行MDX计算和ETL计算，得到可视化数据集。Preferably, the BI platform is equipped with a data processing engine, through which the source data is defined with table relationships, dimensions, and measures, and MDX calculations and ETL calculations are performed to obtain a visual data set.

优选的，低代码平台搭建时需要确定自定义的表单、流程和服务规则，还需要建立翻译以及代码资源库。Preferably, when building a low-code platform, it is necessary to determine customized forms, processes and service rules, and to establish translation and code resource libraries.

优选的，用户通过发送公钥，进入低代码平台，接着发送私钥，解锁保密协议文件，确认数据传输等级。Preferably, the user enters the low-code platform by sending the public key, and then sends the private key to unlock the confidentiality agreement file and confirm the data transmission level.

优选的，数据模型工作方法如下：Preferably, the data model working method is as follows:

a、通过数据源接口与各个数据集建立动态连接，根据数据传输等级，筛选相关数据；a. Establish dynamic connections with each data set through the data source interface, and filter relevant data according to the data transmission level;

b、接着对筛选的数据进行校正、统一格式，并创建智能分析报表；b. Then correct and unify the format of the filtered data, and create intelligent analysis reports;

c、最后将对应的智能分析报表发送至跨平台数据交换通道。c. Finally, send the corresponding intelligent analysis report to the cross-platform data exchange channel.

优选的，低代码平台实时获取用户端的指令以及数据传输相关信息，并生成树形结构的日志信息。Preferably, the low-code platform obtains the user's instructions and data transmission-related information in real time, and generates tree-structured log information.

优选的，跨平台数据交换通道进行数据传输时需要对数据源进行验证，确认其IP地址以及通信端口信息，还需要对不安全数据进行筛查。Preferably, when transmitting data through a cross-platform data exchange channel, the data source needs to be verified, its IP address and communication port information need to be confirmed, and unsafe data needs to be screened.

优选的，跨平台数据交换通道内设置安全监测中心，通过对BI平台和低代码平台每个连接节点的传输数据进行监测，提取异常特征数据；在出现异常特征数据时，对该数据的连接节点进行定位，并对异常传输进行强制中断。Preferably, a security monitoring center is set up in the cross-platform data exchange channel to extract abnormal characteristic data by monitoring the transmission data of each connection node of the BI platform and the low-code platform; when abnormal characteristic data occurs, the connection node of the data Locate and force interruption of abnormal transmission.

与现有技术相比，本发明具有如下有益的技术效果：Compared with the existing technology, the present invention has the following beneficial technical effects:

首先通过BI平台对源数据进行加工和深度挖掘，将数据按照分类转化为智能分析报表，使得源数据的数据关系更加的可视化。接着跨平台数据交换通道对处理后的数据进行分析、检测，保证数据的安全可靠。最后低代码平台通过代码对智能分析报表进行传输、转化，获得数据以及数据关系。通过BI平台和低代码平台的结合，既保证了低代码平台的通用性、便捷性，又实现对数据关系的深度挖掘，提高了数据价值，同时也保证了数据传输的安全性。First, the source data is processed and deeply mined through the BI platform, and the data is converted into intelligent analysis reports according to classification, making the data relationships of the source data more visual. Then the cross-platform data exchange channel analyzes and detects the processed data to ensure the safety and reliability of the data. Finally, the low-code platform transmits and transforms intelligent analysis reports through code to obtain data and data relationships. Through the combination of the BI platform and the low-code platform, it not only ensures the versatility and convenience of the low-code platform, but also enables in-depth exploration of data relationships, improves the value of the data, and also ensures the security of data transmission.

附图说明Description of the drawings

图1为基于BI平台的低代码平台数据传输方法的流程图；Figure 1 is a flow chart of the low-code platform data transmission method based on the BI platform;

图2为数据模型工作方法流程图。Figure 2 is a flow chart of the data model working method.

具体实施方式Detailed ways

实施例Example

如图1所示，本发明提出的一种基于BI平台的低代码平台数据传输方法，步骤如下：As shown in Figure 1, the present invention proposes a low-code platform data transmission method based on BI platform. The steps are as follows:

S1、搭建BI平台、低代码平台以及两者之间的跨平台数据交换通道；S1. Build a BI platform, a low-code platform and a cross-platform data exchange channel between the two;

S2、用户登录低代码平台，发出数据传输请求；S2. The user logs in to the low-code platform and issues a data transmission request;

S3、BI平台对所有的源数据进行批量加工，并通过提前建立的数据模型对源数据进行分类，使其可视化，深度挖掘数据关系；S3 and BI platforms process all source data in batches and classify the source data through data models established in advance to visualize them and deeply mine data relationships;

S4、BI平台确定需要传输的数据类型和格式，配置数据交换协议和相关参数，建立带数据层级关系的智能分析报表；S4. The BI platform determines the data type and format that needs to be transmitted, configures the data exchange protocol and related parameters, and establishes an intelligent analysis report with data hierarchical relationships;

S5、跨平台数据交换通道建立BI平台和低代码平台之间的连接，供对应的智能分析报表数据传输，在传输过程中对数据的安全性进行监测；S5. The cross-platform data exchange channel establishes a connection between the BI platform and the low-code platform to provide corresponding intelligent analysis report data transmission and monitor the security of the data during the transmission process;

S6、低代码平台编写数据传输和转换代码，对智能分析报表数据进行翻译，实现传输目标数据以及与目标数据相关联的数据关系。S6. The low-code platform writes data transmission and conversion codes, translates intelligent analysis report data, and realizes the transmission of target data and data relationships associated with the target data.

本实施例的工作原理如下：首先通过BI平台对源数据进行加工和深度挖掘，将数据按照分类转化为智能分析报表，使得源数据的数据关系更加的可视化。接着跨平台数据交换通道对处理后的数据进行分析、检测，保证数据的安全可靠。最后低代码平台通过代码对智能分析报表进行传输、转化，获得数据以及数据关系。既保证了低代码平台的通用性、便捷性，又实现对数据关系的深度挖掘，提高了数据价值，同时也保证了数据传输的安全性。The working principle of this embodiment is as follows: first, the source data is processed and deeply mined through the BI platform, and the data is converted into intelligent analysis reports according to classification, so that the data relationships of the source data are more visualized. Then the cross-platform data exchange channel analyzes and detects the processed data to ensure the safety and reliability of the data. Finally, the low-code platform transmits and transforms intelligent analysis reports through code to obtain data and data relationships. It not only ensures the versatility and convenience of the low-code platform, but also enables in-depth mining of data relationships, improves the value of data, and also ensures the security of data transmission.

实施例Example

如图1所示，本发明提出的一种基于BI平台的低代码平台数据传输方法，步骤如下：As shown in Figure 1, the present invention proposes a low-code platform data transmission method based on BI platform. The steps are as follows:

S1、搭建BI平台、低代码平台以及两者之间的跨平台数据交换通道；S1. Build a BI platform, a low-code platform and a cross-platform data exchange channel between the two;

S2、用户登录低代码平台，发出数据传输请求；S2. The user logs in to the low-code platform and issues a data transmission request;

S3、BI平台对所有的源数据进行批量加工，并通过提前建立的数据模型对源数据进行分类，使其可视化，深度挖掘数据关系；S3 and BI platforms process all source data in batches and classify the source data through data models established in advance to visualize them and deeply mine data relationships;

S4、BI平台确定需要传输的数据类型和格式，配置数据交换协议和相关参数，建立带数据层级关系的智能分析报表；S4. The BI platform determines the data type and format that needs to be transmitted, configures the data exchange protocol and related parameters, and establishes an intelligent analysis report with data hierarchical relationships;

S5、跨平台数据交换通道建立BI平台和低代码平台之间的连接，供对应的智能分析报表数据传输，在传输过程中对数据的安全性进行监测；S5. The cross-platform data exchange channel establishes a connection between the BI platform and the low-code platform to provide corresponding intelligent analysis report data transmission and monitor the security of the data during the transmission process;

S6、低代码平台编写数据传输和转换代码，对智能分析报表数据进行翻译，实现传输目标数据以及与目标数据相关联的数据关系。S6. The low-code platform writes data transmission and conversion codes, translates intelligent analysis report data, and realizes the transmission of target data and data relationships associated with the target data.

需要进一步说明的是，BI平台上设置有数据处理引擎，数据处理引擎可以存储、处理和保护数据，通过使用SQL Server Management Studio生成数据库项目，再通过数据处理引擎对源数据进行表关系定义、维度定义、度量定义，并进行MDX计算和ETL计算，同时通过多维数据进行切片、块、旋转等动作剖析数据，最终得到可视化数据集。It should be further explained that the BI platform is equipped with a data processing engine. The data processing engine can store, process and protect data. It uses SQL Server Management Studio to generate database projects, and then uses the data processing engine to define table relationships and dimensions for the source data. Definition, measurement definition, and MDX calculation and ETL calculation. At the same time, the data is analyzed through multi-dimensional data slicing, block, rotation and other actions, and finally a visual data set is obtained.

需要进一步说明的是，低代码平台搭建时需要确定自定义的表单、流程和服务规则，例如表单的字段、字段类型和配置属性，而流程包括工作流和审核流，工作流负责将多个表单关联起来，可以做到表单联动，审核流是在单个表单中，实现表单审核状态变化。此外低代码平台上还需要建立翻译以及代码资源库，对传输后的智能分析报表数据进行精准转化。What needs further explanation is that when building a low-code platform, you need to determine customized forms, processes and service rules, such as form fields, field types and configuration properties. The process includes workflow and review flow. The workflow is responsible for combining multiple forms. By association, form linkage can be achieved, and the review flow is in a single form to realize changes in the form review status. In addition, a translation and code resource library needs to be established on the low-code platform to accurately transform the transmitted intelligent analysis report data.

需要进一步说明的是，用户通过发送公钥，进入低代码平台，接着发送私钥，解锁保密协议文件，确认数据传输等级。数据传输等级需要提前建立用户等级名单。并对不同等级的用户派发对应的公钥和私钥，通过公钥-私钥配合，对用户进行身份验证以及文件传输限制。It should be further explained that the user enters the low-code platform by sending the public key, and then sends the private key to unlock the confidentiality agreement file and confirm the data transmission level. Data transmission levels require a user level list to be established in advance. Corresponding public keys and private keys are distributed to users of different levels. Through the cooperation of public key and private key, users are authenticated and file transfer restrictions are implemented.

实施例Example

如图1所示，本发明提出的一种基于BI平台的低代码平台数据传输方法，步骤如下：As shown in Figure 1, the present invention proposes a low-code platform data transmission method based on BI platform. The steps are as follows:

S1、搭建BI平台、低代码平台以及两者之间的跨平台数据交换通道；S1. Build a BI platform, a low-code platform and a cross-platform data exchange channel between the two;

S2、用户登录低代码平台，发出数据传输请求；S2. The user logs in to the low-code platform and issues a data transmission request;

S3、BI平台对所有的源数据进行批量加工，并通过提前建立的数据模型对源数据进行分类，使其可视化，深度挖掘数据关系；S3 and BI platforms process all source data in batches and classify the source data through data models established in advance to visualize them and deeply mine data relationships;

S4、BI平台确定需要传输的数据类型和格式，配置数据交换协议和相关参数，建立带数据层级关系的智能分析报表；S4. The BI platform determines the data type and format that needs to be transmitted, configures the data exchange protocol and related parameters, and establishes an intelligent analysis report with data hierarchical relationships;

S5、跨平台数据交换通道建立BI平台和低代码平台之间的连接，供对应的智能分析报表数据传输，在传输过程中对数据的安全性进行监测；S5. The cross-platform data exchange channel establishes a connection between the BI platform and the low-code platform to provide corresponding intelligent analysis report data transmission and monitor the security of the data during the transmission process;

S6、低代码平台编写数据传输和转换代码，对智能分析报表数据进行翻译，实现传输目标数据以及与目标数据相关联的数据关系。S6. The low-code platform writes data transmission and conversion codes, translates intelligent analysis report data, and realizes the transmission of target data and data relationships associated with the target data.

需要进一步说明的是，BI平台上设置有数据处理引擎，数据处理引擎可以存储、处理和保护数据，通过使用SQL Server Management Studio生成数据库项目，再通过数据处理引擎对源数据进行表关系定义、维度定义、度量定义，并进行MDX计算和ETL计算，同时通过多维数据进行切片、块、旋转等动作剖析数据，最终得到可视化数据集。It should be further explained that the BI platform is equipped with a data processing engine. The data processing engine can store, process and protect data. It uses SQL Server Management Studio to generate database projects, and then uses the data processing engine to define table relationships and dimensions for the source data. Definition, measurement definition, and MDX calculation and ETL calculation. At the same time, the data is analyzed through multi-dimensional data slicing, block, rotation and other actions, and finally a visual data set is obtained.

需要进一步说明的是，低代码平台搭建时需要确定自定义的表单、流程和服务规则，例如表单的字段、字段类型和配置属性，而流程包括工作流和审核流，工作流负责将多个表单关联起来，可以做到表单联动，审核流是在单个表单中，实现表单审核状态变化。此外低代码平台上还需要建立翻译以及代码资源库，对传输后的智能分析报表数据进行精准转化。What needs further explanation is that when building a low-code platform, you need to determine customized forms, processes and service rules, such as form fields, field types and configuration properties. The process includes workflow and review flow. The workflow is responsible for combining multiple forms. By association, form linkage can be achieved, and the review flow is in a single form to realize changes in the form review status. In addition, a translation and code resource library needs to be established on the low-code platform to accurately transform the transmitted intelligent analysis report data.

需要进一步说明的是，用户通过发送公钥，进入低代码平台，接着发送私钥，解锁保密协议文件，确认数据传输等级。数据传输等级需要提前建立用户等级名单。并对不同等级的用户派发对应的公钥和私钥，通过公钥-私钥配合，对用户进行身份验证以及文件传输限制。It should be further explained that the user enters the low-code platform by sending the public key, and then sends the private key to unlock the confidentiality agreement file and confirm the data transmission level. Data transmission levels require a user level list to be established in advance. Corresponding public keys and private keys are distributed to users of different levels. Through the cooperation of public key and private key, users are authenticated and file transfer restrictions are implemented.

如图2所示，数据模型工作方法如下：As shown in Figure 2, the data model works as follows:

a、通过数据源接口与各个数据集建立动态连接，根据数据传输等级，筛选相关数据；a. Establish dynamic connections with each data set through the data source interface, and filter relevant data according to the data transmission level;

b、接着对筛选的数据进行校正、统一格式，并创建智能分析报表；b. Then correct and unify the format of the filtered data, and create intelligent analysis reports;

c、最后将对应的智能分析报表发送至跨平台数据交换通道。c. Finally, send the corresponding intelligent analysis report to the cross-platform data exchange channel.

本实施例中结合BI平台的可视化性能，通过数据模型建立智能分析报表，实现多维度的深度挖掘数据关系。In this embodiment, the visualization performance of the BI platform is combined to establish intelligent analysis reports through the data model to achieve multi-dimensional deep mining of data relationships.

需要进一步说明的是，低代码平台实时获取用户端的指令以及数据传输相关信息，并生成树形结构的日志信息。便于后续查询和自检。What needs further explanation is that the low-code platform obtains the user's instructions and data transmission-related information in real time, and generates tree-structured log information. Convenient for subsequent inquiries and self-checks.

需要进一步说明的是，跨平台数据交换通道进行数据传输时需要对数据源进行验证，确认其IP地址以及通信端口信息，还需要对不安全数据进行筛查。It should be further explained that when transmitting data through cross-platform data exchange channels, the data source needs to be verified, its IP address and communication port information need to be confirmed, and unsafe data needs to be screened.

需要进一步说明的是，跨平台数据交换通道内设置安全监测中心，通过对BI平台和低代码平台每个连接节点的传输数据进行监测，提取异常特征数据；在出现异常特征数据时，对该数据的连接节点进行定位，并对异常传输进行强制中断。例如通过在连接节点处链接钩子子程序，在访问异常情况下，生成对应类型的钩子函数，对异常访问数据进行捕获，达到快速阻拦和隔离的目的。It should be further explained that a security monitoring center is set up in the cross-platform data exchange channel to extract abnormal characteristic data by monitoring the transmission data of each connection node of the BI platform and low-code platform; when abnormal characteristic data occurs, the data The connection node is located and the abnormal transmission is forced to interrupt. For example, by linking the hook subroutine at the connection node, in the event of abnormal access, a corresponding type of hook function is generated to capture the abnormal access data to achieve the purpose of rapid blocking and isolation.

上面结合附图对本发明的实施方式作了详细说明，但是本发明并不限于此，在所属技术领域的技术人员所具备的知识范围内，在不脱离本发明宗旨的前提下还可以作出各种变化。The embodiments of the present invention have been described in detail above with reference to the accompanying drawings. However, the present invention is not limited thereto. Within the scope of knowledge possessed by those skilled in the art, various modifications can be made without departing from the spirit of the present invention. Variety.

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.
CN202311155188.2A 2023-09-08 2023-09-08 Low-code platform data transmission method based on BI platform Pending CN116881983A (en)

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)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN118245551A (en) * 2024-05-28 2024-06-25 杭州跃翔科技有限公司 A low-code platform data transmission method and system based on BI platform
CN119577222A (en) * 2024-09-04 2025-03-07 中科赛德（北京）科技有限公司 A cross-platform data acquisition system and method

Citations (5)

* Cited by examiner, † Cited by third party
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

Patent Citations (5)

* Cited by examiner, † Cited by third party
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

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN118245551A (en) * 2024-05-28 2024-06-25 杭州跃翔科技有限公司 A low-code platform data transmission method and system based on BI platform
CN119577222A (en) * 2024-09-04 2025-03-07 中科赛德（北京）科技有限公司 A cross-platform data acquisition system and method

Similar Documents

Publication Publication Date Title
CN116881983A (en) Low-code platform data transmission method based on BI platform
US8365195B2 (en) Systems and methods for generating sets of model objects having data messaging pipes
US11487772B2 (en) Multi-party data joint query method, device, server and storage medium
CN111614696B (en) A network security emergency response method and system based on knowledge graph
CN113114498A (en) Architecture system of trusted block chain service platform and construction method thereof
CN108665248A (en) BIM-based building information integrated management system and construction method
US20080256172A1 (en) Tracing of collaborative workflows
CN111198914A (en) Whole database real-time data acquisition method based on oracle database filing log
CN112835784B (en) Method for evaluating and optimizing interoperation capacity of complex giant system
WO2020042504A1 (en) Method and apparatus for diagnosing exception in blockchain information processing, device, and storage medium
CN116861708B (en) Method and device for constructing multidimensional model of production equipment
CN116415203A (en) Government information intelligent fusion system and method based on big data
CN114706839A (en) Log data processing method and device, electronic equipment and storage medium
CN106920022B (en) Safety vulnerability assessment method, system and equipment for cigarette industrial control system
CN117951341A (en) Block chain-based service processing method, device, equipment, medium and product
CN107341608A (en) One kind production basic data index analysis method
CN119004000A (en) Parallel preprocessing analysis system based on big data algorithm and application method
US9336408B2 (en) Solution for continuous control and protection of enterprise data based on authorization projection
CN103295102A (en) Construction method applicable to multi-hierarchical flat information management systems
CN117667065A (en) A low-code application configuration platform
Ashrafi et al. A data mining architecture for distributed environments
CN113032089B (en) Distributed simulation service construction method based on API gateway
CN110633269A (en) Standardization method of equipment parameter data based on Tableau
CN117061560A (en) Audit method, audit device, electronic equipment and readable storage medium
KR102403881B1 (en) Apparatus and method for visualizing causality of events

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
RJ01 Rejection of invention patent application after publication

Application publication date: 20231013