Configuring Data Integrators

[Contents] [Prev] [Next] [Index] [Report an Error]

Configuring Data Integrators
To configure a data integrator, you must create a property file that contains specific properties for the overall data transfer and for the individual data processors. When you create a property file, you must:

Define logging properties (see Defining Logging Properties).

Define properties for the individual processors (see Defining Properties for the Individual Processors).

Define the order in which the processors are called (see Defining the Order of Processors).

Defining Logging Properties

You define logging properties by using the standard property names and values for SDX logging. Define the logging properties by using the following format:
Logger.<groupName>.<propertyName>=<value>
<groupName>—Name of group for this log

<propertyName>—Name of property

<value>—Value of property

For detailed information about configuring SDX logging properties, see SDX Components Guide, Vol. 1, Chapter 11, Configuring Logging.

Defining Properties for the Individual Processors

The properties that you must or can configure depend on the particular processor. You define properties by using the following format:
Processor.<processorName>.<propertyName>=<value>
<processorName>—Name of processor that you define; each processor in a property file must have a unique name

<propertyName>—Name of property; may comprise several text strings separated by dots

<value>—Value of property

The following sections describe how to define properties for each processor. For detailed information about each processor, see the online documentation on the SDX software CD in SDK/doc/dataint.

Database Reader

You must define the following properties for this processor:
Class of the processor

Data that you want to read from the database
Processor.dbreader.dbQuery=SELECT <sqlQuery>
<sqlQuery>—SQL query that summarizes and processes data from the database
Class of the JDBC driver
Processor.dbreader.driverClass=<driverClass>
<driverClass>—Class of JDBC driver
URL of the database
Processor.dbreader.dbURL=<databaseURL>
<databaseURL>—URL of the database
Username and password for logging into the database
Processor.dbreader.user=<username>
Processor.dbreader.password=<password>
<username>—Username that the database uses to authenticate the processor

<password>—Password that the database uses to authenticate the processor
Output format, Document Object Model (DOM) for the query result
Processor.dbreader.out=dom
Inclusion of data in the XML document that the processor returns
Processor.dbreader.genData=true
You can also define optional properties about the database from which this processor reads data. For information about optional properties for this processor, see the online documentation on the SDX software CD in SDK/doc/datint.

Example
# Database Reader
Processor.dbreader.class=net.juniper.smgt.ent.datamgt.reader.DBReader
Processor.dbreader.driverClass=org.gjt.mm.mysql.Driver
Processor.dbreader.dbURL=jdbc:mysql://127.0.0.1:3306/vpn
Processor.dbreader.user=admin
Processor.dbreader.password=secret
Processor.dbreader.genData=true
Processor.dbreader.out=dom
# The SQL query 
Processor.dbreader.dbQuery=SELECT vpn_ownership.vpn_id, 
vpn_ownership.vpn_owner,vpn_sites.router_name,vpn_sites.interface_name    FROM 
vpn_ownership, vpn_sites where vpn_ownership.vpn_id=vpn_sites.vpn_id
# XML element names
Processor.dbreader.elname.database=database
#Processor.dbreader.elname.record=record
LDAP Reader

This processor obtains the query it performs as an XML document from the previous processor in the chain, and you do not need to define the query. You must, however, define the following properties for this processor:
Name of the class of the processor

DES properties in the format
Processor.<processorName>.<desProperty>=<value>
<processorName>—Name of processor that you define; each processor in the same property file must have a unique name

<desProperty>—Name of the DES property

<value>—Value of the DES property

For information about DES properties and values, see SDX Components Guide, Vol. 1, Chapter 12, Configuring the Directory Eventing System.

Any optional properties that you require

For information about optional properties for this processor, see the online documentation on the SDX software CD in SDK/doc/dataint.

Example
Processor.ldapreader.class=net.juniper.smgt.ent.datamgt.reader.LDAPReader
Processor.ldapreader.java.naming.provider.url = ldap://127.0.0.1/
Processor.ldapreader.java.naming.security.principal = cn=umcadmin,o=umc
Processor.ldapreader.java.naming.security.credentials = admin123
Processor.ldapreader.continuous=true
Processor.ldapreader.java.naming.provider.url = ldap://127.0.0.1/
XML File Reader

You must define the following properties for this processor:
Name of the class of the processor

In the following format, the XML document from which this processor reads data:
Processor.<processorName>.XMLFileName= <path>
<processorName>—Name of processor that you define; each processor in the same property file must have a unique name

<path>—Path to XML document relative to the folder /opt/UMC/datint

Example
Processor.xmlfilereader.class=net.juniper.smgt.ent.datamgt.reader.XMLFileReader
Processor.xmlfilereader.XMLFileName=var/log/dbout.xml
Enterprise Audit File Reader

You must define the following properties for this processor:
Name of the class of the processor

In the following format, the log file from which this processor reads data:
Processor.<processorName>.auditFileName=<path>
<processorName>—Name of processor that you define; each processor in the same property file must have a unique name

<path>—Path to XML document relative to the folder /opt/UMC/datint

Any optional properties that you require

For information about optional properties for this processor, see the online documentation on the SDX software CD in SDK/doc/dataint.

Example
Processor.auditfilereader.class=net.juniper.smgt.ent.datamgt.reader.EntAuditFileReader
Processor.auditfilereader.auditFileName=ent_audit.log
Processor.auditfilereader.filter=(Action=Unexport-VPN)
XML File Writer

You must define the following properties for this processor:
Name of the class of the processor

In the following format, the XML document to which the processor writes data:
Processor.xmlfilewriter.XMLFileName=<path>
<path>—Path to XML document relative to the folder /opt/UMC/datint

Example
Processor.xmlfilewriter.class=net.juniper.smgt.ent.datamgt.filter.XMLFileWriter
Processor.xmlfilewriter.XMLFileName=var/log/ldapout.xml
XSLT Translator

You must define the following properties for this processor:
Name of the class of the processor

In the following format, the XSLT file that the processor uses
Processor.<processorName>.XSLTFileName=<path>
<processorName>—Name of the XSLT translator

<path>—Path to XSLT file relative to the folder /opt/UMC/datint

Example
Processor.toabstract.class=net.juniper.smgt.ent.datamgt.filter.XSLTTranslator
Processor.toabstract.XSLTFileName=xslt/vpn.xslt
LDAP Writer

You must define the following properties for this processor:
Name of the class of the processor

DES properties in the format
Processor.ldapwriter.<desProperty>=<value>
<desProperty>—Name of the DES property

<value>—Value of the DES property

For information about DES properties and values, see SDX Components Guide, Vol. 1, Chapter 12, Configuring the Directory Eventing System.

Any optional properties that you require

For information about optional properties for this processor, see the online documentation on the SDX software CD in SDK/doc/dataint.

Example
Processor.ldapwriter.class=net.juniper.smgt.ent.datamgt.filter.LDAPWriter
Processor.ldapwriter.java.naming.provider.url = ldap://127.0.0.1/
Processor.ldapwriter.java.naming.security.principal = cn=umcadmin,o=umc
Processor.ldapwriter.java.naming.security.credentials = admin123
Processor.ldapwriter.updateRateLimit=3
Processor.ldapwriter.continuous=true
Defining the Order of Processors

To define the order in which the processors will be executed, enter one statement in the following format:
Processor.chain=<comma-separated list of names of processors in order>
For example:
Processor.chain=dbreader,toldap,xmlfilewriter,ldapwriter

[Contents] [Prev] [Next] [Index] [Report an Error]