Connector Stage versus Enterprise Stage

vmcburney · Post by **vmcburney** » Sun Mar 18, 2012 7:21 pm

What do you miss from the Enterprise Stage that isn't in the Connector stage? What would you like added to the Connector stages?

My example: I noticed this week that adding a filter to an existing Connector is painful if it has Generated SQL. In the old Enterprise Stage it was easy - just switch to a read method of "TABLE" and choose "WHERE CLAUSE" from the option options. Or copy the generated SQL statement, switch to user-defined and paste into the user-defined field and add the WHERE clause. In a connector I cannot find a quick way to add a filter to a generated SQL statement. There are two read methods - generated or not generated. When switching to non Generated the SQL statement is lost and in order to add a filter I have to build the SQL all over again with the SQL Builder or user defined SQL before I can add the WHERE clause.

suse_dk · Post by **suse_dk** » Mon Mar 19, 2012 2:02 am

I would like the ability to concatenate parameters in the table name field. Right now a new parameter overwrites the existing one automatically in the Connector stage (at least in v. 8.1).

ray.wurlod · Post by **ray.wurlod** » Mon Mar 19, 2012 3:11 am

You can concatenate them if you type them in manually.

suse_dk · Post by **suse_dk** » Mon Mar 19, 2012 3:58 am

I know I can type them manually... or copy/paste from notepad or the likes... but in the Enterprise stage I don't have to, so I would just be nice if the Connector stage allowed it too....

vmcburney · Post by **vmcburney** » Mon Mar 19, 2012 6:01 pm

I like that idea, I seem to remember some old Server Job stages let you append a job parameter into a text field without replacing the entire field. I would prefer if insert parameter was the default and not replace for SQL fields.