We recommend a BI tool: Talend Open Studio. I also just contact, know not much, feel more magical I would like to recommend you ...
Because of the company project, touch the BI tool Talend, feel very powerful, can synchronize a variety of databases, but also can clean, filter, Java code processing data, data import and export.
You can even query multiple databases inline, feeling more magical. Of course, we can use SQL statements and programs can also be implemented, but for millions data, security and reliability ...?
This job involves: Excel data import, data cleansing, Java code processing, MySQL synchronization, MySQL and Oracle inline sync Oracle, synchronous SQL Server, data separation export file.
Problems encountered:
1. When using output, it feels best not to use existing or used links, which may occur and data cannot be inserted. You can create a new link.
2. With the Chinese data, when using the template components, especially output, remember to change the default encoding.
I feel like talend tools, which make data transfer, communication convenient and smooth, especially across a variety of databases. Can be distributed on a par with WCF and webservice, at least with them
The same solution for cross-platform data exchange. Suddenly feel as the developer of us, no matter what kind of development,. NET, Java, PHP, iOS, Andriod, WP. Actually we are a can
Co-ordination of the whole, not the respective camps. Because we can from the distributed perspective, cross-platform, database synchronization and other aspects of smooth data transmission and communication. Especially now, for a project,
No matter what kind of development, inevitably encounter bottlenecks, and even need a variety of platform parallel combination. We can combine the development techniques of each major development camp in a cost-controlled range.. NET can't solve things,
Not necessarily Java can not solve, just another Java service can ...., a site cannot solve the problem, we may enable multiple sites, multiple background services, or enable
More than one virtual machine or service .... Maybe we should go into other development camps and learn about their development skills ... and maybe we'll find out ... In fact, our development thinking is the same, we will not consciously
Compare with similar development technology ..., the principle of non-autonomous to locate the development technology ....
Talend Open Studio Data import, export, Sync mysql, Oracle, SQL Server simple case