Installation Guide for Microsoft SQL Server with Red Hat JBoss

10.3

Back Next

Step 1. Creating Data Sources

Before you manually deploy the Hub Server applications, create data sources. Also, if you want to configure multiple

Process Servers

or troubleshoot installation issues, create data sources.

Create the following directory structure under

JBoss installation directory

>/modules/

/com/informatica/mdm/jdbc/main

In the

main

directory, create the

module.xml

file with the following content:

<?xml version="1.0" encoding="UTF-8"?>
<module xmlns="urn:jboss:module:1.0" name="com.informatica.mdm.jdbc">
	<resources>
		<resource-root path="<JDBC driver file name>"/>
	</resources>
	<dependencies>
		<module name="javax.api"/>
		<module name="javax.transaction.api"/>
	</dependencies>
</module>

Download and copy the supported version of the JDBC drivers to the

main

directory.

Open the JBoss Management console, and click

Profile

The

Datasources

page appears.

Click

Connector

Datasources

Click the

XA Datasources

tab.

The

JDBC XA Datasources

page appears.

Click

Add

The

Create XA Datasource

dialog box appears.

Enter values in the

Name

and

JNDI Name

fields, and click

The following table lists the syntax of the values to specify:

Field Name	Syntax of Value
Name	jdbc/siperian-<Microsoft SQL Server host name >-<Operational Reference Store name>-ds
JNDI Name	java:jboss/datasources/jdbc/siperian-<Microsoft SQL Server host name>-<Operational Reference Store name>-ds

The

XA Datasource

page appears.

In the XA Datasource Class field, enter

com.informatica.mdm.jdbc

, and click

The

XA Properties

page appears.

Enter the key and value pairs, and click

The following table lists the key value pairs:

Key	Value
DatabaseName	Name of the Operational Reference Store
PortNumber	1433
SelectMethod	cursor
ServerName	Microsoft SQL Server host name

The

Connection Settings

window appears.

Enter values for the connection settings, and click

Done

The following table describes the connection fields:

Field Name	Description
Username	Name of the Operational Reference Store
Password	Password to access the Operational Reference Store

The

JDBC XA Datasources

page appears.

In the Selection section, edit the properties under the

Pool

tab.

Property	Value
Min Pool Size	5
Max Pool Size	100
Strict Minimum	false
Prefill enabled	false
Flush Strategy	FailingConnectionOnly
Idle Timeout	0
Track Statements	false

In the Selection section, edit the properties under the

Validation

tab.

Property	Value
Valid Connection Checker	org.jboss.jca.adapters.jdbc.extensions.mssql.MSSQLValidConnectionChecker
Check Valid Sql	Not applicable
Validate On Match	false
Background Validation	false
Validation Millis	0
Stale Connection Checker	Not applicable
Exception Sorter	Not applicable