Delphix Products

  • 1.  Need assistance on SQL server application Masking

    Posted 01-30-2019 04:25:00 AM

    We are currently masking for one of the SQL server application. We are successfully able to create connector, rule and job and able to test it also.

     

    But while running the job it is throwing below error:-

    "Error occurred while trying to connect to the database. Error connecting to database: (using class net.sourceforge.jtds.jdbc.Driver).Unable to get information from SQL Server: xxxxxxxxxx.xmp."

    We tried to manually test the connection using SQL server management studio and were able to do so, but after running the job still we are getting above error.

    Could you please provide your input on this? Thanks in advance.

     

    Regards,

    Ashok Kumar.


    #Masking


  • 2.  RE: Need assistance on SQL server application Masking
    Best Answer

    Posted 01-30-2019 07:38:00 AM
    Hi Ashok,

    Are you using Instance Name and Port both in your connector ? If yes,  please remove the instance name and retry once.

    Regards,
    Mayank


  • 3.  RE: Need assistance on SQL server application Masking

    Posted 01-30-2019 09:13:00 AM

    Hi Mayank,

    Yes, It is working now. Thank you so much for your help.

    I have one more question. Does Delphix  5.2.6.1 version support T SQL scripts in Masking Pre-script?



  • 4.  RE: Need assistance on SQL server application Masking

    Posted 01-30-2019 02:36:00 PM
    Hi Ashok,
    T-SQL is not supported directly within prescripts. You can call a stored procedure which can contain T-SQL, from what I've been told by our field team, but within a prescript you cannot declare variables and such.

    Thanks,
    Michael