saveAsJDBCDataSource

(To be removed) Save JDBC data source

The saveAsJDBCDataSource function will be removed in a future release. Use the saveAsDataSource function instead. For details, see Compatibility Considerations.

Syntax

saveAsJDBCDataSource(opts)

Description

example

saveAsJDBCDataSource(opts) saves the JDBC data source specified by the JDBCConnectionOptions object opts.

Examples

collapse all

Create JDBC Data Source

Create, configure, test, and save a JDBC data source for a Microsoft^® SQL Server^® database.

Create an SQL Server data source.

opts = configureJDBCDataSource('Vendor','Microsoft SQL Server')

opts = 

  JDBCConnectionOptions with properties:

                      Vendor: 'Microsoft SQL Server'
              DataSourceName: ''

                DatabaseName: ''
                      Server: 'localhost'
                  PortNumber: 1433
                    AuthType: 'Server'

          JDBCDriverLocation: ''

opts is a JDBCConnectionOptions object with these properties:

Vendor — Database vendor name
DataSourceName — Name of the data source
DatabaseName — Name of the database
Server — Name of the database server
PortNumber — Port number
AuthType — Authentication type
JDBCDriverLocation — Full path of the JDBC driver file

Configure the data source by setting the JDBC connection options for the data source SQLServerDataSource, database server dbtb04, port number 54317, full path to the JDBC driver file, and Windows® authentication.

opts = setConnectionOptions(opts, ...
    'DataSourceName','SQLServerDataSource', ...
    'Server','dbtb04','PortNumber',54317, ...
    'JDBCDriverLocation','C:\Drivers\sqljdbc4.jar', ...
    'AuthType','Windows')

opts = 

  JDBCConnectionOptions with properties:

                      Vendor: 'Microsoft SQL Server'
              DataSourceName: 'SQLServerDataSource'

                DatabaseName: ''
                      Server: 'dbtb04'
                  PortNumber: 54317
                    AuthType: 'Windows'

          JDBCDriverLocation: 'C:\Drivers\sqljdbc4.jar'

The setConnectionOptions function sets the DataSourceName, Server, PortNumber, AuthType, and JDBCDriverLocation properties in the JDBCConnectionOptions object.

Test the database connection with a blank user name and password. The testConnection function returns the logical 1, which indicates the database connection is successful.

username = "";
password = "";
status = testConnection(opts,username,password)

status = logical

   1

Save the configured data source.

saveAsJDBCDataSource(opts)

You can connect to the new data source using the database function or the Database Explorer app.

Input Arguments

collapse all

`opts` — JDBC connection options
`JDBCConnectionOptions` object

JDBC connection options, specified as a JDBCConnectionOptions object.

Alternative Functionality

App

You can save a JDBC data source by using the JDBC Data Source Configuration dialog box in the Database Explorer app. In the Data Source section of the Database Explorer tab, select Configure Data Source > Configure JDBC data source.

Compatibility Considerations

expand all