Forum Discussion

Anonymous

Not applicable

2 years ago

Solved

SQL query/ ODBC connector - not working

Hi All,

I connected PBI to our ERP system (QAD) with ODBC conncetor, connection is fine and I'm extracting full tabels,

The problem begin when I'm trying to use SQL statment in order to recduce the amount of data, attached pics below :

Not sure what is going wrong here,

Thanks

Joe_Barry
2 years ago
Hi Anonymous

can you try at the end of your statement

from your_schema_name.country

Joe

3 Replies

Joe_Barry
Solution Sage
2 years ago
Hi Anonymous

can you try at the end of your statement

from your_schema_name.country

Joe
- Anonymous
  Not applicable
  2 years ago
  Hi,
  By any chance
  from your_schema_name.country
  will be :from MFGPROD [2].country?
  - Joe_Barry
    Solution Sage
    2 years ago
    Please test it, I haven't used ODBC since my last job, but when I do other sql statements now, I always use the schema before the table name. I just tested, using the Azure SQL Connector and it works without the schema name too. Maybe this article will help Error (7519) or (15814) Table/view/synonym cannot be found when trying to access an OpenEdge table or view through SQL - Progress Community