Follow these steps to connect to oracle database:
1. Click on New data source.
2. Go to More and select Oracle database.
3. Type your server name.
4. Enter username and password.
5. Type any sql statements. (optional)
6. click on sign in.
7. Select required tables and fields residing in oracle database for creating your report and visualization.
8. Go to sheet.
Hope this helps you.