title: Oracle to SQL server communication - JDBC vs ODBC
body: <p>Just looking for people's opinion regarding communication between an Oracle 10G database running on Unix and a SQL Server database running on Windows. </p>
  
  <p>I have a requirement to write a batch job that will read data from the Oracle database and populate the data onto a table on the SQL Server. </p>
  
  <p>Oracle supports "Heterogeneous Services" features where i can use an ODBC driver to create a database link from the Oracle database to the SQL Server database. </p>
  
  <p>The other option i have is use a Java process that uses JDBC to connect to the SQL Server and populate the data using the JDBC connection without database links. </p>
  
  <p>Curious to know the advantages and disadvantages of the two. </p>
  
  <p>Thanks</p>