Windows Batch File

Step 1 - Issue port forward command to the Control Panel

START /B kubectl port-forward  5000:5000 > sscp.txt

Step 2 - Create Pod

curl -X "POST" ^
  "http://localhost:5000/api/PodAPI/CreatePod?podname=&dbtype=oracle&hdsize=10" ^
  -H "accept:  text/plain" 

Step 3- Issue port forwarding to the pod

START /B kubectl port-forward [podname] 8080:80 1522:1521 > podresults.txt

Step 4- Initialize Pod

curl -X "POST" ^
  "http://localhost:8080/api/Pod/Init?username=[username]&password=[password]" ^
  -H "accept:  text/plain" 

Step 5- Upload SQL Files to Pod. Below shows you how to add multiple files.

curl -X  "POST" "http://localhost:8080/api/SQLFiles/Add?programming_langague=plsql" ^
  -H "accept: */*" ^
  -H "Content-Type: multipart/form-data" ^
  -F files="@C:\\your directory\\your sub directory\\file1.plsql" ^
  -F files="@C:\\your directory\\your sub directory\\file2.plsql" 

Step 6-Add Data Source

curl -X "POST" ^
  "http://localhost:8080/api/DataSources/Add" ^
  -H "Content-Type: application/json" ^
  -d "{  \"database_type\": \"ORACLE\",  \"source_uid\": \"[source db username]\",  \"source_pwd\": \"[source db password]\",  \"source_database_name\": \"[source db name]\",  \"source_host\": \"[source server ip address]\",  \"source_port\": \"1521\",  \"simulated_uid\": \"[pod user name]\",  \"simulated_pwd\": \"[pod password]\",  \"simulated_database_name\": \"FREE\",  \"simulated_schema_name\": \"\",  \"simulated_host\": \"\",  \"simulated_port\": \"1521\"}"

Step 7 - Test Data Source(optional)

curl -X "POST" ^
  "http://localhost:8080/api/DataSources/TestConnection" ^
  -H "accept:  text/plain" 

Step 8-Perform Preview Merge. You also have the option of doing a DryRun or PostviewMerge.

curl -X "GET" ^
  "http://localhost:8080/api/Run/PreviewMerge" ^
  -H "accept:  text/plain" 

Last updated