Closed

Extract huge Oracle table via VPN (NO split connection!)

The task is to find a way to pull a huge table with 80 million lines from an Oracle DB into a SQL DB or SQL dump via the internet. The source DB (Oracle) is in an enterprise setting with access being restricted to Cisco VPN. Split tunneling is not allowed! (This is my problem: This means a machine that is connected via the VPN has no internet access, a physical access to control the machine is therefore necessary.)

Simple converter tools I have tried suffer from a latency issue (84MB in 8 hours pulled), apparently they go line by line and the latency kills me.

The table itself is extremely simple (no no views, storage produceres, no indexes, identities etc.).

The task here is to find a workable way that allows the extraction of the table within hours, not month. And to explain the procedure and configuration clearly. Given data security issues the solution would then be implemented by myself.

Skills: Oracle, SQL

See more: oracle connection vpn latency, workable, sql to oracle, procedure sql oracle, db converter, cisco connected, oracle vpn problem, oracle sql with, tunneling, table, sql views, split, oracle data, Enterprise solution, table extract, apparently, extraction oracle, vpn cisco, setting sql, physical security, vpn oracle, oracle procedure, simple vpn, pull data sql, extract data internet

About the Employer:
( 0 reviews ) United Kingdom

Project ID: #1150299

3 freelancers are bidding on average $300 for this job

kfanx

I am an expert in Oracle 8.x/9.x/10G and Microsoft SQL 4.5/7/2000/2005/2008. Thanks!

$300 USD in 5 days
(0 Reviews)
0.0
rb2011

I would like to bid on your project I have extensive experience of Oracle data extraction and have developed a backup technology which would be suitable for your project. I look forward to working with you on thi More

$300 USD in 1 day
(0 Reviews)
0.0
heyGuru

Hi, I would like to use my long experience of databases technologies to see if my solutions can work, I have few approaches both from SQL and Oracle end. Please let me know how we can move forward. thanks.

$300 USD in 3 days
(0 Reviews)
0.0