Database Connected Data in CSA: Unterschied zwischen den Versionen

Aus OCAD 11 Wiki - Deutsch
Zur Navigation springen Zur Suche springen
Zeile 1: Zeile 1:
 
[[Category:Client Server Architecture]][[File:Ent40px.PNG|This function is only available in the OCAD 11 Enterprise Edition.|link=https://www.ocad.com/en/products/ocad-for-cartography]]
 
[[Category:Client Server Architecture]][[File:Ent40px.PNG|This function is only available in the OCAD 11 Enterprise Edition.|link=https://www.ocad.com/en/products/ocad-for-cartography]]
==Import of Database Connected Data==
+
==Datenbankverbundene Daten importieren==
 
When a CSA-Project is opened, it is possible to import the database connection data to the PostgreSQL database on the server:
 
When a CSA-Project is opened, it is possible to import the database connection data to the PostgreSQL database on the server:
# Choose the '''Manage Database Connections''' command in the '''[[Database]]''' menu
+
# Choose the '''Manage Database Connections''' command in the '''[[Datenbank]]''' menu
# The '''[[Database#Manage Database Connections|Manage Database Connections]]''' dialog appears. On the right side of the dialog the '''Import to PostgreSQL''' button is shown.
+
# The '''[[Database#Datenbankverbindungen verwalten|Datenbankverbindungen verwalten]]''' dialog appears. On the right side of the dialog the '''Import to PostgreSQL''' button is shown.
 
# Click this button.
 
# Click this button.
 
# The '''Server Import PostgreSQL Data''' dialog appears.
 
# The '''Server Import PostgreSQL Data''' dialog appears.

Version vom 21. Juni 2013, 10:53 Uhr

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

Datenbankverbundene Daten importieren

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 Datenbank menu
  2. The Datenbankverbindungen verwalten 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).