No results DBX

[LH_SPLUNK]

I like to use DATABASES. I connected DBX and made a connection. With the query: | dbxquery query="SELECT * FROM \"XXX\".\"XX\".\"X\"" I can find my results, but in the search I like to use it with index=main sourcetype=Type source=Source.
What to do?

[493669]

use DB connect app and use dbx query to store results in index.