About the basis
As stated in the other answer, the lattice directly related to SIS is actually the $q$-ary lattice defined as
$$\mathcal{L}_q^\bot(A) := \{ u \in \mathbb{Z}^m : Au = 0 \mod q \}.$$
And its basis is not the matrix $A$. To construct a basis to this lattice, one usually suppose that $A$ has $n$ linearly independent columns (let's say, the first $n$) and write $A = [A_1 \quad A_2]$ with $A_1$ being an $n\times n$ matrix invertible over $\mathbb{Z}_q$, then the following matrix $B$ is a basis:
$$
B =
\begin{pmatrix}
~q\cdot I_n~ & -A_1^{-1}A_2 \\
~\vec 0~ & I_{m-n}
\end{pmatrix} \in \mathbb{Z}^{m \times m}
$$
About the hardness
Actually, it could be a hard problem regardless its connections with lattice problems. But it is connect to lattices in several ways. First, it is obvious that finding short vectors in $\mathcal{L}_q^\bot(A)$ gives us solutions to SIS. Moreover, it has been proved that if one can solve SIS in polynomial time in average, then one can solve hard lattice problems.
Roughly speaking: if you had an algorithm to solve SIS with non-negligible probability (for instance, your algorithm could work one time out of one million), then you would have an algorithm to solve approximate versions of GapSVP and SIVP).
About the value $\beta$
The value $\beta$ is a parameter of the problem. It is easy to find $u$ such that $Au = 0 \mod q$ (just use Gaussian elimination), what may be hard is to find a short vector satisfying this equation. But how do you define short? Using $\beta$ as an upper bound to the length.
These are standard facts: if $\beta \ge q$, then $u = (q, 0, 0,..., 0)$ is a valid solution, therefore, SIS is trivial for such values of $\beta$. If $\beta$ is too small, then maybe there is no valid solution. If $\beta \ge \sqrt{m}$ and $m \ge n\log q$, then it is guarantee that there exist at least one valid solution.