M001: MongoDB Basics

Compass: Visual interface
Query language
MongoDB Atlas: DBaaS

XML to PDF

https://technology.amis.nl/2006/03/22/converting-word-documents-to-xsl-fo-and-onwards-to-pdf/

Oracle RTF to xslFO

http://www.shareoracleapps.com/2015/05/how-to-convert-rtf-to-xsl-fo-using-bi-publisher-api-in-oracle-apps.html

XML to PDF Java
https://cuppajavamattiz.wordpress.com/2006/02/23/practical-example-using-fop-for-pdf-generation-updated/

https://netjs.blogspot.in/2015/07/how-to-create-pdf-from-xml-using-apache-fop.html

Automate REST testing

http://blog.getpostman.com/2014/03/07/writing-automated-tests-for-apis-using-postman/
http://blog.getpostman.com/2014/04/17/how-to-write-automated-tests-for-apis-with-postman-part-2/
https://www.getpostman.com/docs/postman/collection_runs/starting_a_collection_run
https://www.getpostman.com/docs/postman/collection_runs/command_line_integration_with_newman

FMW Monitoring framework

Enable and disable OSB services in batch: https://technology.amis.nl/2017/02/28/oracle-service-bus-disable-enable-a-proxy-service-via-weblogic-server-mbeans-with-jmx/

jDeveloper 12.1.3 not starting on El Captian

try run it from command to get the start logs, i.e., 

<ORACLE_HOME>/jdeveloper/jdev/bin/jdev 

I got error: 

Oracle JDeveloper 12c Development Build 12.2.1.0.0

Copyright (c) 1997, 2015, Oracle and/or its affiliates. All rights reserved.

java.lang.RuntimeException: Exception in org.eclipse.osgi.framework.internal.core.SystemBundleActivator.start() of bundle org.eclipse.osgi.

at org.eclipse.osgi.framework.internal.core.InternalSystemBundle.resume(InternalSystemBundle.java:233)

at org.eclipse.osgi.framework.internal.core.Framework.launch(Framework.java:656)

Now you have delete the system_cache folder located /Users/<user>/.jdeveloper/system12.1.3.0.41.140521.1008/system_cache

And jdeveloper start again

Splunk

Data masking:
https://answers.splunk.com/answers/211998/masking-sensitive-data.html


5 main function of Splunk enterprise:
1. Index: collects data
2. Search : index based: Search language
3. Monitor, alert
4. Report, Dashboard

Process components:

Indexer
Search Head: Search langauge
Forwarder

Forwarder(client machine)-> Indexer(server machine)-> Search Head

Input->parsing->Indexing->Searching

Three roles:

• Admin: install and create knowledge objects for all users
• Power : create and share knowledge objects for user of an app and searches
• user: Only see their own knowledge objects and those shared with them

Mulesoft pattern 1 : File(PGP Encrypted) to Database

Requirements:

Schedule
Read file from SFTP
Delimited
PGP Encrypted
Insert to database

Scheduler:
https://docs.mulesoft.com/mule-user-guide/v/3.7/poll-schedulers
Publickey based SFTP:
https://forums.mulesoft.com/questions/38463/sftp-connector-not-work-for-publickey-setting.html
Delimited, File:
https://technicalmumbojumbo.wordpress.com/2014/02/01/mule-tutorial-series-file-endpoint-csvtomaps-java-component/
Encrypted
https://docs.mulesoft.com/mule-user-guide/v/3.6/pgp-encrypter#decrypting
Insert to Database
https://forums.mulesoft.com/questions/4986/how_to_insert_dynamically_into_database_newbie_to_mule.html
https://docs.mulesoft.com/mule-user-guide/v/3.6/database-connector-examples

REST API testing tool

1. Install json2csv for generating csv from sample json file

$npm i -g json2csv

2. Install csv-split to generate multiple csv file from one csv file

$npm i -g csv-split

3. Install csvtojson to convert csv files to json

$ npm i -g csvtojson

4. Save sample json in file example: sample.json

3. Run command to generate csv from sample file

$json2csv -i sample.json -o sample.csv -F

$json2csv -i <sample json file> -o <output csv file> -F (to flatten hierarchal json in single line )

5. Create rows for various test cases in csv file

6. Generate multiple csv files from test case file, which is csv file

$csv-split -i sample.csv -o sample -b name

$csv-split -i <csv file> -o <folder name> -b <file name prefix from csv header>

6. Convert CSV files to json files

$csvtojson sample/sample1.csv > sample/sample1.json

https://github.com/zeMirco/json2csv

https://www.npmjs.com/package/csvtojson

https://www.npmjs.com/package/csv-split

Apache flink

Mac El captian

check java version

java -version

brew install apache-flink

/usr/local/Cellar/apache-flink/1.2.0

cd bin

flink --version

Version: 1.2.0, Commit ID: 1c659cf

as per document there must be ./bin/start-local.sh however this does not have it.

Download flink with scala and hadoop from http://www.webhostingreviewjam.com/mirror/apache/flink/flink-1.2.0/flink-1.2.0-bin-hadoop27-scala_2.11.tgz

have patience it is 122 MB and it has flink, hadoop and scala you can see the version of them in download link itself

ok! since we are done with the download.

let us unzip it, in Mac you can click and unzip or you can try tar xzf flink-*.tgz

move in, cd flink-*/bin

>>./start-local.sh, and there you go

it is running and goto console:

http://localhost:8081/#/overview