I amtrying to change the existing Datasource to use a sql table instead of a file, I could not find the SQL as one of the option. The SQL option is presented when i am creating a new datasource.

I amtrying to change the existing Datasource to use a sql table instead of a file, I could not find the SQL as one of the option. The SQL option is presented when i am creating a new datasource.

book

Article ID: KB0087174

calendar_today

Updated On:

Products Versions
TIBCO Collaborative Information Manager -
Not Applicable -

Description

Resolution:
Please try deleting all the attributes of the Datasource and save it.
Now when you modify the datasource again you will be able to select SQL from the dropdown.

Please note that some of the attributes could have a (*) in front of them. If you see any of this attribute that mean that you have referenced that attribute in the map.
You wll have to delete the Mapping in the Master Catalog before you can delete this attribute.

If you have any further questions regarding this issue please contact Tibco Support.

Thanks,
Tibco Support.

Issue/Introduction

I amtrying to change the existing Datasource to use a sql table instead of a file, I could not find the SQL as one of the option. The SQL option is presented when i am creating a new datasource.