Page History
You can configure your DataSync Agent to share data from ServiceNow or Salesforce to a PostgreSQL database by changing some additional configurations in your agent.xml file.
Prerequisites
First, you will need to Install the DataSync Agent.
You will also need to create a ServiceNow dynamic share/bulk share or create a Salesforce dynamic share/bulk share.
Make sure to stop running your DataSync Agent before making any Agent configuration changes.
Finally, you will need to create a database in PostgreSQL that will store data replicated via the DataSync Agent.
Procedure
To set up your DataSync Agent to share application data to a PostgreSQL database, follow these steps:
UI Steps | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Additional Configurations
For optional configurations for how the DataSync Agent interacts with your PostgreSQL database. Contact Contact Perspectium Support if you have any questions.
UI Expand | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||
By default, the DataSync Agent will set datetime fields with the timestamp data type which by default will not have a time zone. The PostgreSQL JDBC driver as used by the Agent does not support a time zone parameter so any datetimes are passed in based on the time zone of the server. If you are running the Agent on a server with a non-UTC time zone and want to ensure the records are saved properly so you can query the PostgreSQL database in different time zones, do the following:
Since ServiceNow's data is sent out is in UTC time, you can now query in different time zones by using the SET TIME ZONE '<TIME ONE>'; SQL command where <TIME ZONE> is the desired time zone to query in. For example SET TIME ZONE 'US/Eastern'; Will allow you to query for records in the US Eastern Timezone. See SET for more information. NOTE: Using SET only sets the time zone for the current session. Contact your Database/System Administrator for changing the default time zone as this requires modifying the postgresql.conf main configuration file. |