YAML
####################################################################################################
# Example YAML for Tot Plugin JDBC SQLServer #
# #
# This file has all the technical properties that can be edited for the client. #
# These properties have a default value in the application, #
# so there is no necessity to configure them. #
# Only configure these properties if they are going to be different to the value of this file, #
# this will make your files more clean and readable. #
####################################################################################################
#########################
### Server properties ###
#########################
server:
# Port where service will be listening
port: 15005
#############################
### Tot Plugin properties ###
#############################
totplugin:
server:
# Tot server URL. It is a list because Tot can have more than one instance running.
urls:
- https://tot1server.anjanadata.local/totserver/
################################
## url: connection url
## imType: EID / AD / NONE
## ## EID: for EntraID (former AzureAD)
## ## AD: for Windows AD
## ## NONE: leave empty the property for pure SQLServer (default value)
## imDomain: the domain of the IM to work with, it has no default value and it is only required if imType is not empty
## user: the user
## password: the password
## serverName: the server name
## databaseName: the database name
## principalId: the principal id
## principalSecret: the principal secret
## path-separator: separator on path attribute of the objects
## sampleRows: number of rows retrieved on sample data functionality
################################
connection:
- name: sqlserver-local
technology:
imType: <type>
imDomain: <domain>
url: <url>
user: <user>
password: <password>
serverName: <serverName>
databaseName: <databaseName>
principalId: <principalId>
principalSecret: <principalSecret>
path-separator: <principalSecret>
sampleRows: 15
# Role suffix to add on the role creation
rolePrefix: "_role"
# Properties to retry and wait if AzureAD is connected to SQLServer
azureCountRetry: 5
azureWaitRetry: 15
# To define the different ARIs of plugin functionalities
aris:
- ari: "anja:totplugin:extract:/jdbc/sqlserver/devQA/"
- ari: "anja:totplugin:sample:/jdbc/sqlserver/devQA/"
- ari: "anja:totplugin:create:/jdbc/sqlserver/devQA/"
- ari: "anja:totplugin:edit:/jdbc/sqlserver/devQA/"
- ari: "anja:totplugin:im:/jdbc/sqlserver/devQA/"
imAri: "anja:totplugin:im:/Azure Analytics/azureAD/devQA/"
# Prefix group to concat the group name
groupPrefix: Dsa_
# SQL queries for every action
sql:
query-pattern:
createRole: "CREATE ROLE {0}"
existRole: "SELECT DATABASE_PRINCIPAL_ID({0})"
grantSelect: "GRANT SELECT ON {0} TO {1}"
deleteRole: "DROP ROLE {0}"
revokeSelect: "REVOKE SELECT ON {0} FROM {1}"
# If we want to connect to an external AD different from AzureAD the createFromExternalProvider must be: CREATE USER [DOMAIN\{0}] FROM EXTERNAL PROVIDER WITH DEFAULT_SCHEMA = [{1}]
createFromExternalProvider: "CREATE USER [{0}] FROM EXTERNAL PROVIDER WITH DEFAULT_SCHEMA = [{1}]"
deleteUser: "DROP USER IF EXISTS [{0}]"
addMemberRole: "ALTER ROLE [{0}] ADD MEMBER {1}"
dropMemberRole: "ALTER ROLE [{0}] DROP MEMBER {1}"
########################
## Logs properties ###
########################
logging:
pattern:
# Pattern to convert logs in the convenient format for the client
console: "%clr(%d{yyyy-MM-dd HH:mm:ss.SSS}){faint} [TOT-PLUGIN-JDBC-SQLSERVER] %clr(${LOG_LEVEL_PATTERN:%5p}) %clr(${PID:- }){magenta} %clr(---){faint} %clr([%15.15t]){faint} %clr(%-40.40logger{39}){cyan} %clr(:){faint} %m%n${LOG_EXCEPTION_CONVERSION_WORD:%wEx}"
# Mark the level of log to show for every package. ERROR > WARN > INFO > DEBUG > TRACE
level:
# The main log level this is the base fot all logs
root: info
# Every package of code can be marked with a different log level, every package of code printed on log is selectable to have a record here and mark a log level
com.anjana: DEBUG
#################################
### Hecate(Eureka) properties ###
#################################
eureka:
client:
serviceUrl:
# Url where Tot is listening
defaultZone: http://totserver/totserver/eureka