Is there a way to filter the schema objects using the SQL connector in a data provider?
While I am only using one table I see reference to all the tables in the import scenario XML
Best answer by cmoreland
View originalImport Scenario From SQL. Filter Schema Objects SQL Data Provider
Userlevel 4
When you create the data provider, manually type in the table (or view) name of the object field (and do NOT click FILL SCHEMA OBJECTS) then you will only see the table you want to use. Then you can click FILL SCHEMA FIELDS to load the fields from the table.
Userlevel 4
When you create the data provider, manually type in the table (or view) name of the object field (and do NOT click FILL SCHEMA OBJECTS) then you will only see the table you want to use. Then you can click FILL SCHEMA FIELDS to load the fields from the table.
No way to filter it afterwards? I see the you can edit the command under the » menu. I just really dont want to recreate it if I don’t need to
Userlevel 7
+17
Hi
Hope this helps!
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.