Cabletron Systems 9C106 User's Guide Page 127
- Page / 134
- Table of contents
- BOOKMARKS
Rated. / 5. Based on customer reviews
9030971 E17
E-1
Appendix E
Exporting To Other Databases
Describes how a post export script can be used to export data to other databases.
Data exports from SPECTRUM to a third party database can be readily
accomplished using a post-export script that uses SQL commands to copy
ASCII delimited data files to the designated database. To export to SQL
output formats, Data Export internally exports to ASCII delimited files and
then runs a script to import the data.
Both the Data Export import script and any post-export script you may specify
need to know information about the ASCII exported files. Data Export
provides this information in a post-export SPECTRUM parameters file. The
name of the file is the same as the definition file name with the .sprm (for
SPECTRUM parameters) extension appended to it (see Organization Of The
Post-Export Parameter File on Page E-2 for the format of the .sprm file.)
The Data Export scripts that copy ASCII data into an SQL database can be
used as a model for scripts to export to other database formats. The scripts
(SDEIngImport for Ingres, SDESybImport for Sybase, SDEOraImport for
Oracle, and for NT platforms only the SDESqlServerImport for SQL Server)
read the .sprm file and the schema files (.sch) and create, copy, and index the
appropriate tables.
Follow these steps to export SPECTRUM data into a third party database
other than Ingres, Oracle, Sybase, or SQL Server:
1. Write a script or other executable file that will copy the ASCII data to the
chosen database using information from the schema files and the .sprm
file. The .sprm file will be passed as an input parameter when the script
is executed. (This script can be modeled after the Data Export import
script files.)
2. Create an export definition file to export to ASCII delimited files,
specifying the necessary delimiters and format options for the target
product. Specify the script executable created in Step 1 as the post-export
script.
3. Perform the ASCII export or schedule it.
- Data Export User’s Guide 1
- Version 5.0rev1 1
- Virus Disclaimer 4
- Restricted Rights Notice 4
- Contents 5
- Who Should Read This Guide 13
- Prerequisites for Users 13
- How to Use This Guide 14
- Typographical Conventions 15
- Chapter 1 17
- Data Export Files 18
- The Data Export Process 19
- Special Considerations 20
- For SAS Users Only 21
- 1-6 Version 5.0rev1 22
- Chapter 2 23
- Accessing Data Export 24
- Application Commands 25
- Command Icons 26
- General Information 27
- Historical Data 29
- Current Data 31
- Chapter 3 33
- Opening a Definition File 34
- Saving a Definition File 35
- Specifying Landscapes 37
- Setting ASCII Format Options 39
- Specifying Events Data 42
- Specifying Models 43
- Selecting Models 44
- Selecting Filter Criteria 45
- Selecting Event Codes 45
- Selecting Alarms 46
- Specifying Statistics Data 47
- Specifying Output Parameters 50
- Specifying an Export Range 51
- 3-22 Version 5.0rev1 54
- Chapter 4 55
- Starting an Export Now 56
- Scheduling an Export 56
- Working with the Scheduler 57
- Checking Export Output 61
- Log File 62
- Sample ASCII Output 63
- Sample SQL Output 64
- Sample SAS Output 64
- Chapter 5 65
- Data Sets 66
- SAS Export Errors 66
- Leftover SAS Processes 67
- SAS Log Files 67
- SAS Work Area 67
- Chapter 6 69
- Chapter 7 71
- Chapter 8 73
- Installation Considerations 75
- 8-4 Version 5.0rev1 76
- Chapter 9 77
- Configuring the dtxscript File 78
- 9-2 Version 5.0rev1 78
- Appendix A 79
- Schema Format 87
- Appendix B 89
- List Attribute Format 100
- Imported Data Information 102
- Appendix C 103
- SPECTRUM Data Types 104
- Attributes 105
- Extended Attributes 107
- Model Type Hierarchy 108
- Model Types 110
- Relations 112
- Statistics 114
- C-16 Version 5.0rev1 118
- Appendix D 119
- D-2 Version 5.0rev1 120
- D-4 Version 5.0rev1 122
- D-6 Version 5.0rev1 124
- During Installation 125
- D-8 Version 5.0rev1 126
- Appendix E 127
- Appendix F 129
- Two Attributes and One Model 130
Related products and manuals for Chassis components Cabletron Systems 9C106
(6 pages)© 2020, manymanuals.com. All rights reserved. | 0.263 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comments to this Manuals