%% 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 for a JDBC database connection.

vendor = "Microsoft SQL Server";
opts = databaseConnectionOptions("jdbc",vendor)

% opts is an SQLConnectionOptions object with these properties:
% DataSourceName — Name of the data source
% Vendor — Database vendor name
% JDBCDriverLocation — Full path of the JDBC driver file
% DatabaseName — Name of the database
% Server — Name of the database server
% PortNumber — Port number
% AuthenticationType — Authentication type
%
% Configure the data source by setting the JDBC connection options for the data source SQLServerDataSource, full path to the JDBC driver file, database name toystore_doc, database server dbtb04, port number 54317, and Windows® authentication.

opts = setoptions(opts, ...
    'DataSourceName',"SQLServerDataSource", ...
    'JDBCDriverLocation',"C:\Drivers\mssql-jdbc-7.0.0.jre8.jar", ...
    'DatabaseName',"toystore_doc",'Server',"dbtb04", ...
    'PortNumber',54317,'AuthenticationType',"Windows")

% The setoptions function sets the DataSourceName, JDBCDriverLocation, DatabaseName, Server, PortNumber, and AuthenticationType properties in the SQLConnectionOptions 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.

saveAsDataSource(opts)

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