# Grai SQL Server Integration
The SQL Server integration synchronizes metadata from your SQL Server database into your Grai data lineage graph.
Tests assume you have working installation of pyodbc and a supported
ODBC driver installed on your host machine.
## Installation Notes
Installing ODBC drivers can be particularly tricky on M1 machines.
You'll need to install the unixodbc drivers through brew first
```bash
brew install unixodbc
```
You can attempt installing pyodbc directly at this point though I was forced to
set LDFLAGS and CPPFlags in my bashrc/zshrc file, i.e.
```bash
export LDFLAGS="$LDFLAGS -L$(brew --prefix unixodbc)/lib"
export CPPFLAGS="$CPPFLAGS -I$(brew --prefix unixodbc)/include"
```
At this point you should be able to `pip install pyodbc` successfully
and import the package from within python. However, you'll still require an
ODBC driver in order to connect with an MS SQL server. There are multiple options
for potential drivers but ODBC 18 from Microsoft has worked in testing.
```bash
brew tap microsoft/mssql-release https://github.com/Microsoft/homebrew-mssql-release
brew update
HOMEBREW_ACCEPT_EULA=Y brew install msodbcsql18 mssql-tools18
```
If you continue to experience issues you might try creating these symlinks
below.
```
sudo ln -s /opt/homebrew/etc/odbcinst.ini /etc/odbcinst.ini
sudo ln -s /opt/homebrew/etc/odbc.ini /etc/odbc.ini
```
When installing locally, if you get an error like `ImportError: dlopen(/opt/homebrew/lib/python3.11/site-packages/pyodbc.cpython-311-darwin.so, 0x0002): symbol not found in flat namespace (_SQLAllocHandle)`, you can try uninstalling `pip uninstall pyodbc` and then reinstall with build `pip install --no-binary :all: pyodbc`.
Raw data
{
"_id": null,
"home_page": "https://www.grai.io/",
"name": "grai-source-mssql",
"maintainer": "",
"docs_url": null,
"requires_python": ">=3.8,<4.0",
"maintainer_email": "",
"keywords": "",
"author": "Ian Eaves",
"author_email": "ian@grai.io",
"download_url": "https://files.pythonhosted.org/packages/4a/95/5ea86ebdf3ca6336f2fb2191e82d3ec7c5d3d4e41ee6f9f1d3e460771a21/grai_source_mssql-0.1.0.tar.gz",
"platform": null,
"description": "# Grai SQL Server Integration\n\nThe SQL Server integration synchronizes metadata from your SQL Server database into your Grai data lineage graph.\n\nTests assume you have working installation of pyodbc and a supported\nODBC driver installed on your host machine.\n\n## Installation Notes\n\nInstalling ODBC drivers can be particularly tricky on M1 machines.\nYou'll need to install the unixodbc drivers through brew first\n\n```bash\n brew install unixodbc\n```\n\nYou can attempt installing pyodbc directly at this point though I was forced to\nset LDFLAGS and CPPFlags in my bashrc/zshrc file, i.e.\n\n```bash\nexport LDFLAGS=\"$LDFLAGS -L$(brew --prefix unixodbc)/lib\"\nexport CPPFLAGS=\"$CPPFLAGS -I$(brew --prefix unixodbc)/include\"\n```\n\nAt this point you should be able to `pip install pyodbc` successfully\nand import the package from within python. However, you'll still require an\nODBC driver in order to connect with an MS SQL server. There are multiple options\nfor potential drivers but ODBC 18 from Microsoft has worked in testing.\n\n```bash\nbrew tap microsoft/mssql-release https://github.com/Microsoft/homebrew-mssql-release\nbrew update\nHOMEBREW_ACCEPT_EULA=Y brew install msodbcsql18 mssql-tools18\n```\n\nIf you continue to experience issues you might try creating these symlinks\nbelow.\n\n```\nsudo ln -s /opt/homebrew/etc/odbcinst.ini /etc/odbcinst.ini\nsudo ln -s /opt/homebrew/etc/odbc.ini /etc/odbc.ini\n```\n\nWhen installing locally, if you get an error like `ImportError: dlopen(/opt/homebrew/lib/python3.11/site-packages/pyodbc.cpython-311-darwin.so, 0x0002): symbol not found in flat namespace (_SQLAllocHandle)`, you can try uninstalling `pip uninstall pyodbc` and then reinstall with build `pip install --no-binary :all: pyodbc`.\n",
"bugtrack_url": null,
"license": "Elastic-2.0",
"summary": "",
"version": "0.1.0",
"project_urls": {
"Documentation": "https://docs.grai.io/",
"Homepage": "https://www.grai.io/",
"Repository": "https://github.com/grai-io/grai-core/tree/master/grai-integrations/source-mssql"
},
"split_keywords": [],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "8e8dbb087cbc736dd5f0117fde194566c1d17c64d3af8de1acbdf5178ce52386",
"md5": "383970fa6da3eefca794a0bb7889a01f",
"sha256": "2ab02eb014dd96475e24de2c926d9d3bfb6f3b9a5d77f99a4155f20883de035e"
},
"downloads": -1,
"filename": "grai_source_mssql-0.1.0-py3-none-any.whl",
"has_sig": false,
"md5_digest": "383970fa6da3eefca794a0bb7889a01f",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.8,<4.0",
"size": 9585,
"upload_time": "2023-07-19T14:18:03",
"upload_time_iso_8601": "2023-07-19T14:18:03.202601Z",
"url": "https://files.pythonhosted.org/packages/8e/8d/bb087cbc736dd5f0117fde194566c1d17c64d3af8de1acbdf5178ce52386/grai_source_mssql-0.1.0-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "4a955ea86ebdf3ca6336f2fb2191e82d3ec7c5d3d4e41ee6f9f1d3e460771a21",
"md5": "21e8515225448535cb385e06771a85ed",
"sha256": "3e109d7b0538f1d023c76cd4d38c353807148ac655d8004161b5dc07bb8dc1f6"
},
"downloads": -1,
"filename": "grai_source_mssql-0.1.0.tar.gz",
"has_sig": false,
"md5_digest": "21e8515225448535cb385e06771a85ed",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.8,<4.0",
"size": 8767,
"upload_time": "2023-07-19T14:18:05",
"upload_time_iso_8601": "2023-07-19T14:18:05.033687Z",
"url": "https://files.pythonhosted.org/packages/4a/95/5ea86ebdf3ca6336f2fb2191e82d3ec7c5d3d4e41ee6f9f1d3e460771a21/grai_source_mssql-0.1.0.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2023-07-19 14:18:05",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "grai-io",
"github_project": "grai-core",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"lcname": "grai-source-mssql"
}
JSON
