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

[fmvizcaino]

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

[AndrewSu]

@fmvizcaino , any luck with this?  Have a need to connect with Sage 100 for one of my partners and came across this post while doing some research. 

[fmvizcaino]

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

Not a great workaround, but it works!

[AndrewSu]

@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]

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