Skip to Content

ODBC/NETWORK CONNECTION PROTOTYPE FOR SQL ANYWHERE 16

  1. Download Sybase SQL Anywhere 16 from the link Sybase Sql Anywhere 16
  1. Install SQL Anywhere 16 with default settings, which installs Sybase Central
  1. Open Sybase Central from Start→ Programs → SQL Anywhere 16 → Sybase Central

10.png

  1. Connect to the SQL Anywhere server 16 Database from Sybase Central → Connections → Connect with SQL Anywhere 16 database

11.png

  1. Enter the Connection Details for the SQL Anywhere 16 database connection and click on Tools buttons Test connection

  12.JPG 

  1. The connection will open the connected database
  2. The default authentication details are user id:DBA Password:sql
  3. The Connection to the SQL Anywhere 16 is of different types
    1. Connect with an ODBC data source
      1. Download and install the SQL Anywhere 16 ODBC drivers and Create an ODBC connection with the database connection details 

18.JPG

      1. Check the connection
    1. Connect to a Running Database on this computer
      1. Enter the Authentication details
      2. Select the Connect to a running database on this computer from Action list
      3. Run the Personal Server or Personal Server sample from the start→ SQL Anywhere 16 → SQL Anywhere → Personal Server / Personal Server sample

14.png

    1. Select the DB file path enter the server name and click on OK to start the local personal server with the selected database
    2. Now select the server Name and Database Name in the connect to SQL Anywhere 16 database window

15.png

    1. Check the connection
    1. Connect to a running database on another computer
      1. Enter the details of connection parameters

16.JPG

    1. The port is assigned by the Network server

5.JPG

      1. To connect to the database running on the another computer, we need to create and start the Network server like how personal server created with the selected database
    1. Connect to a running database in a cloud
      1. Enter the cloud connection details

17.JPG

  1. Open DPL/SSIS and create new connection with the ODBC connection to the SQL Anywhere 16
  2. Select the tables you want to import and export to SQL Server through export option.

FIREBIRD DATA CONNECTION PROTOTYPE

Process

To download the files from the remote server, create an FTP server for the folder

  • FTP server creation for the firebird database file
  • Creating script file in ScriptFTP to download the FTP files


Download the “DBConvert for firebird and MS SQL”  tool

  1. Use DB Convert to convert from .fdb format to .sql format (FireBird to SQL Server)
  2. Use the target connection to staging database

Steps

  1. Enable FTP service from Start → Control Panel → Programs and Features → Turn windows features on and off


  1. Expand the IIS and select FTP Service


  21.JPG

  1. Open IIS window from Administrative tools → IIS

7.JPG

  1. Right click on the sites folder and select Add FTP site option

8.JPG

  1. Enter the name for the FTP Site and click Next

9.JPG

  1. Enter the Binding and SSL settings

  10.JPG

  1. Select the Authentication and Authorisation information and click finish

  11.JPG

  1. Now check the FTP connection by opening explorer and enter the ftp address as ftp://<ipaddress>

12.JPG

  1. Now open ScriptFTP tool select New→ download.ftp → save the .ftp file and enter the script


# Connect to FTP serverOPENHOST(“10.100.1.21″,”RISECORP\ppandela”,”T3mp2014″)                        <ip address>,      <user name>,       <password># Go to C:\MyDirLOCALCHDIR(“D:\BODS Videos”)                             <file path to where the downloaded file has to place># Get all the files in the FTP serverGETFILE(“*.FDB”)                <file name to download># Transfer finished, close the connectionCLOSEHOST 14.JPG

  1. Click on Run to execute the script and download the file

15.JPG16.JPG

  1. Click on scheduler menu, select the script file and create scheduling for download the files

22.JPG.

  1. Now open the DB Convert tool
  2. Select the source connection to .fdb database file

17.JPG

  1. Enter the target staging database connection details

18.JPG19.JPG

  1. click on commit to convert the .fdb file to .sql database

20.JPG

  1. click on schedule button to schedule the conversion
To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply