Database Schema Configuration
The figure shows the configuration fields for a MySQL database. The configurations for Oracle and SQL Server databases include some different fields.
The fields that are included on this dialog depend on the database management system you specify. Select one of the Database options, MySQL, Oracle, or SQL Server, and then enter values in the related fields.
• Host Name – Name of the server where MySQL is installed and hosts the database.
• Port Number – The default value is 3306. Change the value to something different only if you changed it during the MySQL installation.
• Database Schema Name – Name specified during the creation of the database schema. The typical value is apriori. Variations on the typical value also include software and company information such as version, geographic location, or division.
• Database Username – Username specified during the creation of the database schema.
• Database Password – Password specified during the creation of the database schema.
Oracle – Refer to Oracle Installation and Configuration or see your database administrator.
• URL Style Name – Select either SID or Service Name.
• Host Name – Name of the server where Oracle is installed and hosts the database.
• Port Number – this is typically 1521
• Database SID/Service Name –SID or service name of your database
• Database Username – enter the username of the aPriori database as configured by your database administrator
• Database Password – enter the password of the aPriori database as configured by your database administrator
• Host Name – This is the name of the server where SQL Server was installed and hosts the database.
• Port Number – this is typically 1433
• Database Instance Name – enter name of your database as configured in the SQL Server chapter
• Authentication Style – Select SQL Server or Windows, as configured in the SQL Server chapter
• Database Username – enter the username for the aPriori database as configured by your database administrator
• Database Password – enter the password for the aPriori database as configured by your database administrator
• Click Next when done.