CONNXデータの移動と移行

Whenever changes are taking place in the IT infrastructure or application landscape within an organization, there will be a need to move or migrate data among new and existing systems. There can be different scenarios, each requiring a specific set of functionality:

• Migrating a vendor-specific RDBMS to an open-source DBMS, such as Oracle^® to PostgreSQL, IBM^® インフォミックス^® to MySQL^®
• Consolidating a multi-vendor RDBMS to a single or fewer RBDMS, such as Sybase^® to SQL Server^®, Db2^® to Oracle
• Moving data to cloud databases, such as MySQL to Microsoft^® アジュール^® SQL Database, Oracle to Amazon^® AWS RDS, SQL Server^® to Amazon REDSHIFT^®
• Providing or extending Extract, Transformation, Load (ETL) capabilities to connect and transform legacy data sources to a data warehouse environment, such as OpenVMS^® Rdb to Teradata^®
• Moving data from transactional databases, such as Adabas, VSAM or IMS, to a big data or data lake environment, such as Hadoop.^®  

Whatever your scenario, you’re covered by CONNX.  

---

主なメリット

• Access all of your data sources with standard SQL
  
• Deliver your data integration projects in less time and at less cost
• Ensure secure access to sensitive data
• メタデータ管理による完全な制御と柔軟性の維持
  
• 変化する要件にデータ変換を素早く適応させる
  
• Use one integrated technology to connect to 150+ data sources
• Seamlessly move and migrate data across legacy, RDBMS, big data and cloud  

CONNX will help you quickly move and migrate data

特徴

150以上のデータコネクタ

CONNXは、メインフレーム、OpenVMS、iSeries (AS/400)、Linuxなどのプラットフォームに存在するさまざまなデータベース（レガシー、リレーショナル、ビッグデータ、クラウド）への標準SQL接続を提供します。^®ウィンドウズ^® とデスクトップ。

Standard support

CONNX DBアダプター provide read/write SQL data access supporting ODBC, OLE DB, JDBC^®, J2EE^® and .NET^® technologies.

Comprehensive transformation

SQL-based transformation with a graphical query builder allows comprehensive mappings of tables and fields. In addition, a library of more than 100 transformation functions provides many ways to map the value of a field.

Scheduled and on-demand

Transformation settings give full control of scheduling incremental or full data movements, launching pre- or post-sync tasks, and setting up automatic email event notifications.

メタデータ管理

メタデータ管理を通じて、ソース構造を変更することなく、すべてのデータを単一の理解しやすい構造に統合する語彙を作成します。

安全なアクセス

CONNX Securityは、複数のデータベースログインを管理し、各システムのデータへのアクセスを保護することで、クロスプラットフォームのセキュリティ問題を扱うのに理想的です。

Data replication

Enhance the CONNX platform with data replication capabilities that allow you to share data in an event-driven way leveraging Change Data Capture (CDC) technology.  

---

Simplified SQL data access to more than 150 data sources:

• アダバス
• Amazon AWS
• C-ISAM^®
• データフレックス^®
• Hadoop^®
• IBM Db2
• IMS^™
• Infomix
• マリアDB
• マイクロソフト・アジュール
• MySQL
• オラクル^®
• PostgreSQLまたはEnterpriseDB
• データベース
• かいふくかんりきのう
• SQLサーバー
• サイベース
• テラデータ
• VSAM™
• さらに

---

Get your data to work

CONNX will help you to move and migrate your data wherever it is needed. Whether you want to move legacy data or relational databases to analytical systems (such as data warehouse, business intelligence, big data or the cloud) or migrate from one database to another database — CONNX is your platform of choice. And by integrating CONNX with Software AG’s suite of products, you can rest assured that your high-value data will play a key role in your organization’s digital transformation.