0

Reverse-engineer (XSD schema)

Abdul Shaik

August 31, 2022 23:09

None

Follow

Hi,

I am working on POC project to migrate from ER studio to Hackolade. For the import, I am using the XSD file generated from ER Studio and then reverse-engineer (XSD schema) option. I am running into couple of issues as mentioned below

1. After I import the XSD from Er studio, I see Hackolade does not import relationships. The entities and attributes are showing up but no relationships. Please see the attached image.
2. Columns does not mention whether if it is PK, FK. Please see the attached image.
3. Data types are not migrated as well, all the attributes are shown as string. Please see the attached image.

I have attached the image which I imported into Hackolade. Can you please answer these questions.

Thanks,
Abdul

• Facebook
• Twitter
• LinkedIn

4 comments

• 
  Helpdesk September 01, 2022 04:46 Official comment

  Hello Abdul,
   

  As responded in the support ticket you opened:
  Can you please send the XSD?  Does it include PKs and FKs?  If they're not declared, it would be difficult for us to import them.  On the other hand, we also have a feature in Tools > Infer PKs and FKs with which we we can discover them metadata, if not available otherwise.
   

• 0
  
  Abdul Shaik September 01, 2022 20:09

  HI,

  please let me know how I can send the XSD file. I dont see option to attach file here.

  Thanks,

  Abdul

• 0
  
  Helpdesk September 01, 2022 20:12

  You have opened a ticket with support@hackolade.com   Please use that channel.

• 0
  
  Abdul Shaik September 01, 2022 20:56

  Thank you, I have emailed the XSD file to the support@hackolade.com