It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×12,010
×1,230

question asked: Jul 12 '13, 8:35 a.m.
question was seen: 4,167 times
last updated: Jul 16 '13, 4:26 a.m.

Related questions

Insight integration with Lotus Notes

0
Jill Davies (24●14●17) | 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

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Shuai Hu (41●1●1●2) | 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.