Data Sync - Create Sync State Table
https://164.99.19.131:8443/SentinelRESTServices/datasync/syncstatetable
This creates a sync state table in a destination database.
Authentication
Sentinel Permissions Needed
URL Parameters
Required
Parameter | Type | Description |
password |
String |
The password of the user. |
schemaName |
String |
This is the schema the sync state table is to be created in. If this parameter is missing it defaults to the schema of the database user specified in the "userName" parameter. |
tablespaceName |
String |
Name of the tablespace in the destination database where the sync state table is to be created. NOTE: If this field is missing, the default tablespace will be used. |
Optional
Parameter | Type | Default Value | Description |
hostName |
String |
localhost |
Name or IP address of database system where the sync state table is to be created. If this parameter is missing, the default value will be "localhost". |
port |
int |
5432 |
Port for communicating with the database system where the sync state table is to be created. If this parameter is missing, the default value will be "5432". |
database |
String |
SIEM |
The name of the database in the database system where the sync state table is to be created. If this parameter is missing, the default value will be "SIEM". |
userName |
String |
appuser |
Name of the database user to login to the database system where the sync state table is to be created. If this parameter is missing, the default value will be "appuser". NOTE: This user should have sufficient rights to create a table. |
dbPlatform |
String |
postgresql |
This is the platform of the database system where the sync state table is to be created. It may be <strong>postgresql</strong>, <strong>oracle11g</strong> or <strong>mssql2008</strong>. If this parameter is missing, the default value will be "postgresql". |
Success Codes
Fault Codes
Sample Request
POST /datasync/syncstatetable?hostName=164.99.19.125&port=5432&userName=appuser&password=star1111&dbPlatform=postgresql&schemaName=my_schema&tablespaceName=tablespace1