Configuring the ETL.xml file

The ETL.xml file located in the XM_INSTALL_DIR/apache-tomcat-9.0.x/tools/etl/conf directory is used to configure the information required for a transformation. The parameters are simple. Examples and formats are provided for most of the parameters within the file. Only the parameters in italics require editing.

This is the example of an ETL.xml configuration, including some outlining comments:


<?xml version="1.0"?> 
<metadata>
<!--

The available drivers of the ETL tool:


--> 
<jdbc_drivers>  -- Available JDBC drivers 
<jdbc_driver type="oracle">oracle.jdbc.driver.OracleDriver</jdbc_driver> 
<jdbc_driver type="mssql">net.sourceforge.jtds.jdbc.Driver</jdbc_driver>
<jdbc_driver type="mssql">com.microsoft.sqlserver.jdbc.SQLServerDriver</jdbc_driver>
<jdbc_driver type="db2">COM.ibm.db2.jdbc.app.DB2Driver</jdbc_driver>  
</jdbc_drivers>
<!--

Note: The tool loads the appropriate drivers based on your database connection.

Specify the source (transaction) and destination (reporting) database connection information. Most of the connection information is simple, except for the db URL property. These are the examples of database URL formats used to establish a connection with the database.

MSSQL:

<dbUrl>jdbc:jtds:sqlserver://host:port;databaseName=dbName</dbUrl>

MSSQL with name instance to connect to:

<dbUrl>jdbc:jtds:sqlserver://host;instance=instance;databaseName=dbName</dbUrl>

Oracle:

<dbUrl>jdbc:oracle:thin:@host:port:sid</dbUrl>

Others:



<dbUrl>jdbc:db2:datasource</dbUrl>    
<dbUrl>jdbc:odbc:datasource</dbUrl>

Use one of these for db Type: oracle, mssql, db2


--> 
<connectionInfo> 
<source>            -- Transactional database connection information 
<dbType>mssql</dbType> 
<dbUrl> jdbc:jtds:sqlserver://paris:1433;databaseName=transdb</dbUrl> 
<dbName>transdb</dbName>  
<dbUser>sa</dbUser> 
<dbPassword>sa</dbPassword>  
</source> 
</connectionInfo> 

<connectionInfo> 
<destination> -- Reporting  database connection information 
<dbType>mssql</dbType> 
<dbUrl> jdbc:jtds:sqlserver://paris:1433;databaseName=eportingdb</dbUrl>
<dbName>reportingdb</dbName>  
<dbUser>sa</dbUser>
<dbPassword>sa</dbPassword>  
</destination>  
</connectionInfo>
<!--