Document Type | Technical Information
Category | Interface/Integration
Applicable Product Version | 6FS07
Document Number | TIITI028
Overview
ALTIBASE supports the DBLink feature provided by TIBERO RDBMS through a JAVA GATEWAY, similar to MS-SQL SERVER and Sybase ASE.
This document guides you on how to create and use a DBlink after installing and configuring the JAVA GATEWAY for TIBERO TO ALTIBASE DBLINK usage.
NoteInstallation and configuration methods for the JAVA Gateway are available in separate posts.
Method
1. Create DB Link Object
1.1. Create DB Link Object
Connect to tbsql and create an Altibase database link.
You can create a DB Link object using the syntax below.
SQL> create database link [DB LINK name] connect to [user ID] identified by [password] using [ALIAS to connect]; ex) SQL> create public database link alti connect to SYS identified by 'MANAGER' using 'alti'; Database Link 'ALTI' created.
CautionYou need CREATE DATABASE LINK or CREATE PUBLIC DATABASE LINK privileges to create a DB Link.
1.2. Verify and Connect to DBLINK
Check that the DBLINK has been created using a view such as DBA_DB_LINKS, then connect to ALTIBASE using the created DBLINK.
ex) SQL> select * from dba_db_links; OWNER DB_LINK USERNAME HOST CREATED ---------- ---------- ---------- ---------- -------------------- PUBLIC ALTI SYS alti 2022/11/02 SQL> select * from dual@alti; DUMMY ----- X 1 row selected.