Topic
  • 5 replies
  • Latest Post - ‏2013-12-26T18:12:03Z by venky09
prateek0503
prateek0503
20 Posts

Pinned topic Can Optim archive BLOB or CLOB datatype?

‏2012-10-11T17:03:14Z |
Hello Everyone,

I have a few questions that I struggling with and it would be a great help if someone could help me with below queries.

1. Can Optim archive BLOB and CLOBs ? if yes , How does it stores them?
2. Is there a way to do reporting on Optim Archived files? I think using COGNOS we could do this but my client is not ready to spend for another license. Is there a was we could do custom reporting without spending more money :(

Thanks!!
Prateek Nanda
Updated on 2012-10-15T06:44:21Z at 2012-10-15T06:44:21Z by prateek0503
  • Ducatiman
    Ducatiman
    58 Posts

    Re: Can Optim archive BLOB or CLOB datatype?

    ‏2012-10-11T19:34:22Z  
    Hi Prateek,
    Optim stores the BLOBs in the archive file along with the rest of the fields in the table

    If you have the license to Optim Connect (Attunity) then you can run queries against the archive files using for exemaple ODBC connection and any query reporting tool e.g. EXCEL. Otherwise you'd have to restore to a 'staging' database to access the data.

    • D
  • prateek0503
    prateek0503
    20 Posts

    Re: Can Optim archive BLOB or CLOB datatype?

    ‏2012-10-12T04:42:08Z  
    • Ducatiman
    • ‏2012-10-11T19:34:22Z
    Hi Prateek,
    Optim stores the BLOBs in the archive file along with the rest of the fields in the table

    If you have the license to Optim Connect (Attunity) then you can run queries against the archive files using for exemaple ODBC connection and any query reporting tool e.g. EXCEL. Otherwise you'd have to restore to a 'staging' database to access the data.

    • D
    Thanks a lot for responding back Dukatiman,

    I am just a little curious to know, How does Optim treats Blobs , what I mean by that is does it stores it in form on 0101 ( binary ) in archived files and will they be accessible in archived files ( if we are using Optim connect studio and Excel for custom reporting ).

    Thanks !!
    Prateek Nanda
  • TulasiDas
    TulasiDas
    62 Posts

    Re: Can Optim archive BLOB or CLOB datatype?

    ‏2012-10-15T05:07:24Z  
    Thanks a lot for responding back Dukatiman,

    I am just a little curious to know, How does Optim treats Blobs , what I mean by that is does it stores it in form on 0101 ( binary ) in archived files and will they be accessible in archived files ( if we are using Optim connect studio and Excel for custom reporting ).

    Thanks !!
    Prateek Nanda
    Hi Prateek,

    Just like any column data, Blobs are also part of Optim archive file and yes it is in the binary format. You can also access Optim archive file Blobs data using Optim Connect with the help of SQL.

    Hope that clarifies your question.

    Thanks,
    Tulasi
  • prateek0503
    prateek0503
    20 Posts

    Re: Can Optim archive BLOB or CLOB datatype?

    ‏2012-10-15T06:44:21Z  
    • TulasiDas
    • ‏2012-10-15T05:07:24Z
    Hi Prateek,

    Just like any column data, Blobs are also part of Optim archive file and yes it is in the binary format. You can also access Optim archive file Blobs data using Optim Connect with the help of SQL.

    Hope that clarifies your question.

    Thanks,
    Tulasi
    Thanks a lot TulasiDas

    Prateek Nanda
  • venky09
    venky09
    1 Post

    Re: Can Optim archive BLOB or CLOB datatype?

    ‏2013-12-26T18:12:03Z  
    • TulasiDas
    • ‏2012-10-15T05:07:24Z
    Hi Prateek,

    Just like any column data, Blobs are also part of Optim archive file and yes it is in the binary format. You can also access Optim archive file Blobs data using Optim Connect with the help of SQL.

    Hope that clarifies your question.

    Thanks,
    Tulasi

    How to view the binary data present in archive file through Optim connect ?