Topic
5 replies Latest Post - ‏2013-12-26T18:12:03Z by venky09
prateek0503
prateek0503
13 Posts
ACCEPTED ANSWER

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
    ACCEPTED ANSWER

    Re: Can Optim archive BLOB or CLOB datatype?

    ‏2012-10-11T19:34:22Z  in response to prateek0503
    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
      13 Posts
      ACCEPTED ANSWER

      Re: Can Optim archive BLOB or CLOB datatype?

      ‏2012-10-12T04:42:08Z  in response to Ducatiman
      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
        60 Posts
        ACCEPTED ANSWER

        Re: Can Optim archive BLOB or CLOB datatype?

        ‏2012-10-15T05:07:24Z  in response to prateek0503
        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
          13 Posts
          ACCEPTED ANSWER

          Re: Can Optim archive BLOB or CLOB datatype?

          ‏2012-10-15T06:44:21Z  in response to TulasiDas
          Thanks a lot TulasiDas

          Prateek Nanda
        • venky09
          venky09
          1 Post
          ACCEPTED ANSWER

          Re: Can Optim archive BLOB or CLOB datatype?

          ‏2013-12-26T18:12:03Z  in response to TulasiDas

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

  • This reply was deleted by venky09 2013-12-26T18:11:55Z.