Connect to SQL Server

WP Data Access supports connections to Microsoft SQL Server via ODBC and JDBC. Before you begin, please follow the link below to learn how to set up a connection to SQL Server using ODBC or JDBC.

> ODBC | JDBC Setup and Installation (read this first)

Video Tutorial

Steps Covered in This Video

• Check prerequisites.
• Check system architecture.
• Install the CONNECT storage engine (if not already installed).
• Install ODBC or JDBC drivers.
• Prepare the SQL Server connection (must use SQL Server Authentication).
• Check the SQL Server table structure (are all data types supported? is a primary key needed?).
• Use SQL Server in Data Tables.
• Use SQL Server in Data Projects (supports data management on the back-end and front-end).

Resources

• ODBC Driver for SQL Server
• Installing the Microsoft ODBC Driver for SQL Server (Linux/macOS)