{"action":"created","issue":{"url":"https://api.github.com/repos/square/ETL/issues/11","labels_url":"https://api.github.com/repos/square/ETL/issues/11/labels{/name}","comments_url":"https://api.github.com/repos/square/ETL/issues/11/comments","events_url":"https://api.github.com/repos/square/ETL/issues/11/events","html_url":"https://github.com/square/ETL/issues/11","id":51536999,"number":11,"title":"Is it possible to load data from Source to Dest between servers?","user":{"login":"shut000","id":8196769,"avatar_url":"https://avatars.githubusercontent.com/u/8196769?v=3","gravatar_id":"","url":"https://api.github.com/users/shut000","html_url":"https://github.com/shut000","followers_url":"https://api.github.com/users/shut000/followers","following_url":"https://api.github.com/users/shut000/following{/other_user}","gists_url":"https://api.github.com/users/shut000/gists{/gist_id}","starred_url":"https://api.github.com/users/shut000/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/shut000/subscriptions","organizations_url":"https://api.github.com/users/shut000/orgs","repos_url":"https://api.github.com/users/shut000/repos","events_url":"https://api.github.com/users/shut000/events{/privacy}","received_events_url":"https://api.github.com/users/shut000/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2014-12-10T09:39:30Z","updated_at":"2016-01-24T23:52:15Z","closed_at":null,"body":"Is it possible to load data from Source to Dest between servers? Like what ETL usually does. Thanks!\r\nAnd I don't know where to add questions, just put it here..."},"comment":{"url":"https://api.github.com/repos/square/ETL/issues/comments/174354281","html_url":"https://github.com/square/ETL/issues/11#issuecomment-174354281","issue_url":"https://api.github.com/repos/square/ETL/issues/11","id":174354281,"user":{"login":"jeffreyiacono","id":63325,"avatar_url":"https://avatars.githubusercontent.com/u/63325?v=3","gravatar_id":"","url":"https://api.github.com/users/jeffreyiacono","html_url":"https://github.com/jeffreyiacono","followers_url":"https://api.github.com/users/jeffreyiacono/followers","following_url":"https://api.github.com/users/jeffreyiacono/following{/other_user}","gists_url":"https://api.github.com/users/jeffreyiacono/gists{/gist_id}","starred_url":"https://api.github.com/users/jeffreyiacono/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jeffreyiacono/subscriptions","organizations_url":"https://api.github.com/users/jeffreyiacono/orgs","repos_url":"https://api.github.com/users/jeffreyiacono/repos","events_url":"https://api.github.com/users/jeffreyiacono/events{/privacy}","received_events_url":"https://api.github.com/users/jeffreyiacono/received_events","type":"User","site_admin":false},"created_at":"2016-01-24T23:52:15Z","updated_at":"2016-01-24T23:52:15Z","body":"@Emerson @shut000 was just giving this a look over and have an idea on what could work here: right now we have `ETL.connection` that's used to speak with a single db via `#query`. This works fine when doing data processing within the same server / db, but totally see your use case. My thought: add a `ETL.read_connection` and ETL.write_connection` that you can set and then interact with through two new methods `#read` and `#write` which would use either `{read,write}_connection#query`. One requirement is we'd need to hold the read data in memory and then prepare it to be written, but that shouldn't been too bad!\r\n\r\nHappy to take a pass at doing the above, let me know if it's still something you're interested in!"}}