DataFlux Data Management Studio 2.5: User Guide

Repository Usage Notes

When do I need to use a DataFlux 32-bit SQL Server Wire Protocol driver?

When adding repositories, 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.

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.

How can I create a repository in Informix?

Create a DSN connection to the Informix database as described in Adding ODBC Connections. Then specify that connection in a repository definition, as described in Adding New Repositories.

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.

How do I create a repository in Oracle?

Create a DSN connection to the Oracle database as described in Adding ODBC Connections. Then specify that connection in a repository definition, as described in Adding New Repositories.

If the DBMS for your repository is in Oracle format, then 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.

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

If you upgrade a 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.