Here has two system, an ERP system, a WMS system, to the two database for docking, want to use the table in the middle of the form, but I don't have experience here, what to do, give advice or comments please god

CodePudding user response:

Among this library is defined, in the form of data is how to pass through the middle of the two system database?

CodePudding user response:

If it's not middle library, and what way?

CodePudding user response:

What is ERP and the WMS with database?
In SQL directly pull or use the ETL tool transformation

The key is clear on all the data structures on both sides of the?

CodePudding user response:

According to the object library use ETL data structure

CodePudding user response:

Reading ERP library data from the link to the server, and then insert into (required fields without all) you in the middle of the library, the library in the middle of the table, then according to your business, from the middle library to select the related data, added to the business table, general ERP synchronization is all some documents (PO, for the single), the decisions from the table, general average is such,

CodePudding user response:

Intermediate landing file export and import respectively

CodePudding user response:

Can use datastage etl tools such as kettle directly connects two libraries corresponding table; Or, if you don't make a direct connection system directly, through an exchange platform, the source data into the FTP on the server, and then you can also use datastage, etl tools such as kettle, can also write a sqlload load data

CodePudding user response:

May want to see what I wanted to be when, do interactive platform, data or data warehouse, data loading is offline etl and online real-time, specific see enterprises now equipped with the system the data interaction and frequency of use, but no matter how to establish the underlying layer source data are necessary,

CodePudding user response:

"Docking" this concept is too vague, if have A, B two systems, what is the scope of data sharing about? Or convert A to B, can be read or is put into A B can read, can't see what need to design A C can read on both sides,