Running ETL Scenarios - Revision history

Maxlmus: /* Running ETL scenario using standalone executable */

2015-02-08T23:03:59Z

‎Running ETL scenario using standalone executable

2015-02-08T22:45:07Z

‎Running ETL scenario using standalone executable

2015-02-08T22:44:34Z

‎Running ETL scenario using standalone executable

2015-02-08T22:42:55Z

‎Running ETL scenario using standalone executable

2014-08-03T18:44:07Z

2014-08-03T18:42:35Z

2014-08-03T18:41:36Z

2014-08-03T12:25:07Z

2014-08-03T12:23:57Z

‎Using Web service to run ETL scenario

2014-08-03T12:14:37Z

← Older revision		Revision as of 23:03, 8 February 2015
Line 186:		Line 186:

	In this example move.xml ETL scenario located under the {app.data}/scenario folder will be executed using extract_load action. Alias test javadb will be used for the source connection and alias test oracle for the destination.		In this example move.xml ETL scenario located under the {app.data}/scenario folder will be executed using extract_load action. Alias test javadb will be used for the source connection and alias test oracle for the destination.
		+
		+	Read more about [[Configuration_file\|ETL Configuration File]].

	You can pass properties file name (or any other -D property) as a command line argument:		You can pass properties file name (or any other -D property) as a command line argument:

@@ Line 193: / Line 193: @@
 You can also set the name of the XML configuration file (connections):
-<pre>etl.exe -Detl.config.name=import_data_config.xml<.pre>
+<pre>etl.exe -Detl.config.name=import_data_config.xml</pre>
 Last but not least you can use properties file to define XML configuration file (connections):

@@ Line 189: / Line 189: @@
 You can pass properties file name (or any other -D property) as a command line argument:
-etl.exe -Dconfig.file.name=import_data.properties
+<pre>etl.exe -Dconfig.file.name=import_data.properties</pre>
 You can also set the name of the XML configuration file (connections):
-etl.exe -Detl.config.name=import_data_config.xml
+<pre>etl.exe -Detl.config.name=import_data_config.xml<.pre>
 Last but not least you can use properties file to define XML configuration file (connections):
-<syntaxhighlight>
+<pre>
 # don't modify
 network.appupdateurl=http://www.toolsverse.com/api/services/CheckForUpdates
@@ Line 203: / Line 203: @@
 app.title=ETL Framework
 etl.config.name=import_data_config.xml.xml
-</syntaxhighlight>
+</pre>
 == Creating and running ETL scenario using Data Explorer ==
 The best way to create, run and schedule ETL, data integration and data migration scenario is using [http://toolsverse.com/products/data-explorer/docs/doc.html#developetlscenarios Data Explorer] - an integrated ETL IDE.

@@ Line 186: / Line 186: @@
 In this example move.xml ETL scenario located under the {app.data}/scenario folder will be executed using extract_load action. Alias test javadb will be used for the source connection and alias test oracle for the destination.
 == Creating and running ETL scenario using Data Explorer ==
 The best way to create, run and schedule ETL, data integration and data migration scenario is using [http://toolsverse.com/products/data-explorer/docs/doc.html#developetlscenarios Data Explorer] - an integrated ETL IDE.

@@ Line 65: / Line 65: @@
 <pre>-Dnetwork.appserverurl=http://host:port/dataexplorer/ide</pre>
-You can use ETL_FRAMEWORK_HOME/config/etl.properties to set <pre>network.appserverurl</pre> or set it programmatically.
+You can use ETL_FRAMEWORK_HOME/config/etl.properties to set network.appserverurl or set it programmatically:
 Once server is configured using Web service is as easy as:

← Older revision		Revision as of 18:41, 3 August 2014
Line 65:		Line 65:
	<pre>-Dnetwork.appserverurl=http://host:port/dataexplorer/ide</pre>		<pre>-Dnetwork.appserverurl=http://host:port/dataexplorer/ide</pre>

		+	You can set property network.appserverurl in the ETL_FRAMEWORK_HOME/config/etl.properties or programmatically.
		+
	Once server is configured using Web service is as easy as:		Once server is configured using Web service is as easy as:

@@ Line 67: / Line 67: @@
 Once server is configured using Web service is as easy as:
-# Instantiating ETLConfig and adding all required connection information
+# Instantiating EtlConfig and adding all required connection information
 # Instantiating instance and initializing EtlRequest
 # Instantiating instance of the EtlService interface using ServiceFactory and appropriate dynamic proxy

← Older revision		Revision as of 12:23, 3 August 2014
Line 58:		Line 58:

	To run ETL scenario using Web service you need to have ETL server installed, configured, up and running. Please read [http://www.toolsverse.com/products/data-explorer/docs/doc.html#_Installing_Server here] how to install and configure ETL server.		To run ETL scenario using Web service you need to have ETL server installed, configured, up and running. Please read [http://www.toolsverse.com/products/data-explorer/docs/doc.html#_Installing_Server here] how to install and configure ETL server.
		+
		+	You will also need to specify -Dnetwork.appserverurl JVM option.
		+
		+	Example:
		+
		+	<pre>-Dnetwork.appserverurl=http://host:port/dataexplorer/ide</pre>
		+
		+	Once server is configured using Web service is as easy as:
		+
		+	# Instantiating ETLConfig and adding all required connection information
		+	# Instantiating instance and initializing EtlRequest
		+	# Instantiating instance of the EtlService interface using ServiceFactory and appropriate dynamic proxy
		+	# Calling EtlService#executeEtl

	Example:		Example:

@@ Line 57: / Line 57: @@
 == Using Web service to run ETL scenario ==
-To run ETL scenario using Web service you need to have ETL server installed, configured, up and running. Please read [http://www.toolsverse.com/products/data-explorer/docs/doc.html#installing_server here] how to install and configure ETL server.
+To run ETL scenario using Web service you need to have ETL server installed, configured, up and running. Please read [http://www.toolsverse.com/products/data-explorer/docs/doc.html#_Installing_Server here] how to install and configure ETL server.
 Example: