Documentation

This is machine translation

Translated by Microsoft
Mouseover text to see original. Click the button below to return to the English verison of the page.

Note: This page has been translated by MathWorks. Please click here
To view all translated materals including this page, select Japan from the country navigator on the bottom of this page.

Working with Database Explorer

If you are using Database Explorer for the first time, set Database Explorer preferences. Then, you can configure data sources and connect to your database.

Getting Started with Database Explorer

Database Explorer is a Database Toolbox™ app for connecting to a database and interacting with database data. You can configure ODBC and JDBC data sources, modify database connections, and work with multiple databases. You can also display data from a database table, explore data from multiple database tables, and import data to the MATLAB® workspace for analysis. Once you create queries using Database Explorer, you can generate code. For details, see:

Set Database Explorer Preferences

  1. On the Database Explorer Toolstrip, select Preferences to open the Database Explorer Preferences dialog box. These preference settings apply only to Database Explorer.

  2. Specify the Preferences settings that apply to Database Explorer as described in the following table.

    PreferenceAllowable ValuesDescription

    Data Preview size

    510,000 rows

    The number of rows that you see in the Data Preview pane of Database Explorer.

    Import batch size

    1,0001,000,000 rows

    The number of rows fetched at one time from a database. When importing large amounts of data using Database Explorer, tune this value for optimum performance. For details, see Preference Settings for Large Data Import.

    Select Database Toolbox to manage additional preferences for Database Toolbox. For details, see Working with Preferences. Alternatively, use setdbprefs to specify preferences for the retrieved data.

  3. Click OK.

See Also

|

Related Topics

Was this topic helpful?