Remote database connection configuration
Overview
SDI can connect to a remotely installed database through the SDI Gateway Service.
To connect to a remote database using the SDI Gateway Service:
- Select "Select Remote Database(via SDI Gateway Service)" as the location.
- Choose the appropriate data type.
- Configure the detailed settings accordingly.
The SDI Gateway Service must be installed and set up beforehand.
Configuration
| No | Item | Description |
|---|---|---|
| 1 | Location | Select Remote Database(via SDI Gateway Service) |
| 2 | Date Type | Select the type of target database. * Oracle, SQL Server, MySQL and PostgreSQL are supported. |
| 3 | End Point Address | Enter the End Point Address of SDI Gateway Service. |
| 4 | User Authentication Method | Select User Authentication Method There are three types of authentication methods: None, Basic and UserPsk. If Basic and UserPsk are selected, enter the credentials. |
| 5 | Application Authentication Method | Select Application Authentication Method. There are two types of authentication methods, None and ApplicationPsk. If ApplicationPsk is selected, enter the credentials. |
| 6 | ConnectionString | Please enter the name of the ConnectionString set on the SDI Gateway Service side. |
| 7 | Network Data Encryption | Whether to encrypt the data when SDI communicates with the SDI Gateway Service. (This setting is valid only when the End Point Address is http. If the End Point Address is https, ssl encrypted communication is performed, so this setting will be ignored.) |
| 8 | Network Data Compression | Whether to compress the data when SDI communicates with the SDI Gateway Service. |
| 9 | Default Schema | If Default Schema is specified, the tables and views of the specified schema will be listed during mapping. If blank, all accessible tables and views will be listed. |