ContextQMD
Back to Materialize

Allow Materialize Ips

doc/user/layouts/shortcodes/sql-server-direct/ingesting-data/allow-materialize-ips.html

123723 B
Original Source
  1. In the SQL Shell, or your preferred SQL client connected to Materialize, use the CREATE SECRET command to securely store the password for the SQL Server role you'll use to replicate data into Materialize: mzsql CREATE SECRET sqlserver\_pass AS ''; 1. Use the CREATE CONNECTION command to create a connection object with access and authentication details for Materialize to use: mzsql CREATE CONNECTION sqlserver\_connection TO SQL SERVER ( HOST , PORT 1433, USER 'materialize', PASSWORD SECRET sqlserver\_pass, DATABASE , SSL MODE 'required' ); - Replace with your SQL Server endpoint, and with the database you'd like to connect to.