Problem: Failure to load tables:
ETL+ log reports 0 rows loaded.
Cause: OData user in ETL+ does not have OData rights to data set.
Most common solution: Check that the user assigned to DataSelf has OData rights to that particular data set.
Fix
-
Open ETL+.
-
on the ETL+ Extract, Transform and Load (ETL) Page page in ETL+, select the failing table from the Target Objects panel.
-
Verify that the SQL statement on the Extract SQL Statement panel has correct information.
Fix SQL as needed.