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.
Connector Stage versus Enterprise Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
Connector Stage versus Enterprise Stage
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
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.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn