http://m.getsatisfaction.com/companies/delphix/topics?page=1 Topics in Delphix Community 1970-01-01T00:00:00Z 1298 794 39 186 0 228 http://m.getsatisfaction.com/topics/7819334 7819334 Delphix boot problem :-) 2018-11-19T15:29:59Z 2018-11-18T19:25:51Z Torben Hansen http://m.getsatisfaction.com/people/9841565 https://www.gravatar.com/avatar/d6311909a559f26441183845e0996781?d=identicon&s=55&r=PG torben_hansen_7p2kdkxer2cez <img src="https://d2r1vs3d9006ap.cloudfront.net/s3_images/1762917/RackMultipart20181118-104156-c7q6ik-Sk_rmbillede_2018-11-18_kl._20.20.37_inline.png?1542569035" title="Image: https://d2r1vs3d9006ap.cloudfront.net/s3_images/1762917/RackMultipart20181118-104156-c7q6ik-Sk_rmbillede_2018-11-18_kl._20.20.37_inline.png?1542569035" /><br /><br />And i am not into Linux :-(<br />So can any one point me i a direction for solving this problem, it startet after a reboot. question pending 1 2 1 comment http://m.getsatisfaction.com/topics/7818512 7818512 need dxtoolkit executable to list the delphix timeflows which contain info like vdbname,parenttimeflow,dsource,snpashotsize 2018-11-16T16:38:28Z 2018-11-16T09:39:02Z Ankur Sharma http://m.getsatisfaction.com/people/9817278 https://www.gravatar.com/avatar/ea18966d830f16596a50572b0545e6e8?d=identicon&s=55&r=PG ankur_sharma_52917ts9p82ly i need dxtoolkit executable to list the delphix timeflows which contain info like vdbname,parenttimeflow,dsource,snpashotsize<br alt="" name="" rel="" target="" title="" type="" value="" /> question complete 1 2 1 comment http://m.getsatisfaction.com/topics/7816765 7816765 Upload file-format with PowerShell 2018-11-13T09:51:58Z 2018-11-12T13:17:48Z Torben Hansen http://m.getsatisfaction.com/people/9841565 https://www.gravatar.com/avatar/d6311909a559f26441183845e0996781?d=identicon&s=55&r=PG torben_hansen_7p2kdkxer2cez Anyone having any idea, on how to use powershell to upload a format-file to delphix masking? question complete 5 2 1 comment http://m.getsatisfaction.com/topics/7743138 7743138 Refresh a Self Service Container from a Template Snapshot to reduce refresh time 2018-11-05T21:48:38Z 2018-05-30T22:11:46Z Diego Loureda http://m.getsatisfaction.com/people/7442402 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/10493363/photo_medium.jpg diego_loureda By default Self Service Refreshes on a container will refresh the container database or databases to the latest point in time available. We have seen that some of these refreshes may take some time. In the Oracle case, all archivelogs created after the backup have to be applied.<br /><br /><br />Our clients have been requested a way to refresh a container to the point in time where the snapshot happened in the template, but unfortunately the snapshots are not visible on the template timeline.<br /><br /><br />Here we present a workaround to be able to see snapshots in the template timeline on the Self Service screen.<br /><br /><br />On this example, the template has only one datasource.<br /><br />The solution is very simple and based on the fact that bookmarks on templates are always shared, never private. So what I did is just create a post sync hook on the source (the template), that every time we do a snapsync, it will create a bookmark in the template that will be visible for all Self Service users. The hook is very simple and I used DxToolkit for it:<br /><br /><img src="https://d2r1vs3d9006ap.cloudfront.net/s3_images/1732952/22286-14lvnxv_inline.png?1527723073" /><br /><br />So every time a snapsync runs, this post sync hook will create a bookmark on the template timeline called snapsync&nbsp;+ date:<br /><br /><img src="https://d2r1vs3d9006ap.cloudfront.net/s3_images/1732953/23896-1h7k7ky_inline.png?1527723088" /><br /><br />With this simple hook, all Self Service users will have visibility to all the snapsyncs that are running on the source.<br /><br />If you are not familiar with DxToolkit you must check it out. It's available here:&nbsp;<a href="https://github.com/delphix/dxtoolkit" rel="nofollow" target="_blank" title="Link https//githubcom/delphix/dxtoolkit">https://github.com/delphix/dxtoolkit</a><br /><br /><br />If you don't want to use the DxToolkit script, as you will have to put it in all the targets, we can use a script like the one I pasted below. The good news about this approach is that all the logic to create the bookmark is stored in Delphix. This script has been tested in Red Hat Linux, may require minor changes for other Linux flavors or Unix.<br /><br /><br /><br />On my example you can see delphix_admin is being used. If this is just not good enough in terms of security, we can just create a user with ownership on the dsource.<br /><br /><br /><br /><i>## This hook will create a bookmark in the template that contains this dsource</i><br /><br /><i># Below Variables may change, make sure you have the proper values:</i><br /><i>ENGINEURL=</i><a href="http://192.168.92.220" rel="nofollow" target="_blank"><i>http://192.168.92.220</i></a><br /><i>export URL</i><br /><i>USR=delphix_admin</i><br /><i>export USR</i><br /><i>PASS=delphix</i><br /><i>export PASS</i><br /><i>BRANCHNAME=JS_BRANCH-1</i><br /><i>export BRANCHNAME</i><br /><i>SOURCEDATALAYOUT=JS_DATA_TEMPLATE-1</i><br /><i>export SOURCEDATALAYOUT</i><br /><br /><br /><br /><br /><i>#Below variables are fixed, no need to modify</i><br /><i>BNAME=snapsyc-$(date +%Y-%m-%d-%H-%M-%S)</i><br /><i>export BNAME</i><br /><br /><br /><br /><br /><i>## Connect to the Delphix Engine</i><br /><i>echo</i><br /><i>echo</i><br /><i>echo "Create session"</i><br /><i>curl -s -X POST -k --data @- ${ENGINEURL}/resources/json/delphix/session \</i><br /><i>&nbsp; &nbsp; -c ~/cookies.txt -H "Content-Type: application/json" &lt;<br /><i>{</i><br /><i>&nbsp; &nbsp; "type": "APISession",</i><br /><i>&nbsp; &nbsp; "version": {</i><br /><i>&nbsp; &nbsp; &nbsp; &nbsp; "type": "APIVersion",</i><br /><i>&nbsp; &nbsp; &nbsp; &nbsp; "major": 1,</i><br /><i>&nbsp; &nbsp; &nbsp; &nbsp; "minor": 4,</i><br /><i>&nbsp; &nbsp; &nbsp; &nbsp; "micro": 0</i><br /><i>&nbsp; &nbsp; }</i><br /><i>}</i><br /><i>EOF</i><br /><i>echo</i><br /><i>echo</i><br /><i>echo "Logon as:" ${USR}/${PASS}</i><br /><i>curl -s -X POST -k --data @- ${ENGINEURL}/resources/json/delphix/login \</i><br /><i>&nbsp; &nbsp; -b ~/cookies.txt -H "Content-Type: application/json" &lt;<br /><i>{</i><br /><i>&nbsp; &nbsp; "type": "LoginRequest",</i><br /><i>&nbsp; &nbsp; "username": "${USR}",</i><br /><i>&nbsp; &nbsp; "password": "${PASS}"</i><br /><i>}</i><br /><i>EOF1</i><br /><br /><br /><br /><br /><i># Create Bookmark on Template</i><br /><i>echo</i><br /><i>echo</i><br /><i>echo</i><br /><i>echo</i><br /><i>curl -s -X&nbsp; POST -k --data @- ${ENGINEURL}/resources/json/delphix/jetstream/bookmark \</i><br /><i>&nbsp;-b ~/cookies.txt -H "Content-Type: application/json" &lt;<br /><i>{</i><br /><i>&nbsp; &nbsp; "type": "JSBookmarkCreateParameters",</i><br /><i>&nbsp; &nbsp; "bookmark": {</i><br /><i>&nbsp; &nbsp; &nbsp; &nbsp; "type": "JSBookmark",</i><br /><i>&nbsp; &nbsp; &nbsp; &nbsp; "name": "$BNAME",</i><br /><i>&nbsp; &nbsp; &nbsp; &nbsp; "branch": "$BRANCHNAME"</i><br /><i>&nbsp; &nbsp; },</i><br /><i>&nbsp; &nbsp; "timelinePointParameters": {</i><br /><i>&nbsp; &nbsp; &nbsp; &nbsp; "type": "JSTimelinePointLatestTimeInput",</i><br /><i>&nbsp; &nbsp; &nbsp; &nbsp; "sourceDataLayout": "$SOURCEDATALAYOUT"</i><br /><i>&nbsp; &nbsp; }</i><br /><i>}</i><br /><i>EOF1</i><br /><br /><br /></i></i></i> article 1 2 4 comment http://m.getsatisfaction.com/topics/7814205 7814205 Enabling Native Splunk Integration with Delphix 2018-11-05T20:03:56Z 2018-11-05T20:03:56Z MichaelT http://m.getsatisfaction.com/people/9706172 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/11297306/Torok_medium.png michael_torok <blockquote>We wanted to empower our customers to easily notice problems in real time and allow them to self-diagnose and solve these problems at their convenience. We wanted to ensure that all Delphix users have all the information they need, when they need it, to make the best possible decisions.</blockquote><br alt="" name="" rel="" target="" title="" type="" value="" />Read more here:&nbsp;<a alt="" href="https://www.delphix.com/blog/enabling-splunk-integration" name="" rel="nofollow" target="" title="Link httpswwwdelphixcomblogenabling-splunk-integration" type="" value="">https://www.delphix.com/blog/enabling-splunk-integration</a><br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /> update 0 1 2 create http://m.getsatisfaction.com/topics/7814092 7814092 Benefits of Indexes in case of Virtual DBs 2018-11-05T16:32:34Z 2018-11-05T15:28:34Z Mayank Ahluwalia http://m.getsatisfaction.com/people/9639768 https://www.gravatar.com/avatar/da6c14ed98c94b6e6cbe0f44a7b76f92?d=identicon&s=55&r=PG mayank_ahluwalia_97kbq6ybmbjzs Hi All,<br /><br />I have a question on how indexing works on tables.<br /><br />For instance if I am working on an Oracle DB, creating Indexes on columns speeds up the search because of how the data is stored in the DB.<br /><br />However, in case of a Virtual DB, the data file doesn't reside on the DB server, instead the data i stored in storage attached to Delphix Virtualization Engine. In this case, does having Indexes on tables have the same or any impact to speed up the search on the tables ?<br /><br />Regards,<br />Mayank question complete 6 4 1 comment http://m.getsatisfaction.com/topics/7813676 7813676 Inventory shows no columns 2018-11-04T13:11:34Z 2018-11-04T06:41:22Z Torben Hansen http://m.getsatisfaction.com/people/9841565 https://www.gravatar.com/avatar/d6311909a559f26441183845e0996781?d=identicon&s=55&r=PG torben_hansen_7p2kdkxer2cez i made a connection and ruleset (selected one table), the table is listed in Inventory, but i cant se the columns, therefore i cant set the masking, any ideas?<br />have tried reboot, and diff browsers (and clear chache) problem complete 6 3 1 comment http://m.getsatisfaction.com/topics/7813679 7813679 Using Powershell to manage Delphix Masking 2018-11-04T06:59:27Z 2018-11-04T06:59:27Z Torben Hansen http://m.getsatisfaction.com/people/9841565 https://www.gravatar.com/avatar/d6311909a559f26441183845e0996781?d=identicon&s=55&r=PG torben_hansen_7p2kdkxer2cez If You like i do, prefer Powershell for automation, and want to use Powershell for managing Delphix.<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />You can start with this, the code will do a REST connection to the engine, and return a&nbsp;Authorization code (if your login are successfull)<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /> <p alt="" name="" rel="" target="" title="" type="" value="">&nbsp;$Header&nbsp;=&nbsp;@{<br alt="" name="" rel="" target="" title="" type="" value="" />&nbsp; &nbsp;&nbsp;"Accept"="application/json"<br alt="" name="" rel="" target="" title="" type="" value="" />&nbsp; &nbsp;&nbsp;"connectapitoken"="97fe6ab5b1a640909551e36a071ce9ed"<br alt="" name="" rel="" target="" title="" type="" value="" />&nbsp; &nbsp;&nbsp;"Content-Type"="application/json"<br alt="" name="" rel="" target="" title="" type="" value="" />&nbsp; }</p> <p alt="" name="" rel="" target="" title="" type="" value="">&nbsp;&nbsp;$Jason&nbsp;=&nbsp;@{<br alt="" name="" rel="" target="" title="" type="" value="" />&nbsp; &nbsp;&nbsp;"username"&nbsp;=&nbsp;&lt;username&gt;<br alt="" name="" rel="" target="" title="" type="" value="" />&nbsp; &nbsp;&nbsp;"password"&nbsp;=&nbsp;&lt;password&gt;<br alt="" name="" rel="" target="" title="" type="" value="" />&nbsp; }&nbsp;|&nbsp;ConvertTo-Json</p> <p alt="" name="" rel="" target="" title="" type="" value="">Invoke-RestMethod&nbsp;-Uri&nbsp;"&lt;engine url&gt;:&lt;port&gt;/login"&nbsp;-Method&nbsp;POST&nbsp;-Headers&nbsp;$header&nbsp;-Body&nbsp;$Jason<br alt="" name="" rel="" target="" title="" type="" value="" /></p> <br alt="" name="" rel="" target="" title="" type="" value="" /> article 0 1 1 create http://m.getsatisfaction.com/topics/6959311 6959311 How to write RESTful web services client based on curl 2018-11-04T06:52:52Z 2016-03-22T05:37:23Z Gundamaiah A http://m.getsatisfaction.com/people/8107046 https://www.gravatar.com/avatar/c2f38c2609a997541c2f39115ed24162?d=identicon&s=55&r=PG gundamaiah_a I need to write a RESTful web service client for Delphix.I am new to delphix and RESTful webservices.How can I write a client based on the below curl. <br /><br /><b>&nbsp;Create Delphix API Session</b><br /><br />$ curl -s -X POST -k --data @-&nbsp;<a href="http://delphix-server/resources/json/delphix/session" rel="nofollow" target="_blank" title="Link http//delphix-server/resources/json/delphix/session">http://delphix-server/resources/json/delphix/session</a>&nbsp;\<code>&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;</code><code>-c ~/cookies&#46;txt -H &quot;Content-Type: application/json&quot; &lt;&lt;EOF&lt;br&gt;</code><code>{&lt;br&gt;</code><code>&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;</code><code>&quot;type&quot;: &quot;APISession&quot;,&lt;br&gt;</code><code>&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;</code><code>&amp;quot;version&amp;quot;: {&lt;br&gt;</code><code>&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;</code><code>&quot;type&quot;: &quot;APIVersion&quot;,&lt;br&gt;</code><code>&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;</code><code>&quot;major&quot;: 1,&lt;br&gt;</code><code>&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;</code><code>&quot;minor&quot;: 4,&lt;br&gt;</code><code>&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;</code><code>&quot;micro&quot;: 3&lt;br&gt;</code><code>&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;</code><code>}&lt;br&gt;</code><code>}&lt;br&gt;</code><code>EOF</code><br /><b>Delphix Login<br /><br /></b>$ curl -s -X POST -k --data @-&nbsp;<a href="http://delphix-server/resources/json/delphix/login" rel="nofollow" target="_blank">http://delphix-server/resources/json/delphix/login</a>&nbsp;\<code>&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;</code><code>-b ~/cookies&#46;txt -H &quot;Content-Type: application/json&quot; &lt;&lt;EOF</code><br /><code>{</code><br /><code>&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;</code><code>&quot;type&quot;: &quot;LoginRequest&quot;,</code><br /><code>&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;</code><code>&quot;username&quot;: &quot;delphix_username&quot;,</code><br /><code>&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;</code><code>&quot;password&quot;: &quot;delphix_password&quot;</code><br /><code>}</code><br /><code>EOF</code><br /><b><br /><br /></b> question complete 3 4 1 comment http://m.getsatisfaction.com/topics/7811635 7811635 Referential Integrity Not maintained in two delphix masking engine, Will it support? 2018-11-02T16:25:21Z 2018-10-30T09:30:56Z Rajesh http://m.getsatisfaction.com/people/9569021 https://www.gravatar.com/avatar/456ff6ba74d4babcc44adabbf3b71720?d=identicon&s=55&r=PG rajesh_8dzusd0mmi3ai When there is twp delphix engine&nbsp;<br />Engine 1- DB1<br />Engine 2 - DB2<br /><br />Apply same algorithm on DB1 and DB2 and check the first name and last name on DB1 and DB2 for same customer<br /><br />Expected: It should be same&nbsp;<br />Actual: It is diff, Please let me know how it will be in sync what exactly ( Will delphix support cross engine RI ?) question active 11 4 1 comment http://m.getsatisfaction.com/topics/7810002 7810002 timestamp error on dx_rewind_db script 2018-10-30T14:50:03Z 2018-10-25T17:50:35Z joe sernicola http://m.getsatisfaction.com/people/9049623 https://www.gravatar.com/avatar/f5dffca9f7ce1c35c2b35491bba5d6b0?d=identicon&s=55&r=PG joe_sernicola I am getting this error when trying to rewind to a specific snap by timestamp.&nbsp;<br alt="" name="" rel="" target="" title="" type="" value="" />'Timestamp format doesn't match any known format<br alt="" name="" rel="" target="" title="" type="" value="" />Error with setting point in time for rewind'.<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />this is the command I entered:&nbsp;<br alt="" name="" rel="" target="" title="" type="" value="" /><p alt="" name="" rel="" target="" title="" type="" value=""></p>c:\Delphix\dxtoolkit2&gt;dx_rewind_db -d delphixt05 -group VDB_Team -name CABS -timestamp '2018-10-16 03:30'<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />Here is the list that shows it exists:<br alt="" name="" rel="" target="" title="" type="" value="" /><p alt="" name="" rel="" target="" title="" type="" value="">Engine&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Group&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Database&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Snapshot name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Start time&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; End time</p> <p alt="" name="" rel="" target="" title="" type="" value="">------------------------------ -------------------- ------------------------------ ------------------------------ ------------------------------ ------------------------------</p> <p alt="" name="" rel="" target="" title="" type="" value=""></p>delphixt05&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VDB_Team&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CABS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; @2018-10-16T03:30:28.110&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2018-10-16 03:30:28 EDT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2018-10-16 03:30:28 EDT<br alt="" name="" rel="" target="" title="" type="" value="" /> problem complete 4 3 1 comment http://m.getsatisfaction.com/topics/7687620 7687620 Masking JSON Files 2018-10-29T18:17:40Z 2018-02-15T11:02:55Z Mayank Ahluwalia http://m.getsatisfaction.com/people/9536309 https://www.gravatar.com/avatar/07e6337eb8b9666cda05c540cf0aa0e9?d=identicon&s=55&r=PG mayank_ahluwalia Does Delphix support masking JSON files ? Based on the online documentation it doesn't, but is there a plan to introduce this soon enough ? question pending 7 5 1 comment http://m.getsatisfaction.com/topics/7810444 7810444 Querying Status of an "Execution" with new Masking API (5.2.0) 2018-10-26T18:25:07Z 2018-10-26T18:25:07Z Gianpiero Piccolo http://m.getsatisfaction.com/people/8801241 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/11008985/profilo_linkedin_medium.jpg gianpiero_piccolo_410tutrl8a3f6 Hi all,<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />I'm trying to use new Masking API and I'm wondering how to get info about a masking job with querying the status of an "Execution".<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />I used the&nbsp;<a alt="" href="https://docs.delphix.com/docs52/delphix-masking/masking-api-cookbook/api-calls-for-creating-and-running-masking-jobs#APICallsforCreatingandRunningMaskingJobs-CheckingtheStatusofaMaskingJob" name="" rel="nofollow" target="" title="" type="" value="">https://docs.delphix.com/docs52/delphix-masking/masking-api-cookbook/api-calls-for-creating-and-runn...</a>&nbsp;api call<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />The info returned are about global counters such as:<br alt="" name="" rel="" target="" title="" type="" value="" /><ul alt="" name="" rel="" target="" title="" type="" value=""><li alt="" name="" rel="" target="" title="" type="" value="">status (SUCCESS, FAILED, RUNNING, ...)<br /></li><li alt="" name="" rel="" target="" title="" type="" value="">rowsMasked (total masked rows over all tables of the underlyng ruleset)</li><li alt="" name="" rel="" target="" title="" type="" value="">rowsTotal (total rows contained into all tables of the underlyng ruleset)</li><li alt="" name="" rel="" target="" title="" type="" value="">startTime</li><li alt="" name="" rel="" target="" title="" type="" value="">endTime</li></ul>However I can't find any service to drill down those data: in the monitor page of a masking job I can read for each table, the status, the count of masked rows, the count of total rows into table, the masking rate.<br /><br />I'm using the first version of the new masking api (The version of the Engine is&nbsp;5.2.0).<br /><br />In the 5.2.0, there are other services in order to drill down data of an execution?<br /><br />There will be into a newer version?<br /><br />Thank you.<br />Gianpiero question 0 1 1 create http://m.getsatisfaction.com/topics/7810102 7810102 How to mask file with delimiter ^A 2018-10-26T15:36:11Z 2018-10-25T21:00:20Z santosh kumar http://m.getsatisfaction.com/people/9146772 https://www.gravatar.com/avatar/293750ee0adfcfb027b66f6ba8bef907?d=identicon&s=55&r=PG santosh_kumar_elqum1dgzw9qv Have a delimiter file with ^A and same is defined in delimiter field of Ruleset. Still i don't see masking is working as expected. What am i missing? question complete 3 2 1 comment http://m.getsatisfaction.com/topics/7804883 7804883 Masking Engine and Informix Database 2018-10-26T09:28:48Z 2018-10-15T15:16:32Z Marcin http://m.getsatisfaction.com/people/8097621 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/10852294/Small_Webex_medium.jpg marcin_7782588 <p alt="" name="" rel="" target="" title="" type="" value="">Hi Everyone,</p><br alt="" name="" rel="" target="" title="" type="" value="" /> <p alt="" name="" rel="" target="" title="" type="" value="">&nbsp;</p> <p alt="" name="" rel="" target="" title="" type="" value="">Probably all of you who have met with the masking of the Informix database have learned that Masking Engine qualifies object names in double quotes - ".&nbsp;</p><p alt="" name="" rel="" target="" title="" type="" value="">When you try to mask data in Informix, this problem is manifested by the following message:</p> <p alt="" name="" rel="" target="" title="" type="" value="">2018/10/15 14:29:53 - Table input.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-29 13.29.40 by buildguy) : Unexpected error<br alt="" name="" rel="" target="" title="" type="" value="" /> 2018/10/15 14:29:53 - Table input.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-29 13.29.40 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException:&nbsp;<br alt="" name="" rel="" target="" title="" type="" value="" /> 2018/10/15 14:29:53 - Table input.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-29 13.29.40 by buildguy) : An error occurred executing SQL:&nbsp;<br alt="" name="" rel="" target="" title="" type="" value="" /> 2018/10/15 14:29:53 - Table input.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-<b alt="" name="" rel="" target="" title="" type="" value="">29 13.29.40 by buildguy) : SELECT "company" , "dept" , "email" , "first_name" , "last_name" , "phone" , "id" FROM dbo."employees"</b><b alt="" name="" rel="" target="" title="" type="" value=""><br alt="" name="" rel="" target="" title="" type="" value="" /> 2018/10/15 14:29:53 - Table input.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-29 13.29.40 by buildguy) : A syntax error has occurred.</b><br alt="" name="" rel="" target="" title="" type="" value="" /> ...</p> <p alt="" name="" rel="" target="" title="" type="" value=""><br alt="" name="" rel="" target="" title="" type="" value="" /></p><p alt="" name="" rel="" target="" title="" type="" value="">Masking Engine add double quotes characters to handle any space or special characters.<br alt="" name="" rel="" target="" title="" type="" value="" /></p><p alt="" name="" rel="" target="" title="" type="" value="">The problem is in the Informix instance, which by default does not support double quotes on table, column, or where clause.&nbsp;The solution for the database is very simple. The environment variable <b alt="" name="" rel="" target="" title="" type="" value="">DELIMIDENT</b> corresponds to the ability to accept commands in doulble quotes in Informix. Thanks to this parameter, the Infromix database can be shutdown before the masking process, add the variable <b alt="" name="" rel="" target="" title="" type="" value="">DELIMIDENT=y</b> to the environment and run the Informix database with the new setting.&nbsp;From that moment, Informix accepts double quotes and the masking&nbsp;process in Delphix Masking works just like any database.</p><p alt="" name="" rel="" target="" title="" type="" value=""><br alt="" name="" rel="" target="" title="" type="" value="" /></p><p alt="" name="" rel="" target="" title="" type="" value="">See IBM documentation:</p><p alt="" name="" rel="" target="" title="" type="" value=""><a href="https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.sqlr.doc/ids_sqr_233.htm" rel="nofollow" title="Link: https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.sqlr.doc/ids_sqr_233.htm">https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.sqlr.doc/ids_sqr_233.htm</a><br alt="" name="" rel="" target="" title="" type="" value="" /></p><p alt="" name="" rel="" target="" title="" type="" value=""><br /></p> <p alt="" name="" rel="" target="" title="" type="" value="">Testing environment:</p> <p alt="" name="" rel="" target="" title="" type="" value="">- Informix 12.10 on Linux CentOS 6.6</p><p alt="" name="" rel="" target="" title="" type="" value="">- Delphix Masking Engine 5.2.6</p> <p alt="" name="" rel="" target="" title="" type="" value="">&nbsp;</p> <p alt="" name="" rel="" target="" title="" type="" value="">Also you need to ask Delphix Support for installing JDBC Informix Driver .jar file on your Delphix Masking Engine.</p><p alt="" name="" rel="" target="" title="" type="" value=""><br alt="" name="" rel="" target="" title="" type="" value="" /></p><p alt="" name="" rel="" target="" title="" type="" value="">Regards</p><p alt="" name="" rel="" target="" title="" type="" value="">Marcin</p> <br alt="" name="" rel="" target="" title="" type="" value="" /> idea 1 1 1 create