Microsoft SQL Server

  • This article provides information about configuring MS SQL Server Repository connection

    All versions are supported including 2000, 2005, 2008, 2012, 2014, 2016, 2017 and Compact Edition.
    By default MS SQL Server repository connection is using 32 bit Microsoft OLE DB Provider for SQL Server, 
    it is possible to use different 32 bit OLE DB Provider by switching to OLE DB Repository connection type.

    oledb

    To create a new MS SQL Server repository connection

    Click Options
    Click  Plus
    Enter connection name
    Set type to MS SQL Server
    Select/Enter server name
    Enter username and password
    Select database name
    Make sure that connection actually works

     

    MS SQL Server Repository1

    Note: When user name and password are blank windows autentification is used

    To create a new MS SQL Server repository connection using Ole DB

    Click Options
    Click  Plus
    Enter connection name
    Set type to Ole DB
    Select build connection
    Select relevant Ole DB provider and enter necessary parameters
    Make sure that connection actually works

     

    MS SQL Server Repository2

    To avoid problems always make sure that you are using the latest version of 32 bit MS SQL Server client
    Notes:

    Using Sql Server user name and password is always better than using windows authentication. Consider the following scenario. Administrator Jonh installs the software everything is working fine. Developer Peter logs in, nothing is working, because developer has no access to repository database. Peter gets proper access and he can do his job. Over weekend another administrator want to check execution status he logs in, the same problem happens again.

    Videos

    Download Free Trial Learn More About Our ETL Software
  • Both Visual Importer ETL and Advanced ETL Processor are 32-bit applications so they use 32-bit ODBC drivers

    Our software uses the highest driver installed for example If both SQL server 2005 and 2008 are installed it will use SQL Server 2008 Driver.

    To Check Version of SQL Server ODBC Driver do the following

    • Click  Maintain
    • Click ODBC Manager

    donate

    Here are the links to the latest version of drivers:

    Feature Pack for Microsoft SQL Server 2005

    Download Driver

    Download Instructions
    1. Hit the Download button.
    2. Checkbox one of the installation packages (msi). Make sure you choose the right version:
    3. sqlncli.msi for 32-bit
    4. Click Next.
    5. Download starts.

    Feature Pack for Microsoft SQL Server 2008

    Download Driver

    Download Instructions
    1. Hit the Download button.
    2. Checkbox one of the "sqlncli.msi" installation packages. Make sure you choose the right version:
    3. x86 for 32-bit
    4. Click Next.
    5. Download starts.

    Feature Pack for Microsoft SQL Server 2008 R2

    Download Driver

    Download Instructions
    1. Do NOT hit the Download button
    2. Expand the "Install Instructions" section
    3. Under the "Microsoft SQL Server 2012 Native Client" heading, click one of the "sqlncli.msi" installation package links. Make sure you choose the right version:
    4. X86 Package for 32-bit
    5. Download starts.

    Feature Pack for Microsoft SQL Server 2012

    Download Driver

    Download Instructions
    1. Hit the Download button.
    2. Checkbox one of the "sqlncli.msi" installation packages. Make sure you choose the right version:
    3. sqlncli_x86.msi for 32-bit
    4. Click Next.
    5. Download starts.

    Use SQL Server 2012 Drivers for SQL Server 2014

    Note

    Most of the time existing drivers work fine with all versions of SQL Server all you need to do is to make sure that you have latest driver installed, so if you have SQL server 2008 driver installed and work with SQL server 2012 make sure that you have the latest version of SQL server 2008 driver installed

  • All our ETL products support TLS 1.2 now.

    That does not mean that the software is actually using it.

    To enable you have to install a lot of patches from Microsoft. they must be installed on both the client and the server.

    https://support.microsoft.com/en-gb/help/3135244/tls-1-2-support-for-microsoft-sql-server

    Then you have to enable TLS 1.2 and disable the rest of the protocols (on the server and client)

    We recommend using IISCripto for it

    https://www.nartac.com/Products/IISCrypto 

    iiscrypto

    And the last step is to reboot the computer

    Download Free Trial Learn More About Our ETL Software
  • Advanced ETL Processor Enterprise: Loading QVD file into SQL Server

    All our ETL tools have no limitations, that means you can load your data today and solve all the data quality problems right now.

  • Loading data from multiple files into MS Sql Server

    In this tutorial, you will learn how to use Advanced ETL Processorto perform Loading data from multiple files into MS SQL Server.

    The best way to become acquainted with the new tools, controls and features available in Advanced ETL Processoris to use them.

    This tutorial is intended for users familiar with fundamental database operations, but who have limited exposure to the new features available in Advanced ETL Processor.

    All our ETL tools have no limitations, that means you can load your data today and solve all the data quality problems right now.

  • Load data in Microsoft SQL server in just a few clicks. Plus there is no need to create any scripts or learn command line tools just point and click.

    Learn how you can do it now.

     There several ways to load data into Microsoft SQL Server Database

    • Via ODBC
    • Via OLE DB
    • Using BCP interface

    This article describes loading data via BCP.

    BCP is the fastest way of loading data into SQL Server

    MS SQL Server specific parameters

    Check constraints
    Ensure that any constraints on the destination table are checked during the bulk copy operation. By default, constraints are ignored.

    Keep identity
    Specify that there are values in the data file for an identity column.

    Keep NULLS
    Specify that any columns containing a null value should be retained as null values, even if a default value was specified for that column in the destination table.

    Batch size

    Specify the number of rows in a batch. The default is the entire data file.

    The following values for the Batch sizeproperty have these effects:
    If you set Batch size to zero, the data is loaded in a single batch. The first row that fails will cause the entire load to be cancelled, and the step fails.
    If you set Batch size to one, the data is loaded one row at a time. Each row that fails is counted as a one-row failure. Previously loaded rows are committed.
    If you set Batch size to a value greater than one, the data is loaded one batch at a time. Any row that fails in a batch fails that entire batch; loading stops and the step fails. Rows in previously loaded batches are either committed or if the step has joined the package transaction, provisionally retained in the transaction, subject to later commitment or roll-back.

    Visit Support Forum Learn More Download Buy It
  • Latest versions of Advanced ETL Processor  and Visual Importer ETL loads data up to two times faster

    Old version:1640 records per second:

    Old Version

     New version:4091 records per second:

    New Version

    Note: Only If your table has TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX), XML, IMAGE or BINARY(MAX) fields. 

    Download Free Trial Learn More About Our ETL Software
  • A new version of Advanced ETL Processor is available for download

    Chages are:

     + Up to 2 times faster data extraction from SQL Server
     + Up to 2 times faster data extraction from ODBC sources
     + Up to 40 percent faster loading data into SQL Server
     + Up to 40 percent faster loading data into ODBC
     + Up to 10 percent faster QVX files creation
     + Up to 10 percent faster loading data into PostgreSQL
     - Various bugs fixes and improvements

    Here are our test results: pooling data from SQL server

    VersionRecords per secondTime Taken
    5.8.0.19 41,100 1min 12sec
    5.8.0.6 21,436 2min 19sec

    Extract Data From SQL Server NEW Version

     Extract Data From SQL Server OLD Version

    Notes:

    1. The performance also depends on the hardware configuration
    2. Please use our support forum to provide us with feedback
    Visit Support Forum Learn More Download Buy It

We have 78 guests and one member online