daniela_angelova
05/03/2023, 7:42 AMconnection_string = "DRIVER=NetSuite ODBC Drivers 8.1;"\
"Host=<http://XXXX.connect.api.netsuite.com;%22\|XXXX.connect.api.netsuite.com;"\>
"Port=XXXX;"\
"Encrypted=1;"\
"AllowSinglePacketLogout=1;"\
"Truststore=/opt/netsuite/odbcclient/cert/ca3.cer;"\
"SDSN=<http://NetSuite.com;%22\|NetSuite.com;"\>
f"UID=XXXX;"\
f"PWD=XXXX;"\
f"CustomProperties=AccountID=XXXX;RoleID=XXXX"
connection_url = URL.create("mssql+pyodbc", query={"odbc_connect": connection_string})
I have the ODBC driver installed, but I get the following error when running meltano discover:
```
Traceback (most recent call last):
File "/project/.meltano/extractors/tap-netsuite/venv/bin/tap-netsuite", line 8, in <module>
sys.exit(Tapnetsuite.cli())
File "/project/.meltano/extractors/tap-netsuite/venv/lib/python3.9/site-packages/click/core.py", line 1130, in call
return self.main(*args, **kwargs)
File "/project/.meltano/extractors/tap-netsuite/venv/lib/python3.9/site-packages/click/core.py", line 1055, in main
rv = self.invoke(ctx)
File "/project/.meltano/extractors/tap-netsuite/venv/lib/python3.9/site-packages/click/core.py", line 1404, in invoke
return ctx.invoke(self.callback, **ctx.params)
File "/project/.meltano/extractors/tap-netsuite/venv/lib/python3.9/site-packages/click/core.py", line 760, in invoke
return __callback(*args, **kwargs)
File "/project/.meltano/extractors/tap-netsuite/venv/lib/python3.9/site-packages/singer_sdk/tap_base.py", line 516, in cli
tap = cls( # type: ignore[operator]
File "/project/.meltano/extractors/tap-netsuite/venv/lib/python3.9/site-packages/singer_sdk/tap_base.py", line 568, in init
super().__init__(
File "/project/.meltano/extractors/tap-netsuite/venv/lib/python3.9/site-packages/singer_sdk/tap_base.py", line 103, in init
self.mapper.register_raw_streams_from_catalog(self.catalog)
File "/project/.meltano/extractors/tap-netsuite/venv/lib/python3.9/site-packages/singer_sdk/tap_base.py", line 165, in catalog
self._catalog = self.input_catalog or self._singer_catalog
File "/project/.meltano/extractors/tap-netsuite/venv/lib/python3.9/site-packages/singer_sdk/tap_base.py", line 286, in _singer_catalog
for stream in self.streams.values()
File "/project/.meltano/extractors/tap-netsuite/venv/lib/python3.9/site-packages/singer_sdk/tap_base.py", line 128, in streams
for stream in self.load_streams():
File "/project/.meltano/extractors/tap-netsuite/venv/lib/python3.9/site-packages/singer_sdk/tap_base.py", line 318, in load_streams
for stream in self.discover_streams():
File "/project/.meltano/extractors/tap-netsuite/venv/lib/python3.9/site-packages/singer_sdk/tap_base.py", line 604, in discover_streams
for catalog_entry in self.catalog_dict["streams"]:
File "/project/.meltano/extractors/tap-netsuite/venv/lib/python3.9/site-packages/singer_sdk/tap_base.py", line 592, in catalog_dict
result["streams"].extend(connector.discover_catalog_entries())
File "/project/.meltano/extractors/tap-netsuite/venv/lib/python3.9/site-packages/singer_sdk/connectors/sql.py", line 486, in discover_catalog_entries
inspected = sqlalchemy.inspect(engine)
File "/project/.meltano/extractors/tap-netsuite/venv/lib/python3.9/site-packages/sqlalchemy/inspection.py", line 64, in inspect
ret = reg(subject)
File "/project/.meltano/extractors/tap-netsuite/venv/lib/python3.9/site-packages/sqlalchemy/engine/reflection.py", line 182, in _engine_insp
return Inspector._construct(Inspector._init_engine, bind)
File "/project/.meltano/extractors/tap-netsuite/venv/lib/python3.9/site-packages/sqlalchemy/…