Discussion Board for collaboration on QlikView Scripting.
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 State0022SQL 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?
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.
I will try that...
I think name of Item No_ is
different in back end navision please check?
Here is a part of Field list of Item table.
Enabled Field No. Field Name Data Type LengthYes 1 No. Code 20Yes 2 No. 2 Code 20Yes 3 Description Text 30
And from Value Entry table...
Enabled Field No. Field Name Caption Data Type LengthYes 1 Entry No. Entry No. IntegerYes 2 Item No. Item No. Code 20Yes 3 Posting Date Posting Date Date
No real difference...
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.