Hi,

I'm trying to find a way to make quick query against Adagio's ODBC Connection the same wayI do it in SQLServer Management Studio.

I know I can do it in Visual Studio but is there an easy way.
There is something in SQL Server Management Studio to add linked servers but I do not know what the Datasource, Provider String, Location and Catalog field should contain...

Any insight would be nice.

I understand that the ODBC Module has the ability to connect to SQL Server but I'm not sure what this functionality allows.

Is there more documentation available than the PDF that shows how to create a DNS?


Thanks
Yann

Have a look at AdagioODBCv2.chm

Let me know if you feel that this does not properly document setting up a DSN to connect to the Adagio tables.

Hi Michael,

the DSN is setup. I had no issue there.

I'm just having issues figuring out what tables to use for AP and AR.

It was also not clear how to setup the SAM files. I have quiet a few of them...
I think I have the right one now... I found one 3 inside the company directory. One for AR, another for AP and a GL one.

Are there specific table that I should start with?
Customer Master and Vendor Master look like a good place to start. is there a way to figure out what table is related to what Adagio screen? Also, there are table for older versions and newer version of the software. How do i figure which one to use?

What is the underlaying database that adagio uses?

Thanks
Yann

At the moment i'm looking for transaction history to calculate how much we have purchased from our us vendors in the last 5 years.

my DNS is pointing to

The dictionary exporter seems to suggest that I should use the AP Transaction History.
In crystal, I see APTransactions_ap81btm but there does not seem to be anything in there.

There are other tables with History in their name but I haven't found the right one that correspond to the Historical Transactions from the transactions tab in Payables 8.1E

Hi Yann:

The transaction History table is "APTransactionHistory_ap81bhst". But it's odd that the table you picked would be empty. That is the transaction table for all Current (unpaid) transactions. Unless your Payables department has paid all invoices and just run Period End, you would expect to find something in there. Check what the History table shows and let us know.

Vendor documents are stored in two files. APTransactions_ap81btrn and APTransactionHistory_ap81bhst. The latter would just contain completed transactions. The former would be a mix of paid and unpaid transactions.

Receivables is different. For AR9, all the customer transactions are stored in one file. ARTransactions_ar90atrn.

Hi Bruce.

Here is what I se when I add that table...
There are not fields in it

you can view the image here but your the adagio Forum does not support these linked images...

[img]https://lh6.googleusercontent.com/EXGztC...7bv0=w1448-h729[/img]

and Yes, there is data in the APTransactions_ap81btrn table...
Why does the database definition table exporter not refer to these table names?

A short description somewhere of what is in these table could also be useful but once I play with it, I guess I'll figure it out.

Yann:

When you create the DSN, one of the options is "Table names" and there are 2 options "Long" and "Short". If you choose "Short" the table names will more closely match those located in the Data Dictionary in Excel.

Use the DataDictionary Exporter with /ODBC on the command line to see the ODBC names for the fields.