Data integration strategy configuration method, data integration method, device, equipment and storage medium

Abstract

The present disclosure provides a data integration strategy configuration method, a data integration method, an apparatus, a device and a storage medium, wherein the method comprises obtaining a data structure of a data source based on an access credential of the data source, configuring a data structure of an external object for the data structure of the data source, and a mapping relationship between the data structure of the external object and the data structure of the data source. The disclosed method can reduce data management costs and maintenance costs while satisfying the access rights requirements of the data source, thereby facilitating data communication and data consumption, and reducing virtual integration costs.

Description

Technical Field

[0001] The present invention relates to the field of Internet technology, and in particular to a data integration strategy configuration method, a data integration method, a device, a equipment and a storage medium. Background Art

[0002] When developers build a data management system, they may need to consume data from other systems. In related technologies, the interaction interface between the data management system and other systems can be agreed in advance, and data can be exchanged through network communication or other means. However, the versatility of this data interaction solution is relatively poor. If other systems that interact with the data management system need to be changed, the interface needs to be redesigned and developed, resulting in a relatively high virtual integration cost. Summary of the invention

[0003] According to one aspect of the present disclosure, a method for configuring a data integration strategy is provided, characterized by comprising:

[0004] Acquire a data structure of the data source based on access credentials of the data source;

[0005] The data structure of the external object is configured for the data structure of the data source, and there is a mapping relationship between the data structure of the external object and the data structure of the data source.

[0006] According to another aspect of the present disclosure, there is provided a data integration method, comprising:

[0007] In response to a data query request for an external object, generating a request parameter of the data query request that complies with public protocol requirements based on a mapping relationship between a data structure of the external object and a data structure of a data source;

[0008] Requesting the data source to return data from the data source based on the access credentials of the data source and the request parameters that meet the requirements of the public protocol;

[0009] Based on the mapping relationship between the data structure of the external object and the data structure of the data source, the data returned by the data source is displayed in the data structure of the external object.

[0010] According to another aspect of the present disclosure, a data integration strategy configuration device is provided, comprising:

[0011] An acquisition module, configured to acquire a data structure of a data source based on an access credential of the data source;

[0012] The configuration module is used to configure the data structure of the external object for the data structure of the data source, and there is a mapping relationship between the data structure of the external object and the data structure of the data source.

[0013] According to another aspect of the present disclosure, there is provided a data integration device, comprising:

[0014] A generating module, configured to generate, in response to a data query request for an external object, a request parameter of the data query request that complies with public protocol requirements based on a mapping relationship between a data structure of the external object and a data structure of a data source;

[0015] A communication module, configured to request the data source to return data from the data source based on the access credentials of the data source and the request parameters that meet the requirements of the public protocol;

[0016] The display module is used to display the data returned by the data source in the data structure of the external object based on the mapping relationship between the data structure of the external object and the data structure of the data source.

[0017] According to another aspect of the present disclosure, there is provided an electronic device, comprising:

[0018] processor; and,

[0019] A memory for storing programs;

[0020] The program includes instructions, which, when executed by the processor, cause the processor to perform the method according to the exemplary embodiment of the present disclosure.

[0021] According to another aspect of the present disclosure, a non-transitory computer-readable storage medium is provided, wherein the non-transitory computer-readable storage medium stores computer instructions, and the computer instructions are used to enable the computer to execute the method described in the exemplary embodiments of the present disclosure.

[0022] One or more technical solutions provided in the embodiments of the present disclosure, when obtaining the data structure of the data source based on the access credentials of the data source, the system where the data source is located can be entered by the access credentials while meeting the access rights requirements of the data source, so that the data structure of the data source can be read from the data source using the public data interface. On this basis, the data structure of the external object is configured for the data structure of the data source, so that there is a mapping relationship between the data structure of the external object and the data structure of the data source. At this time, when the data of the data source is consumed using the external object, the data source data displayed according to the data structure of the external object can be obtained by the mapping relationship between the data structure of the external object and the data structure of the data source in response to the data query request, using the public data interface as the interactive interface and the access credentials as the basis, so as to consume the data source data normally. It can be seen that the method of the exemplary embodiment of the present disclosure does not need to design and develop a data interface specifically for the data source, and directly integrates and accesses virtual data through the public data interface. Therefore, the method of the exemplary embodiment of the present disclosure can reduce the data management cost and maintenance cost while meeting the access rights requirements of the data source, thereby facilitating data communication and consumption of data, and reducing the virtual integration cost. BRIEF DESCRIPTION OF THE DRAWINGS

[0023] Further details, features and advantages of the present disclosure are disclosed in the following description of exemplary embodiments in conjunction with the accompanying drawings, in which:

[0024] Figure 1 A schematic flow chart showing a method for configuring a data integration strategy according to an exemplary embodiment of the present disclosure;

[0025] Figure 2A A schematic diagram showing a phased process of creating a credential according to an exemplary embodiment of the present disclosure Figure 1 ;

[0026] Figure 2B A second schematic diagram showing a phased process of creating a credential according to an exemplary embodiment of the present disclosure is shown;

[0027] Figure 3A The schematic diagram shows the stages of the external object creation process of the exemplary embodiment of the present disclosure. Figure 1 ;

[0028] Figure 3B A second schematic diagram of the stage structure of the external object creation process of the exemplary embodiment of the present disclosure is shown;

[0029] Figure 3C A third schematic diagram showing a phased process of creating an external object according to an exemplary embodiment of the present disclosure;

[0030] Figure 4 A schematic diagram showing a mapping relationship configuration process of an exemplary embodiment of the present disclosure is shown;

[0031] Figure 5 A schematic diagram showing a field setting interface of an exemplary embodiment of the present disclosure is shown;

[0032] Fig. 6A A schematic diagram showing a display state of an object editing interface in a first editing sub-interface of an exemplary embodiment of the present disclosure is shown;

[0033] Figure 6B A schematic diagram showing a display state of an object editing interface in a second editing sub-interface of an exemplary embodiment of the present disclosure is shown;

[0034] Figure 7 A schematic diagram showing an error page of an exemplary embodiment of the present disclosure;

[0035] Figure 8 A schematic flow chart showing the second data attribute deletion of an exemplary embodiment of the present disclosure;

[0036] Fig. 9A The following is a schematic diagram showing a stage-by-stage process of deleting the second data attribute of an exemplary embodiment of the present disclosure. Figure 1 ;

[0037] Fig. 9B A second stage schematic diagram showing a second data attribute deletion process of an exemplary embodiment of the present disclosure;

[0038] Fig. 9C A schematic diagram showing a deletion failure bullet box according to an exemplary embodiment of the present disclosure is shown;

[0039] Fig.10 A schematic flow chart showing a data integration method according to an exemplary embodiment of the present disclosure is shown;

[0040] Fig.11 A schematic diagram of a data integration architecture of an exemplary embodiment of the present disclosure is shown;

[0041] Fig.12 A schematic block diagram showing functional modules of a device for configuring a data integration strategy according to an exemplary embodiment of the present disclosure is shown;

[0042] Fig.13 A schematic block diagram of functional modules of a data integration device according to an exemplary embodiment of the present disclosure is shown;

[0043] Fig.14 A schematic block diagram of a chip according to an exemplary embodiment of the present disclosure is shown;

[0044] Fig.15 A structural block diagram of an exemplary electronic device that can be used to implement the embodiments of the present disclosure is shown. DETAILED DESCRIPTION

[0045] Embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although certain embodiments of the present disclosure are shown in the accompanying drawings, it should be understood that the present disclosure can be implemented in various forms and should not be construed as being limited to the embodiments described herein, which are instead provided for a more thorough and complete understanding of the present disclosure. It should be understood that the drawings and embodiments of the present disclosure are only for exemplary purposes and are not intended to limit the scope of protection of the present disclosure.

[0046] It should be understood that the various steps described in the method embodiments of the present disclosure may be performed in different orders and / or in parallel. In addition, the method embodiments may include additional steps and / or omit the steps shown. The scope of the present disclosure is not limited in this respect.

[0047] The term "including" and its variations used in this document are open inclusions, that is, "including but not limited to". The term "based on" means "based at least in part on". The term "one embodiment" means "at least one embodiment"; the term "another embodiment" means "at least one other embodiment"; the term "some embodiments" means "at least some embodiments". Relevant definitions of other terms will be given in the description below. It should be noted that the concepts of "first", "second", etc. mentioned in this disclosure are only used to distinguish different devices, modules or units, and are not used to limit the order or interdependence of the functions performed by these devices, modules or units.

[0048] It should be noted that the modifications of "one" and "plurality" mentioned in the present disclosure are illustrative rather than restrictive, and those skilled in the art should understand that unless otherwise clearly indicated in the context, it should be understood as "one or more".

[0049] The names of the messages or information exchanged between multiple devices in the embodiments of the present disclosure are only used for illustrative purposes and are not used to limit the scope of these messages or information.

[0050] Before introducing the embodiments of the present disclosure, the following definitions are given for the terms involved in the embodiments of the present disclosure:

[0051] Virtual integration refers to a method by which users can reduce their own vertical integration as much as possible and make the most of external resources.

[0052] Application Platform as a Service (aPaaS) is a category of cloud-based software that provides users with a platform to develop, deploy, and manage applications without the complexity of building and maintaining the infrastructure typically associated with developing and launching applications.

[0053] A data structure refers to a collection of data elements that have one or more specific relationships between them, that is, a collection of data elements with "structure".

[0054] A field describes a certain feature of a document, namely a data item, and has a unique field identifier for computer recognition, also known as a data attribute.

[0055] A unique key refers to an attribute or attribute group that can uniquely identify each instance in an entity set or relationship set. A field is a smaller unit than a record, and a set of fields constitutes a record.

[0056] An exemplary embodiment of the present disclosure provides a method for configuring a data integration policy, which can be executed by an electronic device or a chip applied to an electronic device to reduce data management costs and maintenance costs while satisfying access rights requirements of a data source, thereby effectively reducing virtual integration costs.

[0057] The electronic device of the exemplary embodiment of the present disclosure has a networking function and can be connected to an external data source in the same network. The electronic device can have a display function, including but not limited to vehicle-mounted devices, laptops, ultra-mobile personal computers 5 (ultra-mobile personal computers, UMPCs), netbooks, PDAs, and wearable devices based on augmented reality (AR) and / or virtual reality (VR) technology, etc.

[0058] For example, when the user device is a wearable device, the wearable device can also be a general term for wearable devices that are intelligently designed and developed by applying wearable technology to daily wear, such as glasses, gloves, watches, clothing and shoes. A wearable device is a portable device that is worn directly on the body or integrated into the user's clothes or accessories.

[0059] The electronic device of the exemplary embodiment of the present disclosure has a platform for building a data integration system, such as an aPaaS platform, and uses the aPaaS platform to build a data integration system. In the data integration system, application products can be built to allow developers to virtually integrate external data sources without code, thereby reducing data management costs and maintenance costs while meeting the access rights requirements of the data source, thereby facilitating data communication and reducing virtual integration costs. The data model of the external data source and the data model of the external object in the data integration system can also be defined based on a public protocol to conveniently complete data communication without the need to repeatedly develop interfaces.

[0060] Figure 1 FIG. 1 is a schematic flow chart showing a method for configuring a data integration strategy of an exemplary embodiment of the present disclosure. Figure 1As shown, the configuration method of the data integration strategy of the exemplary embodiment of the present disclosure may include:

[0061] Step 101: Obtain the data structure of the data source based on the access credentials of the data source. The data source here can be an external data source. The data integration platform can access the system where the data source is located by using the access credentials if the data source's access permission requirements are met. Therefore, the data integration platform can use the public data interface to read the data structure of the data source from the data source. It should be understood that the public data interface may include but is not limited to an Open Data Protocol (OData) interface, a database direct connection interface such as a Java Database Connectivity interface, and the like.

[0062] In practical applications, the method of the exemplary embodiment of the present disclosure can create an external object using the access credentials of the data source to support the service of the public protocol as the external data source, and map the data model (schema) of the public protocol to the data model of the internal and external objects of the data integration platform. That is, when the data integration platform and the external data source are established in communication with the public protocol, the data integration platform can obtain the data structure of the data source according to the data model of the public protocol.

[0063] The exemplary embodiment of the present disclosure can declare access credentials based on the data source. The access credentials can be used as credentials for public data interfaces such as OData to access the data source, so as to achieve normal communication between the data integration platform and the data source, thereby ensuring that the data integration platform can successfully access the data source through the public data interface. The access credentials may include a credential identifier and credential information. The credential identifier serves as a credential label to distinguish it from other credentials, and the credential information serves as legal data source access verification information.

[0064] Step 102: The data structure of the external object is configured for the data structure of the data source, and there is a mapping relationship between the data structure of the external object and the data structure of the data source. After the operation of configuring the data structure of the external object for the data structure of the data source is completed, the created external object can be updated in the object list. For easy distinction, the external object record can be marked in the object list, and when the mouse hovers over the external object record, a description can be displayed, describing the external object references to data of the external system and other similar content.

[0065] When using external objects to consume data from a data source, you can respond to data query requests, use the public data interface as the interaction interface, and use access credentials as the basis to obtain the data structure of the external object through the mapping relationship between the data structure of the external object and the data structure of the data source, thereby consuming the data source data normally.

[0066] It can be seen that the method of the exemplary embodiment of the present disclosure does not require special design and development of data interfaces for data sources, and virtual data integration and access are directly performed through public data interfaces as interactive interfaces. Therefore, the method of the exemplary embodiment of the present disclosure can reduce data management costs and maintenance costs while satisfying the access rights requirements of the data source, thereby facilitating data communication and data consumption and reducing virtual integration costs.

[0067] In an optional manner, the credential identification of the exemplary embodiment of the present disclosure may include a primary credential identification as a credential label, and may also include a secondary credential identification, or may include a primary credential identification and a secondary credential identification. The primary credential label may be considered as the name of the credential, which supports a name in one language or multiple languages, and the secondary credential identification may be considered as a unique positioning symbol of the credential. When the primary credential identification cannot uniquely determine the access credential, the primary credential identification and the secondary credential identification may be combined to jointly determine the access credential.

[0068] The above-mentioned credential information, as access credentials and authentication information for accessing the data source, may include data location parameters and permission verification information. If the data source is an open data source that does not require login, the credential information may include the data source address (i.e., Uniform Resource Locator, abbreviated as URL); if the data source is a data source that requires password verification, the credential information includes not only the URL of the data source, user name and password.

[0069] Exemplarily, the parameters used by the access credentials of the exemplary embodiments of the present disclosure in the development environment and the online environment may be the same or different, and these parameters may be the content contained in the credential information. Here, the development environment may refer to the environment for creating credentials, external objects, and establishing pages, and the online environment may refer to the scenario in which other user terminals access the application after the application is developed and released.

[0070] For example, when the parameters used by the access credentials in the development environment and the online environment are divided into two sets of parameters, the development environment and the online environment, they are saved in the data integration system respectively, so that subsequent external objects can call them in the development environment and the online environment. In other words, when performing virtual integration and testing in the development environment, the development environment parameters of the access credentials can be used to obtain the data format for configuration or the data details for display and consumption. When performing display and consumption in the online environment, the online environment parameters of the access credentials can be used to obtain the data details for display and consumption. In addition, when the development environment is released, it is possible to verify whether the data formats of the development environment parameters and the online environment parameters are consistent, thereby ensuring that the online environment can run as smoothly as the development environment.

[0071] In order to facilitate understanding of the credential creation process of the exemplary embodiment of the present disclosure, the following examples are illustrated with reference to the accompanying drawings. It should be understood that the following examples are only used to explain the credential creation process, and in actual scenarios, the credential creation process can be presented in various forms, not limited to the following examples.

[0072] Figure 2A A schematic diagram showing a phased process of creating a credential according to an exemplary embodiment of the present disclosure Figure 1 , Figure 2B FIG2 shows a schematic diagram of a phased process of creating a credential according to an exemplary embodiment of the present disclosure. Figure 2A As shown, the integrated credential tab can be selected in the application interface 200 of the data integration platform to display the integrated credential interface 201. The local integration tab, the third-party integration tab, and the API credential management interface tab can be displayed in the integrated credential interface 201. By selecting the third-party integration tab, a new control as a credential creation entry can be displayed. Clicking the new control can pop up the initial page 202 of the new credential. The initial page 202 of the new credential can display the operation instructions for creating the credential, for example: "Step 1 / 2: Select the credential connection service". The credential creation process can be ended by canceling the control, or by clicking the next control to enter Figure 2B The credential filling pop-up box 204 is shown.

[0073] like Figure 2B As shown, the credential filling pop-up box 204 of the exemplary embodiment of the present disclosure displays a credential identification filling unit and a credential information filling unit, and can also display the current operation instructions of the credential filling pop-up box 204, for example: "Step 2 / 2: Fill in credential information".

[0074] The above-mentioned credential identification filling unit includes a name tag and an API name tag. These tags are configured with a filling box for filling in the corresponding tag content. These tag contents can be user-defined content or randomly assigned content by the data integration system. The name of the exemplary embodiment of the present disclosure serves as the main credential identification, and can be in Chinese and English. For example, you can directly fill in the Chinese name in the filling box with the "Chinese" mark below the name, and you can also add an English filling box for the name through the Add English control below, and enter the English name in it. The API name tag serves as an auxiliary credential identification and has the function of a unique positioning symbol to ensure the uniqueness of the access credential.

[0075] The above-mentioned credential information filling unit includes a data source URL tag, a user name tag and a password tag, and these tags are all configured with a filling box for filling in the corresponding tag content. These tag contents all come from the data source. The URL filled in the filling box of the data source URL tag here can be a manually entered URL or a URL automatically filled in by the data integration system. In addition, the credential information filling unit can also display relevant instructions for the credential information, for example: it can explain whether the credential information used in the online environment and the development environment is the same, etc.

[0076] For example, if Figure 2A As shown, a data source selection entry 203 is displayed on the initial page 202 of the new credential. The data source to be connected to the credential can be selected by clicking the data source selection entry 203, so that the data integration system can determine the data source URL based on the selected data source. Figure 2B When filling in the credential pop-up box 204 shown, the data integration system can automatically fill in the specific content of the data source URL in the filling box of the data source URL label based on the determined data source URL.

[0077] Considering that some data sources may provide free public accounts to users such as trial users, Figure 2A As shown, after clicking the data source selection entry 203 to select the data source for the credential connection, the data integration system can also determine the account information of the data source based on the selected data source, which includes the user name and password. Figure 2B When filling in the credential pop-up box 204 shown, the data integration system can also automatically fill in the corresponding label content in the username label and the password label based on a free public account.

[0078] After completing the required label content in the credential filling pop-up box 204, you can click Submit and Test Control to test the filled label content to ensure that the data integration system can test whether the data source can be accessed based on the access credential. If the data source can be accessed successfully, it means that the access credential is created successfully and saved successfully. Otherwise, it means that there is a problem with the access credential and the access credential cannot be created successfully. At this time, the data integration system can pop up a reminder message that the access credential creation failed, so that the user can view and re-enter the required label.

[0079] Exemplarily, each label contained in the credential identification filling unit and the credential information filling unit may be marked as required, requiring the user to fill in the content in the filling boxes of these labels. For the label filling boxes without the required mark, the content may be filled in or not.

[0080] In some optional ways, the exemplary embodiments of the present disclosure may declare an external object of the data integration system according to the selected data source. In this case, obtaining the data structure of the data source based on the access credentials of the data source may include:

[0081] In response to an operation of selecting an access credential, if the access credential is a valid access credential, a target data table of the data source is determined based on the access credential, a data structure of the target data table is obtained based on the access credential, and a data structure of the data source is obtained based on the target data table. The data structure of the target data table may be a data structure of the data source.

[0082] In actual applications, after selecting the access credentials, the access credentials can be automatically verified to determine whether there is a network failure or the data table of the data source cannot be queried. If the access credentials are successfully verified, the various data tables contained in the data source can be obtained from the data source based on the access credentials. Otherwise, it means that there is a network failure or the data table of the data source cannot be queried. The data integration system displays an error message, prompting "Credential verification failed, please check the credentials" and other related information.

[0083] If there is one data table, it can be directly determined as the target data table. If there are multiple data tables, one needs to be selected from the multiple data tables as the target data table. Based on this, there is a one-to-one correspondence between the data table and the external object. Based on this, after an external object is created based on the target data table, another external object cannot be created using the target data table. It can be seen that when there are multiple data tables, the multiple data tables may include optional data tables and non-optional data tables. Based on the access credentials, at least multiple data tables of the data source are displayed, and the multiple data tables include optional data tables and non-optional data tables. Based on this, when there are multiple data tables of the data source, the process of determining the target data table of the data source based on the access credentials may include:

[0084] In response to a selection operation on an optional data table among the multiple data tables, a target data table of the data source corresponding to the external object is determined. For an unselectable data table, the unselectable data table can be grayed out, marked or locked so that a selection operation cannot be performed on the unselectable data table, thereby avoiding the situation where the unselectable data table is defined as a target data table.

[0085] The exemplary embodiment of the present disclosure can also fill in the basic information of the external object, for example, the identifier of the external object, the identifier of the external object can be divided into the object main identifier and the object auxiliary identifier, the object main identifier can support one language, and can also support multiple languages.

[0086] In order to facilitate understanding of the external object creation process of the exemplary embodiment of the present disclosure, the following examples are illustrated in conjunction with the accompanying drawings. It should be understood that the following examples are only used to explain the external object creation process, and in actual scenarios, the external object creation process can be presented in various forms, not limited to the following examples.

[0087] Figure 3A The schematic diagram shows the stages of the external object creation process of the exemplary embodiment of the present disclosure. Figure 1 , Figure 3B FIG2 shows a schematic diagram of the stage structure of the external object creation process of the exemplary embodiment of the present disclosure. Figure 3A As shown, the data model tab can be selected in the application interface 300 of the data integration platform to display the object creation interface 301. The object creation interface 301 can display a new control as an object creation entry. Click the new control to pop up the initial interface 302 of the new object. The initial interface 302 of the new object can create both a blank object and an external object. You can click the external object new label to jump to Figure 3B The external object basic information editing page 303 is shown.

[0088] like Figure 3B As shown, on the external object basic information editing page 303, the label content can be filled in the name label and API label filling box, and the name label supports bilingual naming in Chinese and English. At the same time, the credential drop-down box 304 can be displayed by clicking the drop-down button on the right side of the credential label filling box, and an access credential displayed in the credential drop-down box 304 can be filled in the credential label filling box. If the required access credential does not exist in the credential drop-down box 304, a new access credential can be created by clicking the add control displayed in the credential drop-down box 304. It can be seen that the access credential creation process of the exemplary embodiment of the present disclosure can be implemented in two ways, one is to create a new access credential through the integrated credential interface, and the other is to create a new access credential in the add control of the credential drop-down box 304 of the external object basic information editing page 303. This process of creating new access credentials can actually be done by low-code means.

[0089] like Figure 3B As shown, in the exemplary embodiment of the present disclosure, after selecting access credentials in the credential drop-down box 304, if the data integration platform can access the data source through the access credentials, if there is a data table in the data source, it can be automatically filled in the filling box of the data source label; if there are multiple data tables in the data source, they can be displayed and selected using the data table drop-down box.

[0090] Figure 3C FIG3 shows a schematic diagram of the stages of the external object creation process of the exemplary embodiment of the present disclosure. Figure 3CAs shown, when multiple data tables are obtained based on the access credentials, the drop-down control on the right side of the fill-in box of the data source label can be clicked to display the data table drop-down box 305. Considering that there is a one-to-one correspondence between data tables and external objects, if there is a data table with an external object created in the data table list displayed in the data table drop-down box 305, the data table can be marked as a used data table. The marking method can include but is not limited to text marking, graphic marking or voice marking. After completing the credential filling, data table selection and external object identification filling, you can jump to the field setting interface for subsequent processes.

[0091] In an optional manner, the data structure of the data source of the embodiment of the present disclosure may include multiple first data attributes, the data structure of the external object may include at least one second data attribute, and at least one of the multiple first data attributes has a mapping relationship with the second data attribute. In other words, the second data attribute may be mapped to each of the multiple first data attributes, or the second data attribute may be mapped to some of the multiple first data attributes. The mapping relationship here may be a one-to-one mapping relationship.

[0092] In actual applications, the first data attribute is essentially the first field in the data table stored in the data source, and the second data attribute is essentially the first field customized in the external object, and both the first field and the second field may include a field identifier and the field type of the field. Exemplarily, after determining the target data table of the data source based on the access credentials, the exemplary embodiment of the present disclosure may obtain the data structure of the target data table, that is, the data source definition, which contains the first field, from the data source based on the access credentials.

[0093] Figure 4 FIG. 1 is a schematic diagram showing a mapping relationship configuration process of an exemplary embodiment of the present disclosure. Figure 4 As shown, the exemplary embodiment of the present disclosure configures the data structure of the external object based on the data structure of the data source, which may include:

[0094] Step 401: Display multiple first data attributes of the data source based on the data structure of the data source. Since the data structure of the data source includes multiple first data attributes, all first data attributes of the data source can be displayed based on the data structure of the data source, and a selection control can be displayed for each first data attribute. By selecting the selection control, it can be determined whether to map the second data attribute to the first data attribute. A configuration box of the second data attribute can also be displayed for each first data attribute. The configuration box of the second data attribute can be located in the same row as the mapped first data attribute to form a record.

[0095] Step 402: In response to a selection operation on at least one of a plurality of first data attributes, determine at least one target data attribute of a data source.

[0096] The above selection control indicates that the first data attribute needs to be mapped, so when a selection operation is performed on one of the multiple first data attributes, it can be determined that the first data attributes need to be configured with a second data attribute that is mapped one-to-one with the first data attribute, for example, the name of the second data attribute can be customized for the name of the first data attribute, and the type of the second data attribute can be customized for the type of the first data attribute.

[0097] Step 403: configuring a second data attribute of an external object for each target data attribute, and each target data attribute has a corresponding relationship with the second data attribute.

[0098] In actual applications, in response to input operations, the second data attribute of the external object can be configured for each target data attribute, so that each target data attribute has a corresponding relationship with the second data attribute. Considering that the first data attribute and the second data attribute as the target data attribute both contain attribute identifiers and attribute types, when configuring the external object for the target data attribute, the field name and field type can be configured separately.

[0099] Considering that the data table has a unique key data attribute, which is not editable, multiple first data attributes contain a unique key data attribute, and at least one second data attribute contains a system default attribute that has a mapping relationship with the unique key data attribute. In other words, the second data attribute may contain a unique key field of the data source, but the unique key field is automatically generated by the system or is a default unique key field and cannot be edited. At this time, the system default attribute corresponding to the unique key data attribute may not be displayed.

[0100] The categories of data attributes of the exemplary embodiments of the present disclosure may include: floating point, string, text, associated object, Boolean, number, date, date and time, mailbox, associated object, etc. In order to increase the depth and breadth of data access, at least one second data attribute contains at least one second data attribute of associated object type. When the data type of the second data attribute is an associated object, it can be associated with any type of created object, such as a blank object, other application objects, etc.

[0101] The exemplary embodiments of the present disclosure may also configure a single-valued association object or a multi-valued association object for an association object. When an association object is configured as a single-valued association object, when accessing a data display page, one of the values ​​or multiple values ​​corresponding to the second field of the association object type has a hyperlink mark, and clicking on the value with the hyperlink mark can jump to its associated object. When an association object is configured as a single-valued association object, when accessing a data display page, two or more of the values ​​or multiple values ​​corresponding to the second field of the association object type have a hyperlink mark, and clicking on the value with the hyperlink mark can jump to the object associated with the value.

[0102] For example, when the second tag corresponding to the associated object is a name, a record corresponding to the name includes three names: Zhang San, Li Si, and Wang Er, wherein at least two of the three names have hyperlink identifiers, and detailed information of the corresponding names can be accessed through the hyperlink identifiers.

[0103] In order to facilitate understanding of the field setting process of the exemplary embodiment of the present disclosure, the following examples are illustrated in conjunction with the accompanying drawings. It should be understood that the following examples are only used to explain the external object creation process, and in actual scenarios, the external object creation process can be presented in various forms, not limited to the following examples.

[0104] Figure 5 FIG. 1 is a schematic diagram showing a field setting interface of an exemplary embodiment of the present disclosure. Figure 5 As shown, the field setting interface 501 in the application interface 500 of the data integration system displays a mapping relationship configuration table 502 formed by multiple records. The mapping relationship configuration table 502 may include four fields: whether to map, data source field, data source type, name and field type. The data source field and data source type are not editable. The system defaults to checking the box in front of each record to indicate that the field name and field type of the record need to be edited.

[0105] Users can selectively cancel the records that do not need to configure mapping relationships according to the records that do not need to configure mapping relationships, and then keep the check boxes of other records that need to configure mapping relationships checked. The record where the unique key data attribute (the first record) is located can be left unedited, and the system automatically assigns the default data attribute, whose attribute type can be a numeric type, as a system field that comes with the external object. When the field names and field types contained in all records that need to configure mapping relationships are configured, the field setting results can be submitted through the Submit button.

[0106] In order to further edit the external object, after submitting the field setting result, in response to the configuration completion operation of the mapping relationship between the first data attribute and the second data attribute, the relevant information of the external object and the relevant information corresponding to at least one second data attribute are edited.

[0107] The above-mentioned relevant information of the external object, as global information, may include the external object identifier and / or the data display method corresponding to the external object, and the relevant information corresponding to the second data attribute, as detailed information, may include the data type corresponding to the second data attribute and / or the data display method corresponding to the second data attribute.

[0108] In actual applications, the mapping relationship between the first data attribute and the second data attribute may not be stored in the library, but may be jumped to the external object editor. If the external object needs to be edited, it can be edited in the external object editor, and then confirmed and submitted, so that the mapping relationship between the first data attribute and the second data attribute is stored in the library. If the external object does not need to be edited, directly confirm and submit, so that the mapping relationship between the first data attribute and the second data attribute is stored in the library.

[0109] Exemplarily, the external object editor has an object editing interface, which can display the object editing interface in response to the configuration completion operation of the mapping relationship between the first data attribute and the second data attribute. The object editing interface is at least used to display a reference list, relevant information of the external object and relevant information corresponding to at least one second data attribute. The reference list can actually be a second data attribute list, and because there is a mapping relationship between the second data attribute and the first data attribute, the reference list can actually be regarded as a list reflecting the first data attribute with the mapping relationship.

[0110] Considering that there may be a first data attribute that is not configured with a second data attribute, the object editing interface can also be used to display a non-reference list, which includes a first data attribute that has no mapping relationship with the second data attribute, so that a new first data attribute is added to the reference list in the object editing interface, and the second data attribute is configured for the newly added first data attribute. Based on this, the method of the exemplary embodiment of the present disclosure may also include: in response to an operation on a first data attribute in the non-reference list, adding the first data attribute to the reference list, configuring the corresponding second data attribute in the external object for the first data attribute, so that the first data attribute in the reference list is converted to a second data attribute that has a mapping relationship with the first data attribute. The second data attribute here can be modified on the basis of the first data attribute, or the second data attribute mapped for the first data attribute can be configured separately elsewhere. After the second data attribute mapped for the first data attribute is configured separately elsewhere, the first data attribute in the reference list is converted to the second data attribute that has a mapping relationship with it.

[0111] For example, the above-mentioned object editing interface has a first editing sub-interface and a second editing sub-interface. The first editing sub-interface includes a list display area and a detail editing area. The list display area can be used to display a reference list and a non-reference list. The detail editing area can edit the relevant information of the external object, and even the relevant information corresponding to at least one second data attribute. For example: in response to a selection operation on the mapping relationship of the second data attribute, the relevant information of the external object can be edited in the detail editing area, thereby providing an entry for modifying the external object. The second editing sub-interface is used to display the relevant information of the external object and provide an entry for modifying the external object. If the type of the second data attribute is an associated object, the relevant information of the associated object can be edited in the detail editing area.

[0112] The first editing sub-interface and the second editing sub-interface can be switched with each other, as illustrated below. It should be understood that the following is only used for explanation and limitation, and various possible variations may exist in actual scenarios.

[0113] Fig. 6A A schematic diagram showing a display state of an object editing interface in a first editing sub-interface of an exemplary embodiment of the present disclosure is shown. Figure 6B A schematic diagram showing the object editing interface of an exemplary embodiment of the present disclosure in the second editing sub-interface display state is shown. Fig. 6A and Figure 6B As shown, the first editing sub-interface 601 and the second editing sub-interface 602 of the object editing interface 600. When the field label is clicked, the first editing sub-interface 601 can be displayed in the object editing interface 600, and when the setting label is clicked, the second editing sub-interface 602 can be displayed in the object editing interface 600.

[0114] like Fig. 6A As shown, the first editing sub-interface 601 may include a list display area 6011 and a detail editing area 6012. The list display area 6011 may display a reference list 6011a and a non-reference list 6011b, the reference list 6011a may be located above the non-reference list 6011b, and the non-reference list 6011b may be titled "unreferenced data source fields".

[0115] like Fig. 6AAs shown, the reference list 6011a includes all second data attributes, which actually indirectly reflects the first data attribute having a mapping relationship with the second data attribute, while the non-reference list includes the first data attribute not having a mapping relationship with the second data attribute. Therefore, the contents displayed by the reference list 6011a and the non-reference list 6011b can reflect that all fields of the data source are displayed in the list display area 6011. When it is necessary to add a new second data attribute to the reference list 6011a in the list display area 6011, it is actually to indirectly add the first data attribute to the reference list 6011a, and then edit the second data attribute mapped by the first data attribute.

[0116] For example, Fig. 6A As shown, if a first data attribute displayed in the non-reference list 6011b needs to be configured with a second data attribute mapped thereto, the add control (i.e., the "plus sign" control) of the first data attribute can be clicked to move the first data attribute to the reference list 6011a, or the first data attribute can be dragged to the reference list 6011a to move the first data attribute to the reference list 6011a.

[0117] like Fig. 6A As shown, when the first data attribute is moved to the reference list 6011a, the name and type of the first data attribute in the reference list 6011a can be edited, and the related content in the detail editing area 6012 can also be edited. For example, the two required items of the name of the external object and the API name can be edited in the detail editing area 6012. The name of the external object can include a Chinese name, an English name, or both a Chinese name and an English name. The data source field name and data source field type belong to the content provided by the data source and are non-editable content.

[0118] If the type of the second data attribute is an associated object, the object name of the associated object can be set, and the number of associated records can be set to be single or multiple, as well as options for displaying relationship records, for example, it can be selected that users can only search for associated records, etc. It should be understood that when setting the object name of the associated object, any type of object that has been created can be associated.

[0119] When you click the Settings tab, you can choose Fig. 6A The first editing sub-interface 601 shown switches to Figure 6BThe second editing sub-interface 602 is shown in the formula. In the second editing sub-interface, configuration items such as the name of the external object, API name, display name, auxiliary information when searching, and searchable fields can be displayed. In the second editing sub-interface 602, the name of the external object, API name, and auxiliary information when searching can be configured according to actual conditions. The display name is set to the identity identification number (Identity, ID) field by default, and can also be modified to other required text fields. If searchable fields are not supported, a reminder message can be displayed when the searchable field editing label is selected (such as the mouse hovers over the searchable field editing label): "The external object does not support configuration [searchable fields]. When searching, all fields of the object will be searched."

[0120] When the exemplary embodiment of the present disclosure detects that a newly added first data attribute exists in a data source, the newly added first data attribute is not configured to map the second virtual data, nor is it included in the non-reference list. Therefore, the non-reference list can be updated based on the newly added first data attribute, so that the first data attribute included in the non-mapping relationship table contains the newly added first data attribute, so that the application builder can promptly discover the increase in the first data attribute of the data source and decide whether the newly added first data attribute needs to be added to the reference list.

[0121] When it is detected that a first data attribute has been reduced in a data source, if there is no mapping relationship between the first data attribute and the second data attribute, it can be determined that the reduced first data attribute was originally in a non-reference list, and the non-reference list can be updated based on the reduced first data attribute so that the non-reference list does not contain the first data attribute that no longer exists in the data source, thereby avoiding the problem of subsequent pages being inaccessible due to the application builder failing to promptly obtain the reduction of data attributes of the data source and adding the first data attribute that no longer exists in the data source to the reference list.

[0122] When a data source has a changed first data attribute, if it contains a first data attribute that has a mapping relationship with a second data attribute, then when accessing the data source through an external object, the data cannot be obtained normally, and the data integration system will report an error, showing Figure 7 The error page 700 and similar messages are shown.

[0123] In order to ensure normal access to the data source, the method of the exemplary embodiment of the present disclosure may also include: detecting that there is a changed first data attribute in the data source, if the changed first data attribute contains a first data attribute having a mapping relationship with the second data attribute, displaying a prompt message with an object editing interface entrance, in response to an operation on the object editing interface entrance, displaying the object editing interface, and displaying the second data attribute mapped by deleting the changed first data attribute in the object editing interface.

[0124] In practical applications, the data source of the exemplary embodiment of the present disclosure may be changed by deleting the first data attribute, changing the name and / or type of the first data attribute, or even completely deleting the entire data table or data source. In this case, the mapping relationship between the first data attribute and the second data attribute is changed.

[0125] The above prompt message is used to prompt that the data source has changed. The following example describes the deletion of a field or the entire table in the data source.

[0126] When a data source deletes a field or the entire table is deleted, the App Engine robot can send a prompt message to the client to alert the developer and / or administrator of the external object. The prompt message can be as follows:

[0127] Title: Data source adjustment of external objects; Text: The upstream data source of "{object name}" in "{application name}" has changed, which has affected the normal operation of the application. Please make adjustments as soon as possible; Button: [Go to development background]; After clicking [Go to development background], you can jump to Fig. 6A An object editing interface 600 is shown.

[0128] In the object creation interface of the external object configuration background, a prompt message can be displayed to remind the application builder. The prompt message may include: the application uses unauthorized external object fields, and the application will not run normally. If you want to run the application normally, please disable the use of unauthorized fields and display the "View Details" button in the prompt message. Click the "View Details" button to jump to the following Fig. 6A An object editing interface 600 is shown.

[0129] If the data source fields of multiple external objects have been deleted, you can jump to the first external object on the object list page by default, click it, and view the "reference status of unauthorized fields" on the unauthorized field reference page.

[0130] The Unauthorized Field Reference page displays the usage of all reference fields whose permissions have been revoked in the development environment. Aggregate modules and reference locations by object and field. Click the "Go to Modification" button to jump to the following rules: Fig. 6A The object editing interface shown in the figure. The difference between the online environment and the development environment for the reference page of unauthorized fields is that a new "Go to development environment to modify" button is added in the prompt area at the top of the page. After clicking it, a new page opens to the "Reference of unauthorized fields" page of the development environment, as shown in the figure. Fig. 6A The object editing interface 600 shown in the figure has a button named "Go to View" which, after being clicked, enters the object editing interface 600 of the metadata in a read-only state.

[0131] In the object editing interface, the second data attribute of the changed first data attribute mapping has invalidity indication information, which is used to indicate that the mapping relationship between the second data attribute and the first data attribute is invalid. At the same time, the invalidity indication information can also identify the reason why the mapping between the second data attribute and the first data attribute is invalid. On this basis, when the mapping relationship between the first data attribute and the second data attribute of the exemplary embodiment of the present disclosure is changed, the second data attribute to be deleted can be found based on the invalidity indication information, and the second data attribute can be deleted. Considering that the external object may be edited after the creation of the external object, if the second data attribute of the external object has not been saved, the name and type of the second data attribute can be directly edited, but if the second data attribute has been saved, the type of the second data attribute cannot be changed, and the second data attribute needs to be deleted, so as to release the mapping relationship between the first data attribute and the second data attribute. In addition, if the first data attribute having a mapping relationship with the second data attribute is a unique key data attribute, the second data attribute is a system default attribute and cannot be deleted.

[0132] When the data source deletes the entire table, deletes a field, or changes the field attribute, if the field has a mapping relationship with the second data attribute, the second data attribute can be deleted. However, if the field of the data source corresponding to the second data attribute is used by the display element, filter element, or screening element of the page component in the application running state, an error can be reported in the page component, and an error message can be displayed, such as: This page uses data without permission, please contact the application administrator, or: The component consumes the deleted field in the data source. If the process consumes the deleted field in the data source, etc., the process triggered by the button: Initiate the process and an error message is reported, the error message can be: This operation uses data without permission, please contact the application administrator. Error: This node uses a field without permission. If the permission consumes the deleted field in the data source, and an error message is reported when the user accesses the page or initiates the process, the error message can be: This page uses data without permission, please contact the application administrator for authorization. The user corresponding to the role affected by the authorization rule can report an error when accessing the application: This application uses data without permission, please contact the application administrator.

[0133] It can be seen that no matter whether the data of the data source changes or the application builder actively changes the type of the second data attribute, it is necessary to consider whether the second data attribute has been consumed when deleting the second data attribute. Therefore, Figure 8 FIG. 4 is a schematic flow chart showing the second data attribute deletion of an exemplary embodiment of the present disclosure. Figure 8 As shown, the exemplary embodiments of the present disclosure may also include:

[0134] Step 801: In response to a deletion operation on a second data attribute mapped to a first data attribute, detect whether the second data attribute is referenced. If the second data attribute is referenced, the second data attribute cannot be deleted and the process jumps to step 802. If the second data attribute is not referenced, the process jumps to step 803.

[0135] Step 802: Release the reference relationship of the second data attribute based on the reference relationship information of the second data attribute. In actual applications, if the second data attribute is referenced, the reference relationship information of the second data attribute can be displayed, and the reference relationship information can at least include reference indication information and a reference editing interface entry. The reference indication information is used to indicate the module description information that references the second data attribute. Therefore, in response to the operation of the reference editing interface entry, the module editing interface that references the second data attribute can be displayed, and the second data attribute can be deleted in the module editing interface.

[0136] Step 803: Delete the second data attribute mapped to the first data attribute. Fig. 6A As shown, the second data attribute contained in the reference list 6011a can be deleted in the list display area of ​​the object editing interface 600.

[0137] If the first data attribute of the second data attribute mapping is not deleted or changed by the data source, the first data attribute of the second data attribute mapping can be added to the non-reference list 6011b for subsequent use. For example, the application builder reselects the first data attribute and configures the name and type of the second data attribute mapped by the first data attribute. In addition, if the relevant content of the second data attribute to be deleted in the detail editing area 6012, such as the object name of the referenced object, can also be deleted in the detail editing area 6012.

[0138] Fig. 9A The following is a schematic diagram showing a stage-by-stage process of deleting the second data attribute of an exemplary embodiment of the present disclosure. Figure 1 .like Fig. 9A As shown, a reference list 9011 and a non-reference list 9012 are displayed in the list display area 901 of the object editing page 900. The data source field corresponding to the person in charge field referenced by the reference list 9011 is deleted, and an invalid field identifier is marked in the person in charge field. When jumping to the object editing interface to delete the field, the second data attribute to be deleted can be easily determined through the invalid field identifier.

[0139] Fig. 9B FIG2 shows a second stage schematic diagram of the second data attribute deletion process of an exemplary embodiment of the present disclosure. Fig. 9BAs shown, when the mouse hovers over or selects the responsible person field, an invalidation description 9013 may be displayed. The invalidation description 9013 and the invalidation field mark may constitute invalidation indication information. In response to clicking the deletion mark 9014 of the responsible person field, it may be detected whether the responsible person field is referenced. If it is referenced, a Fig. 9C A deletion failure dialog box 903 of an exemplary embodiment of the present disclosure is shown.

[0140] like Fig. 9C As shown, the deletion failure pop-up box 903 not only displays the reference indication information, but also displays the solution strategy for the deletion failure. These reference indication information include the module, the reference position, and the module editing interface entry displayed in the form of "Go to Modify". The module indicates the module identifier of the referenced responsible person field, and the reference position indicates the module position of the referenced responsible person field. The module editing interface entry allows the user to quickly and conveniently enter the module editing interface to delete the responsible person field. Of course, you can also manually find the module editing interface and delete the responsible person field directly through the module and reference position.

[0141] Fig.10 A schematic flow chart of a data integration method according to an exemplary embodiment of the present disclosure is shown. Fig.10 As shown, the data integration method provided by the exemplary embodiment of the present disclosure may include:

[0142] Step 1001: In response to a data query request for an external object, based on a mapping relationship between a data structure of the external object and a data structure of a data source, a request parameter that corresponds to the data query request and complies with public protocol requirements is generated.

[0143] In practical applications, a data query request for an external object can be parsed, and the data structure of the data query request matches the data structure of the external object. Therefore, based on the mapping relationship between the data structure of the external object and the data structure of the data source, request parameters corresponding to the data query request that meet the requirements of the public protocol can be generated; and the data structure of the data source matches the public protocol. Therefore, based on the mapping relationship between the data structure of the external object and the data structure of the data source, request parameters that meet the requirements of the public protocol are generated, which is essentially a process of converting the data query request into a data query request that meets the public protocol.

[0144] Step 1002: Request the data source to return data from the data source based on the access credentials of the data source and the request parameters that meet the requirements of the public protocol. This step is essentially the process of data interaction between the application platform and the data source. It uses the access credentials of the data source as authentication information and transmits the request parameters that meet the requirements of the public protocol to the data source through the public protocol. The access credentials can ensure that data can be successfully obtained from the data source based on the request parameters that meet the requirements of the public protocol, and the request parameters that meet the requirements of the public protocol can ensure that the content of the obtained data meets the user's needs. Since the request parameters that meet the requirements of the public protocol match the public protocol, the public protocol can return the data requested from the data source with the request parameters that meet the requirements of the public protocol to the application platform.

[0145] Step 1003: Based on the mapping relationship between the data structure of the external object and the data structure of the data source, the data returned by the data source is displayed in the data structure of the external object.

[0146] In actual applications, the data source returns data through a public protocol. The data is actually data that meets the requirements of the public protocol. By parsing the data that meets the requirements of the public protocol, the data source data requested by the public platform can be obtained. However, the data returned by the data source cannot be displayed on the front end of the application platform due to data structure problems. Therefore, the data source data can be converted into data results that meet the display of the application platform through the mapping relationship between the data structure of the external object and the data structure of the data source, that is, the data structure of the external object, and displayed on the front end of the application platform.

[0147] Fig.11 FIG. 1 shows a schematic diagram of a data integration architecture of an exemplary embodiment of the present disclosure. Fig.11 As shown, the data integration architecture 1100 of the exemplary embodiment of the present disclosure includes an application platform 1101 and an external system 1102. The application platform 1101 can communicate with the external system 1102 through a public digital interface.

[0148] The application platform 1101 includes a business layer 1101A and a data layer 1101B. The business layer 1101A includes a page building module builer, a process building module Auomation and a low-code module LowCode. The page building module is used to build a data display page. Users can access the data display page to display data from the data source. The process building module Auomation is used to jump to the Figure 2B The credential filling pop-up box 204 is shown. The data layer 1101B includes blank objects and external objects.

[0149] In actual applications, the user end can access the application platform 1101 and send the data query request to the data layer 1101B through the business layer 1101A. The data layer 1101B can convert the data query request into request parameters that meet the requirements of the public protocol, and transmit the request parameters and access credentials that meet the requirements of the public protocol to the external system 1102 through the public protocol. After the external system 1102 successfully verifies the access credentials, it can query the data that needs to be returned to the application platform 1101 from the external system data based on the request parameters that meet the requirements of the public protocol, and return the generated data to the application platform 1101 through the public protocol. The application platform 1101 uses external objects to perform data conversion in the data layer 1101B and displays it through the business layer 1101A.

[0150] In practical applications, the above-mentioned data layer 1101B may include an object module and a data processing module. The object module includes a custom object, a system object and an external object. The data processing module may include a data statistics module, a data query module and a format conversion module. The data layer 1101B may use the data query module to query the corresponding external object. With the assistance of the external object, the format conversion module may convert the data query request into a request parameter that meets the requirements of the public protocol, or convert the format of the data returned by the external system 1102 through the external object, and finally display it through the business layer 1101A. At the same time, the business layer 1101A may also send a request to the data layer 1101B. The data layer 1101B may use the data statistics module to perform various statistics on the queried data and return the statistical results to the business layer 1101A for display.

[0151] One or more technical solutions provided in the embodiments of the present disclosure, when obtaining the data structure of the data source based on the access credentials of the data source, the system where the data source is located can be entered by the access credentials while meeting the access rights requirements of the data source, so that the data structure of the data source can be read from the data source using the public data interface. On this basis, the data structure of the external object is configured for the data structure of the data source, so that there is a mapping relationship between the data structure of the external object and the data structure of the data source. At this time, when the data of the data source is consumed using the external object, the data structure according to the external object can be obtained by responding to the data query request, using the public data interface as the interactive interface, and based on the access credentials, through the mapping relationship between the data structure of the external object and the data structure of the data source, so as to consume the data of the data source normally. It can be seen that the method of the exemplary embodiment of the present disclosure does not need to design and develop a data interface specifically for the data source, and directly uses the public data interface as the interactive interface for virtual data integration and access. Therefore, the method of the exemplary embodiment of the present disclosure can reduce data management costs and maintenance costs while meeting the access rights requirements of the data source, thereby facilitating data communication and consumption of data, and reducing virtual integration costs.

[0152] The above mainly introduces the solution provided by the embodiment of the present disclosure from the perspective of an electronic device. It is understandable that, in order to realize the above functions, the electronic device includes a hardware structure and / or software module corresponding to the execution of each function. Those skilled in the art should easily realize that, in combination with the units and algorithm steps of each example described in the embodiments disclosed herein, the present disclosure can be implemented in the form of hardware or a combination of hardware and computer software. Whether a function is executed in the form of hardware or computer software driving hardware depends on the specific application and design constraints of the technical solution. Professional and technical personnel can use different methods to implement the described functions for each specific application, but such implementation should not be considered to exceed the scope of the present disclosure.

[0153] The disclosed embodiment can divide the electronic device into functional units according to the above method example. For example, each functional module can be divided according to each function, or two or more functions can be integrated into one processing module. The above integrated module can be implemented in the form of hardware or in the form of software functional modules. It should be noted that the division of modules in the disclosed embodiment is schematic and is only a logical function division. There may be other division methods in actual implementation.

[0154] In the case of dividing each functional module according to each function, an exemplary embodiment of the present disclosure provides a device for configuring a data integration strategy, and the device for configuring a data integration strategy may be an electronic device or a chip applied to an electronic device. Fig.12FIG. 1 is a schematic block diagram showing the functional modules of a device for configuring a data integration strategy according to an exemplary embodiment of the present disclosure. Fig.12 As shown, the configuration device 1200 of the data integration strategy includes:

[0155] An acquisition module 1201 is used to acquire a data structure of a data source based on an access credential of the data source;

[0156] The configuration module 1202 is used to configure the data structure of the external object for the data structure of the data source, and the data structure of the external object has a mapping relationship with the data structure of the data source.

[0157] In a possible implementation, the data source access credential includes a credential identifier and credential information, and the credential information includes a data location parameter and authority verification information.

[0158] In one possible implementation, the acquisition module 1201 is used to respond to an operation of selecting the access credential. If the access credential is a valid access credential, the target data table of the data source is determined based on the access credential, and the data structure of the target data table is acquired based on the access credential, and the data structure of the target data table is the data structure of the data source.

[0159] In a possible implementation, the data table of the data source is a plurality of data tables, and the acquisition module 1201 is used to display at least the plurality of data tables of the data source based on the access credentials, the plurality of data tables including optional data tables and non-optional data tables, and determine the target data table of the data source corresponding to the external object in response to a selection operation on an optional data table among the plurality of data tables.

[0160] In a possible implementation, the data structure of the data source includes multiple first data attributes, the data structure of the external object includes at least one second data attribute, and there is a mapping relationship between at least one of the multiple first data attributes and the second data attribute.

[0161] In a possible implementation, the at least one second data attribute contains at least one second data attribute of an associated object type; and / or,

[0162] The plurality of first data attributes include a unique key data attribute, and the at least one second data attribute includes a system default attribute having a mapping relationship with the unique key data attribute.

[0163] In one possible implementation, the configuration module 1202 is used to display multiple first data attributes of the data source based on the data structure of the data source, determine at least one target data attribute of the data source in response to a selection operation on at least one of the multiple first data attributes, and configure the second data attribute of the external object for each target data attribute, and each of the target data attributes has a corresponding relationship with the second data attribute.

[0164] In a possible implementation, the device may also include an editing module 1203, which is used to edit the relevant information of the external object and the relevant information corresponding to at least one of the second data attributes in response to the configuration completion operation of the mapping relationship between the first data attribute and the second data attribute; wherein the relevant information of the external object includes the external object identifier and / or the data display method corresponding to the external object, and the relevant information corresponding to the second data attribute includes the data type corresponding to the second data attribute and / or the data display method corresponding to the second data attribute.

[0165] In one possible implementation, the editing module 1203 is also used to display an object editing interface in response to a configuration completion operation of the mapping relationship between the first data attribute and the second data attribute, and the object editing interface is used at least to display a reference list, relevant information of the external object and relevant information corresponding to at least one of the second data attributes, and the reference list is a list of the second data attributes.

[0166] In a possible implementation, the object editing interface is further used to display a non-reference list, where the non-reference list includes a first data attribute that has no mapping relationship with the second data attribute, and the editing module 1203 is further used to:

[0167] When detecting that a newly added first data attribute exists in the data source, updating the non-reference list based on the newly added first data attribute; and / or,

[0168] When detecting that the data source has a reduced first data attribute, if there is no mapping relationship between the first data attribute and the second data attribute, updating the non-reference list based on the reduced first data attribute; and / or,

[0169] In response to an operation on one of the first data attributes in the non-reference list, the first data attribute is added to the reference list, and the corresponding second data attribute in the external object is configured for the first data attribute, so that the first data attribute in the reference list is transformed into the second data attribute having a mapping relationship with the first data attribute.

[0170] In a possible implementation, the editing module 1203 is further used to detect that there is a changed first data attribute in the data source, and if the changed first data attribute contains a first data attribute with a mapping relationship to the second data attribute, a prompt message with an entrance to the object editing interface is displayed, and in response to an operation on the object editing interface entrance, the object editing interface is displayed; the second data attribute mapped to the changed first data attribute is deleted in the object editing interface, and the prompt message is used to prompt that the data source has been changed; the second data attribute mapped to the changed first data attribute has invalidation indication information, which is used to indicate that the mapping relationship between the second data attribute and the first data attribute is invalid.

[0171] In one possible implementation, the device also includes an editing module 1203, which is used to respond to a deletion operation on the second data attribute mapped to the first data attribute, if the second data attribute is referenced, release the reference relationship of the second data attribute based on the reference relationship information of the second data attribute, if the second data attribute is not referenced, delete the second data attribute mapped to the first data attribute.

[0172] In one possible implementation, the editing module 1203 is used to display reference relationship information of the second data attribute, and the reference relationship information includes at least reference indication information and a reference editing interface entry. In response to the operation of the reference editing interface entry, a module editing interface that references the second data attribute is displayed; the second data attribute is deleted in the module editing interface, and the reference indication information is used to indicate the module description information that references the second data attribute.

[0173] In the case of dividing each functional module according to each function, an exemplary embodiment of the present disclosure provides a data integration device, which may be an electronic device or a chip applied to an electronic device. Fig.13 FIG. 1 shows a schematic block diagram of functional modules of a data integration device according to an exemplary embodiment of the present disclosure. Fig.13 As shown, the data integration device 1300 includes:

[0174] A generating module 1301 is used to generate, in response to a data query request for an external object, a request parameter of the data query request that meets the requirements of a public protocol based on a mapping relationship between a data structure of the external object and a data structure of a data source;

[0175] A communication module 1302, configured to request the data source to return data from the data source based on the access credentials of the data source and the request parameters that meet the requirements of the public protocol;

[0176] The display module 1303 is used to display the data returned by the data source in the data structure of the external object based on the mapping relationship between the data structure of the external object and the data structure of the data source.

[0177] Fig.14 Schematic block diagram of a chip according to an exemplary embodiment of the present disclosure is shown. Fig.14 As shown, the chip 1400 includes one or more (including two) processors 1401 and a communication interface 1402. The communication interface 1402 can support the electronic device to perform the data receiving and sending steps in the above method, and the processor 1401 can support the electronic device to perform the data processing steps in the above method.

[0178] Optional, such as Fig.14 As shown, the chip 1400 also includes a memory 1403, which may include a read-only memory and a random access memory, and provides operation instructions and data to the processor. A portion of the memory may also include a non-volatile random access memory (NVRAM).

[0179] In some embodiments, Fig.14 As shown, the processor 1401 performs corresponding operations by calling the operation instructions stored in the memory (the operation instructions may be stored in the operating system). The processor 1401 controls the processing operations of any one of the terminal devices, and the processor may also be called a central processing unit (CPU). The memory 1403 may include a read-only memory and a random access memory, and provides instructions and data to the processor 1401. A portion of the memory 1403 may also include NVRAM. For example, in an application, the memory, the communication interface, and the memory are coupled together through a bus system, wherein the bus system may include a power bus, a control bus, and a status signal bus in addition to a data bus. However, for the sake of clarity, in Fig.14 Various buses are labeled as bus system 1404.

[0180] The method disclosed in the above-mentioned embodiment of the present disclosure can be applied to a processor or implemented by a processor. The processor may be an integrated circuit chip with signal processing capabilities. In the implementation process, each step of the above method can be completed by an integrated logic circuit of hardware in the processor or an instruction in the form of software. The above-mentioned processor may be a general-purpose processor, a digital signal processor (digital signal processing, DSP), an ASIC, a field-programmable gate array (field-programmable gate array, FPGA) or other programmable logic devices, discrete gates or transistor logic devices, discrete hardware components. The methods, steps and logic block diagrams disclosed in the embodiments of the present disclosure can be implemented or executed. The general-purpose processor may be a microprocessor or the processor may also be any conventional processor, etc. The steps of the method disclosed in conjunction with the embodiment of the present disclosure can be directly embodied as being executed by a hardware decoding processor, or executed by a combination of hardware and software modules in the decoding processor. The software module may be located in a mature storage medium in the field such as a random access memory, a flash memory, a read-only memory, a programmable read-only memory or an electrically erasable programmable memory, a register, etc. The storage medium is located in a memory, and the processor reads the information in the memory and completes the steps of the above method in conjunction with its hardware.

[0181] The exemplary embodiment of the present disclosure also provides an electronic device, comprising: at least one processor; and a memory connected to the at least one processor in communication. The memory stores a computer program that can be executed by the at least one processor, and the computer program is used to cause the electronic device to perform the method according to the embodiment of the present disclosure when executed by the at least one processor.

[0182] The exemplary embodiments of the present disclosure also provide a non-transitory computer-readable storage medium storing a computer program, wherein the computer program, when executed by a processor of a computer, is used to cause the computer to perform the method according to the embodiments of the present disclosure.

[0183] The exemplary embodiments of the present disclosure further provide a computer program product, including a computer program, wherein when the computer program is executed by a processor of a computer, the computer is used to enable the computer to perform the method according to the embodiments of the present disclosure.

[0184] refer to Fig.15, a block diagram of an electronic device 1500 that can be used as a server or client of the present disclosure will now be described, which is an example of a hardware device that can be applied to various aspects of the present disclosure. The electronic device is intended to represent various forms of digital electronic computer devices, such as laptop computers, desktop computers, workbenches, personal digital assistants, servers, blade servers, mainframe computers, and other suitable computers. The electronic device can also represent various forms of mobile devices, such as personal digital processing, cellular phones, smart phones, wearable devices, and other similar computing devices. The components shown herein, their connections and relationships, and their functions are merely examples and are not intended to limit the implementation of the present disclosure described and / or required herein.

[0185] like Fig.15 As shown, the electronic device 1500 includes a computing unit 1501, which can perform various appropriate actions and processes according to a computer program stored in a read-only memory (ROM) 1502 or a computer program loaded from a storage unit 1508 into a random access memory (RAM) 1503. In the RAM 1503, various programs and data required for the operation of the device 1500 can also be stored. The computing unit 1501, the ROM 1502, and the RAM 1503 are connected to each other via a bus 1504. An input / output (I / O) interface 1505 is also connected to the bus 1504.

[0186] like Fig.15 As shown, multiple components in the electronic device 1500 are connected to the I / O interface 1505, including: an input unit 1506, an output unit 1507, a storage unit 1508, and a communication unit 1509. The input unit 1506 can be any type of device that can input information to the electronic device 1500, and the input unit 1506 can receive input digital or character information, and generate key signal input related to the user settings and / or function control of the electronic device. The output unit 1507 can be any type of device that can present information, and can include but is not limited to a display, a speaker, a video / audio output terminal, a vibrator, and / or a printer. The storage unit 1508 can include but is not limited to a disk, an optical disk. The communication unit 1509 allows the electronic device 1500 to exchange information / data with other devices through a computer network such as the Internet and / or various telecommunication networks, and can include but is not limited to a modem, a network card, an infrared communication device, a wireless communication transceiver, and / or a chipset, such as a Bluetooth TM device, a WiFi device, a WiMax device, a cellular communication device, and / or the like.

[0187] like Fig.15As shown, the computing unit 1501 can be various general and / or special processing components with processing and computing capabilities. Some examples of the computing unit 1501 include, but are not limited to, a central processing unit (CPU), a graphics processing unit (GPU), various dedicated artificial intelligence (AI) computing chips, various computing units running machine learning model algorithms, digital signal processors (DSPs), and any appropriate processors, controllers, microcontrollers, etc. The computing unit 1501 performs the various methods and processes described above. For example, in some embodiments, the method of the exemplary embodiment of the present disclosure may be implemented as a computer software program, which is tangibly included in a machine-readable medium, such as a storage unit 1508. In some embodiments, part or all of the computer program can be loaded and / or installed on the electronic device 1500 via ROM 1502 and / or communication unit 1509. In some embodiments, the computing unit 1501 can be configured to perform the method of the exemplary embodiment of the present disclosure in any other appropriate manner (e.g., by means of firmware).

[0188] The program code for implementing the method of the present disclosure may be written in any combination of one or more programming languages. These program codes may be provided to a processor or controller of a general-purpose computer, a special-purpose computer, or other programmable data processing device, so that the program code, when executed by the processor or controller, enables the functions / operations specified in the flow chart and / or block diagram to be implemented. The program code may be executed entirely on the machine, partially on the machine, partially on the machine and partially on a remote machine as a stand-alone software package, or entirely on a remote machine or server.

[0189] In the context of the present disclosure, a machine-readable medium may be a tangible medium that may contain or store a program for use by or in conjunction with an instruction execution system, device, or equipment. A machine-readable medium may be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, device, or equipment, or any suitable combination of the foregoing. A more specific example of a machine-readable storage medium may include an electrical connection based on one or more lines, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

[0190] As used in this disclosure, the terms "machine-readable medium" and "computer-readable medium" refer to any computer program product, apparatus, and / or device (e.g., disk, optical disk, memory, programmable logic device (PLD)) for providing machine instructions and / or data to a programmable processor, including a machine-readable medium that receives machine instructions as a machine-readable signal. The term "machine-readable signal" refers to any signal for providing machine instructions and / or data to a programmable processor.

[0191] To provide interaction with a user, the systems and techniques described herein can be implemented on a computer having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to the user; and a keyboard and pointing device (e.g., a mouse or trackball) through which the user can provide input to the computer. Other types of devices can also be used to provide interaction with the user; for example, the feedback provided to the user can be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user can be received in any form (including acoustic input, voice input, or tactile input).

[0192] The systems and techniques described herein may be implemented in a computing system that includes back-end components (e.g., as a data server), or a computing system that includes middleware components (e.g., an application server), or a computing system that includes front-end components (e.g., a user computer with a graphical user interface or a web browser through which a user can interact with implementations of the systems and techniques described herein), or a computing system that includes any combination of such back-end components, middleware components, or front-end components. The components of the system may be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: a local area network (LAN), a wide area network (WAN), and the Internet.

[0193] A computer system may include clients and servers. Clients and servers are generally remote from each other and usually interact through a communication network. The relationship of client and server is generated by computer programs running on respective computers and having a client-server relationship to each other.

[0194] In the above embodiments, it can be implemented in whole or in part by software, hardware, firmware or any combination thereof. When implemented by software, it can be implemented in whole or in part in the form of a computer program product. The computer program product includes one or more computer programs or instructions. When the computer program or instruction is loaded and executed on a computer, the process or function described in the embodiment of the present disclosure is executed in whole or in part. The computer may be a general-purpose computer, a special-purpose computer, a computer network, a terminal, a user device or other programmable device. The computer program or instruction may be stored in a computer-readable storage medium, or transmitted from one computer-readable storage medium to another computer-readable storage medium, for example, the computer program or instruction may be transmitted from one website site, computer, server or data center to another website site, computer, server or data center by wired or wireless means. The computer-readable storage medium may be any available medium that a computer can access or a data storage device such as a server, data center, etc. that integrates one or more available media. The available medium may be a magnetic medium, for example, a floppy disk, a hard disk, a tape; it may also be an optical medium, for example, a digital video disc (DVD); it may also be a semiconductor medium, for example, a solid state drive (SSD).

[0195] Although the present disclosure has been described in conjunction with specific features and embodiments thereof, it is apparent that various modifications and combinations may be made thereto without departing from the spirit and scope of the present disclosure. Accordingly, this specification and the drawings are merely exemplary illustrations of the present disclosure as defined by the appended claims, and are deemed to have covered any and all modifications, variations, combinations or equivalents within the scope of the present disclosure. Obviously, those skilled in the art may make various modifications and variations to the present disclosure without departing from the spirit and scope of the present disclosure. Thus, if these modifications and variations of the present disclosure fall within the scope of the claims of the present disclosure and their equivalents, the present disclosure is also intended to include these modifications and variations.

Claims

1. A method for configuring a data integration strategy, characterized in that: The method is used to create an external object by using access credentials of a data source to support a service of a public protocol as an external data source, and to map a data model of the public protocol to a data model of an internal and external object of a data integration platform, the method comprising: Acquire a data structure of the data source based on the access credentials of the data source, wherein the data structure of the data source includes a plurality of first data attributes; The data structure of the external object is configured for the data structure of the data source, the data structure of the external object has a mapping relationship with the data structure of the data source, the data structure of the external object includes at least one second data attribute, and at least one of the plurality of first data attributes has a mapping relationship with the second data attribute; the method further includes: In response to the configuration completion operation of the mapping relationship between the first data attribute and the second data attribute, an object editing interface is displayed, the object editing interface is used to display at least a reference list, relevant information of the external object and relevant information corresponding to at least one second data attribute, the reference list is a list of the second data attributes having a mapping relationship with the first data attribute; In response to a deletion operation on the second data attribute mapped to the first data attribute, if the second data attribute is referenced, display reference relationship information of the second data attribute, the reference relationship information at least including reference indication information and a reference editing interface entry, the reference indication information is used to indicate module description information that references the second data attribute; in response to an operation on the reference editing interface entry, display a module editing interface that references the second data attribute, and delete the second data attribute in the module editing interface; If the second data attribute is not referenced, the second data attribute contained in the reference list is deleted in the list display area of ​​the object editing interface.

2. The method according to claim 1, characterized in that The access credential of the data source includes a credential identifier and credential information, and the credential information includes data location parameters and authority verification information.

3. The method according to claim 1, characterized in that: The step of obtaining the data structure of the data source based on the access credentials of the data source includes: In response to an operation of selecting the access credential, if the access credential is a valid access credential, determining a target data table of the data source based on the access credential; The data structure of the target data table is acquired based on the access credential, where the data structure of the target data table is the data structure of the data source.

4. The method according to claim 3, characterized in that The data table of the data source is a plurality of data tables, and determining the target data table of the data source based on the access credential includes: Based on the access credentials, at least a plurality of data tables of the data source are displayed, wherein the plurality of data tables include selectable data tables and non-selectable data tables; In response to a selection operation on a selectable data table among the plurality of data tables, a target data table of the data source corresponding to the external object is determined.

5. The method according to claim 1, characterized in that: The at least one second data attribute contains at least one second data attribute of an associated object type; and / or, The plurality of first data attributes include a unique key data attribute, and the at least one second data attribute includes a system default attribute having a mapping relationship with the unique key data attribute.

6. The method according to claim 1, characterized in that The step of configuring the data structure of the external object for the data structure of the data source includes: Displaying a plurality of first data attributes of the data source based on a data structure of the data source; In response to a selection operation on at least one of the plurality of first data attributes, determining at least one target data attribute of the data source; A second data attribute of the external object is configured for each of the target data attributes, and there is a corresponding relationship between each of the target data attributes and the second data attribute.

7. The method according to claim 1, characterized in that The method further comprises: In response to the configuration completion operation of the mapping relationship between the first data attribute and the second data attribute, editing the relevant information of the external object and the relevant information corresponding to at least one of the second data attributes; Among them, the relevant information of the external object includes the external object identifier and / or the data display method corresponding to the external object, and the relevant information corresponding to the second data attribute includes the data type corresponding to the second data attribute and / or the data display method corresponding to the second data attribute.

8. The method according to claim 1, characterized in that: The object editing interface is further used to display a non-reference list, wherein the non-reference list includes a first data attribute that has no mapping relationship with the second data attribute, and the method further includes: When detecting that a newly added first data attribute exists in the data source, updating the non-reference list based on the newly added first data attribute; and / or, When detecting that the data source has a reduced first data attribute, if there is no mapping relationship between the first data attribute and the second data attribute, updating the non-reference list based on the reduced first data attribute; and / or, In response to an operation on one of the first data attributes in the non-reference list, the first data attribute is added to the reference list, and the corresponding second data attribute in the external object is configured for the first data attribute, so that the first data attribute in the reference list is transformed into the second data attribute having a mapping relationship with the first data attribute.

9. The method according to claim 1, characterized in that: The method further comprises: It is detected that there is a changed first data attribute of the data source, and if the changed first data attribute contains the first data attribute with which the second data attribute has a mapping relationship, a prompt message with an entry to the object editing interface is displayed, wherein the prompt message is used to prompt that the data source has been changed; In response to an operation on the object editing interface entry, displaying the object editing interface; The second data attribute mapped to the changed first data attribute is deleted in the object editing interface, and the second data attribute mapped to the changed first data attribute has invalidation indication information for indicating that the mapping relationship between the second data attribute and the first data attribute is invalid.

10. A data integration method, characterized in that: include: In response to a data query request for an external object, based on a mapping relationship between a data structure of the external object and a data structure of a data source, a request parameter of the data query request that complies with public protocol requirements is generated, wherein the mapping relationship between the data structure of the external object and the data structure of the data source is configured by the method described in any one of claims 1 to 9; Requesting the data source to return data from the data source based on the access credentials of the data source and the request parameters that meet the requirements of the public protocol; Based on the mapping relationship between the data structure of the external object and the data structure of the data source, the data returned by the data source is displayed in the data structure of the external object.

11. A data integration strategy configuration device, characterized in that: The device is used to create an external object using access credentials of a data source to support a service of a public protocol as an external data source, and to map a data model of the public protocol to a data model of an internal and external object of a data integration platform, the device comprising: An acquisition module, configured to acquire a data structure of a data source based on an access credential of the data source, wherein the data structure of the data source includes a plurality of first data attributes; a configuration module, configured to configure a data structure of an external object for the data structure of the data source, the data structure of the external object having a mapping relationship with the data structure of the data source, the data structure of the external object including at least one second data attribute, and at least one of the plurality of first data attributes having a mapping relationship with the second data attribute; The device further includes an editing module, which is used to display an object editing interface in response to a configuration completion operation of the mapping relationship between the first data attribute and the second data attribute, wherein the object editing interface is used to display at least a reference list, relevant information of the external object, and relevant information corresponding to at least one second data attribute, wherein the reference list is a list of the second data attributes having a mapping relationship with the first data attribute; In response to a deletion operation on the second data attribute mapped to the first data attribute, if the second data attribute is referenced, reference relationship information of the second data attribute is displayed, the reference relationship information at least includes reference indication information and a reference editing interface entry, the reference indication information is used to indicate module description information that references the second data attribute, in response to an operation on the reference editing interface entry, a module editing interface that references the second data attribute is displayed, and the second data attribute is deleted in the module editing interface; if the second data attribute is not referenced, the second data attribute contained in the reference list is deleted in the list display area of ​​the object editing interface.

12. A data integration device, characterized in that: include: A generating module, configured to generate, in response to a data query request for an external object, a request parameter of the data query request that complies with public protocol requirements based on a mapping relationship between a data structure of the external object and a data structure of a data source; A communication module, configured to request the data source to return data from the data source based on the access credentials of the data source and the request parameters that meet the requirements of the public protocol, wherein the mapping relationship between the data structure of the external object and the data structure of the data source is configured by the method described in any one of claims 1 to 9; The display module is used to display the data returned by the data source in the data structure of the external object based on the mapping relationship between the data structure of the external object and the data structure of the data source.

13. An electronic device, characterized in that: include: processor; as well as, A memory for storing programs; The program includes instructions, which, when executed by the processor, cause the processor to perform the method according to any one of claims 1 to 10.

14. A non-transitory computer-readable storage medium, characterized in that The non-transitory computer-readable storage medium stores computer instructions, and the computer instructions are used to cause the computer to execute the method according to any one of claims 1 to 10.

Images