Ask you about the various ETL tools, remote data integration problem of data tra

Consult a version of the older generation, the mainstream of some data integration related products such as Powercenter, OWB, SSIS and Datastage etc. these, remote data integration is by what means (such as to load the database to extract data from a machine to machine database to)? That is to say, the data in the transmission network is how to achieve?


They are not all of the process to the ODBC data source to do? For example, the establishment of a ODBC data source in the B machine (assuming A) points to a machine database, in addition to build an ODBC data source (assuming B to b) on the machine in the products database, an extraction, A data source configuration to the B data source conversion, loading process and the implementation of.


Or is it the other way, such as a data transmission process displays these products: in a machine extracted form the intermediate file, the intermediate file transfer to B machine and then loaded into the database?


Or some other means.?


This problem is more urgent, please pointing pointing, thank you!!

Started by Austin at December 16, 2016 - 5:35 AM

I.
If is a local area network, ODBC.

Posted by Carina at December 24, 2016 - 6:20 AM

In a machine extracted form the intermediate file, the intermediate file transfer to B machine and then loaded into the database
This is a more reliable method, but the middle process can be complex, involving FTP transmission details.

Posted by Tyrone at January 01, 2017 - 6:23 AM

Data extraction methods from the network to consider is divided into the following three:
LAN: the definition of ODBC
Man: general optical fiber connection, can directly access to the target machine can also adopt ODBC mode
Wan: usually adopt FTP mode

Posted by Edward at January 06, 2017 - 6:24 AM