Skip to main content

SQL Server

Prerequisite steps to perform in the Anansi tool.

Import CSV Templates​

To create a High-Level Demo Catalog, import templates from the provided link. Make the necessary changes to the catalog names in the CSV template.

Import data from SQL Database​

After setting up the tables as per the templates given above, navigate to the Anansi Tool, hover over 'Import' icon and select 'Import DB'.

import_database

Enter parameters into the tool​

  • DB Type: Select "SQL Server" as the database type.
  • Connection String: Enter the ODBC connection string of your SQL Database.
  • Schema Name: Specify the schema name to be imported from SQL Database.

sql_import

note

Sample Connection String

Driver={ODBC Driver 18 for SQL Server};Server=tcp:xxxxxx,1433;Database=xxxx;Uid=xxxx;Pwd=xxxx;Encrypt=yes;TrustServerCertificate=no;Connection Timeout=60;

Replace "Server," "Database," "Uid," and "Pwd" with your database details.

  • Click 'Next'.

In the Data Import Wizard Enter the following parameters

  • DB Name: Provide the unique name/identifier for your database. (For Ex: Smith__Database, Suraj_Sample_Database etc.)
  • Catalog Name: Select the catalog name where the data needs to be imported from the dropdown.

sql_import

  • Click 'Submit'.

After a successful import, it will display 'Metadata Fetched Successfully'.