Rank: Newbie
Groups: Registered
Joined: 7/17/2020(UTC) Posts: 2  Location: Bakersfield
|
Is there a method for tracing data in CenterPoint back to its source tables in SQL Server. My team is trying to push data from CenterPoint to our data warehouse. We have looked at your API, and that seems to be one possible route for exporting data on a scheduled basis, however everyone on staff is much more familiar with SQL than .NET. We have access to the back-end server and have searched around a bit, but can't always find what we need. What do you suggest?
|
|
|
|
|
|
Rank: Administration
Groups: Administrators, Moderator, Registered
Joined: 2/28/2018(UTC)
Posts: 50
Location: Red Wing, MN
Was thanked: 3 time(s) in 3 post(s)
|
Unfortunately we do not offer any method for tracing the origin of data back to the underlying SQL table(s) and do not support pulling data directly from a CenterPoint database.
We do offer Import / Export tools as an alternative to our API, these allow for the transfer of data in a CSV file format.
The export tool is Report driven, so most data can be found and extracted in this way.
Regards,
- Aaron.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 2/28/2018(UTC) Posts: 48 Location: Pennsylvani mostly Was thanked: 7 time(s) in 7 post(s)
|
I'd use the Data Browser (which is the export tool that Aaron mentioned) You don't have to know .NET to use it because you can run it as a command line that returns the data you requested in .CSV or .XML format. All you have to do is identify a report in CenterPont that has the data you want and set up an XML file with the search parameters. There's a UI that will help you create the search parameter XML file. The main reasons that we don't encourage getting data from the SQL database directly are that it can be extremely difficult (especially transaction data) and some of it is encrypted. What kind of data were you interested in grabbing? Edited by user Friday, July 17, 2020 8:28:40 PM(UTC)
| Reason: Not specified
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 7/17/2020(UTC) Posts: 2 Location: Bakersfield
|
That sound pretty straight forward. The data we would like to pull comes from our GL report and includes:
Account, Transaction date, Transaction Number, Vendor, Department, Profit Center, Credit, Debt, Amount
|
|
|
|
|
|
Rank: Administration
Groups: Administrators, Moderator, Registered
Joined: 2/28/2018(UTC)
Posts: 50
Location: Red Wing, MN
Was thanked: 3 time(s) in 3 post(s)
|
Originally Posted by: kduncan  That sound pretty straight forward. The data we would like to pull comes from our GL report and includes:
Account, Transaction date, Transaction Number, Vendor, Department, Profit Center, Credit, Debt, Amount You can install these tools using the standard CenterPoint installer... When installing (or if you modify an existing install from Add/Remove programs) select a "Custom" setup type, then you can select the "Data Import" and/or "Data Export" components under the "Tools" component to install them. This will create shortcuts for "CenterPoint Data Browser" and "CenterPoint Data Importer" under a "Red Wing Software" folder in your Windows Start menu. Regards, - Aaron.
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
Important Information:
The Red Wing Software Developer Forum uses cookies. By continuing to browse this site, you are agreeing to our use of cookies.
More Details
Close
