CN115580562A - ERP data acquisition method based on portable acquisition device and acquisition device thereof - Google Patents

Abstract

The scheme discloses an ERP data acquisition method based on a portable collector and the collector thereof, which comprises a main control chip, a memory and the like, wherein system software and acquisition software which can run on the main control chip are stored in the memory; the system software is configured to be started by power supply, and the acquisition software is controlled to be started after the system software is started; the acquisition software is used for sending the collector driving program to an ERP server connected with the collector after being started, enabling the ERP server to start an acquisition software configurator used for configuring the acquisition software, acquiring ERP data from a target database based on the configuration information, and finally transmitting the acquired ERP data to the target server after compatible processing. The scheme is provided aiming at the collection of the ERP data, the collection and the transfer of the ERP data are realized through the scheme, the ERP server is not required to carry out network transmission, and the problem of difficult collection and transfer caused by the contradiction that the ERP server is not networked but the collection and the transfer need to depend on the network is solved.

Description

ERP data acquisition method based on portable acquisition device and acquisition device thereof

Technical Field

The invention belongs to the technical field of ERP data acquisition and caching, and particularly relates to an ERP data acquisition method based on a portable collector and a collector thereof.

Background

ERP refers to an enterprise management system for managing various resources of an enterprise, and knowledge related to various aspects, such as financial knowledge, production management, quality management, material management, logistics management, customer relationship management, supply chain management, and the like. ERP data includes, but is not limited to, material data, capacity data, inventory data, sales data, procurement data, production data, financial data, and human resources data, among others. In order to better support the analysis of the ERP data, the ERP data is often required to be collected and transferred.

On one hand, in order to ensure the safety of enterprise data, the ERP servers of the enterprise are mostly internal networks and cannot perform network transmission, and the collection and the transfer of the ERP data need to depend on the network, which also causes the difficulty of the collection and the transfer of the ERP data. On the other hand, the relevance between the specific implementation modes of data acquisition and data unloading and the ERP software brand and the database loaded by the ERP software brand is also high.

Therefore, the current situation causes great difficulty in the collection and the dump of the ERP data and energy consumption of users, so that support cannot be provided for ERP data analysis effectively.

Disclosure of Invention

The invention aims to provide an ERP data portable collector and a collection method thereof aiming at the problems.

In order to achieve the purpose, the invention adopts the following technical scheme:

an ERP data acquisition method based on a portable collector comprises the following steps:

s1, a collector responds to a power supply instruction, establishes data connection with an ERP server, controls system software to start and then controls collection software to start;

s2, the collector sends the driver data to an ERP server to enable the ERP server to install the driver of the collector, and then a collection software configurator for configuring collection software is started;

s3, the collector obtains configuration information through collection software, wherein the configuration information comprises a target database path and a target database port;

s4, after receiving a data acquisition instruction, the collector firstly determines a database driving program and then establishes data connection with a target database according to the database driving program, a target database path and a target database port;

and S5, responding to the database connection success command, starting data acquisition on the target database by acquisition software, calling a network communication interface, and transmitting the acquired ERP data to a target server.

In the above ERP data collecting method based on the portable collector, in step S2, the user configures the collecting software by manually inputting the configuration information.

In the above-mentioned ERP data collection method based on the portable collector, in step S2, the collection software configurator has a self-running program capable of automatically searching configuration information, and the collection software is configured by starting the collection software configurator to automatically search configuration information.

In the above-mentioned ERP data collection method based on the portable collector, in step S2, the collection software configurator has a self-running program capable of automatically searching a plurality of configuration information corresponding to each database in the ERP server, and the user selects the configuration information to configure the collection software.

In the above ERP data collection method based on the portable collector, an operation interface of the collection software configurator is provided with a collection start control, and a user triggers the collection start control to send a data collection instruction to the collector.

In the above ERP data collection method based on the portable collector, in step S4, the collector determines the database driver by any one of the following methods:

determining a target database type according to a target database port in the configuration information, and then determining a corresponding database driver according to the target database type;

analyzing a target database path in the configuration information to obtain a target database type, and determining a corresponding database driver according to the target database type;

confirming a target database type according to the brand of ERP software installed on an ERP server and a preset corresponding relationship between a corresponding brand and the database type, and then determining a corresponding database driver according to the target database type;

and enabling the configuration information to simultaneously comprise the target database type, directly acquiring the target database type from the configuration information, and determining a corresponding database driver according to the target database type.

In the above ERP data collection method based on the portable collector, the collection software includes a data processing module and a data logic model module;

and (5) storing SQL statements, an SQL interpreter, an SQL optimizer and an SQL executor in the data processing module in advance, executing the SQL statements written in advance through the SQL interpreter, the SQL optimizer and the SQL executor in the data processing module, acquiring ERP data from a target database, storing the acquired ERP data under model fields in an ERP model table through a data logic model module, and transmitting the ERP model table filled with the model fields to a target server.

In the above ERP data collection method based on the portable collector, the data processing module is connected to the interface cluster integrating the plurality of database drivers, and is used for connecting the target database by using the database drivers therein;

each ERP model table corresponds to a standard table name and a standard field name, and tables of various ERP data and rule tables of fields thereof corresponding to the ERP model table are also prestored in the data logic model module;

the ERP model table comprises a financial data table, a production data table, a purchase data table, a sales data table and an enterprise basic data table;

in step S5, the ERP data collected from the target database is stored in the corresponding model field of the corresponding ERP model table through the rule table.

A portable ERP data collector comprises a main control chip, a memory, a data transmission interface, a power supply circuit and a network communication module, wherein the power supply circuit is connected with the data transmission interface;

the data transmission interface is used for carrying out data transmission with the ERP server after being plugged into the ERP server and obtaining power from the ERP server, and the power supply circuit converts the power voltage into the voltage required by the collector;

the network communication module is used for establishing wireless connection between the collector and the target server;

the memory is stored with system software and acquisition software which can run on the main control chip;

the system software is configured to be started by power supply, and controls the acquisition software to be started after being started;

the acquisition software is used for sending the collector driving program to an ERP server connected with the collector after being started, enabling the ERP server to start an acquisition software configurator used for configuring the acquisition software, acquiring the ERP data from a target database based on the configuration information, and finally transmitting the acquired ERP data to the target server after compatible processing.

In the above ERP data portable collector, the network communication module is a 4G communication module;

or the network communication module comprises a 4G communication module and a wifi communication module, and the communication module with the higher network speed is determined to be used to establish connection with the target server according to the network speed.

The invention has the advantages that:

(1) The acquisition device combines software and hardware, is plug-and-play, acquires, transfers and saves synchronously, and has the advantages of portability, rapidness, convenience for acquiring, transferring and saving and high efficiency;

(2) According to the scheme, the collection and the transfer of the ERP data are realized by using the portable collector, the collector is used for transmitting the ERP data to the target server, the ERP server is not required to carry out network transmission, and the problem that the collection and the transfer are difficult due to the fact that the ERP server is not networked but the collection and the transfer need to depend on a network is solved;

(3) The collector integrates various database driving programs, the corresponding database driving program is determined according to the type of the target database, the collection efficiency of ERP data can be ensured, and the type of the target database is automatically acquired by the collector without being known by a user;

(4) Because the interface cluster integrating various database drivers is designed at an independent collector, the independent collector has independent operating software and hardware environments, an ERP server or a target server does not need to be operated, and the problem that different ERP data use different data acquisition tools is solved under the condition of ensuring the safety of the original system, so that the interface cluster can be fully compatible with the mainstream database on the market;

after the collector obtains the type of the target database, a more appropriate database driver is called based on the type of the target database, and connection with the target database is established, so that data collection of various databases is compatible, the collection speed can be obviously improved when large-scale ERP data is faced, and the coupling degree between data collection codes and the database can be reduced;

(5) The collector is designed with a standard ERP data acquisition model, so that different ERP server data have the same data acquisition standard; meanwhile, various ERP database table structure data are matched, various ERP data acquisition can be compatible, and ERP software under any brand can be stored in the model field of the model table, so that the uniform unloading and management of the ERP data are realized, and the subsequent analysis of the ERP data is facilitated.

Drawings

FIG. 1 is a hardware and software framework diagram of the ERP data portable collector of the present invention;

FIG. 2 is a flow chart of the present invention for collecting ERP data using a portable collector;

FIG. 3 is a diagram of a collection software structure of the ERP data portable collector based on the matching of various databases.

Detailed Description

The present invention will be described in further detail with reference to the accompanying drawings and specific embodiments.

This scheme involves three main parts when coming into operation: ERP server, the portable collector that this scheme provided, target server.

In summary, the portable collector is inserted into the ERP server to retrieve ERP data from the ERP server and transmit the ERP data to the target server.

As shown in fig. 1, the collector provided by the present solution is plug-and-play, and a main control chip, a memory, a data transmission interface, a power supply circuit, and a network communication module are built in the collector. The main control chip is connected with the memory, the data transmission interface, the network communication module and the power supply circuit, and the power supply circuit is connected with the data transmission interface to supply power through the data transmission interface. The memory can comprise a software memory and a data memory, wherein the software memory stores system software and acquisition software which can run on the main control chip, and the data memory is used for temporarily storing the acquired data which are not successfully transferred. In this embodiment, the system software of the collector adopts an android system, and the system software of the ERP server takes win10 as an example, and may also be other system software such as ios and win7 when being applied specifically. After the collector is inserted into the ERP server, the ERP server starts a collection software configurator to configure collection software collection parameters, a data transmission interface can realize power supply and can also perform data transmission, and the android system is automatically started after the power supply.

The network communication module can adopt a 4G communication module to establish data connection with the target server, can also adopt a 4G and WiFi communication module, and adopts a communication module with higher network speed to establish data connection with the target server, and can also be manually selected by a user to establish data connection with the target server.

In addition, the collection software provided by the scheme is various database collection software, can be compatible with data collection under various databases, is compatible with the unloading of ERP data of various brands, and specifically realizes the detailed description below.

As shown in fig. 2, the ERP data collection and dump process is as follows:

s1: and after the collector is inserted into the ERP server, responding to a power supply instruction, establishing data connection between the collector and the ERP server, controlling the android system to start, and then controlling the collection software to start.

S2: the collector sends the driver data to the ERP server, the ERP server installs the driver of the collector according to the received driver data, and the ERP server is controlled to start the collection software configurator after the driver is installed.

S3: and configuring the acquisition software through an acquisition software configurator, wherein the configured configuration information at least comprises a target database path and a target database port, and the target database stores the ERP data to be acquired.

Here, the configuration of the acquisition software includes the following 3 types:

(1) Manually inputting configuration information to configure acquisition software;

(2) Automatic input, namely, automatically searching a self-running program in the acquisition software configurator to obtain a target database path and a target database port to realize the configuration of the acquisition software;

(3) And semi-automatic input, namely, automatically searching a plurality of database paths and a plurality of database ports in the ERP server by a self-running program in the acquisition software configurator, selecting the database paths and the database ports by a user, and determining a target database path and a target database port to configure the acquisition software.

S4: and the collector receives the configuration information through collection software.

In general, different types of databases have different default database ports, and it may be determined in which type of database the ERP data to be collected is stored according to the received target database port.

For example, the types of databases may include MySQL database, SQLServer database, oracle database, sybase database, and the like. The default database port corresponding to MySQL database is 3306, the default database port corresponding to Oracle database is 1521, etc.

Of course, the database port may be modified, and if it cannot be determined through the target database port what type of database the ERP data to be collected is stored in. It can also be solved by the following 3 ways:

(1) Analyzing the path of the target database to obtain the type of the target database;

(2) Confirming the type of a target database according to the brand of ERP software installed on an ERP server and the preset corresponding relation between the brand of the ERP software and the type of the database;

(3) When the configuration information is obtained by the acquisition software configurator, the configuration information further includes a target database type.

S5: and a collection starting control is displayed in an operation interface of the collection software configurator, and a user can send a data collection instruction to the collector by triggering the collection starting control.

S6: and the collector responds to the data collection instruction, firstly determines a corresponding target database driving program according to the type of the target database, and then establishes data connection with the target database according to the database driving program, the target database path and the target database port.

Various database drivers are integrated in the collector, such as: ODBC, JDBC, ADO. Most databases can be accessed through the ODBC, but on one hand, some types of databases are incompatible with some database drivers, and on the other hand, the performance of the database drivers is not uniform when the database drivers face different types of databases, which affects the efficiency of acquiring ERP data. According to the scheme, various database driving programs are integrated firstly, then the database driving program required to be used each time is determined according to the type of the target database, the data acquisition efficiency can be guaranteed, meanwhile, the determination mode of the type of the target data does not need user participation, the system can be automatically determined according to configuration information or ERP software, and the method is very quick and convenient.

S7: responding to a database connection success instruction, starting data acquisition by the acquisition unit, calling a network communication interface by acquisition software, calling a 4g communication module if no WiFi connection exists, transmitting data to a target server through WiFi if the WiFi connection exists, and switching if the 4g network speed is higher than that of the WiFi connection.

Specifically, how the collector realizes data collection will be described below:

as shown in fig. 3, the acquisition software includes a data processing module and a data logic model module.

The data processing module comprises a pre-written SQL statement, an SQL interpreter, an SQL optimizer and an SQL executor.

Specifically, S81: and executing a prewritten SQL statement through an SQL interpreter, an SQL optimizer and an SQL executor in the data processing module, and acquiring ERP data from the target database. The ERP data comprises a plurality of tables and data under a plurality of fields in each table;

s82: and storing the collected ERP data to a model field in an ERP model table through a data logic model module.

In an optional embodiment, data may be obtained from the target database of the ERP field by field, and then, the data is stored in a matching manner under a model field in a corresponding certain model table until the extraction of data under all fields in the ERP database is completed.

Preferably, the table name in the ERP database may be identical to the model table, and the field name in the ERP database may also be identical to the model field, so that the field matching may be performed directly to complete the field-by-field data storage.

However, in the current ERP software of different brands, not only the corresponding database types are different, but also the form names and the field names are different. The following will explain how to accommodate the table names and how to accommodate the field names, respectively.

(1) How compatible to the table name.

Tables in general ERP software include a financial data table, a production data table, a purchase data table, a sales data table, an enterprise basic data table and the like.

The table names corresponding to different tables in ERP software of different brands may be different (1, different calluses, 2, different languages, such as chinese, english, etc.).

Therefore, an ERP model table is preset in a data logic model module in the acquisition software, and table names of the ERP model table are standard table names. And the collector is preset with corresponding table name matching rules, such as: if the table name of a model table is A1, the table name of the same table in the ERP software of brand 1 is A2, and the table name of the same table in the ERP software of brand 2 is A3, then the table name matching rule for brand 1 includes the correspondence between A1 and A2, and the table name matching rule for brand 2 includes the correspondence between A1 and A3.

It can be understood that, under different language models, the form names of ERP software of the same brand may also vary, and therefore, the correspondence relationship in the form name matching rule for a certain brand may not necessarily be one-to-one, but may also be one-to-many.

(2) How compatible to the field name.

There may be several fields under different tables, and different brands of ERP software may have different field names for the same field. Therefore, the field name of the model field is also preset in the ERP model table in the data logic model module. The collector is also provided with a field name matching rule. Here the same as the table name matching rule. For example, such as: the model table A1 contains model fields B1, B2, and B3, the ERP software of brand 1 contains fields B1, B4, and B5 in the table A2, the model table A1 corresponds to A2, B1 is the same, B2 corresponds to B4, and B3 corresponds to B5, so that, in the field name matching rule, the field name matching rule for brand 1 includes the correspondence between B2 and B4, and the correspondence between B3 and B5.

It can be understood that, under different language models, the field names of the ERP software of the same brand may also vary, and therefore, the correspondence relationship in the field name matching rule for a certain brand may not necessarily be one-to-one, but may also be one-to-many.

Based on the compatibility of the table names and the field names, the compatibility unloading of the ERP data of various brands is realized.

The collected ERP data can be filled in the pixel model field of the corresponding ERP model, and the collector only needs to store the ERP model table filled with the model field into a target database of a target server without performing any operation on the ERP server and the target server.

Further, as a preferred scheme, the ERP server has authentication software for sending an authentication code to the collector connected to the ERP server for the first time, the process needs to be started by a password, and for verifying the authentication code of the collector connected to the ERP server, and if the verification is successful, data collection is allowed, otherwise, the collection is rejected. Further preferably, the authentication code is sealed in the collector and cannot be seen or obtained from the outside.

The specific embodiments described herein are merely illustrative of the spirit of the invention. Various modifications or additions may be made to the described embodiments, or alternatives may be employed, by those skilled in the art, without departing from the spirit or ambit of the invention as defined in the appended claims.

Claims (10)

1. An ERP data acquisition method based on a portable collector is characterized by comprising the following steps:

s1, a collector responds to a power supply instruction, establishes data connection with an ERP server, controls system software to start and then controls collection software to start;

s2, the collector sends the driver data to the ERP server to enable the ERP server to install the driver of the collector, and then a collection software configurator for configuring collection software is started;

s3, the collector obtains configuration information through collection software, wherein the configuration information comprises a target database path and a target database port;

s4, after receiving a data acquisition instruction, the collector firstly determines a database driving program and then establishes data connection with a target database according to the database driving program, a target database path and a target database port;

and S5, responding to the database connection success command, starting data acquisition of the target database by the acquisition software, calling a network communication interface, and transmitting the acquired ERP data to the target server.

2. The ERP data collection method based on the portable collector as claimed in claim 1, wherein in step S2, the collection software is configured by the user through a manner of manually inputting configuration information.

3. The ERP data collection method based on the portable collector as claimed in claim 1, wherein in step S2, the collection software configurator has a self-running program capable of automatically searching configuration information, and the collection software is configured by starting the collection software configurator to automatically search configuration information.

4. The ERP data collection method based on the portable collector as claimed in claim 1, wherein in step S2, the collection software configurator has a self-running program capable of automatically searching a plurality of configuration information corresponding to each database in the ERP server, and the configuration information is selected by a user to configure the collection software.

5. The ERP data collection method based on the portable collector as claimed in claim 1, wherein a collection start control is provided in an operation interface of the collection software configurator, and a user triggers the collection start control to send a data collection instruction to the collector.

6. The ERP data collection method based on the portable collector as claimed in claim 1, wherein in step S4, the collector determines the database driver by any one of the following methods:

determining a target database type according to a target database port in the configuration information, and then determining a corresponding database driver according to the target database type;

analyzing a target database path in the configuration information to obtain a target database type, and then determining a corresponding database driver according to the target database type;

confirming a target database type according to the brand of ERP software installed on an ERP server and a preset corresponding relationship between a corresponding brand and the database type, and then determining a corresponding database driver according to the target database type;

and enabling the configuration information to simultaneously comprise the target database type, directly acquiring the target database type from the configuration information, and determining a corresponding database driver according to the target database type.

7. The ERP data collection method based on the portable collector as claimed in any one of claims 1-6, wherein the collection software comprises a data processing module and a data logic model module;

and in step S5, executing the SQL sentences written in advance through the SQL interpreter, the SQL optimizer and the SQL executor in the data processing module, acquiring ERP data from a target database, storing the acquired ERP data under model fields in an ERP model table through a data logic model module, and transmitting the ERP model table filled with the model fields to a target server.

8. The ERP data collection method based on the portable collector as claimed in claim 7, wherein the data processing module is connected to the interface cluster integrating the plurality of database drivers, and is used for connecting the target database by using the database drivers therein;

each ERP model table corresponds to a standard table name and a standard field name, and tables of various ERP data and rule tables of fields thereof corresponding to the ERP model table are also prestored in the data logic model module;

the ERP model table comprises a financial data table, a production data table, a purchase data table, a sales data table and an enterprise basic data table;

in step S5, the ERP data collected from the target database is stored in the corresponding model field of the corresponding ERP model table through the rule table.

9. A portable ERP data collector is characterized by comprising a main control chip, a memory, a data transmission interface, a power supply circuit and a network communication module, wherein the power supply circuit is connected with the data transmission interface;

the data transmission interface is used for carrying out data transmission with the ERP server after being plugged into the ERP server and obtaining power from the ERP server, and the power supply circuit converts the power voltage into the voltage required by the collector;

the network communication module is used for establishing wireless connection between the collector and the target server;

the memory is stored with system software and acquisition software which can run on the main control chip;

the system software is configured to be started by power supply, and controls the acquisition software to be started after being started;

the acquisition software is used for sending the collector driving program to an ERP server connected with the collector after being started, enabling the ERP server to start an acquisition software configurator used for configuring the acquisition software, acquiring the ERP data from a target database based on the configuration information, and finally transmitting the acquired ERP data to the target server after compatible processing.

10. The ERP data portable collector of claim 9, wherein the network communication module is a 4G communication module;

or the network communication module comprises a 4G communication module and a wifi communication module, and the communication module with the higher network speed is determined to be used to establish connection with the target server according to the network speed.

Images