For AI agents: the complete documentation index is available at https://docs.dataplatform.ovh.net/llms.txt, the full documentation bundle is available at https://docs.dataplatform.ovh.net/llms-full.txt, and this page is available as Markdown at https://docs.dataplatform.ovh.net/connectors-sources-sql-server.md.
  • 🇬🇧 English

    • Use SQL Server database tables as Data Platform sources

    Microsoft SQL Server is a relational database management system. The Platform allows you to use the tables in a SQL Server database as sources for your

    Objective

    Microsoft SQL Server is a relational database management system. The Platform allows you to use the tables in a SQL Server database as sources for your application.

    SQL Server

    Add a SQL Server source on the Platform

    Configure your connection

    When creating the source, you will be required to input the following information :

    • Host: the host name of the SQL Server database.
    • Port: the port address of the SQL Server database.
    • Database: the name of the SQL Server database.
    • Username: the user name for the SQL Server database.
    • Password: the password for the Username you are using.
    • SSL: if activated, encrypts the information exchanged between the Data Platform and the database.

    Select the tables you want

    After establishing a connection with your SQL Server database your tables will be fetched and displayed :

    SQL Server

    Select which tables you want to be included in the source by checking the boxes to the left of the table name, as indicated in the image above.

    Info

    If the state of the database changes, you can use the Fetch button to refresh the tables displayed and include them in your source.

    Once you follow the steps above, click on the Create button on the top right-hand corner.

    Warning

    Don't forget to name your source before creating it. The technical name cannot be changed after creating the source and will be used when trying to open the source using the SDK.

    Go further

    If you need training or technical assistance to implement our solutions, contact your sales representative or click on this link to get a quote and ask our Professional Services experts for a custom analysis of your project.

    Ask questions, give your feedback and interact directly with the team building the Data Platform on the dedicated Discord channel.

    If you need support with your OVHcloud services, create a request in our Help Centre.

    Join our community of users.