SQL server访问达梦 可以参考这个文件

创建到SQL server的DBLINK.zip

pg 访问达梦

下载数据库包
https://www.postgresql.org/ftp/source/v11.1/ ###PG数据库包下载路径
https://www.postgresql.org/ftp/odbc/versions/src/ ### PG-ODBC下载路径

1:安装依赖
yum install -y perl-ExtUtils-Embed readline-devel zlib-devel pam-devel libxml2-devel libxslt-devel openldap-devel python-devel gcc-c++ openssl-devel cmake

安装ODBC
[root@localhost ~]# tar -zxcf unixODBC-2.3.9.tar.gz -C /usr/local/
[root@localhost ~]# cd /usr/local/unixODBC-2.3.9/
编译：
[root@localhost ~]#./configure
[root@localhost ~]# make && make install

3:安装Postgresql ODBC驱动
[root@localhost ~]# tar -zxvf psqlodbc-12.02.0000.tar.gz -C /usr/local/
[root@localhost psqlodbc-12.02.0000]# ./configure --with-unixodbc --with-libpq=/pgsql/postgresql/ ##--with-libpq参数对应PG数据库实例路径
[root@localhost psqlodbc-12.02.0000]# make && make install

4:修改ODBC配置源：
vim /usr/local/etc/odbcinst.ini
[{PostgreSQL ANSI(x64)}]
Description = PostgreSQL
Driver = /usr/local/lib/psqlodbcw.so
Setup = /usr/local/lib/psqlodbcw.so
FileUsage = 1
vim /usr/local/etc/odbc.ini
[PostgreSQL]
Description = PostgreSQLODBC
Driver = {PostgreSQL ANSI(x64)}
Database = pg
Servername = localhost
UserName = pg
Password = pg
Port = 5432
ReadOnly = 0

(有时候粘贴会有问题) --遇到这个建议手写配置文件
报错——————注意：odbc.ini和odbcinst.ini中每行开头禁止留有空格，否则会有如下报错信息：
[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified
[ISQL]ERROR: Could not SQLConnect；
切换用户验证：
su - postgres
isql -v PostgreSQL pg pg

达梦配置odbc
1.拷贝odbc下三个.so文件至达梦bin目录下
./cur/.libs/libodbccr.so
./odbcinst/.libs/libodbcinst.so
./DriverManager/.libs/libodbc.so

2:修改配置文件：
添加DM的依赖配置
vim /usr/local/etc/odbcinst.ini
[DM8 ODBC DRIVER]
Description = ODBC DRIVER FOR DM8
DRIVER = /home/dmdba/dmdbms/bin/libdodbc.so

vim /usr/local/etc/odbc.ini
[dm8]
Desription = DM ODBC DSND
Driver = DM8 ODBC DRIVER
SERVER = localhost
UID = SYSDBA
PWD = SYSDBA
TCP_PORT = 5236

测试连接：
su - dmdba
isql dm8

达梦库创建DBLINK
cd /home/dmdba/dmdbms/bin/
./disql
用户名：SYSDBA
密码：SYSDBA

create link "SYSDBA"."TEST" connect 'ODBC'
with "pg" identified by "pg" using 'PostgreSQL';
select * from "mytable"@"TEST";

https://blog.csdn.net/qq_41592403/article/details/119677098
mysql参考上面链接试试