Date format with import from generic ODBC????????????

[Joran]

Hello,

I am triing to import data from a Lotus Notes database into Business Objects. In the universe I select my date object and adjust the data type to date. The problem is that business object doesn't see the date format. If I choose text format the strings of the object are:
as text as date
01-02-2001 00:00:00 0-1-1900 (dd-mm-yyyy)
01-02-2001 0-1-1900

2001-02-01 00:00:00 0-1-1900 (yyyy-mm-dd)

If have replace the - with / and the result is still the same.

Is it possible to get a date format from generic odbc?
Has anybody experianced the same problems?

Any information would be very helpfull.

Thank you,

Jöran

 

[bensonpa]

Joran,

Unfortunately I don't have an answer to your date issue but I would be interested to find out what you did to make the connection to Lotus Notes in the Designer module. I assume you installed some Lotus ODBC drivers etc. Any info would be useful. Thanks.

 

[davideart]

Hi Joran.
I'm Dave and I'm experiencing your very same problem connecting my universe to a DB2 database.
I'm desperetly trying to solve this, and I would like to know if you solved it...I've also contacted BO tech support, but they haven't still solved it.
Thanks a lot for your help.
Bye

 

[blom0344]

There is something from Notes itself to create a connection to a NSF database as if this were a relational database. It is called NotesSQL. (downloadable)

http://www.lotus.com/homepage.nsf/(search)/search?OpenDocument&notessql

I have not yet any experience with the tool, but It will probably be a better bet than generic ODBC.

As for the DB2 connectivity:

I run full client BO 5.1.3 on a datawarehouse DB2 UDB 7.1 and on a ERP system that runs on AS400 and have no problem with dates. The date-definition in the DB2 database is:
date , precision 10. The date are shown as "dd-mm-yyyy" without the 00:00:00. I use the data-access packs that you can install using the custom installation option.

 

[Bilky]

I use AS/400 too and have no rpoblem with date defined fields - this looks more like a char field that has a date and time stamp in it - can you check the format of the field - The universe definition of the field should autmatically detect the format of the field - if you are changing it then it may not be a proper date field and just a char field instead.