Use this page to specify source database connection properties. After selecting the Database option and adding other relevant information on the New Data Source first page, POM displays the New Data Source second page with the options listed in the following table:
Note:
All fields on this page are mandatory. If the POM database restarts during an import, you might lose some data.
Field or Button |
Description |
Import From Following Database: |
Database |
Use the list to specify the database type. The following are the available options: MS-SQL, Postgres, and Oracle. |
Database Host Name |
Use to specify the hostname or IP address of the database server.
Note:
You cannot use the following characters:
|
Database Name |
Use to specify the database name.
Note:
You cannot use the following characters:
|
Database Port Number |
Use to specify the port number to connect to the database. The default ports to connect to the database are:
5432 to connect to Postgres database. 1521 to connect to Oracle database. 1433 to connect to MS-SQL database. |
Database User Name |
Use to specify the username to connect to the database.
Note:
You cannot use the following characters:
|
Database Password |
Use to specify the password to connect to the database. |
Test Connection |
Use to test the database connection. |
SQL Query |
Use to specify the SQL query to get the data from the external database. For example if you set the SQL query as select * from EMP, this imports all data from the EMP table.
Note:
You cannot specify any query which will modify the database data. For example, delete query, update query, insert query, or select into query.
Ensure that the query length does not exceed more than 3990 characters. This limit is applicable for all databases.
|
