Creating databases

Create databases for the applications that you plan to install. You can use the database wizard or run the SQL scripts that are provided with HCL Connections.

Attention:
  • The HCL Connections 7.0 database wizard does not create the database for the Community Highlights / Connections Engagement Center (CEC) or Feature Foundation | Export entries to PDF and provides support for Tailored Experience. The Community Highlights database scripts are located in the folder - /Wizards/connections.sql/icec. The Feature Foundation database scripts are located in the folder - /Wizards/connections.sql/ic360. Refer to the procedure in this section to create the databases. You will need to manually run the SQL scripts that are provided with HCL Connections. See Creating databases for more information.
  • Deployments that upgrade from Connections 6.5 CR1 are required to manually run the Homepage database schema for the SharePoint widget. SharePoint homepage schema script: \Wizards\connections.sql\homepage\<backend>\upgrade-60CR4-70.sql.
There are two methods available to create your databases: SQL scripts and the database wizard. Using SQL Scripts allows you to have more control as you manually create and place databases. The database wizard automates the process of creating databases for the applications that you plan to install. It is a more reliable method for creating databases because it validates the databases as you create them.
Note:
  • The user who runs the database wizard must have write access to the folder the database wizard uses for the installation. Consult your database documentation for detailed information about preparing your databases.
  • You must have already created and started a database instance before you can create databases.

If you install the database for Connections Content Manager, it creates two databases: Global Configuration Database and Object Store. Complete the procedures that are appropriate for your deployment: