Set Up ODBC Connection with Oracle Report Builder

Connection to an ODBC data source in Oracle Report Builder is established using bridged JDBC.

1. Download and install the NetSuite ODBC driver
2. Create a new Data Source by navigating to Start > Control Panel > Administrative Tools > Data Sources (ODBC)
3. Create a User and a System DSN following the instructions below:
   - click Add and choose the NetSuite ODBC Driver and click Finish
   - supply the following information:
     Data Source Name: {user defined}
   
   For production environments:
   OpenAccess Service Host: ODBCSERVER.NETSUITE.COM

    For test enviroments:
    OpenAccess Service Host: ODBCSERVER.NA1.NETSUITE.COM

    For sandbox environments:
    OpenAccess Service Host: odbcserver.sandbox.netsuite.com 

    For release preview enviroments:
    OpenAccess Service Host: odbcserver.na1.beta.netsuite.com  

     OpenAccess Service Port: 1708
     Encrypted (SSL): checked
     OpenAccess Service Data Source: NetSuite.com
4. Open Oracle Report Builder and navigate to File > New > Report
5. On the "Create New Report" popup, choose Use the Report Wizard
6. Choose the desired report Layout and Template format and click next after making your choice of layout
7. On the Data Source Type selection screen, choose JDBC Query and click Next
8. On the Data Source Definition window, click on Query Definition button
9. Enter the SQL query or stored procedure that defines the data to be included for the report, then click on the Connect button
10. On the Connect dialog box, enter the following information then click Connect:
   username: {NetSuite login email}
   password: {NetSuite login password}
   database: {the Data Source Name supplied in step 3}
   driver type: jdbc-odbc
11. Click OK then Next
12. Choose the field that needs to be displayed on the report and click on the succeeding Next buttons until formatting the report is done and click Finish when done