Test Data Manager

Expand all | Collapse all

CA TDM / FDM feasibility to mask Azure SQL Database (Cloud)

Jump to Best Answer
  • 1.  CA TDM / FDM feasibility to mask Azure SQL Database (Cloud)

    Posted 11-08-2016 11:15 AM

    Hi All,

     

    We have a requirement to perform data masking on SQL Database hosted on Azure Cloud. We are looking out for the below two possible approaches.

     

    1. Installing TDM/Fast Data Masker(FDM) components on Azure cloud platform and perform data masking
    2. Using the already available data masking components installed on a remote server and perform data masking of Azure SQL database hosted on cloud by connecting to cloud

     

    Currently we are looking out for any support on how CA masking tools will help interact with databases hosted on cloud.

    Any document related to this will be highly appreciated.

     

    Regards,
    Asif



  • 2.  Re: CA TDM / FDM feasibility to mask Azure SQL Database (Cloud)

    Posted 11-08-2016 12:02 PM

    mohammad.asif.shaik

    What CA Product is this question related to? It is currently posted to the Cloud Service Management community, a SaaS service desk solution.



  • 3.  Re: CA TDM / FDM feasibility to mask Azure SQL Database (Cloud)

    Posted 11-09-2016 04:15 AM

    My question is related to CA Test Data Manager. We are looking out for capabilities of CA Datamaker(TDM) or Fast Data Masker tool to connect to cloud and perform data masking.on Azure SQL database.



  • 4.  Re: CA TDM / FDM feasibility to mask Azure SQL Database (Cloud)
    Best Answer

    Posted 12-19-2016 06:40 PM

    Hi Mohammed, 

     

    I see that you opened a support case on this as well. Currently there are no connectors to use with TDM/FDM and any cloud platforms.

     

    Here is a list of supported data sources for TDM/FDM: Supported Data Sources - CA Test Data Manager - 4.0 - CA Technologies Documentation 

     

    You may be able to use Javelin to help you achieve your goals, but you would need to with CA Services in order to help you with this implementation. As long as you are using one of our supported data sources, it should not matter if it is local or in the cloud, as long as the TDM server can connect. Just "extracting" the data would be more a job for an ETL utility. If you are looking to push generated data or subset/mask existing data, CA Services can help you achieve this. 

     

    If you would like the help of CA Services, please reach out to your CA Account Manager and they can find a resource for you. If you do not know who your account manager is, you can call CA Customer Care at one of these numbers Contact CA Support - CA Technologies

     

    If you would like the Azure cloud platform to be a supported data source with TDM/FDM, please raise an enhancement request. Here is a document explaining how to submit an enhancement request: https://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.tec1107947.html   

     

    Best regards,

    Taylor



  • 5.  Re: CA TDM / FDM feasibility to mask Azure SQL Database (Cloud)

    Posted 12-20-2016 07:13 AM

    Dear Taylor,

     

    Thanks for your update.

     

    Can you please share with us any documentation/links related to the Javelin tool, to help us understand on how the tool connects and interacts with different databases.

     

    Regards,

    Asif



  • 6.  Re: CA TDM / FDM feasibility to mask Azure SQL Database (Cloud)

    Posted 12-20-2016 09:23 AM

    Hi Mohammed, 

     

    Here is some Javelin documentation:

     

    Javelin - CA Test Data Manager - 4.0 - CA Technologies Documentation 

    Using Javelin Programs in CA TDM Portal - CA Test Data Manager - 4.0 - CA Technologies Documentation 

    Using Javelin Programs in Datamaker - CA Test Data Manager - 4.0 - CA Technologies Documentation 

    Using Javelin Programs for Datamaker during Publish - CA Test Data Manager - 4.0 - CA Technologies Documentation 

    Javelin Variables Declaration and Usage - CA Test Data Manager - 4.0 - CA Technologies Documentation 

    Develop and Deploy Custom Extensions - CA Test Data Manager - 4.0 - CA Technologies Documentation 

    Javelin Troubleshooting - CA Test Data Manager - 4.0 - CA Technologies Documentation 

    Manage Publish and Ad hoc Actions - CA Test Data Manager - 4.0 - CA Technologies Documentation 

    Database Activities - CA Test Data Manager - 4.0 - CA Technologies Documentation 

    Visual Work Flow Elements - CA Test Data Manager - 4.0 - CA Technologies Documentation 

    Create and Execute Visual Workflow - CA Test Data Manager - 4.0 - CA Technologies Documentation 

    Communication Activities - CA Test Data Manager - 4.0 - CA Technologies Documentation 

    Shredder Activities - CA Test Data Manager - 4.0 - CA Technologies Documentation 

     

     

    If you would like any training or demonstrations on this feature, please reach out to your CA Account Manager and they can find a resource for you. If you do not know who your account manager is, you can call CA Customer Care at one of these numbers Contact CA Support - CA Technologies

     

    Best regards,

    Taylor



  • 7.  Re: CA TDM / FDM feasibility to mask Azure SQL Database (Cloud)

    Posted 12-20-2016 09:49 AM

    Thanks a lot

     

    Regards,

    Asif