# Error while connecting to SAP

**URL:** <https://matillioncommunity.discourse.group/t/error-while-connecting-to-sap/1840>\
**Category:** Matillion ETL\
**Created:** [August 9, 2022, 6:26pm UTC](https://matillioncommunity.discourse.group/t/error-while-connecting-to-sap/1840 "2022-08-09T18:26:54Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![santosh.b.biradar](https://avatars.discourse-cdn.com/v4/letter/s/e36b37/32.png) [@santosh.b.biradar](https://matillioncommunity.discourse.group/u/santosh.b.biradar)\
**Post date:** [August 9, 2022, 6:26pm UTC](https://matillioncommunity.discourse.group/t/error-while-connecting-to-sap/1840/1 "2022-08-09T18:26:54Z")

</div>

Hi,

I'm using the database query component to connect SAP hana and i'm doing just

select count(\*) from sap\_db\_name.${saptablename}

&nbsp;

${saptablename} = Is passed from scalar variable. I can see this variable showing correct values when i check SQL of database query component to make sure this variable is getting value or not.

&nbsp;

error

SQL compilation error: error line 1 at position 60

invalid identifier '"COUNT(\*)"'

&nbsp;