Symantec IGA

 View Only
  • 1.  CA Connector Xpress Working sample Metadata for Myssql/DB table

    Posted Aug 21, 2019 05:03 AM
    Hi Team,

    I am looking for a working sample metadata file for a simple Database table to start with. I have been having hard time getting endpoint creation working. Even if it works it will not fetch any accounts during exploration. 

    Thanks,
    Sai


  • 2.  RE: CA Connector Xpress Working sample Metadata for Myssql/DB table

    Broadcom Employee
    Posted Aug 21, 2019 11:09 AM
    The product does not currently provide a sample. You can open an Idea in the online communities for that to be considered for a future release.

    Perhaps there are others in the communities who have experience and samples in doing this and we invite them to comment here also.

    Another option may be to reach out to our partner HCL Technologies to see in what way they can assist further. The Enterprise Studio team of HCL can be reached at enterprisestudio@hcl.com. https://www.hcltech.com/enterprise-studio


  • 3.  RE: CA Connector Xpress Working sample Metadata for Myssql/DB table

    Posted Aug 21, 2019 01:45 PM
    Hi Ken,

    Thanks for the information. I am just trying for POC and can hold on. I will see if any community users have achieved it and wait for their response.

    Thanks,
    Sai






  • 4.  RE: CA Connector Xpress Working sample Metadata for Myssql/DB table

    Broadcom Employee
    Posted Aug 21, 2019 03:18 PM
      |   view attached
    Hi Sai,

    Try this metadata. It is connecting to MSSQL, but you may still find it useful.


    Are you getting any errors during explore / correlate? Can you tell if the query is being issued?

    ------------------------------
    Thanks,
    Jeremy
    ------------------------------

    Attachment(s)

    xml
    Demo App.xml   72 KB 1 version


  • 5.  RE: CA Connector Xpress Working sample Metadata for Myssql/DB table

    Posted Aug 22, 2019 01:31 AM
      |   view attached
    Hi Jeremy,

    Thanks for your email. Please see my metadata (attaching xml). 

    image.png

    When I deploy Endpoint it gives below error.

    Failed to acquire Endpoint: javax.naming.NamingException: [LDAP: error code 80 - :ETA_E_0003<ADI>, Endpoint 'mysql' creation failed: Connector Server Add failed: code 80 (OTHER-LdapConfigurationException): failed to add entry eTDYNDirectoryName=mysql,eTNamespaceName=LABDB,dc=im,dc=etasa: JCS@WIN-HJNJNSUFE5O: Virtual container mapping Accounts='eTDYNAccountContainer' is incomplete. (ldaps://win-hjnjnsufe5o:20411) ]; remaining name 'eTDYNDirectoryName=mysql,eTNamespaceName=LABDB,dc=im,dc=eta'

    Let me know if you find any clues. 

    Thanks,
    Sai




    Attachment(s)

    xml
    LABDB.xml   63 KB 1 version


  • 6.  RE: CA Connector Xpress Working sample Metadata for Myssql/DB table
    Best Answer

    Broadcom Employee
    Posted Aug 22, 2019 10:11 AM
    It looks related to the container configuration. Here's a few screenshots as I move down the container settings in my working demo. Keep in mind, I have a single table and no other containers within the DB.

    Containers:

    Account Container:
    Attributes:


    Account Container Name:



    ------------------------------
    Thanks,
    Jeremy
    ------------------------------