• 首頁 Home
  • 關於友環 About Linksoft
  • 活動資訊 Events
  • 聯絡我們 Contact Us
  • 註冊
  • 登入
+886-2-2221-2155
[email protected]
0
已加入詢價收藏車: 0筆
  • 產品分類列表
    • 商務工具
    • 應用軟體
    • 開發及程式工具
    • 系統工具
    • 傳輸.遠控.郵件
    • 資訊安全工具
    • 文書處理
    • PDF 應用
    • 網頁相關
    • 圖表編輯
    • 簡報排版
    • 影音軟體
    • 統計分析軟體
    • 數值分析軟體
    • 學術研究軟體
    • 開發及程式工具
      • 商務工具 應用軟體 系統工具 傳輸.遠控.郵件 資訊安全工具 文書處理 PDF 應用 網頁相關 圖表編輯 簡報排版 影音軟體 統計分析軟體 數值分析軟體 學術研究軟體
    • 資料庫開發管理
      • Java & XML 程式碼編輯 程式碼檢查 虛擬裝置 終端機與伺服器 軟體封裝 開發追蹤檢測 ASP 工具 PHP 工具 C++ 工具 日誌分析 電路板設計 開發整合工具 驅動程式開發 OPC 工具 圖表開發程式
    • Dataedo 資料庫文件產生工具
Dataedo 資料庫文件產生工具

本公司皆販售最新版本,目前版本僅供參考
最新版 Dataedo v9.0.1 更新於 2020/8/20

加入詢價收藏車

直接詢價

  • 產品介紹
  • 特色
  • 系統需求
  • 支援的資料庫
  • 版本比較

Dataedo 快速產生資料庫文件

Dataedo 是一款功能強大的 SQL Server、Oracle 及 MySQL 資料庫自動化文件產生工具。 它使您能夠建立資料庫字典(描述所有資料元素),在您的資料庫中建立實體關係圖或文檔存儲過程和函數。

Dataedo 資料庫文件產生工具是 Windows 應用程式,它連接到現有資料庫並導入模式,然後使用者可以提供描述並將文件匯出為 PDF、HTML 或 Excel 格式檔案。

Architecture

 

使用 Dataedot 自動化產製資料庫文件的主要流程如下:

  1. Import schema from database
  2. Describe database elements
  3. Export documentation (to PDF or HTML) (optional:)
  4. Update documentation when database schema changed
  5. Go to 2

 

Create meaningful ER Diagrams

Create database documentation
With Dataedo you can quickly generate documentation of your existing databases.   

               

 

Create Data Dictionary
Dataedo helps your team and organization to create and maintain Data Dictionary for existing databases.

Discover and document table relationships
Dataedo reads foreign keys form database schema to the repository and enables users to add missing relationships to the same model enabling complete and consistent view of data model.

Document stored procedures and functions
Dataedo reads stored procedures, functions and triggers and enables you to describe procedure body, each parameter and returned value separately and add custom metadata fields. It includes this documentation and script in exported documents.

Discover and document dependencies
Dataedo imports dependencies from the database and lets you browse and navigate dependent objects in user interface or exported documents.

Document cross-database dependencies
What makes Dataedo stand out from other tools is the ability to document cross-database dependencies and define cross-database table relationships.


Create meaningful ER Diagrams

Create database diagrams
You can easily create database relational diagrams for existing databases simply dragging & dropping tables and views from the list.

Automatic and manual relationships
Table relationships are imported from database schema (foreign keys) and user is also able to add his own relationships only in the repository without impacting the database.

Cross database diagrams and relationships
Dataedo enables documenting cross-database table relationships and mix objects from different databases on one diagram.

Consistency across Data Dictionary and ERDs
Dataedo keeps one consistent data model for data dictionary and ERDs and keeps it up to date with physical database schema.

 

Share in beautiful documents
Dataedo exports documentation to beautiful HTML, PDF and Excel documents.

 

Easy to keep documentation up to date
Dataedo is designed for documentation in agile environments. We understand that many databases are being developed constantly.

Import schema changes automatically
Dataedo enables you to easily import changes in the source database to make sure you are documenting the most up to date state of your database.


Documentation progress tracking
Within Dataedo interface you can browse progress of documentation and see which objects still need to be described.

 

 


Rich description capabilities

Modules
Dataedo enables you to define modules that can represent subject areas or topics and split large databases into smaller, more comprehensible pieces.

Custom metadata fields
You can add custom plain text fields to almost any data element and document who data owner is, whether column holds sensitive data, what the source of the data is or what is the expected format and so on.

Rich text and images
Describe objects and modules using Word-like rich text editors. Paste existing documentation, diagrams and images.

Aliases
Names of physical database objects can often be misleading and confusing. You can provide aliases for data elements (e.g. table or column) making it more comprehensible.

 


Enterprise class solution

Repository
Dataedo keeps all its data in open repository that is a plain documented SQL database. This repository can be used to keep documentation for all your databases. Use SQL to read and write metadata.

Search
Search feature enables you to documentation for keywords.

Automation
You automate documentation process and incorporate it into your development and maintenance procedures. Run import and export from command line or run custom scritps triggered with events.

Extended properties
Dataedo reads and writes descriptions and extended properties to your database. You can read and save documentation you create.

Import from external sources   Planned 
Dataedo will have database interface that allows you to import metadata from other external sources like unsupported databases, metadata repositories or data modeling tools.

Multiple environments
Set up different repositories for different environments - Dev/UAT/Live or various versions of your system and copy metadata across them.

Manage permissions   Planned 
Define access permissions to each database in the repository.


No data in cloud
All data kept secure in your network on your servers.

Work offline
Documentation can be performed offline, without access to live databases.

Intuitive UI
Modern, intuitive desktop user interface.

Dataedo Editor (client software) can be run in following operating systems with following requirements:

Windows

  • Windows 8 or newer.
  • NET 4.8 installed.
  • Minimum 512MB of memory.
  • Minimum 250MB of available hard-disk space.
  • Segoe UI Light font (for PDF export).

 

Dataedo on Linux

There are two ways of running Dataedo on Linux machine:

Virtual Machine - you can install Windows in a virtual machine using VMware or similar software. This method provides the best compatibility, but you will have to run a copy of Windows in the background.
Wine - Wine is a compatibility layer that allows running Windows applications on Linux by mapping api calls to Linux equivalents. Note that Wine is Not an Emulator and it won’t allow running Dataedo on architectures that are not natively supported (other than i386 and x64).
Dataedo 32 bit has been tested and runs reasonably well on Wine, however installation requires some tricks.

Dataedo 64 bit likely won’t work as long as .NET 4 is only installable in 32-bit wine prefixes.

Requirements
You will need several pieces of software:

  • Dataedo 5.2 or newer. Earlier versions will not run, causing exception on startup
  • Wine version 2.0. We have tested older Wine (1.6) and Wine 3.0 and Dataedo was unstable.
  • .NET framework 4.0 installed in Wine

In our example we will show how to install Dataedo on 32 bit Ubuntu Linux.

 

Dataedo on Mac

Open beta of Dataedo for MacOS is now available.
Just download the package, drag its contents to Applications folder, and you can run it as usual.
Installation requires an internet connection, as .NET packages are downloaded during the first run.

There are still some issues we're working on:

  • Adding a license key hangs the application. Restart it and the key will be correctly loaded.
  • Keyboard shortcuts are based around CTRL instead of CMD. In some cases CMD+C or CMD+V may work, but differently.
  • File and folder paths use \ instead of /. Mac filesystem is available under Y:\ in path prompts.
  • Commandline operations with .dataedocmd files are not supported yet.
  • Administration console is not supported yet.
  • In some cases, crash reports cannot be sent from application. Please email them to [email protected] instead.
  • Connection requiring an additional ODBC driver (Db2, Snowflake, Redshift) is not supported yet.

 

Server Repository requirements

SQL Server
Supported versions
2008 R2, 2012, 2014, 2016, 2017, 2019.

Supported editions
Express, Developer, Standard, Business Intelligence or Enterprise.

Required access level
To create a Dataedo repository you need a database user with sysadmin role.

Azure SQL
Azure repository support is in beta - find out more here: https://dataedo.com/docs/azure-repo

Relational Databases

  • SQL Server
  • Oracle
  • MySQL
  • PostgreSQL
  • MariaDB
  • IBM Db2

 

Cloud Relational Databases

  • Azure SQL Database
  • Azure Databases
  • Amazon RDS
  • Amazon Aurora
  • Google Cloud SQL
  • Percona MySQL

 

Cloud Data Warehouses

  • Amazon Redshift
  • Snowflake
  • Azure SQL Data Warehouse
     
  Pro Pro+ Enterprise
 
Subscription
Subscription
Subscription
Users Per user Per user Per user
Repository      
Repository File / Server File / Server File / Server
Connections per repository Unlimited Unlimited Unlimited
Imported metadata      
Tables, Views V V V
Functions, Procedures, Triggers V V V
Relations (FKs), Unique Keys V V V
Dependencies V V V
Schema change tracking     V
Manual metadata      
Modules V V V
Manual data dictionary/design V V V
Manual Relations (FKs), Unique Keys V V V
Cross-database Relationships V V V
Manual dependencies V V V
Custom fields 5 10 100
ER Diagrams V V V
Business Glossary     V
Automated data classification     V
Documentation management      
Search V V V
Progress tracking V V V
Run from command line V V V
Access/exports      
PDF export V V V
HTML, Excel export V V V
PDF, HTML Customization V V V
Access to HTML export with Business Glossary (requires Enterprise Viewer license)    
請洽詢友環業務
Writing back to the database V V V
Services      
Email support V V V
Remote desktop support   V V
Additional services (training, auditing)     V

產品目錄

商務工具
  • 專案管理
  • 文檔管理
  • 自動排程
  • 流程管理
  • 條碼製作
  • 列印管理
應用軟體
  • 行事管理
  • 桌面管理
  • 翻譯軟體
  • 傳真伺服器
  • 英語學習
  • 其他應用
  • 光碟工具
開發及程式工具
  • 資料庫開發管理
  • Java & XML
  • 程式碼編輯
  • 程式碼檢查
  • 虛擬裝置
  • 終端機與伺服器
  • 軟體封裝
  • 開發追蹤檢測
  • ASP 工具
  • PHP 工具
  • C++ 工具
  • 日誌分析
  • 電路板設計
  • 開發整合工具
  • 驅動程式開發
  • OPC 工具
  • 圖表開發程式
系統工具
  • 作業系統
  • 磁碟工具
  • 系統優化
  • 效能測試
  • 裝置分析
  • 壓縮工具
傳輸.遠控.郵件
  • FTP伺服器/傳輸
  • 網路通訊
  • 檔案傳輸
  • 遠端控制
  • 網域管理
  • 郵件軟體
資訊安全工具
  • 還原備份
  • 網路監控
  • 系統安全
  • 電腦防毒
  • 資料保護
  • 網路安全
  • 網路分析
  • USB 監控
文書處理
  • 文書管理
  • 文書編輯
  • 文書轉檔
  • 方程式編輯
  • 說明文製作
  • 論文編輯
PDF 應用
  • PDF 編輯
  • PDF 轉檔
  • PDF 加解密
  • Acrobat 插件
網頁相關
  • 網頁設計
  • 網頁瀏覽
  • 網頁安全
  • 網頁分析
  • 網頁打包及管理
圖表編輯
  • 圖表開發程式
  • 圖表製作
  • 圖像編輯
  • 3D 繪圖
  • 圖檔轉換
  • 影像擷取
  • 流程圖製作
簡報排版
  • 字型設計
  • 排版設計
  • 地圖繪製
  • 簡報及電子書
影音軟體
  • 樂曲製作
  • 視頻編碼
  • 影像錄製
  • Flash 製作
  • 動畫製作
  • 影像圖庫
  • 影音分析
  • 影音播放
  • 影音編輯
  • 錄音軟體
  • 字幕軟體
統計分析軟體
  • 統計分析
  • 結構分析
  • 時間序列分析
  • 計量分析
  • 統計流程控制
  • 社會網絡分析
數值分析軟體
  • 決策分析
  • 數值運算
  • 人工智慧
  • 質性分析
  • 生命週期評估
學術研究軟體
  • 化學軟體
  • IRT 應用
  • 生物軟體
  • 水利軟體
  • 視覺思考
  • 數學軟體
  • 互動教學
  • 醫學軟體
  • 物理分析
  • 認知心理
友環股份有限公司   版權所有 2007-2021 Linksoft Inc. All Rights Reserved.

地址: 23504新北市中和區中山路二段351號6樓之10
 
電話: +886-2-2221-2155
 
傳真: +886-2-2221-9008

[email protected]  
http://www.linksoft.com.tw  
關於友環  
聯絡我們   Facebook關注  

會員登入

忘記密碼

會員註冊

Linksoft友環專業軟體代理網站服務,不論會員或非會員均可享受產品詢價和訂購服務。
欲加入會員,可以點選「註冊」成為會員。

加入會員的好處:

1. 您可以隨時登入會員,查詢產品詢價記錄,更新您的會員資料。
2. 系統將自動帶出您的會員資料,免去資料重複繕打的麻煩。
3. 只需填寫基本的聯絡資料,不會要求您留下身份證字號等個人機密性資料。
4. 掌握最新的產品資訊及最新好康,享受完整的客戶服務,註冊的聯繫Email可立即收到通知,再也不用怕漏失重要訊息。

忘記密碼