DSXchange

Thanks Brett. I suspect I will have to go down the View path. Or another possibility might be to build rules up using Virtual Tables, and multiple Data Rules/Rule Sets.

‪I can't figure out how to implement complex logic in data rules. The logic builder and free form editor don't seem to support things like distinct , group by , or sub queries.‬ ‪For example say I had the following SQL query:‬ ‪ ‬ ‪SELECT c1.Name‬ ‪FROM Customers c1‬ ‪WHERE c1.CustomerID NOT IN (SEL...

Ok I figured this out eventually. There's a weird bug where if you define a host that is not an Engine Tier the connector drop-down becomes empty for all hosts/data stores. So if you have an existing host that is a valid Engine Tier, after adding another host (that isn't) the existing data store los...

Ray: I can save a Data Connection in DataStage, but does it have any effect in IA?

Stuart: The installation is split between two boxes, one with services/engine tier, and the other with the client.

I have managed to import some metadata via DataStage using the Connector Import Wizard and my ODBC DSN. It shows up in Information Analyzer. However, I still cannot add a data source in Information Analyzer (same problem as initial post). Also, if I create a data rule and try and set the bindings, t...

I am trying to configure a Data Store for a project in Information Analyzer 8.5, but when I go to create it the Connector drop-down is empty (a mandatory field) under the Define a Data Connection settings. Has anyone experienced this issue before? Is there something wrong with my project setup or pr...