Database Reference
In-Depth Information
4. On the next screen, you can define all the properties. Define the properties and
click on
OK
, and then click on the close button to get the connection added to
your repository.
Note that you need to have all the details available with you before you can configure the
relational database connection object:
•
Database name
: This specifies the name of the database, for example, Oracle,
SQL Server, and so on. In our case, we are using Oracle.
•
Database type
: This specifies the type of the database, for example, Oracle, SQL
Server, and so on. In our case, we are using Oracle.
•
Database user name
: This mentions the name of the database user who has prop-
er authentication to read from and write into the database table. We are using
HR
as the username for our reference.
•
Password
: This mentions the password for the user you mentioned under the
database username. We are using the password as
HR
for our reference.
•
Connect string
: This mentions the connection string that transfers the data to the
table. For our reference, we are using
XE
as the connection string.
•
Database code page
: This selects the code page associated with your database.
The details that need to be filled in are shown in the following screenshot:
