Friday, June 16, 2017

Monday, June 12, 2017

JDBC with IBM Integration Bus

#create configurable serivce:
mqsicreateconfigurableservice TESTNODE -c JDBCProviders -o DSNName -n type4DatasourceClassName,type4DriverClassName,databaseType,jdbcProviderXASupport,portNumber,serverName,description,databaseName,securityIdentity,connectionUrlFormat,databaseSchemaNames -v com.ibm.db2.jcc.DB2XADataSource,com.ibm.db2.jcc.DB2Driver,DB2,jdbcProviderXASupport,446,

,"Data Store",DSNName,DB2SecurityIdentity,"jdbc:db2://[serverName]:[portNumber]/[databaseName]:user=[user];password=[password];",useProvidedSchemaNames

#provide broker with user password
mqsisetdbparms TESTNODE -n jdbc::DB2SecurityIdentity -u userid -p pwd


# link that documents the database config for the different environments:
http://sharethewealth/SiteDirectory/bdsg/IbmRdz/rdzblog/Lists/Posts/Post.aspx?ID=41

Thursday, June 1, 2017

SOAP UI vs POSTMAN

Sometimes SOAP UI displays objects also as arrays for JSON message, better to use Postman tool from google apps which is the best app for JSON or REST API testing.

Distributed Computing: A Guide to Comparing Data Between Hive Tables Using Spark

In big data, efficient data comparison is essential for ensuring data integrity and validating data migrations. Apache Spark, with its in-me...