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?
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.
Release : 4.9
Component : CA Test Data Manager
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.