Create a IBM Controller Financial Analytics Publisher database

When you install IBM® Controller Financial Analytics Publisher, you must create an empty Financial Analytics Publisher database. This is because Financial Analytics Publisher requires a database to publish data from the Controller database.

Procedure

  1. From the Start menu, start IBM Controller Configuration.

    If you are using a Microsoft Windows 2008 or Microsoft Windows 2012 computer, installed the product to the Program Files directory, and the User Account Control (UAC) is turned on, IBM Controller Configuration is identified as an administrative application; therefore, you must run it with elevated administrative privileges. To properly save the configuration settings, the UAC prompts for credentials if you are using a standard account.

  2. In the Explorer window, click Database Connections, and then click File > New.
  3. Type a name for the database connection.
  4. In the Provider field, type the name of the database provider, for example SQLNCLI11.1 for SQL Server.

    To obtain the database provider information, see the SQL Server documentation.

  5. Type the user name and password for the Controller FAP database.
  6. In the Initial catalog field, type the Controller FAP database name.
  7. In the Data source field, type the database server computer name.

    Do not use localhost.

  8. Click File > Save.
  9. Click Actions > Run.

    The Database Conversion Utility opens.

  10. Click FAP DB.
  11. In the Database Conversion Utility window, click Connect, and then Create Db.

    The Database Conversion Utility initializes the database.

  12. To update an existing database, click Upgrade.

    The Database conversion Utility upgrades the existing database.

  13. Close the Database conversion utility.
  14. Click Actions > Check.

    If the database connection validation fails, review the database connection properties and fix any errors.