%% 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 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')

% 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)

%
% Save the configured data source.

saveAsJDBCDataSource(opts)

% You can connect to the new data source using the database function or the Database Explorer app.
%
% Copyright 2019 The MathWorks, Inc.