I am trying to import data to SQL from Excel. I have created a successful connection with the database but while trying to retrieve the schema I am not getting my table, instead I am having the schema of the database (Type CATALOG). How do I get the schema of the table to which I will export the Excel data?
For which database you have tried to retrieve the metadata ? If you retrieve the metadata for a database it is quite normal to get at first the CATALOG and under this node probably a schema node and under this a couple of tables. You can create a metadata node for your excel file as well.