Strategy ONE

可以通过 HTTP 代理服务器连接的关系数据库

您可以通过代理服务器创建与数据库的连接。可以使用连接字符串示例通过 HTTP 代理服务器连接以下数据库。

认证网关和连接字符串示例

数据库 ODBC 连接字符串 JDBC 连接字符串
Microsoft SQL Server
复制 
DRIVER={MicroStrategy ODBC Driver for SQL Server Wire Protocol}; hostname={hostname}; Port={port}; Database={database}; AuthenticationMethod=1;ProxyMode=1;ProxyHost={proxyserverhost};ProxyPort={proxyport};
复制 
JDBC;Driver={com.microstrategy.jdbc.sqlserver.SQLServerDriver};URL={jdbc:microstrategy:sqlserver://{hostname}:{port};DATABASENAME={database};fetchTWFSasTime=TRUE;ProxyMode=1;ProxyHost={proxyserverhost};ProxyPort={proxyport}};
Amazon Redshift
复制 
DRIVER={MicroStrategy ODBC Driver for Amazon Redshift Wire Protocol}; HostName={hostname}; PortNumber={port}; Database={database};ProxyMode=1;ProxyHost={proxyserverhost};ProxyPort={proxyport};
复制 
JDBC;DRIVER={com.microstrategy.jdbc.redshift.RedshiftDriver};URL={jdbc:microstrategy:redshift://{hostname}:{port};DatabaseName={database};ProxyMode=1;ProxyHost={proxyserverhost};ProxyPort={proxyport}};
Azure Synapse Analytics
复制 
DRIVER={MicroStrategy ODBC Driver for SQL Server Wire Protocol}; hostname={hostname}; Port={port}; Database={database}; EncryptionMethod=1; ValidateServerCertificate=0;EnableQuotedIdentifiers=1;ProxyMode=1;ProxyHost={proxyserverhost};ProxyPort={proxyport};
复制 
JDBC;Driver={com.microstrategy.jdbc.sqlserver.SQLServerDriver};URL={jdbc:microstrategy:sqlserver://{hostname}:{port};DATABASENAME={database};EncryptionMethod=SSL;ValidateServerCertificate=false;fetchTWFSasTime=TRUE;ProxyMode=1;ProxyHost={proxyserverhost};ProxyPort={proxyport}};
Azure SQL 托管实例
复制 
DRIVER={MicroStrategy ODBC Driver for SQL Server Wire Protocol}; hostname={hostname}; Port={port}; Database={database}; EncryptionMethod=1;AuthenticationMethod=1;ValidateServerCertificate=0;ProxyMode=1;ProxyHost={proxyserverhost};ProxyPort={proxyport};
复制 
JDBC;DRIVER={com.microstrategy.jdbc.sqlserver.SQLServerDriver};URL={jdbc:microstrategy:sqlserver://{hostname}:{port};DatabaseName={database};EncryptionMethod=SSL;ValidateServerCertificate=false;fetchTWFSasTime=TRUE;ProxyMode=1;ProxyHost={proxyserverhost};ProxyPort={proxyport}};
MySQL
复制 
DRIVER={MySQL ODBC 8.0 Unicode Driver}; SERVER={hostname}; PORT={port}; DATABASE={database};DriverUnicodeType=1;FORWARD_CURSOR=0;NO_CACHE=0;ProxyMode=1;ProxyHost={proxyserverhost};ProxyPort={proxyport};
复制 
JDBC;DRIVER={com.mysql.jdbc.Driver};URL={jdbc:mysql://{hostname}:{port}/{database}?useCursorFetch=true&defaultFetchSize=1000&ProxyMode=1&ProxyHost={proxyserverhost}&ProxyPort={proxyport}};

PostgreSQL
复制 
DRIVER={MicroStrategy ODBC Driver for PostgreSQL Wire Protocol}; HostName={hostname}; PortNumber={port}; Database={database};ProxyMode=1;ProxyHost={proxyserverhost};ProxyPort={proxyport};
复制 
JDBC;Driver={com.microstrategy.jdbc.postgresql.PostgreSQLDriver};URL={jdbc:microstrategy:postgresql://{hostname}:{port};DATABASENAME={database};ProxyMode=1;ProxyHost={proxyserverhost};ProxyPort={proxyport}};
Oracle
复制 
DRIVER={MicroStrategy ODBC Driver for Oracle Wire Protocol}; HostName={hostname}; PortNumber={port}; SERVICENAME={servicename}; AlternateServers=; EnableNCharSupport=1; IANAAppCodePage=111;ProxyMode=1;ProxyHost={proxyserverhost};ProxyPort={proxyport};
复制 
JDBC;DRIVER={com.microstrategy.jdbc.oracle.OracleDriver};URL={jdbc:microstrategy:oracle://{hostname}:{port};ServiceName={servicename};ProxyMode=1;ProxyHost={proxyserverhost};ProxyPort={proxyport}};

Snowflake
复制 
DRIVER={SnowflakeDSIIDriver ODBC};SERVER={hostname};DATABASE={database};SCHEMA={schema};WAREHOUSE={warehouse};Proxy={proxyserverhost}:{proxyport};
复制 
JDBC;DRIVER={net.snowflake.client.jdbc.SnowflakeDriver};URL={jdbc:snowflake://{hostname}/?warehouse={warehouse}&db={database}&schema={schema}&useProxy=true&proxyHost={proxyserverhost}&proxyPort={proxyport}};
IBM Db2
复制 
DRIVER={MicroStrategy ODBC Driver for DB2 Wire Protocol}; IpAddress={hostname}; TcpPort={port}; Database={database};ProxyMode=1;ProxyHost={proxyserverhost};ProxyPort={proxyport};
复制 
JDBC;DRIVER={com.microstrategy.jdbc.db2.DB2Driver};URL={jdbc:microstrategy:db2://{hostname}:{port};DATABASENAME={database};ProxyMode=1;ProxyHost={proxyserverhost};ProxyPort={proxyport}};

MongoDB
复制 
Driver={MicroStrategy ODBC Driver for MongoDB}; hostname={hostname}; Port={port}; Database={database}; SD=#TEMP_PATH#123;WhereClauseHandlingMode=0;ReadOnly=0;ProxyMode=1;ProxyHost={proxyserverhost};ProxyPort={proxyport};
复制 
JDBC;DRIVER={com.microstrategy.jdbc.mongodb.MongoDBDriver};URL={jdbc:microstrategy:mongodb://{hostname}:{port};DATABASENAME={database};ValidateServerCertificate=false;EncryptionMethod=noEncryption;ReadOnly=false;ProxyMode=1;ProxyHost={proxyserverhost};ProxyPort={proxyport};SchemaMap=#TEMP_PATH#/tpch-jdbc-proxy/;};