It's all about the answers!

Ask a question

Insight integration with Lotus Notes


Jill Davies (241417) | asked Jul 12 '13, 8:35 a.m.
Hi,

I am trying to pull data from a Lotus Notes database into Insight 1.0.1.1.
However, it appears that some of the Notes data is being truncated to 255 chars by the time it appears in Insight. 
Is this a known limitation, or is there something I need to set up somewhere?

Thanks,
Jill

One answer



permanent link
Shuai Hu (41112) | answered Jul 15 '13, 9:31 p.m.
Hi,

I suppose you're connecting Insight with Notes by ODBC. You might want to check the first-hand data by Cognos Data Manager->Tools->SQLTerm and run a query to see if the data is truncated. If so, that might be the problem of the ODBC driver.

Comments
Jill Davies commented Jul 16 '13, 4:26 a.m.

Hi,
Thanks for your response.  If I run the query from Data Manager then the data is truncated.  I am using NotesSQL and I think the limitation may be in here.  Can anyone confirm this or suggest any solutions?

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.