Turboline.NLQ2SQL.MSSQL 6.1.9

Turboline.NLP2SQL.MSSQL

Integrating MSSQL Turboline Packages in Your Application

Objective:

To integrate MSSQL Turboline Packages into your application efficiently and effectively.

Key Steps:

1. Create a blank project using the ASP.NET web app model view controller.
2. Choose .NET 8.0 for the project.
3. Select individual accounts for authentication.
4. Install the MSSQL package from NuGet packages. dotnet add package Turboline.NLQ2SQL.MSSQL
5. Add code in the program.cs file:
   • Add namespace using Turboline.NLQ2SQL.MSSQL;.
   • Add builder.Services.EnableTurbolineDashboard(builder.Configuration).ActivateMSSQL();.
   • Add app.UseTurbolineDashboard().UseMSSQL(); after the controller route.
6. Update the application settings with the following configurations:
   • Set MSSQL as the database type.
   • Provide the connection string for the database.
   • Add an API key obtained from the plan subscription from https://platform.turboline.ai.
   • Set an app name and logo URL.

"NLQ2SQLSettings": {
  "MSSQL": {
    "ConnectionString": "<Connectionstring>"
  },
  "APIKey": "",
  "AppName": "Amtev Data Studio, Powered by Turboline",
  "Logo": "https://cdn.turboline.ai/cdn/adminlte/dist/img/TLLogo.png"
}

7. Run the project to complete the setup.
8. To access the Turboline NLQ to MSSQL, navigate /Turboline/mssql.

Cautionary Notes:

• Ensure correct installation of the MSSQL package from NuGet.
• Double-check the code additions in the program.cs file for accuracy.
• Securely store and manage the API key obtained from the subscription plan.

Tips for Efficiency:

• Follow the steps sequentially to avoid missing any crucial configurations.
• Keep all necessary information and URLs handy for quick reference during setup.
• Test the integration thoroughly after completion to ensure functionality.

By following these steps, you can seamlessly integrate MSSQL Turboline Packages into your application within a few minutes.

Using Turboline Lite Studio

Objective

To demonstrate how to navigate and utilize the features of Turboline Lite Studio for data analysis.

Key Steps

1. Access the demo site using the provided URL.
2. Log in using your Google account or personal email address.
3. Explore the table information, including table names, column information, and number of records.
4. Use the search function to find specific data, such as listing all products.
5. Export data to CSV, Excel, PDF, or print it.
6. Utilize the graphical interface to view data in different chart formats.
7. Customize graphs by selecting specific data points or colors.
8. Run complex queries to group data based on specific criteria.

Cautionary Notes

• Ensure proper login credentials to access the platform.
• Be cautious when running complex queries to avoid errors in data grouping.
• Verify data accuracy before exporting or printing.

Tips for Efficiency

• Familiarize yourself with the table information before conducting searches.
• Utilize the graphical interface to visualize data trends effectively.
• Save frequently used queries for quick access in the future.

Video Tutorial: Generate API Keys

Video Tutorial: Integrate MSSQL Turboline Packages in Your Application