Difference between revisions of "Creating a Data Set from a Database"
Deprecated: Optional parameter $attribs declared before required parameter $contents is implicitly treated as a required parameter in /var/www/vhosts/rave.gatech.edu/httpdocs/help/includes/Xml.php on line 131
(→Connecting Rave to a Database) |
(→Connecting Rave to a Database) |
||
| Line 5: | Line 5: | ||
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 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. | + | 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. | #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. | ##If you get an error, it means you don't have the Database Toolbox installed. | ||
| Line 12: | Line 13: | ||
#Note the name that you give your data source. This is what you will type into Rave to link to this database. | #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 | #When you are done, close the Visual Query Builder | ||
| + | |||
| + | 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. | ||
Revision as of 13:17, 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.
Connecting Rave to a Database
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
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.
