You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 19 Next »


The Perspectium DataSync Agent (previously Replicator Agent) requires that you have the following user permission, system, network, and Java version specifications shown below.


System

System Requirements
Memory8GB minimum
Processor Cores4 minimum
Hard Disk Space

100GB minimum

(info) NOTE: The DataSync Agent will only run if 100GB of space is available on the partition that the Agent is installed on

Network InterfaceGigE

Supported Operating Systems

The following operating systems are supported by the Agent:

OSVersion
Windows Professional/Home 7+

Server 2012+
Linux*Red Hat 6+

Ubuntu 14.04+

CentOS 6+

*These versions have been tested to work with the Agent.  Other versions with equivalent Linux kernel and meeting the other requirements above (System, Java, etc.) may also be able to run the Agent. Please contact Perspectium Suppport for more information.

Network

The DataSync Agent requires only outbound access to the Perspectium cloud and the ServiceNow instance.

Perspectium products require that your firewall settings allow traffic to and from your Perspectium MBS. This can be through any one of the following three ports: AMQP, AMQPS, or HTTPS. You will specify which protocol you will be using through the URL of the <message_connection>.

The Agent also requires that your firewall settings allow traffic to and from your ServiceNow instance. To test this access you can consult this page.

Network Requirements
AMQPS Outbound PortTCP/5671 outbound to your Perspectium MBS (amqps://example.perspectium.net)
AMQP Outbound PortTCP/5672 outbound to your Perspectium MBS (amqp://example.perspectium.net)
HTTPS Outbound PortTCP/443 outbound to your Perspectium MBS (https://example.perspectium.net)
HTTPS Outbound PortTCP/443 outbound to your ServiceNow instance



Java

Both 32 and 64 bit versions of Java are supported. The Java version must be Java 8 or higher. As of the Fluorine release, Java versions 9 and 10 are supported. It's strongly recommended that you use a server type JVM instead of a client or desktop version. Both Java and OpenJDK are supported.

DataSync Agent versionJava 7 & earlierJava 8Java 9Java 10Java 11Java 12
Argon & earliertinymce.emotions_dlg.errortinymce.emotions_dlg.checktinymce.emotions_dlg.errortinymce.emotions_dlg.errortinymce.emotions_dlg.check
Bismuthtinymce.emotions_dlg.errortinymce.emotions_dlg.checktinymce.emotions_dlg.errortinymce.emotions_dlg.errortinymce.emotions_dlg.check
Carbontinymce.emotions_dlg.errortinymce.emotions_dlg.checktinymce.emotions_dlg.errortinymce.emotions_dlg.errortinymce.emotions_dlg.check
Dubniumtinymce.emotions_dlg.errortinymce.emotions_dlg.checktinymce.emotions_dlg.errortinymce.emotions_dlg.checktinymce.emotions_dlg.check
Europiumtinymce.emotions_dlg.errortinymce.emotions_dlg.checktinymce.emotions_dlg.checktinymce.emotions_dlg.checktinymce.emotions_dlg.check
Fluorinetinymce.emotions_dlg.errortinymce.emotions_dlg.checktinymce.emotions_dlg.checktinymce.emotions_dlg.checktinymce.emotions_dlg.check
Fluorine Plustinymce.emotions_dlg.errortinymce.emotions_dlg.checktinymce.emotions_dlg.checktinymce.emotions_dlg.checktinymce.emotions_dlg.check
Goldtinymce.emotions_dlg.errortinymce.emotions_dlg.checktinymce.emotions_dlg.checktinymce.emotions_dlg.checktinymce.emotions_dlg.checktinymce.emotions_dlg.check

(info) NOTE: Perspectium DataSync Agents typically provide support for the latest version of Java with our next release that follows the Java version's general release date.


ServiceNow

The DataSync Agent requires a ServiceNow user in order to access the ServiceNow table schemas you share.  This user you specify must be a local user in the ServiceNow instance (i.e. it cannot be a SSO user) that is given at minimum the perspectium role and has permissions to invoke a processor.


Supported Databases

DatabaseVersion
Oracle11g, 12c Release 1: 12.1 - 12.2
SQL Server (MSSQL)2010 - 2019
MySQL5.6 - 8.X.X
SAP HanaSPS 12
Amazon Redshift4.0-4.1
Amazon Aurora (MySQL compatible)N/A
IBM DB211
HP Vertica8.0 - 9.21
PostgreSQL9.6
Snowflake2.0 - 3.9
Microsoft Azure SQL12.X

Database User Permissions

The following are the required permissions that you will configure within the Replicator Agent:

PermissionDescription
Create a new database 

After installation has been performed and the Replicator Agent is started, the agent establishes a connection to the database server using the credentials configured. 

This task must be completed successfully before the agent will proceed with subsequent processing. Once the connection has been established, the agent will attempt to create the configured database.

This step requires that the configured user has the proper permissions to create a new database. If this is not the case then an error will occur. As an alternative, the required database can be created by something or someone other than the agent. When this approach is taken you add the configuration directive <skip_database_creation/> to the configuration and the agent will not attempt to create the database since this tell the agent that the database already exists.

Create tables within defined databases

Once replicated data is available, the agent will determine if the table associated with the replicated data exists, and if not, the agent will create it. This means that the configured user must have the permissions required to create tables within the defined database.

Query database and associated tables and update data in existing tablesWhen you share out data to be consumed by the Replicator Agent, you'll typically specify whether the data is being shared in bulk or dynamically. When the data is shared in bulk and based on how the agent has been configured, it will typically perform a query in order to determine if the row already exists in the database. The agent must therefore have permission to query the database and the associated tables. If the agent determines that the row already exist then it performs an update, otherwise it will insert the row. The agent must have permission to perform both these actions.
Insert data into tables

Once the required table has been created the agent will perform an insert in order to populate the table with the replicated row. This means that the agent must have the permissions to perform an insert into the table.

Alter table

The agent wants to ensure that all data is replicated. It's possible that the structure of the source table has changed.

For example, an additional column has been added to the table or the size of a column has been increased. The agent performs the analysis required to make this determination and by default will alter the table in order to align it with the source table. Currently, Perspectium supports adding a column and increasing the size of a text or character type column to the maximum. Additionally, if the database supports it, a text or character type column can be modified to a larger type of text or character column. Currently, Perspectium does not support altering from one type to another such as a text or character type being modified to an integer or an integer to a float etc.. The agent must therefore have the permissions to alter the table.

(info) NOTE: It is possible to constrain the agent from altering tables by including the <skip_alter/> directive within the SQL Subscribers <task> definition.

Delete table rowIn order to support the deletion of rows from a table, the database user must also have permission to delete a table row