DSXchange

I found this within our Oracle xmeta SELECT PRINCIPALID_XMETA, FIRSTNAME_XMETA, LASTNAME_XMETA, TITLE_XMETA, EMAILADDRESS_XMETA, OFFICEPHONENUMBER_XMETA, BUSINESSADDRESS_XMETA, CELLPHONENUMBER_XMETA, JOBTITLE_XMETA, LOCATION_XMETA, ORGANIZATION_XMETA, PAGERNUMBER_XMETA, CONTAINER_RID, CREATEDBY_PRIN...

Yes, I'm referring to the IS Console. Sorry the two terms are used interchangeably here when there not the same.

Assuming the first two are used in what tables is it stored?

I was just sitting here wondering what database and tables contains the user information that's entered under the administrator (username, name, contact information, etc.). Is it the xmeta database? If not what is it?

Are you saying that '{FILE}/pathnameofsqlfile' will work if I add it to the select statement?

Yes, I understand what a linked conversation is and how to use it. The point is I wasn't able to find anything remotely close within the Teradata connector that allowed one to enter user defined SQL. I may have missed it. Can you tell me where to plug in user defined SQL?

There doesn't appear to be an option for the Teradata connector. Anyone know of one or another way to accomplish this?

Is it possible to read SQL from a file in the Teradata connector? If so where is the file name to be specified in the connector.