Delphix Products

Hi
I'm aware that there is the "pre SQL script" and "post SQL script" functionality available in the masking job definition dialog (GUI) , but I couldn't find any detailed docs on how these features should/could be used (limitations/types of scripts/security requirements/etc.).
Is there something like hooks in the virtualisation engine available or going to be available - where we could call a shell script before /after masking job completion?
I want to implement a notification mechanism and call an external API when masking is completed....
Any suggestions would be welcome.
Thanks!

Hello Arkadiusz, 

In pre and post script you can write simple SQL statement.

like disable/enable  triggers, drop/rebuild indexes write down in in notepad save as text and attached as pre and post script.

to call external API > you can download dxmc utility > Install it on any target server from where delphix engine can be reachable > Make one shell script in that write down ./dxmc job start <JOB NAME> engine name 

wait 

give path for the external api file, so that this file always launch after completion of  masking job.

Kindly let me know if its not clear for you ..i will try to give more clarification

Hi
I'm aware that there is the "pre SQL script" and "post SQL script" functionality available in the masking job definition dialog (GUI) , but I couldn't find any detailed docs on how these features should/could be used (limitations/types of scripts/security requirements/etc.).
Is there something like hooks in the virtualisation engine available or going to be available - where we could call a shell script before /after masking job completion?
I want to implement a notification mechanism and call an external API when masking is completed....
Any suggestions would be welcome.
Thanks!

Thank you Pankaj.

Can I call a stored procedure (I'm masking Oracle/MsSQL DBs) from the "post SQL script" ?

Is this the dxmc utility you mentioned: GitHub - delphix/dxm-toolkit?

Arek

Hello Arkadiusz, 

In pre and post script you can write simple SQL statement.

like disable/enable  triggers, drop/rebuild indexes write down in in notepad save as text and attached as pre and post script.

to call external API > you can download dxmc utility > Install it on any target server from where delphix engine can be reachable > Make one shell script in that write down ./dxmc job start <JOB NAME> engine name 

wait 

give path for the external api file, so that this file always launch after completion of  masking job.

Kindly let me know if its not clear for you ..i will try to give more clarification

Hi
I'm aware that there is the "pre SQL script" and "post SQL script" functionality available in the masking job definition dialog (GUI) , but I couldn't find any detailed docs on how these features should/could be used (limitations/types of scripts/security requirements/etc.).
Is there something like hooks in the virtualisation engine available or going to be available - where we could call a shell script before /after masking job completion?
I want to implement a notification mechanism and call an external API when masking is completed....
Any suggestions would be welcome.
Thanks!

Can I call a stored procedure (I'm masking Oracle/MsSQL DBs) from the "post SQL script" ?

For now Pre and post script only support simple SQL statements . ( DELETE/UPDATE/DROP/TRUNCATE/REBUILD/CREATE).

Is this the dxmc utility you mentioned: GitHub - delphix/dxm-toolkit?

Yes ..

First download > Transfer to server > Untar > Add engines to dxmc and then you can perform masking related operations 

Thank you Pankaj.

Can I call a stored procedure (I'm masking Oracle/MsSQL DBs) from the "post SQL script" ?

Is this the dxmc utility you mentioned: GitHub - delphix/dxm-toolkit?

Arek

Hello Arkadiusz, 

In pre and post script you can write simple SQL statement.

like disable/enable  triggers, drop/rebuild indexes write down in in notepad save as text and attached as pre and post script.

to call external API > you can download dxmc utility > Install it on any target server from where delphix engine can be reachable > Make one shell script in that write down ./dxmc job start <JOB NAME> engine name 

wait 

give path for the external api file, so that this file always launch after completion of  masking job.

Kindly let me know if its not clear for you ..i will try to give more clarification

Hi
I'm aware that there is the "pre SQL script" and "post SQL script" functionality available in the masking job definition dialog (GUI) , but I couldn't find any detailed docs on how these features should/could be used (limitations/types of scripts/security requirements/etc.).
Is there something like hooks in the virtualisation engine available or going to be available - where we could call a shell script before /after masking job completion?
I want to implement a notification mechanism and call an external API when masking is completed....
Any suggestions would be welcome.
Thanks!

Thank you Pankaj.

While dxmc would help, it looks like it is waiting for the job to complete before returning the control.
While it's great for jobs that complete quickly, there is still a challenge for handling long running jobs (and I'm talking couple hours long) or timeouts.
I think some hook-type / notification mechanism internal to the engine would be nice...

Can I call a stored procedure (I'm masking Oracle/MsSQL DBs) from the "post SQL script" ?

For now Pre and post script only support simple SQL statements . ( DELETE/UPDATE/DROP/TRUNCATE/REBUILD/CREATE).

Is this the dxmc utility you mentioned: GitHub - delphix/dxm-toolkit?

Yes ..

First download > Transfer to server > Untar > Add engines to dxmc and then you can perform masking related operations 

Thank you Pankaj.

Can I call a stored procedure (I'm masking Oracle/MsSQL DBs) from the "post SQL script" ?

Is this the dxmc utility you mentioned: GitHub - delphix/dxm-toolkit?

Arek

Hello Arkadiusz, 

In pre and post script you can write simple SQL statement.

like disable/enable  triggers, drop/rebuild indexes write down in in notepad save as text and attached as pre and post script.

to call external API > you can download dxmc utility > Install it on any target server from where delphix engine can be reachable > Make one shell script in that write down ./dxmc job start <JOB NAME> engine name 

wait 

give path for the external api file, so that this file always launch after completion of  masking job.

Kindly let me know if its not clear for you ..i will try to give more clarification

Hi
I'm aware that there is the "pre SQL script" and "post SQL script" functionality available in the masking job definition dialog (GUI) , but I couldn't find any detailed docs on how these features should/could be used (limitations/types of scripts/security requirements/etc.).
Is there something like hooks in the virtualisation engine available or going to be available - where we could call a shell script before /after masking job completion?
I want to implement a notification mechanism and call an external API when masking is completed....
Any suggestions would be welcome.
Thanks!

Thank you Pankaj.

Can I call a stored procedure (I'm masking Oracle/MsSQL DBs) from the "post SQL script" ?

Is this the dxmc utility you mentioned: GitHub - delphix/dxm-toolkit?

Arek

Hello Arkadiusz, 

In pre and post script you can write simple SQL statement.

like disable/enable  triggers, drop/rebuild indexes write down in in notepad save as text and attached as pre and post script.

to call external API > you can download dxmc utility > Install it on any target server from where delphix engine can be reachable > Make one shell script in that write down ./dxmc job start <JOB NAME> engine name 

wait 

give path for the external api file, so that this file always launch after completion of  masking job.

Kindly let me know if its not clear for you ..i will try to give more clarification

Hi
I'm aware that there is the "pre SQL script" and "post SQL script" functionality available in the masking job definition dialog (GUI) , but I couldn't find any detailed docs on how these features should/could be used (limitations/types of scripts/security requirements/etc.).
Is there something like hooks in the virtualisation engine available or going to be available - where we could call a shell script before /after masking job completion?
I want to implement a notification mechanism and call an external API when masking is completed....
Any suggestions would be welcome.
Thanks!