| Browse by Category |
Search the Knowledge Base |
|
|
|
|
|
Can I make custom reports or access the database outside of inFlow? |
|
Last Updated June 20th, 2008
|
| User Opinions (0 votes) |
|
No users have voted.
|
|
Thank you for rating this answer.
|
We don’t officially support this, but you can do this if you
have the appropriate skills with databases and/or reports, or can find somebody
to help you. Some more technical
information is below.
inFlow uses a Microsoft SQL Server database as a back-end
database. You can connect to this using
Crystal Reports or some other reporting tool to create custom reports. It creates an SQL Server instance named
INFLOWSQL on the server machine. You can
log into this using the sa
account. The password for the sa account is the Server Password, which
you can find by switching inFlow to multi-user mode and selecting Change Connection from the File
menu. You can also connect to this
database using an ODBC connection. In
fact, there may have been an ODBC connection called local-sql created for you after installing inFlow.
Some warnings about this - we don’t officially support
connecting to the database outside of inFlow, although we’ll informally be glad
to help you get started. Making changes
to the database outside of inFlow may lead to unexpected problems. Also, many of the update patches for inFlow
will update the database, so if you create some tools that rely on a particular
database structure, you should be careful when choosing to update inFlow.
|
| Visitor Comments |
-
Comment #1 (Posted by Terry
)
any chance you'd share the database entity diagram (or data dictionary) so I can be sure to extract the correct data for our custom reports?
-
Comment #2 (Posted by admin
)
Hi Terry, can you send an email to support@inflowinventory.com to let us know what specific details you need for your custom reports? We can assist you from there. Thanks, -Amy
|
| Attachments |
|
No attachments were found.
|