User`s guide

2 Getting Started with Database Toolbox
2-52
6
To establish the data source without Windows authentication, set Driver Type to
thin.
7
Click Test to test the connection. If your connection succeeded, Database Explorer
displays Connection Successful!
8
Enter a data source name in the Data Source Name field in the Create a New
JDBC data source dialog box. Use a new data source name that does not appear
in the existing list of data source names. Click Save. The new JDBC data source
appears in the list of data sources in the Connect to a Data Source dialog box.
9
If this time is the first time that you are creating a data source using Database
Explorer, the New file to store JDBC connection parameters dialog box opens.
Use this dialog box to create a MAT-file that saves your specified data source
information for future Database Explorer sessions. This MAT-file name is stored in
setdbprefs('JDBCDataSourceFile') and is valid for all MATLAB sessions.
Navigate to the folder where you want to put the MAT-file, specify a name for it that
includes a .mat extension, and click Save.
After you complete the data source setup, connect to the Oracle database using
Database Explorer or the command line with the JDBC connection.
Step 5. Connect using Database Explorer or the command line.
Connect to Oracle using Database Explorer.
1
After setting up the data source, to connect without Windows authentication, select
the data source that you set up from the Data Sources list. Enter a user name and
password. Click Connect.