The Oracle adapter does not support connection to Amazon RDS DB instances, if you want to connect to the Amazon RDS DB instance, please use the Amazon RDS for Oracle adapter.
The above information is described in the following DataSpider Help.
URL:https://www.hulft.com/help/en-us/DataSpider/dss42sp2/help/en/adapter/database/oracle_environment.html
DataSpider Servista Ver.4.1 can use Amazon RDS for Oracle 12c adapter to connect Amazon RDS to Oracle 12c.
The above information is described in the following DataSpider Help.
URL:https://www.hulft.com/help/en-us/DataSpider/dss42sp2/help/en/adapter/cloud/amazonrds_oracle_environment.html
*Amazon RDS for Oracle 12c adapter is added by DataSpider Servista Ver.4.1. Also, the support version of the connection destination database is as described in the help above.
■Supplementary
If you use the Amazon RDS for Oracle 12c adapter, please note that it is necessary to install the library.
URL:https://www.hulft.com/help/en-us/DataSpider/dss42sp2/help/en/adapter/cloud/amazonrds_oracle_library.html