Random_normal
0
/
Y
N
0.0
0.0
10000
50
50
N
Y
50000
Y
Local MySQL
P4
P3
P2
P1
N
MySQL EC2 Schema
P5
P4
P3
P2
N
localhost:8084localhost8084clusterEncrypted 2be98afc86aa7f2e4cb1aa265cd86aac8N
localhost:8083localhost8083clusterEncrypted 2be98afc86aa7f2e4cb1aa265cd86aac8N
localhost:8082localhost8082clusterEncrypted 2be98afc86aa7f2e4cb1aa265cd86aac8N
localhost:8081localhost8081clusterEncrypted 2be98afc86aa7f2e4cb1aa265cd86aac8N
localhost:8080:Masterlocalhost8080clusterEncrypted 2be98afc86aa7f2e4cb1aa265cd86aac8Y
localhost:8080localhost8080clusterEncrypted 2be98afc86aa7f2e4cb1aa265cd86aac8N
SS 1localhost8080clusterEncrypted 2be98afc86aa7f2e4cb1aa265cd86aac8N
SS 2localhost8081clusterEncrypted 2be98afc86aa7f2e4cb1aa265cd86aac8N
SS Masterlocalhost8082clusterEncrypted 2be98afc86aa7f2e4cb1aa265cd86aac8Y
EC_SLAVE_5domU-12-31-33-00-03-EA.usma1.compute.amazonaws.com8080clusterEncrypted 2be98afc86aa7f2e4cb1aa265cd86aac8N
EC_SLAVE_2domU-12-31-33-00-01-F1.usma1.compute.amazonaws.com8080clusterEncrypted 2be98afc86aa7f2e4cb1aa265cd86aac8N
EC_SLAVE_4domU-12-31-33-00-02-55.usma1.compute.amazonaws.com8080clusterEncrypted 2be98afc86aa7f2e4cb1aa265cd86aac8N
EC_SLAVE_3domU-12-31-33-00-03-FB.usma1.compute.amazonaws.com8080clusterEncrypted 2be98afc86aa7f2e4cb1aa265cd86aac8N
Sam 8080192.168.1.118080clusterEncrypted 2be98afc86aa7f2e4cb1aa265cd86aac8N
EC_MASTER_1domU-12-31-33-00-03-9C.usma1.compute.amazonaws.com8080clusterEncrypted 2be98afc86aa7f2e4cb1aa265cd86aac8Y
Laptop 8081192.168.1.108081clusterEncrypted 2be98afc86aa7f2e4cb1aa265cd86aac8Y
Localhost 8081localhost8081clusterEncrypted 2be98afc86aa7f2e4cb1aa265cd86aac8Y
EC2
40000
100000
0
Y
EC_SLAVE_5
EC_SLAVE_4
EC_SLAVE_3
EC_SLAVE_2
EC_MASTER_1
Local
40000
2000
5000
Y
Sam 8080
Laptop 8081
local schema
40000
2000
5000
N
localhost:8082
localhost:8081
localhost:8080:Master
SS
40000
2000
5000
Y
SS Master
SS 2
SS 1
admin
2008/06/27 19:06:38.921
pentaho
localhost
MYSQL
Native
pentaho
3306
aalberici
Encrypted 2be98afc86aa7f2e4a412a17bd1d3f983
EXTRA_OPTION_MYSQL.defaultFetchSize500
EXTRA_OPTION_MYSQL.useCursorFetchtrue
FORCE_IDENTIFIERS_TO_LOWERCASEN
FORCE_IDENTIFIERS_TO_UPPERCASEN
INITIAL_POOL_SIZE5
IS_CLUSTEREDN
MAXIMUM_POOL_SIZE10
MSSQL_DOUBLE_DECIMAL_SEPARATORN
PORT_NUMBER3306
QUOTE_ALL_FIELDSN
STREAM_RESULTSY
USE_POOLINGN
vtiger_locale
localhost
MYSQL
Native
vtiger_clienti
3306
aalberici
Encrypted 2be98afc86aa7f2e4a412a17bd1d3f983
EXTRA_OPTION_MYSQL.defaultFetchSize500
EXTRA_OPTION_MYSQL.useCursorFetchtrue
FORCE_IDENTIFIERS_TO_LOWERCASEN
FORCE_IDENTIFIERS_TO_UPPERCASEN
INITIAL_POOL_SIZE5
IS_CLUSTEREDN
MAXIMUM_POOL_SIZE10
MSSQL_DOUBLE_DECIMAL_SEPARATORN
PORT_NUMBER3306
QUOTE_ALL_FIELDSN
STREAM_RESULTSN
USE_POOLINGN
DW
localhost
MYSQL
Native
DW
3306
DW
Encrypted 2be98afc86aa7f2e4cb79ce10bef28bed
EXTRA_OPTION_MYSQL.characterEncodingUTF8
EXTRA_OPTION_MYSQL.defaultFetchSize500
EXTRA_OPTION_MYSQL.useCursorFetchtrue
IS_CLUSTEREDN
MAXIMUM_POOL_SIZE10
PORT_NUMBER3306
SQL_CONNECTset sql_mode := ''
STREAM_RESULTSY
USE_POOLINGN
PGSQL Localhost test
localhost
POSTGRESQL
Native
test
5432
matt
Encrypted 2be98afc86aa7f2e4cb79ce10df90acde
CLUSTER_DBNAME_0db1
CLUSTER_DBNAME_1db2
CLUSTER_DBNAME_2db3
CLUSTER_DBNAME_3db4
CLUSTER_DBNAME_4db5
CLUSTER_HOSTNAME_0192.168.1.10
CLUSTER_HOSTNAME_1192.168.1.10
CLUSTER_HOSTNAME_2192.168.1.10
CLUSTER_HOSTNAME_3192.168.1.10
CLUSTER_HOSTNAME_4192.168.1.10
CLUSTER_PARTITION_0PartDB1
CLUSTER_PARTITION_1PartDB2
CLUSTER_PARTITION_2PartDB3
CLUSTER_PARTITION_3PartDB4
CLUSTER_PARTITION_4PartDB5
CLUSTER_PASSWORD_0Encrypted
CLUSTER_PASSWORD_1Encrypted
CLUSTER_PASSWORD_2Encrypted
CLUSTER_PASSWORD_3Encrypted
CLUSTER_PASSWORD_4Encrypted
CLUSTER_PORT_03306
CLUSTER_PORT_13306
CLUSTER_PORT_23306
CLUSTER_PORT_33306
CLUSTER_PORT_43306
CUSTOM_DRIVER_CLASScom.ibm.u2.jdbc.UniJDBCDriver
CUSTOM_URLjdbc:universe://localhost/database
EXTRA_OPTION_MYSQL.defaultFetchSize500
EXTRA_OPTION_MYSQL.rewriteBatchedStatementsfalse
EXTRA_OPTION_MYSQL.useCursorFetchtrue
EXTRA_OPTION_MYSQL.zeroDateTimeBehaviorconvertToNull
EXTRA_OPTION_SYBASE.SQLINITSTRINGSET CHAINED OFF
FORCE_IDENTIFIERS_TO_LOWERCASEN
FORCE_IDENTIFIERS_TO_UPPERCASEN
INITIAL_POOL_SIZE5
IS_CLUSTEREDN
MAXIMUM_POOL_SIZE10
MSSQL_DOUBLE_DECIMAL_SEPARATORN
POOLING_defaultCatalogcatalog
POOLING_removeAbandonedtrue
POOLING_testOnReturnfalse
PORT_NUMBER5432
QUOTE_ALL_FIELDSN
STREAM_RESULTSY
USE_POOLINGN
MySQL localhost test
localhost
MYSQL
Native
test
3306
matt
Encrypted 2be98afc86aa7f2e4cb79ce10df90acde
CLUSTER_DBNAME_0db1
CLUSTER_DBNAME_1db2
CLUSTER_DBNAME_2db3
CLUSTER_DBNAME_3db4
CLUSTER_DBNAME_4db5
CLUSTER_HOSTNAME_0192.168.1.10
CLUSTER_HOSTNAME_1192.168.1.10
CLUSTER_HOSTNAME_2192.168.1.10
CLUSTER_HOSTNAME_3192.168.1.10
CLUSTER_HOSTNAME_4192.168.1.10
CLUSTER_PARTITION_0PartDB1
CLUSTER_PARTITION_1PartDB2
CLUSTER_PARTITION_2PartDB3
CLUSTER_PARTITION_3PartDB4
CLUSTER_PARTITION_4PartDB5
CLUSTER_PASSWORD_0Encrypted
CLUSTER_PASSWORD_1Encrypted
CLUSTER_PASSWORD_2Encrypted
CLUSTER_PASSWORD_3Encrypted
CLUSTER_PASSWORD_4Encrypted
CLUSTER_PORT_03306
CLUSTER_PORT_13306
CLUSTER_PORT_23306
CLUSTER_PORT_33306
CLUSTER_PORT_43306
CUSTOM_DRIVER_CLASScom.ibm.u2.jdbc.UniJDBCDriver
CUSTOM_URLjdbc:universe://localhost/database
EXTRA_OPTION_MYSQL.defaultFetchSize500
EXTRA_OPTION_MYSQL.rewriteBatchedStatementsfalse
EXTRA_OPTION_MYSQL.useCursorFetchtrue
EXTRA_OPTION_MYSQL.zeroDateTimeBehaviorconvertToNull
EXTRA_OPTION_SYBASE.SQLINITSTRINGSET CHAINED OFF
INITIAL_POOL_SIZE5
IS_CLUSTEREDN
MAXIMUM_POOL_SIZE10
MSSQL_DOUBLE_DECIMAL_SEPARATORN
POOLING_defaultCatalogcatalog
POOLING_removeAbandonedtrue
POOLING_testOnReturnfalse
PORT_NUMBER3306
QUOTE_ALL_FIELDSN
STREAM_RESULTSY
USE_POOLINGN
Oracle ORCL Acer8104
192.168.1.10
ORACLE
Native
orcl
1521
matt
Encrypted 2be98afc86aa7f2e4cb79ce10df90acde
EXTRA_OPTION_MYSQL.defaultFetchSize500
EXTRA_OPTION_MYSQL.useCursorFetchtrue
IS_CLUSTEREDN
MAXIMUM_POOL_SIZE10
PORT_NUMBER1521
STREAM_RESULTSY
USE_POOLINGN
MySQL Local test
192.168.1.10
MYSQL
Native
test
3306
matt
Encrypted 2be98afc86aa7f2e4cb79ce10df90acde
EXTRA_OPTION_MYSQL.defaultFetchSize500
EXTRA_OPTION_MYSQL.useCursorFetchtrue
IS_CLUSTEREDN
MAXIMUM_POOL_SIZE10
PORT_NUMBER3306
STREAM_RESULTSY
USE_POOLINGN
Partitioned DB
localhost
MYSQL
Native
DB1
3306
matt
Encrypted 2be98afc86aa7f2e4cb79ce10df90acde
CLUSTER_DBNAME_0DB1
CLUSTER_DBNAME_1DB2
CLUSTER_DBNAME_2DB3
CLUSTER_DBNAME_3DB4
CLUSTER_HOSTNAME_0localhost
CLUSTER_HOSTNAME_1localhost
CLUSTER_HOSTNAME_2localhost
CLUSTER_HOSTNAME_3localhost
CLUSTER_PARTITION_0P1
CLUSTER_PARTITION_1P2
CLUSTER_PARTITION_2P3
CLUSTER_PARTITION_3P4
CLUSTER_PASSWORD_0Encrypted 2be98afc86aa7f2e4cb79ce10df90acde
CLUSTER_PASSWORD_1Encrypted 2be98afc86aa7f2e4cb79ce10df90acde
CLUSTER_PASSWORD_2Encrypted 2be98afc86aa7f2e4cb79ce10df90acde
CLUSTER_PASSWORD_3Encrypted 2be98afc86aa7f2e4cb79ce10df90acde
CLUSTER_PORT_03306
CLUSTER_PORT_13306
CLUSTER_PORT_23306
CLUSTER_PORT_33306
CLUSTER_USERNAME_0matt
CLUSTER_USERNAME_1matt
CLUSTER_USERNAME_2matt
CLUSTER_USERNAME_3matt
EXTRA_OPTION_MYSQL.defaultFetchSize500
EXTRA_OPTION_MYSQL.useCursorFetchtrue
IS_CLUSTEREDY
MAXIMUM_POOL_SIZE10
PORT_NUMBER3306
STREAM_RESULTSY
USE_POOLINGN
MySQL EC2
domU-12-31-33-00-02-58.usma1.compute.amazonaws.com
MYSQL
Native
test
3306
matt
Encrypted 2be98afc86aa7f2e4cb79ce10df90acde
CLUSTER_DBNAME_0test
CLUSTER_DBNAME_1test
CLUSTER_DBNAME_2test
CLUSTER_DBNAME_3test
CLUSTER_DBNAME_4test
CLUSTER_HOSTNAME_0domU-12-31-33-00-03-96.usma1.compute.amazonaws.com
CLUSTER_HOSTNAME_1domU-12-31-33-00-03-9A.usma1.compute.amazonaws.com
CLUSTER_HOSTNAME_2domU-12-31-33-00-03-A5.usma1.compute.amazonaws.com
CLUSTER_HOSTNAME_3domU-12-31-33-00-03-9B.usma1.compute.amazonaws.com
CLUSTER_HOSTNAME_4domU-12-31-33-00-03-B8.usma1.compute.amazonaws.com
CLUSTER_PARTITION_0P2
CLUSTER_PARTITION_1P3
CLUSTER_PARTITION_2P4
CLUSTER_PARTITION_3P5
CLUSTER_PARTITION_4P6
CLUSTER_PASSWORD_0Encrypted
CLUSTER_PASSWORD_1Encrypted
CLUSTER_PASSWORD_2Encrypted
CLUSTER_PASSWORD_3Encrypted
CLUSTER_PASSWORD_4Encrypted
CLUSTER_PORT_03306
CLUSTER_PORT_13306
CLUSTER_PORT_23306
CLUSTER_PORT_33306
CLUSTER_PORT_43306
EXTRA_OPTION_MYSQL.defaultFetchSize500
EXTRA_OPTION_MYSQL.useCursorFetchtrue
IS_CLUSTEREDY
PORT_NUMBER3306
vtiger_gandalf
192.168.1.60
MYSQL
Native
vtiger_testing
3306
andrea
Encrypted 2be98afc86aa7f2e48a33ab758a93a7dc
EXTRA_OPTION_MYSQL.defaultFetchSize500
EXTRA_OPTION_MYSQL.useCursorFetchtrue
FORCE_IDENTIFIERS_TO_LOWERCASEN
FORCE_IDENTIFIERS_TO_UPPERCASEN
INITIAL_POOL_SIZE5
IS_CLUSTEREDN
MAXIMUM_POOL_SIZE10
MSSQL_DOUBLE_DECIMAL_SEPARATORN
PORT_NUMBER3306
QUOTE_ALL_FIELDSN
STREAM_RESULTSY
USE_POOLINGN
gandalf_DW
192.168.1.60
MYSQL
Native
gandalf_daw_01
3306
andrea
Encrypted 2be98afc86aa7f2e48a33ab758a93a7dc
EXTRA_OPTION_MYSQL.defaultFetchSize500
EXTRA_OPTION_MYSQL.useCursorFetchtrue
FORCE_IDENTIFIERS_TO_LOWERCASEN
FORCE_IDENTIFIERS_TO_UPPERCASEN
INITIAL_POOL_SIZE5
IS_CLUSTEREDN
MAXIMUM_POOL_SIZE10
MSSQL_DOUBLE_DECIMAL_SEPARATORN
PORT_NUMBER3306
QUOTE_ALL_FIELDSN
STREAM_RESULTSY
USE_POOLINGN
vtiger_ehr
aragorn.openconsul.com
MYSQL
Native
vtigersol_ehr
3306
andrea
Encrypted 2be98afc86aa7f2e48a33ab758a93a7dc
EXTRA_OPTION_MYSQL.defaultFetchSize500
EXTRA_OPTION_MYSQL.useCursorFetchtrue
FORCE_IDENTIFIERS_TO_LOWERCASEN
FORCE_IDENTIFIERS_TO_UPPERCASEN
INITIAL_POOL_SIZE5
IS_CLUSTEREDN
MAXIMUM_POOL_SIZE10
MSSQL_DOUBLE_DECIMAL_SEPARATORN
PORT_NUMBER3306
QUOTE_ALL_FIELDSN
STREAM_RESULTSY
USE_POOLINGN
H2
localhost
H2
Native
jens
-1
Encrypted 2be98afc86aa7f2a1a51abc69ce86aade
EXTRA_OPTION_MYSQL.defaultFetchSize500
EXTRA_OPTION_MYSQL.useCursorFetchtrue
IS_CLUSTEREDN
MAXIMUM_POOL_SIZE10
PORT_NUMBER-1
USE_POOLINGN
aragorn_daw01
aragorn.openconsul.com
MYSQL
Native
bi_daw_01
3306
andrea
Encrypted 2be98afc86aa7f2e48a33ab758a93a7dc
EXTRA_OPTION_MYSQL.defaultFetchSize500
EXTRA_OPTION_MYSQL.useCursorFetchtrue
FORCE_IDENTIFIERS_TO_LOWERCASEN
FORCE_IDENTIFIERS_TO_UPPERCASEN
INITIAL_POOL_SIZE5
IS_CLUSTEREDN
MAXIMUM_POOL_SIZE10
MSSQL_DOUBLE_DECIMAL_SEPARATORN
PORT_NUMBER3306
QUOTE_ALL_FIELDSN
STREAM_RESULTSY
USE_POOLINGN
vtiger_aragorn
aragorn.openconsul.com
MYSQL
Native
vtiger_crm
3306
andrea
Encrypted 2be98afc86aa7f2e48a33ab758a93a7dc
EXTRA_OPTION_MYSQL.defaultFetchSize500
EXTRA_OPTION_MYSQL.useCursorFetchtrue
FORCE_IDENTIFIERS_TO_LOWERCASEN
FORCE_IDENTIFIERS_TO_UPPERCASEN
INITIAL_POOL_SIZE5
IS_CLUSTEREDN
MAXIMUM_POOL_SIZE10
MSSQL_DOUBLE_DECIMAL_SEPARATORN
PORT_NUMBER3306
QUOTE_ALL_FIELDSN
STREAM_RESULTSY
USE_POOLINGN
DW_vtiger
aragorn.openconsul.com
MYSQL
Native
bi_daw_02
3306
andrea
Encrypted 2be98afc86aa7f2e48a33ab758a93a7dc
EXTRA_OPTION_MYSQL.defaultFetchSize500
EXTRA_OPTION_MYSQL.useCursorFetchtrue
FORCE_IDENTIFIERS_TO_LOWERCASEN
FORCE_IDENTIFIERS_TO_UPPERCASEN
INITIAL_POOL_SIZE5
IS_CLUSTEREDN
MAXIMUM_POOL_SIZE10
MSSQL_DOUBLE_DECIMAL_SEPARATORN
PORT_NUMBER3306
QUOTE_ALL_FIELDSN
STREAM_RESULTSY
USE_POOLINGN
demo_vtiger_aragorn
aragorn.openconsul.com
MYSQL
Native
vtiger_crm
3306
andrea
Encrypted 2be98afc86aa7f2e48a33ab758a93a7dc
EXTRA_OPTION_MYSQL.defaultFetchSize500
EXTRA_OPTION_MYSQL.useCursorFetchtrue
FORCE_IDENTIFIERS_TO_LOWERCASEN
FORCE_IDENTIFIERS_TO_UPPERCASEN
INITIAL_POOL_SIZE5
IS_CLUSTEREDN
MAXIMUM_POOL_SIZE10
MSSQL_DOUBLE_DECIMAL_SEPARATORN
PORT_NUMBER3306
QUOTE_ALL_FIELDSN
STREAM_RESULTSY
USE_POOLINGN
Generate RowsNormal NumberY Normal NumberText file outputY
Generate Rows
RowGenerator
Y
1
none
1000
58
187
Y
Normal Number
ScriptValueMod
Y
1
none
Y
0
Script 1
//Script here
java;
var u1= Math.random() ;
var u2= Math.random() ;
var z0;
var z1;
// BOX-MULLER transformation (1958)
z0=Math.sqrt(-2*Math.log(u1)) * Math.cos(2 * Math.PI*u2);
z1=Math.sqrt(-2*Math.log(u1))* Math.sin(2* Math.PI*u2);
u1
u1
Number
10
10
u2
u2
Number
10
10
z0
z0
Number
10
10
z1
z1
Number
10
10
262
102
Y
Text file output
TextFileOutput
Y
1
none
;
"
N
DOS
None
${Internal.Transformation.Filename.Directory}/filename
N
csv
N
N
N
N
Y
N
N
0
z0
Number
.0000000000
10
10
z1
Number
.0000000000
10
10
480
101
Y
N