Database Connected Data in CSA

Aus OCAD 11 Wiki - Deutsch
Zur Navigation springen Zur Suche springen

This function is only available in the OCAD 11 Enterprise Edition.

Diese Funktion ist in OCAD 11 nur in Englisch verfügbar.

Import of Database Connected Data

When a CSA-Project is opened, it is possible to import the database connection data to the PostgreSQL database on the server:

  1. Choose the Manage Database Connections command in the Database menu
  2. The Manage Database Connections dialog appears. On the right side of the dialog the Import to PostgreSQL button is shown.
  3. Click this button.
  4. The Server Import PostgreSQL Data dialog appears.
  5. Enter the connection data and click the Test button to verify the connection.
  6. If the connection was successful, choose a Dataset in the Dataset to Import part of the dialog.
  7. Enter a name for the table.
  8. Check the Drop existing table option to automatically overwrite an existing table with the same name chosen without any warning message. Otherwise a warning message will appear.
  9. Click the Import button.
  10. The Import progress for Dataset part of the dialog shows the progress of the import.
  11. Click the Close button when finished.

If any error occurs during the import, two files are written in the temporary folder: TABLENAME_ddl.sql and TABLENAME_data.sql. Keep them for support reasons.

Last page: Rights Management
Back to the Client Server Architecture page.
An overview about all pages dealing with the Client Server Architecture can be found in the corresponding category (see below for the link).