Topic
  • 5 replies
  • Latest Post - ‏2016-01-15T21:25:11Z by MartinBurch
wei.huang
wei.huang
3 Posts

Pinned topic Is it possible to encrypt the AutoCAD data in Tririga?

‏2016-01-14T17:29:14Z | autocad

Hi All,

Our customer want to secure the confidential AutoCAD data in Tririga.

Do you know how the AutoCAD data are stored in Tririga? In database or in file system?

Are there any option to encrypt the AutoCAD data in Tririga?

 

Thanks in advance for your help!

  • EdSilky
    EdSilky
    56 Posts

    Re: Is it possible to encrypt the AutoCAD data in Tririga?

    ‏2016-01-14T18:47:49Z  

    The drawing data is stored two ways.  It is stored as a DXF blob and as internal TRIRIGA vector graphics information that is used at runtime (the runtime functionality does not use the DXF).

     

    These are not encrypted and there isn't an option to do so, but they are not readily accessible either.  To access the DXF you need access to the database using a database query tool (the Admin Console query capability will not work to access this content).  To access the TRIRIGA vector graphic information you also would need to access the database using a database query tool (again, the Admin Console query capability will not work).

     

  • MartinBurch
    MartinBurch
    146 Posts

    Re: Is it possible to encrypt the AutoCAD data in Tririga?

    ‏2016-01-14T18:53:15Z  

    Generally we store TRIRIGA data on the AutoCAD drawings, not the other way around.  For example, we store a floor record id on an attached drawing, and space record ids on attached spaces, etc; we do not store any AutoCAD handles in TRIRIGA at all.  The main exception is when publishing a drawing to TRIRIGA, in which case we do store the DXF information in the TRIRIGA database.  We also store a graphical representation of the publish drawing as binary data in BLOB fields in the database.  We do store some information in a few database tables for bookkeeping purposes, e.g. you can take a look at this wiki: https://www.ibm.com/developerworks/community/wikis/home?#!/wiki/IBM%20TRIRIGA1/page/Finding%20Floors%20with%20Drawings%20and%20Other%20Information%20about%20Published%20CAD%20Drawings.  In general, this data is not easily accessible in TRIRIGA itself, requiring backend database access instead.  So any AutoCAD data we use is stored in the TRIRIGA database.  I'm not really familiar with the encryption options here; you might want to inquire in the TRIRIGA Application Platform forum.

     

    It might help to know what specific things the customer would want to secure.  For instance, we recently implemented a way to restrict the display of layers based on user security: http://www-01.ibm.com/support/knowledgecenter/SSHEB3_3.5.0/com.ibm.tap.doc/gra_topics/t_configuring_layer_security.html.  This is primarily end-user focused, not general encryption, however.

  • wei.huang
    wei.huang
    3 Posts

    Re: Is it possible to encrypt the AutoCAD data in Tririga?

    ‏2016-01-15T10:25:58Z  
    • EdSilky
    • ‏2016-01-14T18:47:49Z

    The drawing data is stored two ways.  It is stored as a DXF blob and as internal TRIRIGA vector graphics information that is used at runtime (the runtime functionality does not use the DXF).

     

    These are not encrypted and there isn't an option to do so, but they are not readily accessible either.  To access the DXF you need access to the database using a database query tool (the Admin Console query capability will not work to access this content).  To access the TRIRIGA vector graphic information you also would need to access the database using a database query tool (again, the Admin Console query capability will not work).

     

    Thanks Ed, Another question:

    I've read the article https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM%20TRIRIGA1/page/Exporting%20Uploaded%20CAD%20Drawings%20in%20TRIRIGA

    It seems that the Blob data are stored in DM_CONTENT==> So Document Manager content?

    I think that user can still download the dwg file from Document Manger, what does this dwg file contains? DXF content? Thanks in advance for your help!

    Updated on 2016-01-15T10:35:47Z at 2016-01-15T10:35:47Z by wei.huang
  • wei.huang
    wei.huang
    3 Posts

    Re: Is it possible to encrypt the AutoCAD data in Tririga?

    ‏2016-01-15T11:17:14Z  

    Generally we store TRIRIGA data on the AutoCAD drawings, not the other way around.  For example, we store a floor record id on an attached drawing, and space record ids on attached spaces, etc; we do not store any AutoCAD handles in TRIRIGA at all.  The main exception is when publishing a drawing to TRIRIGA, in which case we do store the DXF information in the TRIRIGA database.  We also store a graphical representation of the publish drawing as binary data in BLOB fields in the database.  We do store some information in a few database tables for bookkeeping purposes, e.g. you can take a look at this wiki: https://www.ibm.com/developerworks/community/wikis/home?#!/wiki/IBM%20TRIRIGA1/page/Finding%20Floors%20with%20Drawings%20and%20Other%20Information%20about%20Published%20CAD%20Drawings.  In general, this data is not easily accessible in TRIRIGA itself, requiring backend database access instead.  So any AutoCAD data we use is stored in the TRIRIGA database.  I'm not really familiar with the encryption options here; you might want to inquire in the TRIRIGA Application Platform forum.

     

    It might help to know what specific things the customer would want to secure.  For instance, we recently implemented a way to restrict the display of layers based on user security: http://www-01.ibm.com/support/knowledgecenter/SSHEB3_3.5.0/com.ibm.tap.doc/gra_topics/t_configuring_layer_security.html.  This is primarily end-user focused, not general encryption, however.

    Thanks Martin, I'll pass the information to our customer and wait for their reply.

  • MartinBurch
    MartinBurch
    146 Posts

    Re: Is it possible to encrypt the AutoCAD data in Tririga?

    ‏2016-01-15T21:25:11Z  
    • wei.huang
    • ‏2016-01-15T10:25:58Z

    Thanks Ed, Another question:

    I've read the article https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM%20TRIRIGA1/page/Exporting%20Uploaded%20CAD%20Drawings%20in%20TRIRIGA

    It seems that the Blob data are stored in DM_CONTENT==> So Document Manager content?

    I think that user can still download the dwg file from Document Manger, what does this dwg file contains? DXF content? Thanks in advance for your help!

    The .dwg file that is accessible through the document manager is different from the .dxf file that CAD Integrator uploads.  Typically customers will also upload the .dwg file itself to Document Manager directly, so that TRIRIGA has a copy of the drawing in case something happens to the original.  For both the .dxf process, and the process of directly upload to Document Manager, they are ultimately stored in the DM_CONTENT table.