Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Navision 4.0 ODBC

Hello!

I have to get data from Navision 4.0 native database. I use the ODBC which came along with NAV installation.

I can connect to the NAV database, see tables and fields... I created a simpe query with the designer...

LOAD "Entry No_",
"Item No_",
"Posting Date";
SQL SELECT "Entry No_",
"Item No_",
"Posting Date"
FROM "Value Entry";

LOAD "No_";
SQL SELECT "No_"
FROM Item;

Value Entry data loads fine... But Item data fails...

SQL Error:[Simba][SimbaEngine ODBC Driver]Invalid column name: 'No_'.
SQL Scriptline:
SQL StateSmiley Frustrated0022
SQL SELECT "No_"
FROM Item

For a SIB I simply copied all required tables to an Excel file an load from there. But it isn't a solution in a long term...

So... How to get data from Navision?

Tags (4)
5 Replies
Not applicable

Navision 4.0 ODBC

You have license to extract data from navision first check

then you install CODBC navision data driver

then make DSN

After making DSN call this DSN in Qlikview ODBC trough.

Regards

Ashish

Not applicable

Navision 4.0 ODBC

Thank you!

I will try that...

Not applicable

Navision 4.0 ODBC

I think name of Item No_ is

different in back end navision please check?

Regards

Ashish

Not applicable

Navision 4.0 ODBC

Here is a part of Field list of Item table.

Enabled Field No. Field Name Data Type Length
Yes 1 No. Code 20
Yes 2 No. 2 Code 20
Yes 3 Description Text 30

And from Value Entry table...

Enabled Field No. Field Name Caption Data Type Length
Yes 1 Entry No. Entry No. Integer
Yes 2 Item No. Item No. Code 20
Yes 3 Posting Date Posting Date Date

No real difference...

Not applicable

Navision 4.0 ODBC

If you're connecting directly to SQL then SQL converts '.' on a field name to '_' (e.g. 'No.' in NAV is 'No_' in SQL). If you're using the CODBC driver then you should be able to reference the field names as you see them in NAV.

Community Browser