DataFlux Data Management Studio 2.7: User Guide

Repository Usage Notes

Upgrade Repositories from Earlier Releases

If you upgrade DataFlux Data Management Studio from an earlier release, you might be prompted to upgrade your repository. For information, see Upgrade Repositories.

Special Considerations for DBMS Repositories

Informix. Informix databases do not have schemas and what appears to be schemas in the Data riser are actually users. To work around this to create a repository always enter a prefix in the Table prefix (optional) field in the New Repository Definition window. If you want to specify the user in the prefix, add a prefix after the ".". For example, "CHARLESN.DMP_22_" is a valid prefix but "CHARLESN." is not. If you created a repository using "CHARLESN.DMP_22_" and "DMP_22_" (both under the charlesn user) as a prefix, then the tables were created under the charlesn schema.

Oracle. When adding a repository in Oracle forrmat, you must use an upper case table prefix. In general, use only a-z, A-Z, 0-9, and the underscore as characters for a table prefix. A period is also acceptable if it is used as a separator between a schema name and the table prefix.

SQL Server. When adding a repository in SQL Server forrmat, you cannot use a DSN that specifies the DataFlux 32-bit SQL Server Legacy Wire Protocol driver or the DataFlux 32-bit SQL Classic Wire Protocol driver. If you have an ODBC DSN that uses one of these drivers, replace that DSN with one that uses the DataFlux 32-bit SQL Server Wire Protocol driver.

SQL Server. When adding a repository in SQL Server forrmat, take one of the following actions to prevent collisions with existing keyword definitions on the database: (a) Specify a table prefix in the database connection definition; or (b) Specify Enabled Quoted Identifiers on the Advanced tab of the database connection definition.

Teradata. Repositories are supported on Teradata via ODBC. However, repositories on Teradata via the SAS Federation Server are not supported.

What does "The version of repository "<ReposName>" is newer than this client mean?

If you get a message that says something like, "The version of repository "<ReposName>" is newer than this client, this means that someone at your site has a newer version of DataFlux Data Management Studio than you do and has upgraded the repository. Contact your site administrator about upgrading your DataFlux Data Management Studio software.

How can I fix a lineage error?

You can sometimes see an error in the lineage for a selected object. For example, you might see the same ProfileJob twice in the used by position of a lineage when you select the lineage of a table. In these cases, you can go to the Repository folder in the Administration riser bar. Then, you can right-click the current repository and select Update Lineage to correct the problem.

Are there any characters I can't use when I upgrade the repository?

If you upgrade a DataFlux Data Management Studio repository, and the names of Rules, Tasks, Data Explorations, or Profiles contain the following characters, then these objects will not perform correctly:

'/', '\\', ':', ';', ',', '?', '*', '<', '>', '|'

You should replace these characters before the upgrade.