title: Streaming from Oracle Tables to Redshift
body: <p>I am new to Redshift and AWS eco-system. I am looking for options or best practices for streaming data changes from Oracle EBS tables on premise to Redshift.</p>
  
  <ol>
  <li>Should S3 be used as the staging area? Thus Oracle->S3->Redshift? Is that good for real-time streaming Oracle tables to Redshift?</li>
  <li>Any way to bypass S3 staging and do Oracle->AWS Kinesis(Firehose)->Redshift? If so, are there such scenarios I can read-up on?</li>
  <li>What about using Kafka instead of AWS Kinesis?</li>
  <li>Can AWS Kinesis or Kafka pull directly from an on-premise Oracle instance?</li>
  <li>Are there other alternatives/components, ETL tools for near real-time or almost real-time data load to Redshift?</li>
  </ol>
  
  <p>There is a large number of tables to stream from Oracle, which is on-prem. I am new to Redshift but familiar with Oracle, SQL Server, PG. Sorry if I am totally of beat here. </p>
  
  <p>Please help :) Any thoughts and/or references would be highly appreciated...</p>