Datasource (SAGE 100) only returning first row for some tables

Question

Hi everyone,

We are connecting to SAGE 100 using ODBC (tested both 32 and 64 bits) and it is only returning the first row for some tables.

I have seen this error in the community for other data sources but it was all related to driver versions and we tested that.

Any suggestions are welcome.

Thanks,

Fernando Vizcaino

fmvizcaino · Answer

Hi @AndrewSu ,

I'm not sure about all of them, but as long as you have the option to configure a linked server, you will be able to do it.

Here are a couple of tutorials about Access and Microsoft SQL Server. (I didn't test the tutorials since I don't have Sage 100 here, so use it with caution)

https://www.acutedata.com/how-to-import-data-into-microsoft-access-or-excel-from-sage-100/

https://www.acutedata.com/sage-100-how-to-set-up-a-linked-server-in-sql-server-management-studio/

Best,

Fernando Vizcaino

AndrewSu · Answer

@fmvizcaino , any chance you can share any documentation/steps on how they connected Sage to Access?  does it have to be Access or can it be any other database that Alteryx can read from?

fmvizcaino · Answer

No luck yet. Our client connected Sage100 to an access database and then connected to Alteryx.

Not a great workaround, but it works!