TDM 4.9 DataMaker Data profiler throws an error when trying to gennerate CSV report.

book

Article ID: 205540

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

We are trying to use the Datamaker Data Profiler for a project, which has SYBASE ASE 15.7 (“Adaptive Server Enterprise/15.7/EBF 27346 SMP SP139 /P/Sun_svr4/OS 5.10/ase157sp138x/4040/64-bit/FBO/Tue Aug  8 00:13:51 2017”) as their source database.

We are able to generate the Profiling report on UI but when we tried to generate CSV report using generated scripts, it errors out.

DBUtils : Logon : dbulogon 1 : logon starts

DBUtils : PerformLogon : dbupl 11 : ClassNotFoundException: java.lang.ClassNotFoundException: gridtools.jdbc.sybase.SybaseDriver

DBUtils : PerformLogon : dbupl 11 : Driver not found:gridtools.jdbc.sybase.SybaseDriver

DBUtils : PerformLogon : dbupl 11 : gridtools.jdbc.sybase.SybaseDriver

DBUtils : Logon : dbulogon 2 : logon ends - returns: false

DBUtils : <init> : dbu 5 : logon ends

 

We think it is missing SYBASE driver. Does TDM Support Sybase ASE, and if so what driver is needed?

Cause

Yes, TDM does have limited support for the Sybase ASE data source. Tofind more information on what data sources are supported see the TDM documentation, which can be found at https://techdocs.broadcom.com/us/en/ca-enterprise-software/devops/test-data-management/4-9/installing/supported-data-sources.html

NOTE: Sybase ASE support is based on the Proof of Concept (PoC) executed with customers and supports limited use cases only.

Environment

Release : 4.9

Component : CA Test Data Manager

Resolution

We don't support Data Profiling/PII scanning for Sybase from TDM Portal.

If you are using Sybase ASE, we don't ship that driver with the product. You will need to download the jconn4.jar driver from https://support.sap.com/en/my-support/software-downloads.html, or better yet, get a copy from your Sybase DBA, since the SAP support website now requires a SAP Support account in order to download the driver.

Once you have a copy of the driver, place the driver in the Datamaker home directory/lib (by default c:\Program Files (x86)\Grid-Tools\GTdatamaker\lib) and the FDM Home\lib directory (by default C:\Program Files\Grid-Tools\FastDataMasker\lib), since only Datamaker and FDM functionalities support Sybase data sources.