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/…josue_sehnem
05/03/2023, 12:27 PMSELECT schema_name()
that is not a valid query.
I don't know exactly what you are trying to accomplish, but it may be feasible using other netsuite taps, there is a version that uses suiteql https://gitlab.com/hotglue/tap-netsuite-rest and should support queries, so you can build your own queries, also new versions for the soap (that has all the object available) and regular rest versions of the API, there may be some internal data that is not accessible though.daniela_angelova
05/03/2023, 12:32 PMjosue_sehnem
05/03/2023, 12:43 PM