- In the Navigator view, double-click Foreign Servers.
- Right-click the desired foreign server and select Modify Foreign Server.
-
[Optional] Click General to edit foreign server information.
You cannot edit the name of the foreign server.
- [Optional] Click Security to change the the name and security type for the authorization that stores the credentials for the foreign server.
- [Optional] Click Name Value Pairs to make changes to the name value pairs the table operators can use to connect to this foreign server.
- [Optional] Click Import to make changes to the IMPORT table operator associated with this foreign server for importing data into Vantage.
- [Optional] Click Export to make changes to the EXPORT table operator associated with this foreign server for exporting data out of Vantage.
- Click SQL to view the generated DDL.
- Click Commit.