Efecte Provisioning Engine - Customer instructions for SQL Connector
Efecte Provisioning Engine - Customer instructions for SQL Connector
Customer instructions for SQL Connector
SQL connector is part of Efecte Connect, native connectors and it is used for reading (ITSM&IGA) and writing (IGA) data towards/from to customers database. It can be used for all Efecte solutions which are using Efecte Provisioning Engine.
Customer deliverables
| Information | Example |
|
SQL Username SQL account name which is used for reading data from customers database. This is send to responsible Efecte consultant via secure mail. |
Efecte_sql |
|
SQL Password Password for the database account. This is send to responsible Efecte consultant via secure mail |
Minimum 10 characters |
|
Port Port to be used for connection to customer database. Usually 389 or 636. |
636 |
|
SQL IP-address or hostname Host address or host name which will be used connecting to customers database |
10.1.11.1 |
|
SQL database type Which of the following is in use: MARIADB, MYSQL, POSTGRESQL, MSSSQLSERVER OR ORACLE |
ORACLE |
|
SQL database name Name of the database |
test |
SQL Connector Description
More info about SQL Connector can be found from here.
Test environment compared to Production
It is good practice to create a dedicated database and database account for the test environment.
Table of Contents