How could we use Mapping LOAD from MySQL(ODBC Connection)
When i connect to Mysql DB from Qlikview (using ODBC 32) it works fine, But when i use Mapping LOAD from Mysql Table it shows
Cannot Open file filepath\InventoryDb.Orders System Can't find the file specified error generate. Actually there is no such location like filepath\ InventoryDb.Orders. Qlikview wrongly assuming my MySQL table as file.What i do to resolve this.
My Script is like this:
ODBC CONNECT TO InventoryDSN; //DSN i used to connect MySQL DB
Also i tried OEDB Provider for ODBC
OLEDB CONNECT32 TO [Provider=MSDASQL.1;Persist Security Info=False;Data Source=InventoryDSN;Extended Properties="DSN=InventoryDSN;";Initial Catalog=InventoryDb];
Re: How could we use Mapping LOAD from MySQL(ODBC Connection)
You need to SELECT only the fields in the SQL statement that you later use in the preceding LOAD statement.
If the DB table doesn't change (often), you can consider storing the table to a QVD to speed up the daily load script. You can look into a multi-staged load process (like QVD generators, data model, dashboard) then.