MicroStrategy 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/;};