User`s guide

Initial Setup Requirements
2-9
Initial Setup Requirements
Refer to the setup requirements below to establish the first connection to your database.
• For ODBC drivers, ensure 32-bit or 64-bit compatibility across your driver, database,
operating system, and MATLAB. For details, see “Configuring a Driver and Data
Source” on page 2-13.
• If you use Visual Query Builder (VQB) to explore the data in your database, you
need to migrate to the Database Explorer app. For details, see “Migrate from VQB to
Database Explorer” on page 4-2.
• Ensure you know the name of your database server or machine, the name of your
database, the port number, and your user name and password. For ODBC drivers,
once you create a data source, remember the data source name. For JDBC drivers,
ensure you know the file path of where the JDBC driver is installed. For some
JDBC drivers, you might need the URL string and the driver Java class object. For
some databases, you might need to know more credentials. Contact your database
administrator for all required database credentials needed for establishing connection
to your database.
• Ensure you have access to your database and driver documentation.
• Check if your database uses operating system authentication. If you can connect to
your database from outside of MATLAB without providing a user name and password,
then your database uses operating system authentication. Exceptions to this rule
are databases set up without any operating system or database authentication
requirements, such as Microsoft Access or SQLite database files. Additional steps
might be required to set up connection to your database using operating system
authentication from MATLAB.
• Ensure you have write access to the path MATLAB displays after executing prefdir
on the command line.