Difference between revisions of "Creating a Data Set from a Database"
(→Connecting Rave to a Database) |
(→Creating a Rave Data Set from a Database) |
||
| Line 23: | Line 23: | ||
#Enter the data source name that you defined in step 3 above in the "Choose source file" text box. Enter any text in the "Name this data set" text box. (Rave will not use this information, but it won't let you click the Create this Data Set button while if this box is empty.) | #Enter the data source name that you defined in step 3 above in the "Choose source file" text box. Enter any text in the "Name this data set" text box. (Rave will not use this information, but it won't let you click the Create this Data Set button while if this box is empty.) | ||
#Click "Create this Data Set" | #Click "Create this Data Set" | ||
| + | #You will be prompted for a user name and password. If your database does not require a login, leave these blank and hit Ok. | ||
| + | #Next you will see a list of the Tables contained in your database. Highlight the tables that contain data that you wish to use in Rave. Rave will create one data set for each Table you select. Press Next when you are done. | ||
Revision as of 16:28, 26 October 2012
Introduction
If you have the MATLAB Database Toolbox, Rave can pull data from a compatible database to use as a Rave data set. This page describes the steps you need to take to link Rave to a database and describes how Rave behaves differently when your data is stored in a database.
Preparing a Database for use with MATLAB
To link Rave to a database, you must have the Database Toolbox installed. If you do not have the database toolbox, you cannot use Rave with your databases.
To connect to a database, you must first set up a connection in MATLAB. This only needs to be done once, ever, for each data source. (Not every time you start Rave or MATLAB, or even if you install a new version of Rave or MATLAB)
- Type "querybuilder" to open the Visual Query Builder dialog box.
- If you get an error, it means you don't have the Database Toolbox installed.
- Select "Define ODBC Data Source" from the Query Menu.
- Follow the prompts to create a new data source (see MATLAB help for more information).
- Note the name that you give your data source. This is what you will type into Rave to link to this database.
- When you are done, close the Visual Query Builder
Tip: If you forget what you named the data source, you can see a list of all data sources you have defined by typing "getdatasources" at the MATLAB prompt.
Creating a Rave Data Set from a Database
To work with data from a database in Rave, first complete the steps above. Then:
- Open Rave. On the Manage Tab, click Manage Data Sets
- Enter the data source name that you defined in step 3 above in the "Choose source file" text box. Enter any text in the "Name this data set" text box. (Rave will not use this information, but it won't let you click the Create this Data Set button while if this box is empty.)
- Click "Create this Data Set"
- You will be prompted for a user name and password. If your database does not require a login, leave these blank and hit Ok.
- Next you will see a list of the Tables contained in your database. Highlight the tables that contain data that you wish to use in Rave. Rave will create one data set for each Table you select. Press Next when you are done.
