Creating a social database

To use an Apteco social integration, you need to create a Social database, define the connection strings to the database in both the FastStats Service and the FastStats Web Service and configure the following settings.

  • Open the FastStats Configurator and select Database Management.

FastStats Configurator

  • Select the Database Creation Wizard for the first time otherwise Database Update Wizard if your Social database already exists, then click Start Wizard.

Create Database Wizard

  • Connect to the database server using the credentials used when installing your Apteco system

If you see the following error click OK, but do not proceed, you may have used the FastStats default Username and Password which will connect but should not be used

  • Click Test Connection then click OK

User schema not dbo error

  • Enter your System name and Password

System Name

At this stage you may find the Social database already exists

Databases

FastStats Services

Define the database connection string for the Social database using your FastStats Service credentials

  • Click Edit Connection String

Choose Database

Connection String Builder

Test the connection

  • Click Test Connection then click OK

Test Connection

One more thing, please check the following topic

Social Audiences in PeopleStage